How we can handle missing data in a pandas DataFrame?
Example of isnull() and notnull():
import pandas as pd df = pd.DataFrame([[10, 20, 30, 40], [7, 14, 21, 28], [5,]], columns=['Apple', 'Orange', 'Banana', 'Pear'], index=['Basket1', 'Basket2', 'Basket3']) print("\n--------- DataFrame ---------\n") print(df) print("\n--------- Use of isnull() ---------\n") print(df.isnull()) print("\n--------- Use of notnull() ---------\n") print(df.notnull())
C:\pandas>python example.py --------- DataFrame --------- Apple Orange Banana Pear Basket1 10 20.0 30.0 40.0 Basket2 7 14.0 21.0 28.0 Basket3 5 NaN NaN NaN --------- Use of isnull() --------- Apple Orange Banana Pear Basket1 False False False False Basket2 False False False False Basket3 False True True True --------- Use of notnull() --------- Apple Orange Banana Pear Basket1 True True True True Basket2 True True True True Basket3 True False False False C:\pandas>
2018-10-17T17:11:52+05:30
2018-10-17T17:11:52+05:30
Amit Arora
Amit Arora
Python Programming Tutorial
Python
Practical Solution