'how to find correlation between two datasets and how to get their heatmap

df1=

                                  PRISM|7662  PRISM|7847  PRISM|7855  
# Feature / Sample                                                     
Methanosphaera_stadtmanae           0.006728    0.000000    0.000000   
Rothia_mucilaginosa                 0.000000    0.000000    0.000000   
Propionibacterium_freudenreichii    0.000000    0.000000    0.000000   
Bifidobacterium_adolescentis        0.029346    0.000064    0.000006   
Bifidobacterium_animalis            0.000000    0.023177    0.000000   
...                                      ...         ...         ...   
Collinsella_stercoris               0.000000    0.000000    0.000000   
Bacteroides_clarus                  0.000000    0.000000    0.000000   
Bacteroides_plebeius                0.000000    0.000000    0.000000   
Lactobacillus_delbrueckii           0.000000    0.000000    0.000000   
Lactobacillus_sakei                 0.000000    0.000000    0.000000 

df2=

                                    Validation|LLDeep_0001  \      Validation|LLDeep_0003 
# Feature / Sample                                         
Methanosphaera_stadtmanae                       0.000000                 0.000000 
Rothia_mucilaginosa                             0.000000                 0.000000
Propionibacterium_freudenreichii                0.000000                 0.000000
Bifidobacterium_adolescentis                    0.028835                 0.000000    
Bifidobacterium_animalis                        0.000000                 0.000000                                       
Collinsella_stercoris                           0.000000                 0.001327    
Bacteroides_clarus                              0.000000                 0.000000  
Bacteroides_plebeius                            0.000000                 0.000142 
Lactobacillus_delbrueckii                       0.000000                 0.000000 
Lactobacillus_sakei                             0.000000                 0.112162 

How to find correlation between them?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source