/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

3 votes195 views2 answers
Add in python
Python
25 votes206 views3 answers
Numpy merge arrays
Python
7 votes209 views3 answers
Pandas replace nonetype with empty string
Python
8 votes223 views1 answer
Find sum of 2 numbers in array using python
Python
-1 vote201 views1 answer
Import http response in django
Python
4 votes233 views2 answers
Make a nested list flat python
Python
1 vote194 views1 answer
Max string length python
Python
0 vote202 views1 answer
Dictionary to a dataframe pandas arrays must all be same length
Python
1 vote257 views1 answer
Hex to binary python3
Python
0 vote205 views1 answer
Concatenate strings of numpy array python
Python