Finding number of missing values and removing those missing values from a data-frame

Question

I have this data-frame "Box_Category" with missing values:

ID        Category       Count
1            A             10
2            F             10
3            NA            13
4            B             NA
5            C             NA
6            NA            12
7            D             9
8            NA            NA
9            C             10

There are 5312 rows in total and I would want to find out the total number of NA values in the enitre data-set and remove all those NA values.

Answer 1

This code gives the total number of missing values:

sum(is.na(Box_Category))

Now, you can go ahead remove all the NA values with this command:

na.omit(Box_Category)

Answer 2

To find number of missing values for each column.

lapply(Box_Category[-1],function(x) { length(which(is.na(x))) })

and to remove them try this.

Box_Category = Box_Category[-which(is.na(Box_Category)),]