/Python/Pandas correlation matrix between one column and all others

Pandas correlation matrix between one column and all others

correlations = df.corr().unstack().sort_values(ascending=False) # Build correlation matrix
correlations = pd.DataFrame(correlations).reset_index() # Convert to dataframe
correlations.columns = ['col1', 'col2', 'correlation'] # Label it
correlations.query("col1 == 'v2' & col2 != 'v2'") # Filter by variable
# output of this code will give correlation of column v2 with all the other columns

Source: stackoverflow.com

Similar codes

0 vote155 views2 answers
Python change format of datetime
Python
0 vote177 views1 answer
Customise django admin edit model button in field
Python Django
0 vote184 views1 answer
Pandas set index integer not float
Python
-1 vote169 views9 answers
Django for Beginners
Python
0 vote174 views1 answer
Plt off axis
Python
7 votes149 views1 answer
Module namespace in python
Python
0 vote191 views1 answer
Get list of all document in django-elasticsearch-dsl
Python Django
30 votes185 views6 answers
Pandas count distinct values in column
Python
0 vote159 views1 answer
Saaaaaaaaaaaaa
Python
0 vote171 views1 answer
Drawing rectangle with border only in matplotlib
Python