rz.csv python简单的数据清洗

import pandas as pd
df = pd.read_excel('C:/Users/Administrator/Desktop/rz.xlsx')
print(df[df.duplicated()])
df1=df.drop_duplicates()
print(df1.shape)
print(df1.isnull().any())  #缩小控制范围
print(df1[df1.isnull().values==True])
df2 =df1.fillna(0)   #填充空值

df0 = df2.copy()#拷贝数据  比如把解几这行处理掉   df0=df2[:]
df0['解几'] = df2['解几'].astype(str).map(str.strip)
df0.columns=['id','grade','name'