how to find the correlation between categorical and numerical columns
it doesn't mean anything to calculate the correlation between two variables if they are not quantitative.
I think what you want to do is to study the link between them.
The purpose is to explain the first variable with the other one through a model.
You can use the logistic regression.
But you will only know if there is a link between these two variables with a T-Test or a wilcoxon test depending on the normality of the data
I'm trying to find the correlation between categorical and numerical columns in my dataset using Python, can anyone help?
Here is the data that I have.
Thank you in advance.




Light_Sensor_Reading
Light_Sensor_Status




231
Dim


231
Dim


231
Dim


231
Dim


231
Dim


231
Dim


231
Dim


231
Dim


231
Dim


232
Dim


950
Very_bright


988
Very_bright


987
Very_bright


986
Very_bright


986
Very_bright


986
Very_bright


986
Very_bright


986
Very_bright


986
Very_bright


986
Very_bright


986
Very_bright


986
Very_bright


986
Very_bright


985
Very_bright


985
Very_bright