/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 vote197 views2 answers
Pydrive download file
Python
0 vote221 views1 answer
Pandas groupby and show specific column
Python
0 vote221 views1 answer
How to make python print 2 line text in one code
Python
0 vote247 views1 answer
Python scipy put more weight to a set value in curve_fit
Python
0 vote223 views1 answer
K-Means Clustering in Python – 3 clusters
Python
2 votes231 views2 answers
Print list of list line by line python
Python
0 vote238 views1 answer
*args **kwargs together in python
Python
3 votes218 views3 answers
Steps in for loop python
Python
0 vote235 views1 answer
Head first python by paul barry pdf
Python
7 votes218 views2 answers
How to get the remainder in python
Python