python pandas数据挖掘实验

1. 导入iris_pandas数据集并保持文本不变read_table。

import pandas as pd
isir=pd.read_table(r'C:\Users\ asus \Desktop\iris_pandas.csv',sep=',')
print(isir.head())

   SepalLength  SepalWidth  PetalLength  PetalWidth      species
0          5.1         3.5          1.4         0.2  Iris-setosa
1          4.9         0.1          1.4         0.2  Iris-setosa
2          4.7         3.2          1.3         0.2  Iris-setosa
3          4.6         3.1          1.5         NaN  Iris-setosa
4          5.0         3.6          1.4         0.2  Iris-setosa

2. 删除有缺失值的行和列

import pandas as pd
isir=pd.read_table(r'C:\Users\asus\Desktop\iris_pandas.csv',sep=',')
isir2=isir.dropna()
print(isir2.head())

        SepalLength  SepalWidth  PetalLength  PetalWidth      species
0          5.1         3.5          1.4         0.2  Iris-setosa
1          4.9         0.1          1.4         0.2  Iris-setosa
2          4.7         3.2          1.3         0.2  Iris-setosa
4          5.0         3.6          1.4         0.2  Iris-setosa
5          5.4         3.9          1.7         0.4  Iris-setosa

3. 重新导入iris_pandas，用众数、均值、中位数分别替换SepalWidth、PetalLength、PetalWidth列空数据

import pandas as pd
isir=pd.read_table(r'C:\Users\asus\Desktop\iris_pandas.csv',sep=',')
isir2=isir.fillna(value={
   'SepalWidth':isir.SepalWidth.mode()[0],'PetalLength'