Split column into rows when the Delimiter is vertical bar ( | ) in R

Question

#Input Table :-

Movie  Genre


Avatar Action|Sci-Fi


#Output Table Required <- 

Movie   Genre

Avatar        Action

Avatar         Sci-Fi

#Consider the name of the dataframe is input

I tried

output <-separate_rows(input, genre)

The resulted in :-

Avatar        Action

Avatar         Sci

Avatar    Fi

Which is not what is required

You can give a separator to `separate_rows`. If you look at the docs, it separates by punctuation marks by default, which includes `-` — camille, Jan 05 '20 at 16:54

score 2 · Accepted Answer · answered Jan 05 '20 at 16:53

2

Try separate_rows(input, genre, sep='\\|')

(sep is a regular expression so the | needs to be escaped with \\.)

answered Jan 05 '20 at 16:53

Kent Johnson

3,320
1
22
23

Upvote but I'm closing as dupe. – Rui Barradas Jan 05 '20 at 16:55

Split column into rows when the Delimiter is vertical bar ( | ) in R

1 Answers1

Related