
import numpy as np
import pandas as pd
import seaborn as sns
from sklearn import metrics
import matplotlib.pyplot as plt
data=pd.read_csv(r'C:\Users\BX田田\Desktop\数据挖掘\Titanic\data.csv',encoding='UTF-8')
#data.csv是泰坦尼克的训练集数据
data['Age']=data['Age'].fillna(data['Age'].median())
data.describe()
# 可以发现AGE现在全部被填充了
## 统计出Embarked列各个元素出现次数
ans=data['Embarked'].value_counts()
# 返回最大值索引
fillstr=ans.idxmax()
data['Embarked']=data['Embarked'].fillna(fillstr)
data.head()
#可以发现embarked无缺失了
data_test=pd.read_csv(r'C:\Users\BX田田\Desktop\数据挖掘\Titanic\test.csv',encoding='UTF-8')
data_test['Age']=data_test['Age'].fillna(data_test['Age'].median())
data_test.describe()
ans=data_test['Embarked'].value_counts()
fill