Conditional replacement of values in entire dataframe

Question

What's the appropriate way to replace values within an entire data frame, without specifying rows or columns?

Let's assume that I'd like to replace all values where abs(x) > .5 by <- "duck"

In this case

> df <- data.frame(a = rnorm(5), b = rnorm(5), c = rnorm(5))
> df
            a          b          c
1  1.37481216 -0.1760366 -0.5122730
2  0.09204844 -0.4270991  0.3211998
3 -0.43563818  0.7560178  0.5399643
4 -0.02078887  0.5961020 -0.5985515
5  0.99129234 -0.9959395 -0.6488177

the desired output would be

            a          b          c
1  "duck"     -0.1760366  "duck"
2  0.09204844 -0.4270991  0.3211998
3 -0.43563818  "duck"     "duck"
4 -0.02078887  "duck"     "duck"
5  "duck"      "duck"     "duck"

While this post requires a specification of columns, I'm looking for a dynamic replacement for the entire data frame.

Thanks

Wimpel · Accepted Answer · 2018-09-10T12:46:52.797

1

Base R

df[abs(df) > 0.5] <- "duck"

edited Sep 10 '18 at 12:46

answered Sep 10 '18 at 11:26

Wimpel

26,031
1
20
37

score 1 · Answer 2 · answered Sep 10 '18 at 11:27

1

Using replace:

replace(df,abs(df)>0.5,"duck")

answered Sep 10 '18 at 11:27

Saurabh Chauhan

3,161
2
19
46

score 1 · Answer 3 · answered Sep 10 '18 at 11:33

1

A dplyr solution:

df %>% 
  mutate_all(funs(ifelse(abs(.) > .5, "duck", .)))

answered Sep 10 '18 at 11:33

tmfmnk

38,881
4
47
67

Conditional replacement of values in entire dataframe

3 Answers3