I want to create a new variable based on two conditions, for which the second condition may take two alternative values. Is there a way in the case_when function to combine "and" with "or" in one line of code? Say this is the first dataframe: df1 <- data.frame(company = c("A", "B", "C", "D"), since =… Read More mutate case_when and combined with or

This is not reproducible because my dataset is really large to post here. I am getting a warning that I don’t understand when using across inside mutate on the line of code below: mort %>% mutate(across(lifestage, factor, levels=c("larvae","adult", "postlarvae"))) There was 1 warning in `mutate()`. i In argument: `across(lifestage, factor, levels = c("larvae", "adult", "postlarvae"))`.… Read More across inside mutate warning

I wonder what I am doing wrong here. I am trying to use case_when() with summarise() to get a summary for each, depending on the number of rows for each id. library(dplyr, warn.conflicts = F) mock <- tibble::tribble(~id, ~name, ~year, 1, "xy", 2022, 1, "xyz", 2021, 2, "aaa", NA, 3, "xaa", 2021) mock %>% group_by(id)… Read More Summarise + case_when with n()

I have the following data frame in R. # Create a data frame with duplicates df <- data.frame( pagePath = c( "/page7", "/page9", "/page3", "/page9", "/page5", "/page7", "/page4", "/page9", "/page9", "/page4", "/page5", "/page7" ), country = c( "USA", "Canada", "UK", "Germany", "France", "India", "Australia", "Japan", "Brazil", "India", "South Africa", "Canada" ) ) I want to… Read More Custom Sort in R

I have DATA = data.frame(GROUP = c(1,2,1,2,1,2), TIME = c(1,1,2,2,3,3), SCORE = c(0,7,9,8,3,4)) and seek to create WANT = data.frame(GROUP = c(1,2,3,1,2,3,1,2,3), TIME = c(1,1,1,2,2,2,3,3,3), SCORE = c(0,7,7,9,8,17,3,4,7)) Where for each value of TIME I sum up the SCORE values for all GROUP I try without success, WANT = DATA %>% group_by(TIME) %>% rowwise() %>%… Read More R DPLYR Rowwise SUM

Is it possible to create multiple new columns based on a pattern of column names, and a function of multiple column values? For example set.seed(123) tibble(x = seq(1:10), bm_a = runif(10), val_a = runif(10), bm_b = runif(10), val_b = runif(10)) |> mutate(rel_a = val_a – bm_a, rel_b = val_b – bm_b) # A tibble: 10… Read More Use `across()` to create new columns with a function of multiple other columns

I have a dataframe as follows: df = data.frame(row.names = c("IL6", "AS-1", "KPMG", "DS55", "CD44", "Type"), Class1 = c(1, 19, 18, 11, 2, "ACC"), Class2 = c(3, 12, 20, 9, 12, "ACC"), Class3 = c(6, 5, 9, 16, 9, "BRCA"), Class4 = c(3, 9, 18, 15, 14, "BRCA"), Class5 = c(4, 20, 19, 19, 16,… Read More How replace values in the specific row in a dataframe using R?

My dataset records presentations to a location by an individual. This is tabulated below but included as a dput further down. Identifier date "A1" "28/01/2020" "A1" "01/04/2020" "A1" "16/08/2020" "A1" "20/08/2020" "A1" "30/08/2020" "A1" "31/10/2020" "A1" "14/11/2020" "A1" "26/11/2020" "A1" "25/12/2020" "A1" "04/05/2021" "A1" "08/05/2021" "A1" "26/07/2021" The individual attends sporadically and on occasions returns… Read More Identify index presentations and re-attendances within a 28 day period

I found a post very similar to my problem (subtract a constant vector from each row in a matrix in r), but I was hoping I could solve this using dplyr. I have a data.frame that looks like this: set.seed(1) toy_df <- data.frame(Patient.ID = letters[1:5], Patient.Age = rnorm(5,35,4), Protein.A = rnorm(5,100,10), Protein.B = rnorm(5,100,10), Protein.D… Read More Subtracting column values by a named vector in R

the key issue is i need it dynamic, as I many not know which columns are empty (especially if new ones are added). here is my current attempt based on code from here: singleAction <- tibble::tibble( datePublished = as.Date("2022/01/01"), title = "", summary = " ", createdby = "bob", customer = "james", contactAnalyst = "jack",… Read More R dplyr replace strings with only spaces, for all columns