-1

df1 and df2

I have one df1 and I want to merge certain rows of specific columns based on the names of another column

Henrik
  • 65,555
  • 14
  • 143
  • 159
mk894
  • 33
  • 7

1 Answers1

1

An option is aggregate by specifying a formula with the rhs specifying the grouping column ('Name') and . for all the others ('Likes', 'How many hrs spend liking') and paste them together

aggregate(. ~ Name, df1, FUN = toString)
akrun
  • 874,273
  • 37
  • 540
  • 662
  • 1
    If you use the vector function `c` as your FUN you can keep the class of each column. – Daniel O Mar 28 '21 at 11:41
  • @DanielO It would return a `list` column. Not sure if the OP wants that – akrun Mar 28 '21 at 11:42
  • Thank you for the suggestion! What do you mean by rhs? So you mean it would be: df2 <- aggregate(Likes ~ Name, df1, FUN= toString) The next would be df3<- aggregate(How many hrs spend liking ~ Name, df1, FUN= toString) final_df <- cbind(df2,df3) – mk894 Mar 29 '21 at 01:03
  • @mk894 It means each of the columns are individually aggregated by Name with that single command. – akrun Mar 29 '21 at 04:58