Replace NA with 0 in R

Опубликовано: 29 Сентябрь 2024
на канале: DataDaft
8,246
120

Replacing NA values with 0 or some other value is a common data cleaning task.

Code used in this clip:


Identify NA and save as a logical index:
index = is.na(df)

Use the logical index to index into the Data Frame and assign 0
df[index] = 0

In one step:
df[is.na(df)] = 0


Code Clips are basic code explanations in 2 minutes or less. They are intended to be short reference guides that provide quick breakdowns and copy/paste access to code needed to accomplish common data science tasks. Think Stack Overflow with a video explanation.


* Note: YouTube does not allow greater than or less than symbols in the text description, so the code above will not be exactly the same as the code shown in the video! For R that means I may use = for assignment and the special Unicode large < and > symbols in place of the standard sized ones for dplyr pipes and comparisons. These special symbols should work as expected for R code on Windows, but may need to be replaced with standard greater than and less than symbols for other operating systems.