皮尔森相关性系数的计算python代码（三）

电玩女神 2023-09-29 12:56 34阅读 0赞

**部分代码**

import os
    import pandas as pd
    import numpy as np
    from scipy.stats import pearsonr
    
    def Pearson(data):
        selected = []
        for i in range(len(data.columns) - 1):
            coor, p = pearsonr(list(data.iloc[:, i]), list(data.iloc[:, -1]))
            if p < 0.05 or len(selected) < 0.8 * (len(data.columns) - 1):
                selected.append(data.columns[i])
            print("{0}与Result的corr为: {1}".format(data.columns[i], coor))
    
    if __name__ == "__main__":
        path = os.path.join(os.getcwd(), 'XXX.xls')
        # 读取数据
        data = pd.read_excel(path, skiprows=0)
        data.head()
        X = np.array(data.iloc[:, :-1])
        y = np.array(data.iloc[:, -1:])
        # 3. 皮尔逊分析
        remaining = Pearson(data)
        data = data.loc[:, remaining + ['Result']]
        print(data.head())

**实验结果**  
![在这里插入图片描述][44a9a0f9a91c45fb9303009c0011156a.png]  
**完整代码链接：**[皮尔森相关性系数的计算python代码（三）][python]  
**相关链接**  
1、[皮尔森相关性系数的计算python代码（一）][python 1]  
2、[皮尔森相关性系数的计算python代码（二）][python 2]  
3、[皮尔森相关性系数的计算python代码（三）][python 3]  
4、[皮尔森相关性系数的计算python代码（四）（热力图版）][python 4]  
5、[斯皮尔曼相关系数计算的python代码][python 5]

[44a9a0f9a91c45fb9303009c0011156a.png]: https://img-blog.csdnimg.cn/44a9a0f9a91c45fb9303009c0011156a.png
[python]: https://download.csdn.net/download/blbyu/85262958
[python 1]: https://blog.csdn.net/blbyu/article/details/123798839
[python 2]: https://blog.csdn.net/blbyu/article/details/123798928
[python 3]: https://blog.csdn.net/blbyu/article/details/124533233?csdn_share_tail=%7B%22type%22:%22blog%22,%22rType%22:%22article%22,%22rId%22:%22124533233%22,%22source%22:%22blbyu%22%7D&ctrtid=xKIV8
[python 4]: https://blog.csdn.net/blbyu/article/details/124541289
[python 5]: https://blog.csdn.net/blbyu/article/details/123798294