/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

109 votes128 views6 answers
While loop in python
Python
3 votes144 views1 answer
Application of stack python
Python
97 votes128 views6 answers
Python time.sleep
Python
0 vote150 views1 answer
Mutiple condition in dataframe
Python
0 vote125 views1 answer
Python prime number sum
Python
-1 vote117 views1 answer
Traduce query model
Python
0 vote121 views1 answer
Networkx max degree node
Python
0 vote129 views1 answer
Packing and unpacking in python
Python
-3 votes160 views1 answer
Django socketio web chat example
Python Django
7 votes131 views4 answers
Extract year from datetime pandas
Python