I have a list object below and I need to assign each list object with a specific name such as if the object is in the 1st place in my.list, DF.1, if it is in the 10th place, DF.10. Many thanks in advance. df1 <- data_frame(ID = paste0(LETTERS[1],1:4), valueA = seq(0.1,0.4,0.1), Category= "Apples", valueDEF =… Read More setnames() in a list object in R
I have 2 datasets that I would like to merge. But before that, I would like to increment ID as tail(df1$ID, n=1) + 1 as long as the last row of the df2 df1 <- data_frame(ID = c(1:4), valueA = seq(0.1,0.4,0.1), Category= "Apples" ) df2 <- data_frame(ID = "I NEED TO DEFINE", valueA = seq(0.1,0.4,0.1),… Read More Increment the vector value as long as the row number
I have an list object like below. df1 <- data_frame(ID = paste0(LETTERS[1],1:4), valueA = seq(0.1,0.4,0.1), Category= "Apples", valueDEF = seq(0.1,0.4,0.1), valueDEF2 = seq(0.1,0.4,0.1) ) df2 <- data_frame(ID = paste0(LETTERS[1],5:8), valueB = seq(0.1,0.4,0.1), Category= "Apples2") df3 <- data_frame(ID = paste0(LETTERS[1],9:12), valueC = seq(0.1,0.4,0.1), Category= "Apples3") list1 <- list(df1, df2, df3);list1 [[1]] # A tibble: 4 ×… Read More combining common columns in a list in R
I want to determine whether the observations in df1 are in df2. If they are not, I would like to see the ids that are not in df2. df1 id 1 2 3 4 df2 1 4 The output I am looking for is: id 2 3 I tried using tidyverse for this, but I… Read More determining observation overlap
I’m new to R and have scoured the site to find a solution – I’ve found lots of similar, but slightly different questions. I’m stumped. I have a dataset in this structure: SURVEY_ID CHILD_NAME CHILD_AGE Survey1 Billy 4 Survey2 Claude 12 Survey2 Maude 6 Survey2 Constance 3 Survey3 George 22 Survey4 Marjoram 14 Survey4 LeBron… Read More Pivot_wider: Combine Duplicate Observations AND Create New Variable Columns for Those Values
I’m trying to find the equivalent of tidyr::unnest() for a data.table with multiple nested columns: MT <- as.data.table(mtcars) MT_NEST_MULT <- MT[, .(data1 = .(.SD[, .(mpg, hp)]), data2 = .(.SD[, !c("mpg", "hp")])), by = .(cyl, gear)] cyl gear data1 data2 8 3 <S3: data.table> <S3: data.table> 8 5 <S3: data.table> <S3: data.table> 6 4 <S3: data.table>… Read More Un-nesting multiple columns with data.table in R
I was plying with higher order functions, and I started getting different results when I created two instances and assigning them to variables. I reduced the issue to the following example: #include <iostream> using ColorGetter = int(*)(void); auto paint(const ColorGetter &f) { return [&]() { return f(); }; } int colorA() { return 10; }… Read More C++ higher order functions: different results when declaring multiple functions
Ok so say we have two different columns of data. One is just a running date column: day 2017-11-08 2017-11-09 2017-11-10 2017-11-13 2017-11-14 2017-11-15 The other is just an ID column ID asdflauih3298b43f9n akjwn3ibfun9834n93n nv43879n4vliuhs87ba I would like to join these columns in a way so that each ID occurs for every day. Like this:… Read More Join columns, duplicating existing row for each variable in new column
I am teaching myself to use tidyverse more, as I’m hoping to be able to make cleaner code in the future. I have data that looks like this: data <- as_tibble(data.frame(x = c(1,2,3,3,4), y = c(3,4,4,2,5), z = c(1,1,5,5,3))) And I would like to get the mean, sd, and confidence intervals for all 3 columns.… Read More pulling specific function columns from a list of functions
I have grouped data like follows: group id var 1 1 1 1 2 1 2 0 3 1 3 1 4 2 1 0 5 2 2 1 6 3 1 0 I’d like to create N new var columns (var1, var2,…) where N is the max number of individuals in a group (in… Read More Mutate a transposed column into new columns row-wise by group