Splitting strings into multiple columns using str_split

Question

i'm trying to use str_split to split this:

col
a_b_c
c_d_e

into this:

col_1	col_2	col_3
a	b	c
c	d	e

here's the code but i'm getting an error on the replacement rows not matching


  df %>%
  dplyr::mutate(
    col_1 = stringr::str_split(
      string = col, 
      pattern = "_", 
      simplify = T)[,1],
    col_2 = stringr::str_split(
      string = col, 
      pattern = "_", 
      simplify = T)[,2],
    col_3 = stringr::str_split(
      string = col, 
      pattern = "_", 
      simplify = T)[,3])

TarJae · Accepted Answer · 2022-08-04 22:34:26Z

2

We could use separate for this:

library(dplyr)
library(tidyr)

df %>% 
  separate(col, c("col_1", "col_2", "col_3"))

  col_1 col_2 col_3
1     a     b     c
2     c     d     e

answered Aug 4, 2022 at 22:34

TarJae

80.2k6 gold badges30 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Chris · Accepted Answer · 2022-08-04 22:56:21Z

1

Using strsplit

col <- c('a_b_c', 'c_d_e')
matrix(unlist(strsplit(col, '_')), nrow=2, ncol = 3, byrow = TRUE)
     [,1] [,2] [,3]
[1,] "a"  "b"  "c" 
[2,] "c"  "d"  "e"

answered Aug 4, 2022 at 22:56

Chris

2,3992 gold badges22 silver badges33 bronze badges

Comments

PaulS · Accepted Answer · 2022-08-04 23:30:49Z

1

Yet another solution, based on tidyr::extract:

library(tidyverse)

extract(df, col, str_c("col_", 1:3), "(.*)_(.*)_(.*)")

#>   col_1 col_2 col_3
#> 1     a     b     c
#> 2     c     d     e

answered Aug 4, 2022 at 23:30

PaulS

27.1k3 gold badges18 silver badges40 bronze badges

Comments

Mohamed Desouky · Accepted Answer · 2022-08-04 23:01:05Z

0

We can use

library(stringr)

data.frame(do.call(rbind , str_split(df$col , "_")))

output

  X1 X2 X3
1  a  b  c
2  c  d  e

answered Aug 4, 2022 at 23:01

Mohamed Desouky

4,4452 gold badges6 silver badges21 bronze badges

Collectives™ on Stack Overflow

Splitting strings into multiple columns using str_split

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related