/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 vote195 views1 answer
Python read tab delimited file
Python
0 vote208 views1 answer
Distribute a local Python collection to form an RDD
Python
24 votes348 views3 answers
Flask vs django
Python Flask
8 votes217 views6 answers
Def function python
Python
0 vote192 views1 answer
Python - from most_similar to ldictionary
Python
20 votes267 views6 answers
Extract tar
Python
0 vote199 views1 answer
Keras functional api embedding layer
Python
2 votes187 views4 answers
Pygame
Python
0 vote191 views1 answer
Python ceil method
Python
30 votes208 views4 answers
UnicodeDecodeError: 'utf-8' codec can't decode byte invalid start byte
Python