Drop columns with missing data in Pandas DataFrame
Drop columns with missing data:
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--------- Drop Columns) ---------\n") print(df.dropna(1))
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 --------- Drop Columns) --------- Apple Basket1 10 Basket2 7 Basket3 5 C:\pandas>
2018-10-18T04:11:55+05:30
2018-10-18T04:11:55+05:30
Amit Arora
Amit Arora
Python Programming Tutorial
Python
Practical Solution