/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

5 votes274 views2 answers
Install pandas in python mac
Python
0 vote329 views1 answer
How to estimate memory of dataset using python command
Python
0 vote295 views2 answers
Count repeated characters in a string python
Python
1 vote377 views2 answers
Json.stringify equivalent in python
Python
4 votes315 views1 answer
Python make comparison non case sensitive
Python
0 vote295 views1 answer
Python extract words from string with format
Python
-1 vote290 views1 answer
Regex find all sentences python
Python
5 votes303 views1 answer
Python how move file to directory
Python
31 votes321 views3 answers
Django createsuperuser
Python
0 vote305 views1 answer
Randomforestregressor in sklearn
Python