How to replace NA values in a table for selected columns

by

You can do:

x[, 1:2][is.na(x[, 1:2])] <- 0

or better (IMHO), use the variable names:

x[c("a", "b")][is.na(x[c("a", "b")])] <- 0

In both cases, 1:2 or c("a", "b") can be replaced by a pre-defined vector.

More Related Contents:

  1. Replace in a factor column
  2. Aggregate / summarize multiple variables per group (e.g. sum, mean)
  3. How do I replace NA values with zeros in an R dataframe?
  4. Replacing character values with NA in a data frame
  5. Assign multiple columns using := in data.table, by group
  6. Omit rows containing specific column of NA
  7. Count NAs per row in dataframe [duplicate]
  8. Subset of rows containing NA (missing) values in a chosen column of a data frame
  9. Match values in data frame with values in another data frame and replace former with a corresponding pattern from the other data frame
  10. Remove columns from dataframe where some of values are NA
  11. How to subset data in R without losing NA rows?
  12. How to delete columns that contain ONLY NAs?
  13. Merge rows in a dataframe where the rows are disjoint and contain NAs
  14. Replace logical values (TRUE / FALSE) with numeric (1 / 0)
  15. Randomly insert NAs into dataframe proportionaly
  16. R: Replace multiple values in multiple columns of dataframes with NA
  17. Select last non-NA value in a row, by row
  18. Replace a value NA with the value from another column in R
  19. Cleaning `Inf` values from an R dataframe
  20. Replace empty values with value from other column in a dataframe
  21. write.csv for large data.table
  22. Select NA in a data.table in R
  23. Replace all NA with FALSE in selected columns in R
  24. DT[!(x == .)] and DT[x != .] treat NA in x inconsistently
  25. Merge overlapping ranges into unique groups, in dataframe
  26. Convert a data frame to a data.table without copy
  27. Find columns with all missing values
  28. R: replacing NAs in a data.frame with values in the same position in another dataframe
  29. Move NAs to the end of each column in a data frame
  30. What you can do with a data.frame that you can’t with a data.table?

Leave a Comment