Find all nan columns pandas

nan_cols = [i for i in df.columns if df[i].isnull().any()]
print("No. of columns containing null values")
print(len(df.columns[df.isna().any()]))

print("No. of columns not containing null values")
print(len(df.columns[df.notna().all()]))

print("Total no. of columns in the dataframe")
print(len(df.columns))

Similar codes

0 vote143 views1 answer
Import "reportlab" could not be resolved django
Python
0 vote136 views1 answer
__pycache__
Python
-1 vote164 views1 answer
Pop a string from a list python
Python
1 vote142 views1 answer
Add directory to pythonpath(in ~/.bashrc
Python
3 votes131 views2 answers
Apply lambda function to multiple columns pandas
Python
0 vote136 views2 answers
Pip config proxy
Python
15 votes269 views6 answers
How to install flask
Python Flask
0 vote127 views1 answer
Custom django password checker
Python
6 votes156 views3 answers
Concatenate lists
Python
0 vote130 views2 answers
Pandas series to numpy array
Python