/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

5 votes140 views3 answers
Convert categorical column to int in pandas
Python
0 vote105 views1 answer
Pandas read all csv in folder
Python
0 vote133 views1 answer
How to close windows in selenium python without quitting the browser
Python
12 votes139 views1 answer
Copy a dict in python
Python
2 votes140 views1 answer
Python convert list to true falsebased on condition
Python
25 votes171 views6 answers
Python check if list contains elements of another list
Python
0 vote151 views1 answer
Voting classifier with different features
Python
0 vote233 views1 answer
Tkinter attribute error
Python
1 vote140 views1 answer
Debug flask powershel
Python
0 vote129 views1 answer
Select non nan values python
Python