Find unique values and then retrieve all associated values

Asked Feb 22 '17 at 17:36

Active Feb 22 '17 at 17:45

Viewed 35 times

So i am trying to convert a file with over a million rows which looks like below for example:

But with a lot more rows. I want to convert this data frame into the format below:

I've used this so far:

subset(rawdata, !duplicated(rawdata$Col1))

where rawdata is the dataset. But this just gives the first corresponding value associated with each unique column.

edited Feb 22 '17 at 17:45

m0nhawk

asked Feb 22 '17 at 17:36

user1834217

Try `df1 <- unique(df);split(df1$col2, df1$col1)` – akrun Feb 22 '17 at 17:38
The problem is that there cannot be such a data frame. You could maybe use `tapply(DF$v, DF$id, FUN = unique)` or something. – Frank Feb 22 '17 at 17:38
`aggregate(V2~V1, df, function(x) paste(x, sep=' '))` – Sandipan Dey Feb 22 '17 at 17:40

0 Answers0