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
Here is what the above code is Doing:
1. We’re using the corr() method to build a correlation matrix.
2. We’re using the unstack() method to reshape the correlation matrix so that we can filter by variable.
3. We’re sorting the values in descending order.
4. We’re converting the correlation matrix to a dataframe.
5. We’re labeling the columns.
6. We’re filtering the dataframe by variable.
