Advertisements I am quite new to dplyr and can’t figure what I am doing wrong. I have the following dataset: INSTRUMENT_USED Year UniqueCount 1 QUEST_A 2015 1 2 QUEST_A 2016 1 3 QUEST_A 2017 1 4 QUEST_A 2018 1 5 QUEST_A 2019 1 6 QUEST_A 2020 1 7 QUEST_A 2021 0 8 QUEST_A 2022 0… Read More Using current value inside of a conditional summarise in dplyr

Advertisements In my DATA below, I wonder how to summarize() the number of 6 different Ethnicities (Hispanic, AmIndian, Asian, White, Pacific, AsiaPacific) chosen ("Y") when Ethinc_overall!="B"? library(tidyverse) DATA <- read.table(h=TRUE,text= "EL_Type Language Black Hispanic AmIndian Asian White Pacific AsiaPacific Ethinc_overall Current English Black Y N N N N N H Current English Black N N… Read More Conditional dplyr::summarize() of a data.frame in R

Advertisements library(tidyverse) set.seed(1) start <- mdy("01/01/2022") end <- start + as.difftime(4, units = "days") days <- seq(from = start, to = end, by = 1) days <- sample(days, 100, replace = T) flip <- sample(c("Heads", "Tails"), 100, replace = TRUE) numbers <- rchisq(100, 30) df <- tibble(days, numbers, flip) I have this dataframe and would… Read More Summarize with arithmetic operations on rows by column entry

Advertisements I would like to create a table of mean and sd for multiple variables for grouped data. However, the data has NAs, so I need to include the na.rm =T command. Using iris as a MWE, altered to include NAs: irisalt = iris irisalt[1,1] =NA irisalt[52,2] =NA irisalt[103,3]= NA First attempt: irisalt%>% group_by(Species)%>% summarise(count… Read More Mean and sd per group for multiple variables when NAs present

Advertisements I am quite new to R. I have a dataset with 8081 observations for 113 variables. The data was collected in 4 waves (panels), with some individuals being interviewed multiple times. They were sometimes asked the same questions, but some questions were only asked during one wave. Most answers were on a scale (e.g.… Read More Collapsing multiple observations based on specific parameters in R

Advertisements My dataset is like this. ID Col_01 Col_02 Col_03 Col_04 Col_05 Col_06 1 1 2 1 3 4 -9 2 1 1 2 1 2 2 3 2 4 1 1 1 1 4 3 1 3 2 -9 4 5 2 3 4 4 3 2 I like to create a summarized dataset… Read More r table for many columns

Advertisements I want to group by district summing ‘incoming’ values at quarter and get the value of the ‘stock’ in the last quarter (3) in just one step. ‘stock’ can not summed through quarters. My example dataframe: library(dplyr) df <- data.frame ("district"= rep(c("ARA", "BJI", "CMC"), each=3), "quarter"=rep(1:3,3), "incoming"= c(4044, 2992, 2556, 1639, 9547, 1191,2038,1942,225), "stock"=… Read More Group and add variable of type stock and another type in a single step?

Advertisements Problem I have a list of data frames. All of the dataframes have the same column names, but different numbers of rows. One column, called pred has the following four factors. Apple Cherry Orange Pear I wish to count how many rows are ‘apple’, ‘cherry’ etc. If I single out one dataframe (dataframe1), and… Read More Count observations by group in a list of dataframes in r

Advertisements I want to summarize my data in different ways, specifically, I want to count how many values are greater or equal than a certain threshold. I could easily do that with e.g. library(tidyverse) mtcars |> summarize(test1 = sum(mpg > 15, na.rm = TRUE)) However, how could I use summarize with using several, dynamic such… Read More dplyr summarize with a dynamic number of stats/conditions

Advertisements I am working with R and I have a series x at quarterly frequency and for which I want to extract the mean over the four quarters in 2012 and store that value in all rows of a newly created column. I have this kind of dataset date durabl services 2011-10-01 56.7 37.1 2012-01-01… Read More Groupby, filter, summarise and then apply the result to the whole column