Replace values in R dataframe based on conditions

Question

In R, I'm using a for loop with an if statement to replace all values in a dataframe that fall outside of a certain range.

for (i in seq_along(df$Age)) {
  if (df$Age[[i]] > 90 || df$Age[[i]] < 16) {
    df$Age[[i]] <- NA
  }
}

This seems like clunky code. Is there a faster, easier way to do this?

`df$Age[df$Age > 90 | df$Age < 16] <- NA`? – r.user.05apr Jul 25 '18 at 14:21 — r.user.05apr, Jul 25 '18 at 14:21

score 2 · Accepted Answer · answered Jul 25 '18 at 14:22

2

Yes! There's a command called replace:

df$Age <- with(df, replace(Age, Age > 90 | Age < 16, NA))

answered Jul 25 '18 at 14:22

Jake Fisher

1

I have four reference books on R that I read through, and I searched extensively online with phrases like "R replace," and for whatever reason, I wasn't able to find that simple solution... so thank you! Much appreciated. – EmotionResearcher Jul 25 '18 at 15:02

1 Answers1