/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 vote151 views1 answer
Unpack a sequence into variables python
Python
0 vote164 views1 answer
Omr sheet python stackoverflow
Python
0 vote149 views1 answer
Python select columns names from dataframe
Python
0 vote165 views1 answer
Using np.unravel_index on argmax output
Python
0 vote139 views1 answer
No module named cbor2 windows
Python
89 votes107 views6 answers
Int to string python
Python
0 vote163 views1 answer
Pandas, python, dataframes
Python
0 vote153 views1 answer
Numpy histogram 0 to 100 percent
Python
1 vote187 views1 answer
Python 3 play sound
Python
23 votes144 views2 answers
How to check in which directory python in running
Python