Recent questions tagged dplyr

0 votes

639 views

1 answer

dplyr - Generate all possible pairs and count frequency in R

I have a data frame of products (apple, pear, banana) sold across different locations (cities) within different ... the count for each pair. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

490 views

1 answer

dplyr - How to present another column on this R data.table output?

I am trying to present another columns DF2$time_expected and DF$time/DF2$time_expected in the output of DF[DF$Experiment=="A", ] ... 2 A 5 1.84 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

484 views

1 answer

dplyr - Creating a table for frequency analysis results in R

I need to create a table of a certain type and based on a certain template. This is my data: df = structure(list(group = ... 0(0,0%%)0 1(2,3) 1 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

518 views

1 answer

dplyr - R Replace Intermittent NA Values With Last Observation Carried Forward (NA.LOCF)

Background I neeed to replace the NA's in my data frame by using different methods depending on the NA's ... TRUE after running this test. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

818 views

1 answer

dplyr - R/tidyverse: calculating standard deviation across rows

Say I have the following data: colA <- c("SampA", "SampB", "SampC") colB <- c(21, 20, 30) colC <- ... ' solution (base R also works just fine). See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

566 views

1 answer

dplyr - Cumulative sum in a window (or running window sum) based on a condition in R

I am trying to calculate cumulative sum for a given window based on a condition. I have seen threads where the ... this problem for two days. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

610 views

1 answer

dplyr - Cumulative sum in a window (or running window sum) based on a condition in R

I am trying to calculate cumulative sum for a given window based on a condition. I have seen threads where the ... this problem for two days. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

531 views

1 answer

dplyr - R: pass a list of filtering conditions into a dataframe

I have a dataframe like: Symbol Yield PE Growth 1 ABBV 3.46 18.80 5.00 2 ABM 2.24 21.18 3.33 3 ABT 2.26 23. ... Yield within (2 3) & PE>3 &...) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

787 views

1 answer

dplyr - How do I select all unique combinations of two columns in an R data frame?

I have a correlation matrix that I put in a dataframe like so: row | var1 | var2 | cor 1 | A | B | ... to do this without resorting to a loop. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

722 views

1 answer

dplyr - How do I select all unique combinations of two columns in an R data frame?

I have a correlation matrix that I put in a dataframe like so: row | var1 | var2 | cor 1 | A | B | ... to do this without resorting to a loop. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

678 views

1 answer

dplyr - What are helpful optimizations in R for big data sets?

I built a script that works great with small data sets (<1 M rows) and performs very poorly with large datasets. I've ... key_z[1:(3*10^6)] ) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

916 views

1 answer

dplyr - R: cumulative sum over rolling date range

In R, how can I calculate cumsum for a defined time period prior to the row being calculate? Prefer dplyr if possible. ... 20 31/01/2000 6 85 18 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

454 views

1 answer

dplyr - Importing multiple .csv files with variable column types into R

How can I properly build an lapply to read (from out of one directory) all the .csv files, load all the columns ... for loop myself - per this. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

543 views

1 answer

dplyr - complete time series by group in r

I have a dataframe dat <- data.frame(c("G", "G", "G", "G"), c("G1", "G1", "G2", "G2"), c( ... it does not work. Can anyone help me with this? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

477 views

1 answer

dplyr - Rbind corresponding elements in two or more lists in R

I have 3 lists, each with 500 elements. Here for demonstrative purposes, I have 2 lists with 1 element each: ... class = "data.frame")) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

520 views

1 answer

dplyr - resetting cumsum if value goes to negative in r

ve <- c(17, -9, 9, -17, 17, -17, 11, -9, 16, -18, 17, 0, 0, -18, 17, 0, 0, -17, 14 ... of -1 and continue cumsum, hence the next would be 17 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

608 views

1 answer

dplyr - How to replace certain values in a specific rows and columns with NA in R?

In my data frame, I want to replace certain blank cells and cells with values with NA. But the cells I want to ... NA. How should I do this? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

591 views

1 answer

dplyr - R: Further subset a selection using the pipe %>% and placeholder

I recently discovered the pipe operator %>%, which can make code more readable. Here is my MWE. library( ... writing this seems more concise. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

dplyr - How to replace empty string with NA in R dataframe?

My first approach was to use na.strings="" when I read the data in from a csv. This doesn't work for some reason. ... ), ""), class = "noquote") See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

392 views

1 answer

dplyr - R - Unable to install R packages - Cannot open the connection

Before you mark this as duplicate, I wish to say that I already referred the related post 1,post 2, 3, 4 ... but still no help Can help please? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

515 views

1 answer

dplyr - R: Adding a "tool tip" to interactive plot (plotly)

I am using the R programming language. From a previous post (R: Plot not Fully Loading), I learned how to ... row of that line appears? Thanks See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

712 views

1 answer

dplyr - How to filter rows based on difference in dates between rows in R?

Within each id, I would like to keep rows that are at least 91 days apart. In my dataframe df below, id=1 ... function or slice? If so, how? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

615 views

1 answer

dplyr / R cumulative sum with reset

I'd like to generate cumulative sums with a reset if the "current" sum exceeds some threshold, using dplyr. In ... reset after the first time. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags