pandas处理缺失值

from numpy import nan as NA
data = pd.Series([1,NA,3.5,NA,7])
print(data)
print(data.dropna())

以上是对于Serise,对于DataFrame来说，默认丢弃含有缺失值的行

from numpy import nan as NA
data = pd.DataFrame([[1,6.5,3],[1,NA,NA],[NA,NA,NA],[NA,6.5,3]])
print(data)
print(data.dropna())

传入how = ‘all’只丢弃全为NA的行：

from numpy import nan as NA
data = pd.DataFrame([[1,6.5,3],[1,NA,NA],[NA,NA,NA],[NA,6.5,3]])
print(data)
print(data.dropna(how=’all’))

同样，想对列操作 只要设置axis = 1即可