/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

1 vote145 views1 answer
Python groupby sum single columns
Python
0 vote102 views1 answer
How to take input a matrix using map in python
Python
3 votes93 views1 answer
SQLalchemy delete by id
Python
0 vote93 views2 answers
Days in month function python
Python
5 votes103 views1 answer
Find all files in a directory with extension python
Python
11 votes99 views3 answers
Logistic regression algorithm in python
Python
4 votes107 views1 answer
Find text between two strings regex python
Python
9 votes134 views2 answers
How to fill nan values with mean in pandas
Python
1 vote110 views2 answers
Np.eye
Python
0 vote103 views1 answer
How to get RGB value from pixel in screen live python
Python