How to replace all NA in a dataframe using tidyr::replace_na?

r dplyr tidyr
zesla picture zesla · Aug 8, 2017 · Viewed 48.5k times · Source

I'm trying to fill all NAs in my data with 0's. Does anyone know how to do that using replace_na from tidyr? From documentation, we can easily replace NA's in different columns with different values. But how to replace all of them with some value? I have many columns...

Using mtcars dataset as an example:

mtcars [sample(1:nrow(mtcars), 4), sample(1:ncol(mtcars), 4)]<- NA
mtcars %>% replace_na( ??? )

Answer

Sagar picture Sagar · Aug 8, 2017

If replace_na is not a mandatory requirement, following code will work:

mtcars %>% replace(is.na(.), 0)

Reference Issue: https://stackoverflow.com/a/45574804/8382207

Related questions

Gather multiple sets of columns

I have data from an online survey where respondents go through a loop of questions 1-3 times. The survey software (Qualtrics) records this data in multiple columns—that is, Q3.2 in the survey will have columns Q3.2.1., Q3.2.2., and Q3.2.3.: …

Read More
Removing NA observations with dplyr::filter()

My data looks like this: library(tidyverse) df <- tribble( ~a, ~b, ~c, 1, 2, 3, 1, NA, 3, NA, 2, 3 ) I can remove all NA observations with drop_na(): df %>% drop_na() Or remove all NA observations in a single column (a for …

Read More
R spreading multiple columns with tidyr

Take this sample variable df <- data.frame(month=rep(1:3,2), student=rep(c("Amy", "Bob"), each=3), A=c(9, 7, 6, 8, 6, 9), B=c(6, 7, 8, 5, 6, 7)) I can use spread from tidyr to change this to wide format. > df[, -4] %>% spread(student, A) …

Read More