Code snippet to find number of null values in each column in a dataframe in R

Question

Hi. Can someone help me to create R code to find number of null values in each column in a dataframe? I want group of statements to find number of nulls in a single function than finding for each column separately.

Answer 1

Hi @prakash, Use lapply function() to find the length for each column.

R code - 

lapply(data_frame,function(x) { length(which(is.na(x)))})

Ex: I used Air quality dataset available in R datasets.

Hope it helps!

Answer 2

You can also use summary(data_frame) to see the number of nulls for every column at the last row.

Answer 3

colSums(is.na(data_frame_name)) will return you number of nulls in each column.