数据
查看空值
dropna 函数
处理缺失值
import pandas as pd
path='C:/Users/Admin/Desktop/pandas/删除.xlsx'
data=pd.read_excel(path,index_col='序号')
print(data.dropna())
至少保留
import pandas as pd
path='C:/Users/Admin/Desktop/pandas/删除.xlsx'
data=pd.read_excel(path,index_col='序号')
print(data.dropna(thresh=2))
对指定列空值删除
import pandas as pd
path='C:/Users/Admin/Desktop/pandas/删除.xlsx'
data=pd.read_excel(path,index_col='序号')
print(data.dropna(subset=['语文','数学']))