Replacing NA's in a dataframe/tibble

[cardinal400]

I've been using the following code to replace NA's with zeros:

mutate_all(funs(replace(., is.na(.), 0)))

Is there some more elegant option out there?

Thanks for your help.

[sharlagelfand]

tidyr::replace_na() may be helpful (if your number of variables is not too large + cumbersome to write out manually)!

Replace NAs with specified values — replace_na

[cardinal400]

Thanks for the suggestion to look again at replace_na. After some more experimentation these worked well and are slightly simpler:

mutate_all(funs(replace_na(., 0)))
mutate_if(is.numeric, funs(replace_na(., 0)))

[sharlagelfand]

Oh right, I forgot you could use mutate_all + replace_na and not have to type them all out

[jdlong]

That's a good solution. I've been using:

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

but it does not fit in a pipe chain very smoothly. I really like

mutate_if(is.numeric, funs(replace_na(., 0)))

thanks for sharing what you figured out!

[mara]

If your question's been answered (even if by you), would you mind choosing a solution? (See FAQ below for how).

Having questions checked as resolved makes it a bit easier to navigate the site visually and see which threads still need help.

FAQ: How do I mark a solution?

If your question has been answered, don't forget to mark the solution! How do I mark a solution? Find the reply you want to mark as the solution and look for the row of small gray icons at the bottom of that reply. Click the one that looks like a box with a checkmark in it: [image] Hovering over the mark solution button shows the label, "Select if this reply solves the problem". If you don't see the mark solution button, try clicking the three dots button ( ••• ) to expand the full set of options. When a solution is chosen, the icon turns green and the hover label changes to: "Unselect if this reply no longer solves the problem". Success! [solution_reply_author] …

Thanks