初识pandas库与缺失值的补全

1.打开数据（csv文件、excel文件）

2.查看数据（尺寸信息、查看列名等方法）

import pandas as pd
data = pd.read_csv(r"C:\Users\23997\Desktop\python60-days-challenge-master\data.csv")
# print(data.head(10))
# print(data.isnull())

3.查看空值

print(data.isnull())

4.众数、中位数填补空值

median_score = data["Credit Score"].median()
data['Credit Score'].fillna(median_score,inplace=True)
print(data['Credit Score'].isnull().sum())
#中位数为例，众数同理

5.利用循环补全所有列的空值

import numpy as np
a =np.array([1,2,3])
a.tolist()
c = data.columns.tolist()
type(c)
for i in c:
    if data[i].dtype != 'object': 
        if data[i].isnull().sum() > 0: 
            mean_value = data[i].mean()
            data[i].fillna(mean_value, inplace=True)
data.isnull().sum()

​​​​@浙大疏锦行