How do I replace NA values with zeros in an R dataframe?

See my comment in @gsk3 answer. A simple example:

> m <- matrix(sample(c(NA, 1:10), 100, replace = TRUE), 10)
> d <- as.data.frame(m)
   V1 V2 V3 V4 V5 V6 V7 V8 V9 V10
1   4  3 NA  3  7  6  6 10  6   5
2   9  8  9  5 10 NA  2  1  7   2
3   1  1  6  3  6 NA  1  4  1   6
4  NA  4 NA  7 10  2 NA  4  1   8
5   1  2  4 NA  2  6  2  6  7   4
6  NA  3 NA NA 10  2  1 10  8   4
7   4  4  9 10  9  8  9  4 10  NA
8   5  8  3  2  1  4  5  9  4   7
9   3  9 10  1  9  9 10  5  3   3
10  4  2  2  5 NA  9  7  2  5   5

> d[is.na(d)] <- 0

> d
   V1 V2 V3 V4 V5 V6 V7 V8 V9 V10
1   4  3  0  3  7  6  6 10  6   5
2   9  8  9  5 10  0  2  1  7   2
3   1  1  6  3  6  0  1  4  1   6
4   0  4  0  7 10  2  0  4  1   8
5   1  2  4  0  2  6  2  6  7   4
6   0  3  0  0 10  2  1 10  8   4
7   4  4  9 10  9  8  9  4 10   0
8   5  8  3  2  1  4  5  9  4   7
9   3  9 10  1  9  9 10  5  3   3
10  4  2  2  5  0  9  7  2  5   5

There’s no need to apply apply. =)

EDIT

You should also take a look at norm package. It has a lot of nice features for missing data analysis. =)

Related Posts:

  1. Poker hand range chart visualization in R
  2. ggplot wrong color assignment
  3. How to rename a single column in a data.frame?
  4. Critical t values in R
  5. What does %>% function mean in R?
  6. t-stat for feature selection
  7. Reasons for using the set.seed function
  8. R on MacOS Error: vector memory exhausted (limit reached?)
  9. Remove legend ggplot 2.2
  10. R: Using equation with natural logarithm in nls
  11. How to change legend title in ggplot
  12. Error in do_one(nmeth) : NA/NaN/Inf in foreign function call (arg 1)
  13. kmeans complains “NA/NaN/Inf in foreign function call (arg 1)”, when there are none?
  14. Why use as.factor() instead of just factor()
  15. mean() warning: argument is not numeric or logical: returning NA
  16. R issue “object not found”
  17. How do I delete rows in a data frame?
  18. Error in grid.Call(L_textBounds, as.graphicsAnnot(x$label), x$x, x$y, : Polygon edge not found
  19. Having trouble setting working directory
  20. How can two strings be concatenated?
  21. SummarySE (Rmisc package) to produce a barplot with error bars (ggplot2)
  22. Remove a row from a data table in R
  23. R ggplot2 scale_y_continuous : Combining breaks & limits
  24. Add color to boxplot – “Continuous value supplied to discrete scale” error
  25. Error in file(file, “rt”) : invalid ‘description’ argument in complete.cases program
  26. Error in plot.window(…) : need finite ‘xlim’ valuescc
  27. rmarkdown error “attempt to use zero-length variable name”
  28. Error: Incorrect number of dimensions in R
  29. cannot coerce type ‘closure’ to vector of type ‘character’
  30. Error in lm.fit(x, y, offset = offset, singular.ok = singular.ok, …) : NA/NaN/Inf in ‘y’, tried every possible way
  31. Basic – T-Test -> Grouping Factor Must have Exactly 2 Levels
  32. R – longer object length is not a multiple of shorter object length
  33. How does one reorder columns in a data frame?
  34. R: Using equation with natural logarithm in nls
  35. remove legend title in ggplot
  36. scale_color_manual() not working
  37. Clear R environment of all objetcs & packages
  38. “replace” function examples
  39. Why I get this error writing data to a file
  40. R: need finite ‘ylim’ values in function
  41. Convert a list to a data frame
  42. Manually colouring plots with `scale_fill_manual` in ggplot2 not working
  43. Subscript out of bounds – general definition and solution?
  44. R: Error in eval(predvars, data, env) : numeric ‘envir’ arg not of length one in intrinsic.pars() in multgee package
  45. Correlation between multiple variables of a data frame
  46. Remove grid, background color, and top and right borders from ggplot2
  47. R: “Unary operator error” from multiline ggplot2 command
  48. What does the double percentage sign (%%) mean?
  49. not a Stata version 5-12 .dta file
  50. How to subset a Data frame column wise using column names?
  51. Error : length of ‘dimnames’ [2] not equal to array extent
  52. Mean of a column in a data frame, given the column’s name
  53. How can I plot data with confidence intervals?
  54. No non-missing arguments warning when using min or max in reshape2
  55. Unimplemented type list when trying to write.table
  56. How to convert a factor to integer\numeric without loss of information?
  57. Having trouble setting working directory
  58. Custom legend for multiple layer ggplot
  59. file.path function in R
  60. predict.lm() in a loop. warning: prediction from a rank-deficient fit may be misleading
  61. Convert categorical variables to numeric in R
  62. How to sum data.frame column values?
  63. Error: invalid subscript type ‘list’ in R
  64. “non-numeric argument to binary operator” error in R
  65. How to sum a variable by group
  66. readOGR() cannot open file
  67. What does “The following object is masked from ‘package:xxx'” mean?
  68. grep using a character vector with multiple patterns
  69. How to avoid “Error in stripchart.default(x1, …) : invalid plotting method” error?
  70. R error in unique.default(x) unique() applies only to vectors
  71. Unused arguments in R
  72. Combine two data frames by rows (rbind) when they have different sets of columns
  73. Boxplot dplyr: Error: non-numeric argument to binary operator
  74. How do I install an R package from source?
  75. Getting invalid model formula in ExtractVars when using rpart function in R
  76. Error: ggplot2 doesn’t know how to deal with data of class matrix?
  77. Aggregate multiple columns at once
  78. Error in match.fun(FUN)
  79. Error in file(filename, “r”, encoding = encoding) : cannot open the connection
  80. installing data.table results in “there is no package”
  81. What is integer overflow in R and how can it happen?
  82. R histogram range error: some ‘x’ not counted; maybe ‘breaks’ do not span range of ‘x
  83. Correct syntax for mutate_if
  84. Plotting data in R; error: default method not implemented for type ‘list’
  85. Error:attempt to apply non-function
  86. Error in contrib.url(repos, “source”) in R trying to use CRAN without setting a mirror Calls: install.packages -> contrib.url Execution halted
  87. Changing fonts in ggplot2
  88. Error in : target of assignment expands to non-language object
  89. How do I combine two data-frames based on two columns?
  90. How to eliminate “NA/NaN/Inf in foreign function call (arg 7)” running predict with randomForest
  91. Indicator function in R
  92. Batch convert columns to numeric type
  93. R4DS error comparison (1) is possible only for atomic and list types
  94. How can I make a list of lists in R?
  95. Error in x[[i]] : recursive indexing failed at level 2
  96. How to avoid “operations are possible only for numeric, logical or complex types” when computing top 3 elements in each group
  97. Warning: non-integer #successes in a binomial glm! (survey packages)
  98. Remove columns from dataframe where some of values are NA
  99. Difference between as.POSIXct/as.POSIXlt and strptime for converting character vectors to POSIXct/POSIXlt
  100. How to deal with “data of class uneval” error from ggplot2?

Leave a Comment

tech