how to collapse a data frame based on a specific column

Asked Nov 26 '21 at 13:15

Active Nov 26 '21 at 13:15

Viewed 316 times

I have a data frame like this:

   symbol ls1   lsp10   ls02    ls6 
    a   ""  gh  ""  "" 
    a   ""  ""  ""  "" 
    b   ""  ""  gh  "" 
    df  ""  ""  ""  lm 
    b   gh  ""  ""  ""

how can I convert this to below table:

 symbol   ls1   lsp10   ls02    ls6 
    a   ""  gh  gh  "" 
    b   gh  ""  gh  "" 
    df  ""  ""  ""  lm

I tried below code but didn't worked

result <- aggregate(. ~ symbol, data = df, paste)

asked Nov 26 '21 at 13:15

minoo

`result <- aggregate(. ~ symbol, data = df, paste0, collapse = '')` – Ronak Shah Nov 26 '21 at 13:17
try `aggregate(. ~ symbol, df, max)` – ThomasIsCoding Nov 26 '21 at 13:19
Thanks Ronak, it worked with your response. – minoo Nov 29 '21 at 09:16

how to collapse a data frame based on a specific column

0 Answers0