python删除空值_python – 从pandas数据框中删除具有空值的行

这应该做的工作：

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

它将擦除其中包含“任何”Null值的每一行(axis = 0).

例：

#Recreate random DataFrame with Nan values

df = pd.DataFrame(index = pd.date_range('2017-01-01', '2017-01-10', freq='1d'))

# Average speed in miles per hour

df['A'] = np.random.randint(low=198, high=205, size=len(df.index))

df['B'] = np.random.random(size=len(df.index))*2

#Create dummy NaN value on 2 cells

df.iloc[2,1]=None

df.iloc[5,0]=None

print(df)

A B

2017-01-01 203.0 1.175224

2017-01-02 199.0 1.338474

2017-01-03 198.0 NaN

2017-01-04 198.0 0.652318

2017-01-05 199.0 1.577577

2017-01-06 NaN 0.234882

2017-01-07 203.0 1.732908

2017-01-08 204.0 1.473146

2017-01-09 198.0 1.109261

2017-01-10 202.0 1.745309

#Delete row with dummy value

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

print(df)

A B

2017-01-01 203.0 1.175224

2017-01-02 199.0 1.338474

2017-01-04 198.0 0.652318

2017-01-05 199.0 1.577577

2017-01-07 203.0 1.732908

2017-01-08 204.0 1.473146

2017-01-09 198.0 1.109261

2017-01-10 202.0 1.745309

有关更多详细信息,请参见reference.

如果您的DataFrame一切正常,丢弃NaN应该就这么简单.如果仍然无法正常工作,请确保为列定义了正确的数据类型(pd.to_numeric可以考虑…)