Count the number of null values in a dataframe

[jaiswal78]

Hi Community. I am new in R and need some help. I am working on a capstone project of the bike sharing app and have imported csv files into a dataframe and a few columns are having 'null' and 'na' values as shown in the screenshots below.

Can someone guide me how to get :-

1. A summary of the null and na values in the observations for all the variables
2. How to filter out the null and na values and create a new dataframe

[M_AcostaCH]

Hi @jaiswal78 , remember put a reproducible example of data for better help you all the community.

FAQ: How to do a minimal reproducible example ( reprex ) for beginners

A minimal reproducible example consists of the following items: A minimal dataset, necessary to reproduce the issue The minimal runnable code necessary to reproduce the issue, which can be run on the given dataset, and including the necessary information on the used packages. Let's quickly go over each one of these with examples: Minimal Dataset (Sample Data) You need to provide a data frame that is small enough to be (reasonably) pasted on a post, but big enough to reproduce your issue. Let's say, as an example, that you are working with the iris data frame head(iris) #> Sepal.Length Sepal.Width Petal.Length Petal.Width Species #> 1 5.1 3.5 1.4 0.…

Try with this:
Im make a toy data year21_22

year21_22 <- data.frame(A= c(1,2,NA,4,7),
                        B=c('amarillo',NA, 'rojo', NA, NA),
                        D=c(NA,NA,NA,NA,NA))


colSums(is.na(year21_22)

# NA in each column
# A B D 
# 1 3 5 

# For filter all rows with complete cases
year21_22_New=year21_22[complete.cases(year21_22),]

# A        B   D
# 1 amarillo 1