Inserting Column By Grouping Values in different column with Commas

Question

I have a dataframe as follows:

COL1     COL2 
Dest1    SMALL
Dest1    MED
Dest2    SMALL
Dest3    LARGE

I want convert it to this:

COL1     COL2        COL3
Dest1    SMALL    SMALL, MED
Dest1    MED      SMALL, MED
Dest2    SMALL       SMALL
Dest3    LARGE       LARGE

I tried something like this but I don't know how to get the comma in there.

library(dplyr)
df2 <- df %>% group_by(COL1) %>% mutate(COL3 = paste(COL2))

score 0 · Accepted Answer · answered Jun 28 '16 at 19:11

0

Nevermind I figured it out:

df2<-df %>% group_by(COL1) %>% mutate(COL3=paste(COL2, sep="", collapse=","))

answered Jun 28 '16 at 19:11

nak5120

1

There's a function for that `df %>% group_by(COL1) %>% mutate(COL3=toString(COL2))` – Pierre L Jun 28 '16 at 19:14
1

By the way, you might want to `sort` and `unique` COL2 before pasting, depending on why you're doing it. – Frank Jun 28 '16 at 19:16
@Frank yes I ended up taking the unique values in the end. Thanks! – nak5120 Jun 29 '16 at 02:34

score 0 · Answer 2 · answered Jun 30 '16 at 15:23

0

Maybe this is an another option using base function

aggregate(data = df,COL2~COL1,FUN = paste)

answered Jun 30 '16 at 15:23

user2100721

2 Answers2