How can extract text by matching letters and characters?

user_15610709 0
Viewed 79

I have a data frame containing

Drug name
コージネイトＦＳバイオセット注２５０　２５０国際単位
アドベイト注射用５００　５００単位

I want to extract the the Japanese drug names and volume to create two new columns,

Drug_clean   Volume
コージネイト    250
アドベイト　　　500

In order to do this, I plan to identify the letter of F and specific character "注", but I don't know how to do that. Can you please tell me how can I achieve it?

Thank you.

stringr r
2 Answers

A few hurdles here - one is to extract the matches, and two is to convert Unicode to numeric. We can do this by defining a small translation function, and setting the appropriate locale.

df <- tibble(drug_name = c("コージネイトＦＳバイオセット注２５０　２５０国際単位", "アドベイト注射用５００　５００単位"))

library(stringr)
library(dplyr)
tmcn::setchs() # to set locale (Chinese here, might need an appropriate Japanese instead)

translate <- Vectorize(function(x){
  x <- strsplit(x, "")
  as.list(x[[1]]) %>%
    lapply(function(x){
      switch(x,
             "３" = 3, "７" = 7, "８" = 8, "２" = 2, "５" = 5,
             "４" = 4, "６" = 6, "１" = 1, "９" = 9, "０" = 0, NA
      )}) %>%
    paste0(collapse = "") %>% as.numeric()
})

df %>%
  transmute(
    Drug_clean = ifelse(str_detect(drug_name, "Ｆ"),
                        str_extract(drug_name, ".*(?=Ｆ)"),
                        str_extract(drug_name, ".*(?=注)")),
    Volume = translate(str_extract(drug_name, "[３７８２５４６１９０].{2}"))
  )

#>  A tibble: 2 x 2
#>  Drug_clean   Volume
#>  <chr>         <dbl>
#> 1 コージネイト    250
#> 2 アドベイト      500
user_148539070

With a character vector, you can use strsplit() from base with a | separating the different delimiters. From your example, you want the 1st element of each of these splits which the unlisted lapply() provides.

df<- rbind("コージネイトＦＳバイオセット注２５０　２５０国際単位",
          "アドベイト注射用５００　５００単位")

#extract the columns
library(dplyr)
Drug_clean <-strsplit(df,"Ｆ|注") %>% lapply(., `[[`, 1) %>% unlist()
Volume <- str_extract(df, "[３７８２５４６１９].{2}")

tibble(Drug_clean,Volume)
> tibble(Drug_clean,Volume)
# A tibble: 2 × 2
  Drug_clean   Volume
  <chr>        <chr> 
1 コージネイト ２５０
2 アドベイト   ５００

For getting as.numeric() for Volume column, follow @Donald Seinen's excellent switch() code.

user_20709990
Related