How to find missing values?

[aakash2world]

I am having an excel document with two sheets containing survey data .
Sheet 1 one contains a list of around 21,000 responses for which Assembly Constituency names(AC), Mandal and Village Names are missing and Sheet 2 contains a list of tablets (2224 responses) in use in different villages in different dates.
Q ) how to find missing Village Names from the survey data using R programming?

[jalFaizy]

You can refer this answer:

How to count the missing value in R

Hi @harry Hope you got the answer from Above replies .If your not getting have a look at this might be helpful!!! If You need NA count of all — table(is.na(z)) If you need NA count Column wise – sapply(z, function(x) sum(is.na(x))) If you need NA count Row wise — rowSums(is.na(z)) Hope it Useful Regards Raghavendra

[sauravkaushik8]

Hi @aakash2world,

1. You can use is.na(data_file) in R to find the missing values.

2. To get the total no. of missing values, you can use sum(is.na(data_file)),

3. You can also use the following command to get the columns with the proportion of missing values in them:

sort(sapply(data_file,function(x){sum(is.na(x))/length(x)}),decreasing = T)

Hope this helps.