数据格式：
    image.png

    1. # coding=utf-8
    2. import pandas as pd
    3. import seaborn as sns
    4. import matplotlib.pyplot as plt
    5. plt.rcParams['font.sans-serif']=['SimHei'] #显示中文标签
    6. plt.rcParams['axes.unicode_minus']=False   #这两行需要手动设置
    8. # 读取数据
    9. io = 'data.xlsx'
    10. df = pd.read_excel(io, sheet_name = 0)
    11. df.head()
    13. # print(df.index)
    14. # print("df.head(10) :")
    15. # print(df.head(10))
    17. # print("df.describe():")
    18. # print(df.describe())
    20. # print("df['电压等级']")
    21. # print(df['电压等级'])
    23. so2 = 'so2'
    24. PM10 = 'PM10'
    25. xheight = '悬挂高度'
    26. dgrade = '电压等级'
    28. ectrifyRatio = '带电积污系数'
    30. x_ = [so2, PM10, xheight, dgrade]  # 自变量
    31. y_ = [ectrifyRatio]  # 因变量
    33. x__ = (so2, PM10, xheight, dgrade)
    34. y__ = (ectrifyRatio)
    36. def show_pair_plot():
    37.     sns.pairplot(df, x_vars=x_, y_vars=y_, kind="reg", height=5, aspect=0.7)
    39.     plt.show()
    40.     # plt.savefig('img.png')
    42. # show_pair_plot()
    44. def load_data():
    45.     X = df.loc[:, x__]
    46.     y = df.loc[:, ectrifyRatio]
    47.     print('X','\n',X)
    48.     print('y','\n',y)
    49.     return X,y
    50. load_data()