How to separate the data based on names present in a column?

Question

I have a data frame that looks this.

df <- data.frame(names = c("Ram","Siddhharth","Nithin","Aashrit","Bragadish","Sridhar"),
                 house = c("A", "B", "A", "B", "A", "B"))

I want to create a new data frame which gets re-arranged based on the house they are in.

Expected Output

house_A   house_B
1 Ram       Siddhharth
2 Nithin    Aashrit
3 Bragadish Sridhar

How can I achieve this? Many thanks in advance.

You can use `df %>% group_by(house) %>% mutate(row = row_number()) %>% pivot_wider(names_from = house, values_from = names, names_prefix = 'house_')` . This link has other options : https://stackoverflow.com/questions/11322801/transpose-reshape-dataframe-without-timevar-from-long-to-wide-format — Ronak Shah, Jun 28 '20 at 16:26
Does this answer your question? [R Reshape data frame from long to wide format?](https://stackoverflow.com/questions/50765323/r-reshape-data-frame-from-long-to-wide-format) — Jan, Jun 28 '20 at 16:53

score 3 · Accepted Answer · answered Jun 28 '20 at 15:49

3

You could use tidyr:

df %>%
  pivot_wider(names_from="house", names_prefix="house_", values_from="names", values_fn=list) %>%
  unnest(cols=everything())

This returns

# A tibble: 3 x 2
  house_A   house_B   
  <chr>     <chr>     
1 Ram       Siddhharth
2 Nithin    Aashrit   
3 Bragadish Sridhar

answered Jun 28 '20 at 15:49

Martin Gal

I am getting the following error when I run the code.Error in values_fn[[value]] : object of type 'builtin' is not subsettable – Sri Sreshtan Jun 28 '20 at 15:53
What's your package version? Please type in `packageVersion("tidyr")`. – Martin Gal Jun 28 '20 at 15:57
Tidyr package Version is 1.0.2 – Sri Sreshtan Jun 28 '20 at 15:59
Please update your `tidyr` package to `1.1.0` and try again. – Martin Gal Jun 28 '20 at 16:03

1 Answers1