Replace NA with Zero in dplyr without using list()

r dplyr na
stackinator picture stackinator · Apr 20, 2018 · Viewed 39.3k times · Source

In dplyr I can replace NA with 0 using the following code. The issue is this inserts a list into my data frame which screws up further analysis down the line. I don't even understand lists or atomic vectors or any of that at this point. I just want to pick certain columns, and replace all occurrences of NA with zero. And maintain the columns integer status.

library(dplyr)
df <- tibble(x = c(1, 2, NA), y = c("a", NA, "b"), z = list(1:5, NULL, 10:20))
df
df %>% replace_na(list(x = 0, y = "unknown"))

That works but transforms the column into a list. How do I do it without transforming the column into a list?

And here's how to do it in base R. But not sure how to work this into a mutate statement:

df$x[is.na(df$x)] <- 0

Answer

Oliver Oliver picture Oliver Oliver · Mar 31, 2020

To replace all NAs in a dataframe use

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

Related questions

Removing NA in dplyr pipe

I tried to remove NA's from the subset using dplyr piping. Is my answer an indication of a missed step. I'm trying to learn how to write functions using dplyr: > outcome.df%>% + group_by(Hospital,State)%>% + arrange(…

Read More
Correct syntax for mutate_if

I would like to replace NA values with zeros via mutate_if in dplyr. The syntax below: set.seed(1) mtcars[sample(1:dim(mtcars)[1], 5), sample(1:dim(mtcars)[2], 5)] <- NA require(dplyr) mtcars %>% mutate_if(is.na,0) mtcars %>% mutate_…

Read More
How to replace empty string with NA in R dataframe?

My first approach was to use na.strings="" when I read the data in from a csv. This doesn't work for some reason. I also tried: df[df==''] <- NA Which gave me an error: Can't use matrix …

Read More