/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 vote131 views2 answers
Pytest teardown method
Python
3 votes152 views1 answer
Word pattern python
Python
123 votes132 views6 answers
Input python
Python
0 vote143 views1 answer
Python form html
Python
1 vote115 views1 answer
Pyflakes invalid syntax
Python
3 votes131 views3 answers
2d array python initialize
Python
0 vote141 views1 answer
How to return value in new record to odoo
Python
1 vote131 views1 answer
Openpyxl write in cell
Python
0 vote129 views1 answer
Micropython free space esp32 esp2866
Python
0 vote131 views1 answer
Use nltk to remove stop words
Python