斯皮尔曼相关系数计算的python代码

痛定思痛。 2023-09-30 11:29 10阅读 0赞

import pandas as pd
    import numpy as np
    import scipy
    
    def excel_one_line_to_list():
        X1 = pd.read_excel("G:\文件夹1\文件夹2\文件夹3\data.xls", usecols=[0],
                           names=None)  # 读取项目名称列,不要列名
        X1 = np.array(X1)
        X1 = X1.tolist()
        X1 = pd.Series(X1)
        X1 = X1.astype('str')
    
        Y1 = pd.read_excel("G:\文件夹1\文件夹2\文件夹3\data2.xls", usecols=[2],
                            names=None)  # 读取项目名称列,不要列名
        Y1 = np.array(Y1)
        Y1 = Y1.tolist()
        Y1 = pd.Series(Y1)
        Y1 = Y1.astype('str')
    
        # 处理数据删除Nan
        x1 = X1.dropna()
        y1 = Y1.dropna()
        n = x1.count()
        x1.index = np.arange(n)
        y1.index = np.arange(n)
    
        # 分部计算
        d = (x1.sort_values().index - y1.sort_values().index) ** 2
        dd = d.to_series().sum()
    
        p = 1 - n * dd / (n * (n ** 2 - 1))
    
        # s.corr()函数计算
        r = x1.corr(y1, method='spearman')
        print(round(r,3), p)  # 0.942857142857143 0.9428571428571428
        print(scipy.stats.spearmanr(X1, Y1))
    
    if __name__ == '__main__':
        excel_one_line_to_list()

**计算结果：**  
![在这里插入图片描述][4d88a86179fd45e18220e2f74473858d.png]  
**相关链接**  
1、[皮尔森相关性系数的计算python代码（一）][python]  
2、[皮尔森相关性系数的计算python代码（二）][python 1]  
3、[皮尔森相关性系数的计算python代码（三）][python 2]  
4、[斯皮尔曼相关系数计算的python代码][python 3]

[4d88a86179fd45e18220e2f74473858d.png]: https://img-blog.csdnimg.cn/4d88a86179fd45e18220e2f74473858d.png
[python]: https://blog.csdn.net/blbyu/article/details/123798839
[python 1]: https://blog.csdn.net/blbyu/article/details/123798928
[python 2]: 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 3]: https://blog.csdn.net/blbyu/article/details/123798294