How can I get the total counts of columns in a Dataset having null values?

Question

Say I have a dataset having 100 columns and 25 columns having one or more null values.

How can I get the total counts of columns as the output say something like out of 100 columns 25 columns have null values and 75 has no null values?

As the following code gives me an error:

data[data.columns[data.isnull() == True]].shape[1]

Also: https://stackoverflow.com/questions/36226083/how-to-find-which-columns-contain-any-nan-value-in-pandas-dataframe — some_programmer, Jun 10 '20 at 12:20

score 1 · Accepted Answer · answered Jun 10 '20 at 12:20

1

You need to use any:

s = data.isnull().any()

# number of columns with null
num_col_with_null = s.sum()

# number without
df.shape[1] - num_col_with_null

answered Jun 10 '20 at 12:20

Quang Hoang

1 Answers1