I have a dataframe with 20 variables describing the situation of the students in a school while the do two different courses. Now, I am studying if there are multicollineality between some columns and I have the next question:
I have two categorical variables (with the same 4 categories) describing if a student has a good mod (1-bad mood, 4-awesome mood) while he does the two different courses:
~ goodmood_course1 goodmood_course2 student1 0 3 student2 1 1 ...
I found that the two columns are almost the same:
table( df$goodmood_course1 == df$goodmood_course2 ) ... FALSE TRUE 5 375
How can I deal with this multicollinarity? Could I remove one of the columns or would be better to do a mean of the values. Should I do a chi test with the data? Thank you so much!