Advertisements I am trying to add a column to my dataframe based on if a string is detected in another column. I have done this in two chunks of code and then merged them together, but I am trying to streamline my code so that there is less to type out in the future. I… Read More dplyr if else without the else/ conditional mutate in one chunk

Advertisements I have a dataset of U.S. cities that includes 400 variables (with both character and numeric values). I want each row to be a unique city, but the dataset contains duplicate rows for many cities. In these duplicate rows, the values that are missing in one row are non-missing in the other, and vice… Read More Consolidating rows using 'mutate_at' in R?

Advertisements I am trying to treat the values in a list as column names to filter against in a for loop using R. However, R seems to be treating the values as strings, not actual column names. For example, let’s say that I have a dataframe with 3 columns: PERSON_NAME, SCORE_1 and SCORE_2. Then I… Read More How do I treat an element of a list as a column of dataframe for loop

Advertisements I have a df : df <- data.frame(ID = c(1, 2, 3, 3, 4, 5, 5, 7, 7, 8), var1 = c(‘a’, ‘b’, ‘c’, ‘c’, ‘d’, ‘e’, ‘f’, ‘g’, ‘h’, ‘h’), var2 = c(1, 1, 1, 0, 1, 1, 0, 0, 1, 0), var3 = c(21, 50, 40, NA, 29, 45, NA, NA, NA,… Read More Replace NAs in column based on values in other column r dplyr

Advertisements I need to summarise some data.frame containing both numeric and character values. I need to sum the numerical features and to keep the most frequent character value per group at the same time. Ideally, it should be with dplyr but that’s not mandatory. Here is a reproducible example : have <- data.frame("id" = c(1,1,1,2,2,2),"a"… Read More Keep most frequent value per group

Advertisements I’m having trouble adding a new column to a dataframe based on values from another dataframe. I’m going to try to provide a minimal, replicable example; of course my real dataframes have lots of other columns, but I don’t think they matter here. So let’s say I have two dataframes, DF1 and DF2. ID… Read More How can I calculate a new column for a dataframe in R based on another dataframe?

Advertisements I have a dataset in long-format called df containing four key variables: respondent_id, time (the time period), change (a variable indicating the last period before a change of income) and lost_income, a variable indicating when a person lost their income. The lost_income column is currently empty, only in rows that follow a row where… Read More Filling in Missing Values in R Based on Previous Rows within Group

Advertisements This is a slight variation on a question I asked previously, which I have not been able to adapt the answer for. When there are repeated measurements I would like to replace the associated BP/BP2 with the mean for the first three measurements (if >=3), or the mean of two measurements (if == 2).… Read More How to replace repeated measurements with the mean of the first three or two measurements in R

Advertisements I want make a ‘new column’ with values from ‘number’ only for ‘sp.name’ (grouping variable) where both responses ‘young’ and ‘adult’ are present; if not, enter 0 in the ‘new column’. df <- data.frame(sp.name= c(‘a’,’a’, ‘b’, ‘b’ ,’c’, ‘d’ ), number=c(2,2,3, 3,4,4), stage= c(‘adult’, ‘young’, ‘young’,’adult’, ‘adult’, ‘young’)) Here is what I tried. df… Read More Make new colum based on values in two different columns by group

Advertisements I am trying to learn how to use the ellipses (…) when I program using dplyr. I cannot work out how to pass a character into the ellipses. Here is a toy problem to illustrate set.seed(10) data.frame(var1 = factor(sample(x = letters[1:3], size = 10, replace = T))) -> df Now say I want to… Read More Using quoted variable names when creating functions containing ellipses (i.e. '…') in dplyr