/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

25 votes215 views4 answers
Time in python code
Python
0 vote193 views1 answer
Python currnent time
Python
0 vote207 views1 answer
No default language could be detected for django app
Python Django
0 vote197 views1 answer
Scikit learn split data set site:stackoverflow.com
Python
2 votes196 views1 answer
Jupyter notebook pass python variable to shell
Python
2 votes199 views2 answers
Python read requests response
Python
12 votes189 views6 answers
Tkinter
Python
0 vote190 views1 answer
Compute slice distance from image position
Python
0 vote191 views1 answer
R - scale data from 0 to 1
Python
0 vote140 views1 answer
Dip programming language
Python