Advertisements I have a time data looks like this: 2024-01-26 19:24:40.0 I want to extract everything before the second colon like this: 2024-01-26 19:24 I tried the code as below: a="2024-01-26 19:24:40.0" b=sub("(^([^:]+:){2}).*$", "\\1",a) But the result was like this: 2024-01-26 19:24: So how to write the code in the right way? >Solution : Option… Read More How to extract all the strings before the second colon in r?
Advertisements I have this data frame. What I want to find is the maximum of row cumulative sums for each group given that they are adjacent and have values =1. For example, Group 1 has Year 1,2,3,4 adjacent and values add up =4, and year6 =1 so the max value is 4 for group 1… Read More Find max of row cumulative sum of adjacent columns by group in R
Advertisements I have a long string, the part is x <- "Text1 q10_1 text2 q17 text3 q22_5 …" How to subtract 1 from each number after "q" letter to obtain y <- "Text1 q9_1 text2 q16 text3 q21_5 …" I can extract all my numbers from x: numbers <- stringr::str_extract_all(x, "(?<=q)\\d+") numbers <- as.integer(numbers[[1]]) -… Read More How to subtract a number from string elements in R?
Advertisements I have a data frame where I wish to change any values from a 0 to an NA but only of the values of paired columns are both 0. I have attached an example below of what I currently have and what I am trying to return. I think to do this its best… Read More Chaning values to NA based on multiple columns
Advertisements I am trying to make the creation of a summary column within my data "future proof" for the case that another variable is added to the dataset. For this I tried using tidy-select language, but failed to accomplish this. a minimal example is: variables = c("v1", "v2") tst = tribble( ~ID, ~time, ~v1, ~v2,… Read More Use tidy-select to create a new summary variable with mutate
Advertisements I have a data frame – each individual has multiple visits. I want to filter out patients who had disease 2 after disease 1. In this case, I would pick out ID 2 & 4. ID <- c(1,1,2,2,2,3,3,3,4,4,4,4,5,5) Visit <- c(1,2,1,2,3,1,2,3,1,2,3,4,1,2) Disease <- c(2,2,1,2,1,1,1,1,1,1,1,2,2,1) df <- data.frame(ID, Visit, Disease) >Solution : A dplyr solution:… Read More Filter out individuals who developed diseases in a certain sequence
Advertisements I have a string which includes square brackets, sometimes this is a set of double square brackets and sometimes a set of single followed by a double set. My issue my issue here is that when i try to use gsub to remove these I can’t seem to remove both sets, depending on my… Read More Gsub with single and multiple square brackets
Advertisements I have a data frame as follows: comment_id <- c(1, 2, 2, 3, 4, 5, 6, 7, 8, 9, 10) cat <- c("acc_sp", "acc_lex", "org_gen", "acc_gen", "ran_lex", "arg_rel", "len", "org_lay", "org_spe", "org_gen", "coh_link") df <- data.frame(comment_id, cat) You’ll notice that there are two items with comment_id = 2. I need to create a new… Read More Adding a column based on counts of another column value in R
Advertisements I have two listing plot_overall_hema and plot_overall_chem. I would like to get get all names from each list to a df with name outputs. How can I achieve this goal? I can use codes like names(plot_overall_hema) to get the names from each list. Is it a more convenient way to get all names from… Read More How to get the names from multiple lists at once?
Advertisements Say I have a dataframe with families and I have the read counts for each sample. I want to return another dataframe that just shows me the sample in column 1, and which family is likely the biggest contributor to the total read count in that sample. Sample dataframe: structure(list(Family = c("Asteraceae", "Fabaceae", "Plantaginaceae",… Read More Get the categorical value for each column based on sum