R: Replace multiple values in multiple columns of dataframes with NA

by

You can also do this using replace:

sel <- grepl("var",names(df))
df[sel] <- lapply(df[sel], function(x) replace(x,x %in% 3:4, NA) )
df

#  name foo var1 var2
#1    a   1    1   NA
#2    a   2    2   NA
#3    a   3   NA   NA
#4    b   4   NA   NA
#5    b   5    5   NA
#6    b   6    6   NA
#7    c   7    7    5
#8    c   8    8    5
#9    c   9    9    5

Some quick benchmarking using a million row sample of data suggests this is quicker than the other answers.

More Related Contents:

  1. How to replace NA values in a table for selected columns
  2. Combine two or more columns in a dataframe into a new column with a new name
  3. Replace all particular values in a data frame
  4. Match values in data frame with values in another data frame and replace former with a corresponding pattern from the other data frame
  5. apply a function over groups of columns
  6. Replace in a factor column
  7. Replace empty values with value from other column in a dataframe
  8. replacing values in a column with another column R
  9. Repeat each row of data.frame the number of times specified in a column
  10. Filter data.frame rows by a logical condition
  11. Split column at delimiter in data frame [duplicate]
  12. Pass a data.frame column name to a function
  13. Select groups based on number of unique / distinct values
  14. Remove an entire column from a data.frame in R
  15. Sample n random rows per group in a dataframe
  16. How to replace NaN value with zero in a huge data frame?
  17. Remove Rows From Data Frame where a Row matches a String
  18. duplicates in multiple columns
  19. R – add column that counts sequentially within groups but repeats for duplicates
  20. R self reference
  21. in R, use gsub to remove all punctuation except period
  22. Subsetting a data frame based on contents of another data frame
  23. How to complete missing factor levels in data frame?
  24. Calculate row-wise proportions
  25. Using lapply to apply a function over list of data frames and saving output to files with different names
  26. Return df with a columns values that occur more than once [duplicate]
  27. Row-wise sum of values grouped by columns with same name
  28. Replicate each row of data.frame and specify the number of replications for each row?
  29. R how can I calculate difference between rows in a data frame
  30. Color one point and add an annotation in ggplot2?

Leave a Comment