How to remove a character in the dataframe using the stringi package?

Question

I currently have a dataframe of stock KPIs and I would like to remove the "$" character from the data. However, I can only use one line of code in addition to the mandatory usage of the stringi package. Looking at the documentation, the "stri_replace_all_fixed" was the function that stood out to me, but upon running that function, my data frame lost its formatting. I tried combining both the lapply and the stri_replace_all_fixed functions to no avail. Pointers on how to address this problem would be much appreciated.

Post an example dataset using `dput(head(yourdataframe))` – IRTFM Nov 13 '17 at 23:56 — IRTFM, Nov 13 '17 at 23:56

CER · Accepted Answer · 2017-11-14T15:34:11.443

0

With library(stringi)

yourdataframe[] <- lapply(yourdataframe, stri_replace_all_regex,"\\$", "")

edited Nov 14 '17 at 15:34

answered Nov 14 '17 at 01:14

CER

784
7
20

score 0 · Answer 2 · answered Nov 14 '17 at 01:19

# Dummy data
dta <- data.frame(group = rep(LETTERS[1:5], 10)) %>%
    mutate(value = sample(1:10, 50, replace = TRUE) %>% paste("$"))

# scrub a dub (using dplyr)
dta %>% mutate_all(funs(stri_replace_all_fixed(., "$", "")))

and it is one of the faster approaches, too: replacement drag races

How to remove a character in the dataframe using the stringi package?

2 Answers2