Convert lists in a dataframe column into a single list in R

user_18825913 0
Viewed 44

I have a dataframe named df with only a column named Reviews:

Reviews
"Good, Excellent, I love this!"
"This is great, quality is good"
"Excellent service and quality, Good, amazing"

How could I convert the column into a single list as follows?:

Reviews 
"Good, Excellent, I love this!", "This is great, quality is good", "Excellent service and quality, Good, amazing"

I tried unnest but it is not suitable in this case as it returns Error in UseMethod("unnest"): no applicable method for 'unnest' applied to an object of class "list"

r
2 Answers

Try this

paste0(df$Reviews , collapse = ", ")
  • output
[1] "Good, Excellent, I love this!, This is great, quality is good, Excellent service and quality, Good, amazing"
user_191983370

Update: OP Request: We can do it this way:

df %>% 
  mutate(Reviews = paste0('"',Reviews,'"')) %>% 
  summarise(Reviews = toString(Reviews))

 Reviews
1 "Good, Excellent, I love this!", "This is great, quality is good", "Excellent service and quality, Good, amazing"
>

First answer: We could use toString with summarise

library(dplyr)
df %>% 
  summarise(Reviews = toString(Reviews))

1 Good, Excellent, I love this!, This is great, quality is good, Excellent service and quality, Good, amazing
>
user_133216470
Related