ehp
0
Q:

find nan values in a column pandas

# to mark NaN column as True
df['your column name'].isnull()
7
df.isnull().values.any()
1
df['your column name'].isnull().values.any()
0
df['your column name'].isnull().sum()
1
In [1]: s = pd.Series([1,2,3, np.nan, np.nan])

In [4]: s.isna().sum()   # or s.isnull().sum() for older pandas versions
Out[4]: 2
1
df.isnull().sum().sum()
0
df['your column name'].isnull()
0
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))
0

New to Communities?

Join the community