python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - tidyr

How to use separate_rows in tidverse when the sep is ;

I have a data frame whose one of the column has this data. info1@domain.com; info2@domain.com; info3@domain.com q= tibble("info1@domain.com; info2@domain.com; info3@domain.com") sepa...
test-img

AJAY

r

string

split

tidyr

Votes: 0

Answers: 2

Latest Answer

You need to specify the column. For your one and only column: separate_rows(q,1 ,sep = ";") # A tibble: 3 × 1 `"info1@domain.com; info2@domain.com; info3@domain.com"` <chr...
test-img

Dave2e

Creating multiple rows from a complex string in R

Example of string in question called gene_snps: "ultra_rare_variant_chr9:23143143_A/C_chr9:5322432_G/T_chr9:9840984342_T/C;chr9:5324234:G/T;chr9:324424_T/A" Desired outcome: markerID chr9:...
test-img

tacrolimus

r

string

dplyr

tidyr

Votes: 0

Answers: 3

Latest Answer

We just need to use a regex with a lookahead: library(stringr) x = str_split(str, '[_;](?=chr)', simplify = T)[-1] x [1] "chr9:23143143_A/C" "chr9:5322432_G/T" "chr9:98...
test-img

divibisan

How to reshape using R for multiple value columns across one gather column

I want to reshape my data from wide to long using specific columns but create multiple value columns. Pasting below an example: data <- read.table(header=T, text=' hhid villageid hh_1 hh_2 ag...
test-img

user2905919

r

reshape

tidyr

Votes: 0

Answers: 2

Latest Answer

Using tidyr::pivot_longer which superseded gather plus some additional data wrangling steps you could do: library(tidyr) library(dplyr) data %>% pivot_longer(-c(hhid, villageid), names_to = c(&...
test-img

stefan

How to sort data in descending order based on every second value in R?

I am using dplyr for most of my data wrangling in R. Yet, I am having a hard time achieving this particular effect. Can't also seem to find the answer by googling either. Assume I have data like this ...
test-img

bajun65537

r

dplyr

tidyverse

tidyr

data-wrangling

Votes: 0

Answers: 2

Latest Answer

One approach using a join: df %>% filter(year == 2021) %>% # group_by(person) %>% slice(2) %>% ungroup() %>% #each person's yr2 arrange(-cash) %>% select(-cash, -year) %>...
test-img

Jon Spring

Posts

Questions

Blogs

Jobs