How to make a column into a list in R

Asked Aug 12 '20 at 02:25

Active Aug 12 '20 at 02:25

Viewed 36 times

I'm looking to edit a column in my dataset so that I can make a collection of features one row instead of many. I've considered pivot_wider and dcast but they aren't quite what I'm looking to do.

I start with something like this reprex:

df <- data.frame(a = c(2,2,2,3,3,4,5,5,5,5),
                 b = c("sunshine","lollipops","rainbows","clouds","rain","dinner","headphones","pen","pencil","desk"))

Something like this is my goal.

df <- data.frame(a = c(2,3,4,5),
                 b = c("sunshine, lollipops, rainbows","clouds, rain","dinner","headphones, pen, pencil, desk"))

I appreciate any suggestions that you may have.

asked Aug 12 '20 at 02:25

sunshinegirl

1

`aggregate(b~a, df, toString)` – Ronak Shah Aug 12 '20 at 02:28
Not quite - I received this error: Error in as.data.frame.default(data, optional = TRUE) : cannot coerce class ‘"function"’ to a data.frame – sunshinegirl Aug 12 '20 at 02:31
Did you try it on the example that you have provided in your post? – Ronak Shah Aug 12 '20 at 02:34
I made a typo when copying the text. Thank you, that works! – sunshinegirl Aug 12 '20 at 03:12

How to make a column into a list in R

0 Answers0