Home > Net >  splitting values in a dataframe R
splitting values in a dataframe R

Time:03-12

I have this data frame in R. name of df: POST

Order_id Postcalcode
1        5253HP
2        4261FF
44       5111QW

I want to split the numbers and the letters from the postal code because i only need the numbers so expected output is

Order_id Postalcode
1        5253
2        4261
44       5111

CodePudding user response:

library(magrittr)
library(dplyr)
library(stringr)

df %>% mutate(Postcalcode = str_extract(Postcalcode,"\\d "))

  Order_id Postcalcode
1        1        5253
2        2        4261
3       44        5111

CodePudding user response:

Also, tidyr::separate may be worth looking at. In the example below the split is taking place at the defined position.

dta <- readr::read_table(file = "
Order_id Postcalcode
1        5253HP
2        4261FF
44       5111QW")

tidyr::separate(
    data = dta,
    col = "Postcalcode",
    into = c("first_part", "second_part"),
    sep = 4,
    remove = FALSE
)

Results:

# A tibble: 3 × 4
  Order_id Postcalcode first_part second_part
     <dbl> <chr>       <chr>      <chr>      
1        1 5253HP      5253       HP         
2        2 4261FF      4261       FF         
3       44 5111QW      5111       QW   
  • Related