Count NA in R

Channel:

DataDaft

Subscribers:

54,100

Published on May 15, 2019 8:18:54 PM ● Video Link: https://www.youtube.com/watch?v=t-45JcPN3N8

Duration: 1:51

5,149 views

86

Counting the NA values in a data frame is a common step when exploring and cleaning data.

Code used in this clip:

# Load data
df ＜- mtcars

# Set some values to NA
df[2:5, 5:7] ＜- NA

# Count total NA
sum(is.na(df))

# Count NA per column
colSums(is.na(df))

# Count NA per row
rowSums(is.na(df))



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.