先創建一個數據框:
import pandas as pd
df = pd.DataFrame({'a':[1,1,np.nan,np.nan,4], 'b':[5,6,np.nan,8,np.nan]})
刪除特定值存在的行
數據框刪去特定值所在行:
df1 = df.drop(df[df['a']==4].index, inplace = True) ?
刪除存在空值的行
刪除有空值的所有行:
df1 = df.dropna()
刪除a列為空值的所有行:
df1 = df.dropna(subset = ['a'])
刪除a列或b列為空值的所有行:
df1 = df.dropna(subset = ['a','b'], how = any)
刪除a和b都為空值的所有行:
df1 = df.dropna(subset = ['a','b'], how = all)
刪除存在空值的列
刪除存在空值的所有列:
df1 = df.dropna(axis = 1)
?
?