Replace specific character from all columns of a dataframe

Question

Having a dataframe like this:

df <- data.frame(id = c(1,2), date1 = c("Nov 2016 <U+2192> Current", "Nov 2016 <U+2192> Current"), date2 = c("Nov 2016 <U+2192> Current", "Nov 2016 <U+2192> Current"))

Is there any command to replace this character in the whole dataframe?

Example:

df <- gsub(' <U+2192> ', '-', df)

@PanagiotisTogias for the whole dataframe not for one column — Erik Brole
– Erik Brole, Commented Oct 22, 2022 at 12:36
with dplyr : df %>% mutate(across(everything(), ~ gsub(' <U+2192> ', '-', ., fixed = TRUE))) — Panagiotis Togias
– Panagiotis Togias, Commented Oct 22, 2022 at 12:41

Panagiotis Togias · Accepted Answer · 2022-10-22 12:42:40Z

1

Placing it here also as an answer:

library(dplyr)

df %>% mutate(across(everything(), ~ gsub(' <U+2192> ', '-', ., fixed = TRUE)))

Output

  id            date1            date2
1  1 Nov 2016-Current Nov 2016-Current
2  2 Nov 2016-Current Nov 2016-Current

answered Oct 22, 2022 at 12:42

Panagiotis Togias

3333 silver badges13 bronze badges

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

Comments

Chris Ruehlemann · Accepted Answer · 2022-10-22 16:38:10Z

0

A base R solution with sapply:

df <- sapply(df, function(x) gsub(" <U\\+2192>", " -", x))

Note that + must be escaped unless you use the fixed = TRUE argument

df
     id  date1                date2               
[1,] "1" "Nov 2016 - Current" "Nov 2016 - Current"
[2,] "2" "Nov 2016 - Current" "Nov 2016 - Current"

answered Oct 22, 2022 at 16:38

Chris Ruehlemann

21.5k4 gold badges15 silver badges45 bronze badges

Collectives™ on Stack Overflow

Replace specific character from all columns of a dataframe

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related