R dplyr/tidyr Duplicate Rows

Asked Jan 24 '20 at 04:45

Active Jan 24 '20 at 04:59

Viewed 19 times

I have a multiple countries in a cell. I need duplicate rows for each country. Would prefer dplyr/tidyr if possible.

Original data:

df_in <- data.frame(Invoice = c("12345","54321"),
                    Dollar = c(1000,2000),
                     Country = c("Argentina, Chile, Colombia, Mexico, Venezuela","Japan, China, Korea"))
df_in
#  Invoice Dollar                                       Country
#1   12345   1000 Argentina, Chile, Colombia, Mexico, Venezuela
#2   54321   2000                           Japan, China, Korea

Output needed:

df_out <- data.frame(Invoice = c("12345","12345","12345","12345","12345","54321","54321","54321"),
                 Dollar = c(1000,1000,1000,1000,1000,2000,2000,2000),
                 Country = c("Argentina","Chile","Colombia","Mexico","Venezuela","Japan","China","Korea"))
df_out

#  Invoice Dollar   Country
#1   12345   1000 Argentina
#2   12345   1000     Chile
#3   12345   1000  Colombia
#4   12345   1000    Mexico
#5   12345   1000 Venezuela
#6   54321   2000     Japan
#7   54321   2000     China
#8   54321   2000     Korea

edited Jan 24 '20 at 04:59

Ronak Shah

377,200
20
156
213

asked Jan 24 '20 at 04:45

jayfrost

`tidyr::separate_rows(df_in, Country, sep = ",")` – Ronak Shah Jan 24 '20 at 04:50
This is my first time posting a question. How can I show the output table as part of the code above? – jayfrost Jan 24 '20 at 04:53
you need to paste it the same way as your input. I have edited your post to show output. – Ronak Shah Jan 24 '20 at 05:00
@RonakShah, that worked perfectly. Thanks so much! – jayfrost Jan 24 '20 at 05:00

R dplyr/tidyr Duplicate Rows

0 Answers0