/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 vote315 views1 answer
Pandas group by concat
Python
23 votes271 views2 answers
Converting month number to month name python
Python
-2 votes290 views5 answers
Convert python to java
Python
0 vote260 views1 answer
Who is agada nathan
Python
0 vote270 views1 answer
How to sum a column in csv python using list in python
Python
0 vote263 views1 answer
Python to open .seg file
Python
1 vote284 views2 answers
Python mp4 to mp3
Python
7 votes279 views5 answers
Pandas split train test
Python
0 vote256 views1 answer
TypeError at /admin/auth/user/
Python
0 vote310 views1 answer
Selenium python get element by type
Python