Split one row into multiple rows

Question

I have a column in a dataframe like the one below, each row contains multiple countries separated by ,

df <- data.frame(
                  countries = c(
                                "UK , Spain , Germany , Italy , Netherlands" , 
                                "UK , Canada , AUS , China" , 
                                "Spain , AUS , Italy , Russia"
                                )
                )

This is how data looks like

                   countries
1 UK , Spain , Germany , Italy , Netherland
2                 UK , Canada , AUS , China
3              Spain , AUS , Italy , Russia

How can we transform this to be something like below?

  countries
1   UK
2   Spain
3   Germany
4   Italy
5   Netherlands
6   UK
7   Canada
8   AUS
9   China
10  Spain
11  AUS
12  Italy
13  Russia

In case you have more column there, you could also do `library(splitstackshape) ; cSplit(df, "countries", direction = "long")` — David Arenburg, May 17 '15 at 06:16
Another option is `data.frame(countries=scan(text=gsub(' ', '', df$countries), what='', sep=','))` — akrun, May 17 '15 at 06:27

score 10 · Accepted Answer · edited Sep 09 '20 at 05:37

10

Just try:

data.frame(countries = unlist(strsplit(as.character(df$countries), " , ")))

edited Sep 09 '20 at 05:37

zx8754

52,746
12
114
209

answered May 17 '15 at 06:07

nicola

24,005
3
35
56

score 10 · Answer 2 · answered Jul 12 '19 at 02:01

10

You can use 'separate_rows' from "tidyr" package:

df = separate_rows(df,1,sep = ",")

answered Jul 12 '19 at 02:01

ALAKANANDA

101
1
2

Split one row into multiple rows

2 Answers2

Linked

Related