How to separate Column string by ; and assign row value in R

Question

I have an example dataframe

df = data.frame(day = c("Monday", "Tuesday; Wednesday", "Thursday"),
                      c(2, 3, 5))

I want to separate all strings with "; " and assign the value of the second column like this:

      df_goal = data.frame(value= c("Monday", "Tuesday", "Wednesday", "Thursday"),
                           c(2, 3, 3, 5))

My original data is much larger so I am looking for larger scale applicable solution

Maël · Accepted Answer · 2022-09-14T08:00:07.773

1

Use separate_rows, by default, the default separator is punctuation signs; but you can manually indicate it using sep = "; "

library(tidyr)
separate_rows(df, day)
#separate_rows(df, day, sep = "; ")

output

  day       c.2..3..5.
  <chr>          <dbl>
1 Monday             2
2 Tuesday            3
3 Wednesday          3
4 Thursday           5

edited Sep 14 '22 at 08:00

answered Sep 14 '22 at 07:47

Maël

how do I add the separation condition "; " ? – math_ist Sep 14 '22 at 07:50
Use `sep = "; "` – Maël Sep 14 '22 at 07:51
inside the separate rows? like separate_rows(df, day, sep = "; ") ? – math_ist Sep 14 '22 at 07:52
Yep; see the answer. – Maël Sep 14 '22 at 07:53

1 Answers1