How to replace all 0 values to NA but only in a part of data frame?

Question

I want to replace all 0 values to NA but only in subset of columns.

df <- data.frame(replicate(100,sample(0:9,1000,rep=TRUE)))

To change all 0 to NA in the entire df one should use

df[df == 0] <- NA

but I want to change 0 to NA only in subset of columns 5:100, I have tried

df[df == 0][ , 5:100] <- NA

df[df == 0][5:100] <- NA

df[ , 5:100][df == 0] <- NA
df[5:100][df == 0] <- NA
df[5:100][df[5:1000] == 0] <- NA
df[df[5:1000] == 0] <- NA
df[which(df[, 5:100] == 0)] <- NA
df[which(df[5:100] == 0)] <- NA

but all of that returns an error.

How to apply the operation to part of the df?

I had that but with a mistake (put 1000 instead of 100)

mschmidt
– mschmidt

2023-01-27 12:17:42 +00:00
Commented Jan 27, 2023 at 12:17 — mschmidt
– mschmidt, Commented Jan 27, 2023 at 12:17

Maël · Accepted Answer · 2023-01-27 13:06:22Z

2

You should do the subsetting on both df calls:

df[5:100][df[5:100] == 0] <- NA

Take this smaller example:

set.seed(1)
df <- data.frame(replicate(3,sample(0:9,10,rep=TRUE)))
df[2:3][df[2:3] == 0] <- NA

   X1 X2 X3
1   8  4  4
2   3  9  4
3   6  5  1
4   0  9  9
5   1  6  8
6   6  8 NA
7   1  4  3
8   2  4  2
9   0  8  5
10  4  8  9

edited Jan 27, 2023 at 13:06

answered Jan 27, 2023 at 11:35

Maël

53k6 gold badges47 silver badges85 bronze badges

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

Comments

Quinten · Accepted Answer · 2023-01-27 11:41:38Z

0

dplyr option using across and replace like this:

df <- data.frame(replicate(100,sample(0:9,1000,rep=TRUE)))

library(dplyr)
df %>%
  mutate(across(5:100, ~ replace(.x, .x == 0, NA)))

answered Jan 27, 2023 at 11:41

Quinten

42.8k12 gold badges58 silver badges117 bronze badges

Collectives™ on Stack Overflow

How to replace all 0 values to NA but only in a part of data frame?

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