Samplaying

u/Samplaying


r/Rlanguage•

Hi,

I am dabbling with tick data for cryptocurrencies from binance.

I am testing the waters with data from 2 months: 250 million rows x 9 columns.

I am trying multiple variations of code, but the problem is the repeated use of all my RAM, and eventual crashing of R studio. This happens in both duckdb and arrow or mixed pipelines.

My question i a nutshell, I currently have 32 GB RAM. is this generally too little for such data, should i upgrade? or do i need to improve/optimize on my code?

Sample code that aborts R session after 11 minutes:

library(tidyverse)

library(duckdb)

library(arrow)

library(here)

schema_list <- list(

trade_id = int64(),

price = float64(),

qty =

1012

r/selfhosted•

Hi,

My gmail accounts are starting to fill up, and quite frankly i would like to store my data at home and start deleting older emails from gmail account. My idea is: to sync my gmail accounts to a local disc, serve them on my LAN fom a linux container on proxmox. I plan to use mbsync and dovecot.

I have no intention of exposing the lxc to the internet and i have no intention to send or receive emails directly from or to my system.

I already setup roundcube to access the emails, but that is not relevant to my current issue.

My first question:

  1. is the solution using mbsync and dovecot the best / easiest? I am open to suggestions
  2. I use the system login for dovecot. But i cant seem to
54

r/rstats•

I am faced with the following problem, which i cant seem to find a solution to.

My data set is a series of 11 readings along a tube-like structure, quantifying the contact of this tube to a neighbouring structure as a fraction between 0 and 1, 0 being no contact, 1 being full contact, at certain positions along the tube.

Sample data:

structure(list(subject = c("A", "A", "A", "A", "A", "A", "A", "A", "A", "A", "A", "B", "B", "B", "B", "B", "B", "B", "B", "B", "B", "B"), position = c(1L, 2L, 3L, 4L, 5L, 6L, 7L, 8L, 9L, 10L, 11L, 1L, 2L, 3L, 4L, 5L, 6L, 7L, 8L, 9L, 10L, 11L), value.gt = c(0, 0, 0, 0, 0.0018975, 0.0074407, 0.027362, 0.10947, 0.2906, 0.35397, 0.36235, 0.91014, 0.94228, 0

27

r/rstats•

Dear community,

my google search did not yeald satisfactory results for my specific problem.

I had 4 readers assess variables using a qualitative scale: no, mild, moderate or strong. There are some real NA (missing) values.

​

In the irr package, this could be done using the irr::kappa2(df, "squared"). But this is only for 2 readers.

I failed to find another resource, that answers my question.

Could someone point me in the right direction?

If need be, I can remove the NA values.

​

Thanks

39

r/Rlanguage•

Hi R community,

I would like to calculate the state of charge of a battery at the end of each day, depending on charge and discharge loads. I can mutate a column reflecting current state of charge using cumsum().

The problem is, using cumsum() leads to values above or below minimum and maximum capacites of the battery.

I achieved this using a for loop, but regarding that my table has about 60K rows and I need to repeat the calculation about 200 times. The for loop takes hours.

Is there a quicker way to do that?

this is my code:

``` r
library(tidyverse)
#> Warning: Paket 'tidyr' wurde unter R Version 4.1.3 erstellt
#> Warning: Paket 'readr' wurde unter R Version 4
29

r/Rlanguage•

Hello dear community,

again I need the help of the tidyverse gurus.

I would like to filter groups, based on non grouped columns

library(tidyverse)
#> Warning: Paket 'readr' wurde unter R Version 4.1.2 erstellt
test_df <- tibble(
    key = rep(1:3, 4) %>% sort(),
    value = c(rep(TRUE, 4), rep(FALSE, 4), rep(TRUE,2), rep(FALSE, 2))
    )
test_df
#> # A tibble: 12 x 2
#>      key value
#>    <int> <lgl>
#>  1     1 TRUE 
#>  2     1 TRUE 
#>  3     1 TRUE 
#>  4     1 TRUE 
#>  5     2 FALSE
#>  6     2 FALSE
#>  7     2 FALSE
#>  8     2 FALSE
#>  9     3 TR
1429

r/AutoHotkey•

Hello community,

I am faced with this problem:

I have a non admin and a local admin accounts on the same computer.

I have a script, that performs mouseclicks and movements and writes the resulting info to a network drive. for this i have to use a non admin account. My local admin acount is blocked from using the network drives.

I will supply sample code to illustrate my problem. The actual code is on another computer, so please excuse any typing errors.

So I wrote the following script to block the input:

sleep, 20000
loop{
if (fileexist("flag.txt")
    blockinput, On
else
    blockinput, Off
}

To run it I use rightclick and run as adminstrator

​

10

r/rstats•

Hi,

I need some help with plotting shift in results of a test over time.

I will try to keep details to the necessary minimum. I have little to no flexibiity with type of chart, as the community is somewhat fixated to this visualisation

​

​

library(tidyverse)

sample_data <- tibble(

res = factor(c(0:6)),

time_1 = sample(0:20, 7, replace = T),

time_2 = sample(0:20, 7, replace = T)

) %>% pivot_longer(cols = c(time_1, time_2))

​

​

sample_data %>%

ggplot(aes(value, name, fill = res))+

geom_bar(stat = "identity")

​

I would like to connect the edges of the groups with lines, to highlight the change in

11

r/Rlanguage•

Hello dear community

I need some help, if possible.

to show my question, i created the following code:

library(tidyverse)

# create a tibble with dummy values
df <- tibble(category = rep(seq(1,5), 4),
             val = rnorm(20, 1, 5))

# create a function that plots the dummy values per category
gplot <- function(tib, cat){
    tib %>% filter(category == cat) %>% 
        ggplot(aes(category, val))+
        geom_jitter()
}


l <- list()

#iterate along categories and produce a plot per category
for (i in seq(min(df$category), max(df$category))){ 
    l[[i]] <- df %>% filter(category == i) %&
69

r/freenas•

Hi guys,

I just installed Freenas, and coming from Win 10 shares I am understandably very happy.

My HW:

AMD athlon 200g

SSD for system

2x 2TB HDD for storage.

My question is: Is there a guide somewhere about which power settings that make sense, to decrease unneeded power consumption.

Thx guys

06


r/ElgatoGaming•
  1. Sorry guys. Non informative title. PC with 4 capture cards for video recording of 4 monitors
  2. ​
  3. **What will you be doing with this PC? Be as specific as possible, and include specific games or programs you will be using.**
  4. I will be recording the outputs of 4 different monitors at the same time. The monitors belong to a dedicated machine. I have no software access to the output. I have a hardware splitter, which gives me 4 HDMI cable outs. all video outputs are below FHD.
  5. >**What is your maximum budget before rebates/shipping/taxes?**
  6. This is for work, so relatively flexible if required. 1500 Euroes are currently allocated
  7. >**When do you plan
20

r/CompetitivePUBG•

To start:

  1. Wall of text incoming, please be patient. TLDR at the end.
  2. This is about the new ranked system, please let me know if this is the wrong subreddit. But I feel the new ranked system interests the same people who have competitive interests.
  3. To my person: I am a PUBG nobody, so I claim no authourity. I am just an avid regular joe, who enjoyes tryharding in this game.

Problem:

In the last patch PUBG introduced a ranked system, which was greeted largely as postive. In their implementation, 2 things were really strange:

  1. Individual preformance decided your ranking.
  2. You can't team up with players of a higher tier than yours (10 tier difference is in force).

The

2022