19 August 2020
Code
# Import library
import numpy as np
import pandas as pd
# Create a DataFrame
df = pd.DataFrame({
'activity': [np.nan, 'run', 'walk', 'run', 'walk', 'jump'],
'duration(min)': [45, np.nan, 60, 15, np.nan, 5]
})
print(df)
activity duration(min)
0 NaN 45.0
1 run NaN
2 walk 60.0
3 run 15.0
4 walk NaN
5 jump 5.0
.
# Get sum of NaN for each column
x = df.isna().sum()
# Output
print("Total count of NaN's by columns:")
print(x)
Output:
Total count of NaN's by columns:
activity 1
duration(min) 2
dtype: int64
Any errors in code above?
Please send a message.
learndataa 