Replace specific value in R

Question

I know it's something it should be easy but somehow I am stuck I am trying to eliminate an outlier, replacing it for NA dat is my data, and the value is what I want to modify

dat[dat$i_huvisfatin_v00 == 16527.98, "i_huvisfatin_v00"] <- NA

Error in `[<-.data.frame`(`*tmp*`, dat$i_huvisfatin_v00 == 16527.98, "i_huvisfatin_v00",  : 
  missing values are not allowed in subscripted assignments of data frames

dat[dat$i_huvisfatin_v00 == "16527.98", "i_huvisfatin_v00"] <- NA

Error in `[<-.data.frame`(`*tmp*`, dat$i_huvisfatin_v00 == 16527.98, "i_huvisfatin_v00",  : 
  missing values are not allowed in subscripted assignments of data frames

What am I doing wrong?

`dat$i_huvisfatin_v00[dat$i_huvisfatin_v00 == 16527.98] <- NA` ? — xilliam, Feb 14 '22 at 10:33

benson23 · Accepted Answer · 2022-02-14T10:32:37.217

0

From your error message, it's either your dat$i_huvisfatin_v00 column doesn't contain the value 16527.98, or it already have NA in the column.

dat$i_huvisfatin_v00 == 16527.98 returns a logical vector, which cannot be treated as index itself if it contains NA. Use which() in the row index seems to solve the problem.

dat[which(dat$i_huvisfatin_v00 == 16527.98), "i_huvisfatin_v00"] <- NA

edited Feb 14 '22 at 10:32

answered Feb 14 '22 at 10:24

benson23

16,369
9
19
38

Exactly, the column already had NA in other rows. Thanks – Javier Hernando Feb 14 '22 at 10:37

Replace specific value in R

1 Answers1