/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

1 vote123 views2 answers
Django content type
Python
-2 votes122 views1 answer
Does python pass by reference
Python
1 vote117 views1 answer
Drop every other column pandas
Python
0 vote109 views1 answer
Reveal a defined function in python
Python
28 votes108 views4 answers
Seaborn figure size
Python
3 votes152 views6 answers
2+2
Python
10 votes128 views2 answers
Django delete object
Python
21 votes111 views5 answers
How to get input from list in python
Python
0 vote109 views1 answer
Rounding with .2g gives strange results
Python
2 votes116 views1 answer
How to return a value from a function in python
Python