/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 vote110 views1 answer
Codeforces - 570b python
Python
1 vote106 views1 answer
Python random.choices vs random.sample
Python
7 votes146 views2 answers
Pandas profile
Python
0 vote125 views2 answers
Create a list of pandas index
Python
16 votes113 views1 answer
Print surrent directory python
Python
0 vote108 views1 answer
Historicaltickbidask
Python
0 vote104 views1 answer
Apply 2d mask to 3d array python
Python
3 votes125 views4 answers
Fizz buzz fizzbuzz python game
Python
0 vote113 views1 answer
Python add hyphen to string
Python
15 votes146 views4 answers
How to find last element in array python
Python