How to combine columns into single column in R

Question

so I'm new to coding and need some help with data cleaning/organizing. My data currently looks like this:

Date                  Case Num                  Name
12/16                  1, 2                     Smith, John
12/16                  3, 4                     Smith, John
01/17                  5, 6                     Smith, John

And I want it to look like this:

Date                  Case Num                  Name
12/16                  1                        Smith, John
12/16                  2                        Smith, John
12/16                  3                        Smith, John
12/16                  4                        Smith, John
01/17                  5                        Smith, John
01/17                  6                        Smith, John

Please help. Thank you!

Could you post some code with what you have already try? – SirPeople Jul 02 '18 at 14:26 — SirPeople, Jul 02 '18 at 14:26

score 2 · Answer 1 · answered Jul 02 '18 at 14:21

2

library(tidyverse)
dat%>%
  mutate(Case.Num=strsplit(Case.Num,","))%>%
  unnest()
   Date        Name Case.Num
1 12/16 Smith, John        1
2 12/16 Smith, John        2
3 12/16 Smith, John        3
4 12/16 Smith, John        4
5 01/17 Smith, John        5
6 01/17 Smith, John        6

answered Jul 02 '18 at 14:21

Onyambu

67,392
3
24
53

Thank you so much!! – Anna Rouw Jul 02 '18 at 14:31

score 1 · Answer 2 · answered Jul 02 '18 at 14:25

You can use separate_rows from the tidyr package

library(tidyr)
df1 %>% separate_rows(Case_Num)

   Date Case_Num        Name
1 12/16        1 Smith, John
2 12/16        2 Smith, John
3 12/16        3 Smith, John
4 12/16        4 Smith, John
5 01/17        5 Smith, John
6 01/17        6 Smith, John

data:

df1 <- structure(list(Date = c("12/16", "12/16", "01/17"), 
                      Case_Num = c("1, 2","3, 4", "5, 6"), 
                      Name = c("Smith, John", "Smith, John", "Smith, John")), 
                 class = "data.frame", 
                 row.names = c(NA, -3L))

How to combine columns into single column in R

2 Answers2