How to add new row with concatenated strings for each group?

Asked Jun 29 '22 at 13:45

Active Jun 29 '22 at 13:45

Viewed 26 times

df <- tribble(~ID, ~Text,
              "Q1", "Never",
              "Q1", "Sometimes",
              "Q1", "Always",
              "Q2", "Agree",
              "Q2", "Disagree")

I tried using add_row and paste, but it obviously gives me an error. I also get a "Can't add rows to grouped data frames" error

df %>%
  group_by(ID) %>%
  add_row(ID, paste(Text, sep = "; "))

I'm trying to get something like this:

ID	Text
Q1	Never
Q1	Sometimes
Q1	Always
Q1	Never; Sometimes; Always
Q2	Agree
Q2	Disagree
Q2	Agree; Disagree

asked Jun 29 '22 at 13:45

writer_typer

4

This should work: `df %>% group_by(ID) %>% group_modify(~add_row(.x, Text=paste(.x$Text, collapse = "; ")))` – MrFlick Jun 29 '22 at 13:48
2

Don't know why this question was closed with a non relevant link given in the closure. – stefan_aus_hannover Jun 29 '22 at 14:34

How to add new row with concatenated strings for each group?

0 Answers0