/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

6 votes264 views2 answers
Numpy from csv
Python
0 vote284 views1 answer
Pandas look for values in column with condition
Python
0 vote282 views1 answer
How to pull images from android device from usb in python
Python
3 votes263 views2 answers
Return df.iloc[1:]
Python
0 vote268 views1 answer
Hwo to except every error in python try statemen
Python
6 votes267 views5 answers
Python while True
Python
0 vote294 views1 answer
Write a python program to find fibonacci series upto a certain limit using while loop
Python
0 vote273 views1 answer
Django raw without sql injection
Python
0 vote290 views1 answer
Purpose of migration folder in django
Python Django
79 votes271 views4 answers
Write a file python
Python