python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - tidyr

Use `pivot_longer` to turn a 1x4 table into a 2x2 one

I have a 1-by-4 table that contains summary statistics of two variables. For example, df <- data.frame( x_min=1, x_max=2, y_min=3, y_max=4) df x_min x_max y_min y_max 1 1 2 3...
test-img

Herr K.

r

tidyr

Votes: 0

Answers: 2

Latest Answer

You could do: df <- data.frame( x_min=1, x_max=2, y_min=3, y_max=4) tidyr::pivot_longer(df, everything(), names_to = c(".value", "name"), names_sep = "_") #&g...
test-img

stefan

Reshape data with header rows

I have data in this form, where a separate column is included in a separate row at the start of group of detail records data <- data.frame(detail = c("", "Sue", "Fred"...
test-img

Chris

r

tidyr

Votes: 0

Answers: 1

Latest Answer

here is a data.table approach library(data.table) # set to data.table fotmat setDT(data) # set "" as NA data[data == ""] <- NA # fill NA's data[, group := zoo::na.locf(group)] ...
test-img

Wimpel

Struggling to unnest tibble (dput, code, and error included) in r

I'm trying to unnest a species count tibble so I can turn it into a dataframe. The last four columns are species counts and are currently in 'list' form (seems nested?). I'd like to have each column a...
test-img

Bill_marinestats98

r

tidyr

tibble

unnest

dput

Votes: 0

Answers: 2

Latest Answer

You can use apply for this: cols_count <- colnames(tibble)[7:10] # select relevant cols #Overwrite relevant parts of the dataframe tibble[cols_count] <- apply(tibble[cols_count], ...
test-img

Sandwichnick

Fill Columns with TRUE or FALSE based on other Dataframe

Unfortunately I have a problem and would have to ask for your support. I have a list of the most popular pet names. From the dataframe x, it appears that "Jerry" is the most popular mouse na...
test-img

RKF

r

tidyverse

tidyr

data-wrangling

Votes: 0

Answers: 4

Latest Answer

Another approach with left_join. What is different with the above solutions is that I only use one left_join, and use an ifelse statement to assign NA to FALSE, others to TRUE. library(tidyverse) lef...
test-img

benson23

Posts

Questions

Blogs

Jobs