python 两个dataframe 相关性计算_计算所有列之间的成对相关性

from pandas import *

import numpy as np

from libraries.settings import *

from scipy.stats.stats import pearsonr

import itertools

创建随机样本数据：df = DataFrame(np.random.random((5, 5)), columns=['gene_' + chr(i + ord('a')) for i in range(5)])

print(df)

gene_a gene_b gene_c gene_d gene_e

0 0.471257 0.854139 0.781204 0.678567 0.697993

1 0.292909 0.046159 0.250902 0.064004 0.307537

2 0.422265 0.646988 0.084983 0.822375 0.713397

3 0.113963 0.016122 0.227566 0.206324 0.792048

4 0.357331 0.980479 0.157124 0.560889 0.973161

correlations = {}

columns = df.columns.tolist()

for col_a, col_b in itertools.combinations(columns, 2):

correlations[col_a + '__' + col_b] = pearsonr(df.loc[:, col_a], df.loc[:, col_b])

result = DataFrame.from_dict(correlatio