Sorted Absolute Correlation Table

Python

Display the correlation and absolute column values between the numerical columns in the DataFrame and the 'target' column.

 1|  def correlation_table(data,target_column):
 2|  	data_num = data.select_dtypes(include=['int','float'])
 3|  	corr_df = pd.DataFrame(data_num.corrwith(data_num[target_column]),columns=['Correlation']).dropna()
 4|  	corr_df['ABS Correlation'] = abs(corr_df['Correlation'])
 5|  	corr_df.sort_values(by=['ABS Correlation'], ascending=False, inplace=True)
 6|  	print(corr_df)
 7|  
 8|  correlation_table(df, 'target')
Sorted Absolute Correlation Table
analyseup
Pandas | Correlation
Did you find this snippet useful?

Sign up for free to to add this to your code library

Remove Stop Words from Text in DataFrame Column
Python

Pandas | Nltk | Nlp

133
LightGBM Custom Loss Function
Python

LightGBM | Loss function

121
Tuning XGBoost Hyperparameters with Grid Search
Python

XGBoost | Tuning

116
How to Convert DataFrame Values Into Percentages
Python

Lambda | Percentages | Pipe

109
How to Scale Data Using Standard Scaler But Keep Column Names
Python

Scaler | Standard

78
LightGBM Hyperparameter Tuning with GridSearch
Python

Python | LightGBM | Hyperparameter tuning | Gridsearch

77
Calculating Root Mean Squared Error (RMSE) with Sklearn and Python
Python

Rmse

77
Dynamically Create Columns in Pandas Dataframe
Python

Pandas | Columns

61
How to Train a Catboost Classifier with GridSearch Hyperparameter Tuning
Python

Catboost | Hyperparameter tuning

60
Overwriting a Python Logging File Instead of Appending
Python

Logging

55