I am trying to mean-center multiple variables at the same time. I am using the code below, which is replacing the original variables with the mean-centered variables. I want to keep BOTH the original variables and mean-centered variables. Does anyone know how I could modify my code to do that? vars_to_mc <- c("interview_age_1_year", "pea_wiscv_tss_baseline", "cbcl_scr_dsm5_adhd_r_baseline",… Read More keeping original and new variables in df

From the given dataframe i am trying to extract quarterly_values however it fails when i try to mutatue every third month values . mont_dates <- c("201401", "201402", "201403", "201404", "201405", "201406", "201407", "201408", "201409", "201410", "201411", "201412") cat <- c("new", "old", "undefined", "new", "old", "undefined", "undefined", "new", "old", "undefined", "new", "old") mont_vals <- c(221, 433,… Read More Select quarterly months values

I need to subset either the last one or two digits (replicates) of a coding variable (v1), that goes from 1 to 12. With the str_sub function, I cannot get the whole number when there are two digits. If I choose the last two digits, then the function gets the preceeding letter in one-digit replicates:… Read More Extract the last one or two digits of a coding variable with str_sub in R

I want to create the "turn" column in the example data frame. I have a larger dataset with thousands of rows. This column will indicate the current turn of the speaker. Even if the sentences are across different rows, if they are spoken by the same speaker, it will count as the same turn. Then,… Read More Sequentially number across groups without restarting sequence in r

I am trying to vectorize a function for the use in dplyr::mutate. For the life of me, I can’t get it working. This is what I have been doing: str_to_seq <- Vectorize(function(x) { # This function converts text format year ranges (e.g. "1970 – 1979") to # numeric ranges. Handily works with single values and… Read More Vectorized function in dplyr::mutate and logical operators

Here is the sample data stfips <- c("39","39","39") year <- c("2023", "2023","2023") industry_code <- c(112, 113, 114) first_quarter_establishments <- c(987,654,321) county <- data.frame(stfips, year, industry_code, first_quarter_establishments) The task at hand is to create a new column named period which would have a value of 01. The reason for the 01 is that it represents the… Read More How to create these columns in R?

I am making a large data frame using mutate with lots of ifelse conditions. My approach is to not name the columns within mutate because I have many hundreds of these conditions and each time I update one I then have to update them all. Rather I wish to name the columns after the operation… Read More stop mutate truncating column column names

I’m looking for a way to create a new variable for an average of the temperature the week before. I’ve got a data frame that looks like the following weather_data Rows: 3,664 Columns: 2 $ dt <date> 2014-01-01, 2014-01-02, 2014-01-03, 2014-01-04, 2014-01… $ temp <dbl> 6.390000, 6.234167, 6.307500, 4.436250, 4.432917, 8.4508… What I’m hoping to… Read More Using mutate to get an average of the previous weeks temperature

Below is an example of the data frame A B | 0 | NA | | 1 | NA | | 1 | 0 | | 1 | 0 | | 1 | 1 | | 0 | NA | | 1 | NA | | 1 | 0 | | 1 | 0 |… Read More Creating a new column using two columns from the data frame in R

I am working in R Edit: hoping for a dplyr suggestion sample data: df <- data.frame(col1 = c(TRUE, TRUE, NA, NA), col2 = c(FALSE, TRUE, FALSE, NA), col3 = c(NA, TRUE, NA, TRUE)) print(df) col1 col2 col3 TRUE FALSE NA TRUE TRUE TRUE NA FALSE NA NA NA TRUE Desired outcome I would like a… Read More Are all values in columns TRUE ignoring NA