Create summary string of row contents by group using dplyr

Asked Apr 08 '21 at 21:19

Active Apr 08 '21 at 21:19

Viewed 14 times

I'm doing a group_by + summarize() operation on a large dataframe for a lot of groups and across a lot of rows. On the aggregated dataset (each line a group), I would like to concatenate all the row entries in one string per line.

library(dplyr)

df <- tribble(
  ~country, ~var,     
  "France", "Apple",  
  "France", "Pear",   
  "France", "Orange", 
  "France", "Apple",  
  "USA", "Pear",   
  "USA", "Pear",   
  "USA", "Orange" 
)

The output that should result is:

df_summarized <- tribble(
   ~country, ~summary,
  "France", "Apple, Pear, Orange, Apple", 
  "USA", "Pear, Pear, Orange"
)

asked Apr 08 '21 at 21:19

ulima2_

1,276
1
13
23

2

How about `df %>% group_by(country) %>% summarise(summary = paste(var,collapse = ", "))`? – Ian Campbell Apr 08 '21 at 21:22
Wow, didn't think it would be that easy - thanks! Should I withdraw the question? – ulima2_ Apr 08 '21 at 21:25
1

I closed it for you as a duplicate. It can act as a signpost if you want. – Ian Campbell Apr 08 '21 at 21:26

Create summary string of row contents by group using dplyr

0 Answers0