Python numpy DataFrame dropna

import pandas as pd
import numpy as np

date = pd.date_range('20191231', periods=6)
df = pd.DataFrame(np.arange(24).reshape(6,4), index=date, columns=['A','B','C','D'])

df.iloc[0,1] = np.nan
df.iloc[1,2] = np.nan

print(df)

   

print(df.dropna(axis=0, how='any'))

   

print(df.dropna(axis=1, how='any'))

   

print(df.dropna(axis=0, how='all'))

   

print(df.dropna(axis=1, how='all'))

   

posted @ 2019-12-31 17:43  大牛和小白  阅读(1871)  评论(0编辑  收藏  举报