pandas 查看空值 进行填充和删除操作

import pandas as pd
import numpy as np

data = {
'size':['XL','L' ,'M',np.nan,'M','M'],
'color':['red','green',' blue',' green' ,'red',' green'],
'gender':[' female','male', np.nan, ' female', 'female' ,'male'],
'price':[199.0,89.0,np. nan, 129.0, 79.0, 89.0] ,
'weight':[500,450,300,np.nan, 410,np.nan] ,
'bought':[ 'yes','no',np.nan, 'no','yes','no']}
df=pd.DataFrame(data)
print(f'长度len：{len(df)},形状：{df.shape},\n{df.head(2)},\n{df.tail(2)}')

#查看空值情况
print(np.round(df.notnull().sum()/len(df),2))
print(f'df.isnull {df.price.isnull()}')
df.dropna(axis=1,how='any',inplace=True)#删除列，有空置就删除 （是反着的apply axis=1是