/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

17 votes201 views4 answers
How to check how many items are in a list python
Python
0 vote209 views1 answer
Sum of the number in a list in python
Python
0 vote196 views2 answers
Give utton a number python
Python
0 vote197 views1 answer
Day 27: Testing hackerrank solution python
Python
0 vote190 views1 answer
Python how to automatically restart flask sever
Python
0 vote178 views1 answer
Get key of min value
Python
0 vote178 views1 answer
Query a PSQL Database From Python
Python
0 vote178 views1 answer
Feature importance naive bayes python
Python
2 votes174 views2 answers
How to get only first record in django
Python
0 vote166 views1 answer
ImportError: cannot import name ABC
Python