Skip to main content
3 of 4
added 130 characters in body

Finding Relationship between Categorical and Continuous data

A subset of my dataset looks as follows where cells in "cat1_ids" column contains list of "cat1" categories and cells in "person_id_list" column contains list of persons id. There are 2000 "cat1" categories and 1500 person, How to prove "no_of_days" is related to to these two columns? After proving a relationship exists the next step is to train a model on this data for predicting "no_of_days". Any suggestions on how to deal with cells containing tuple of values? (both graphical and statistical methods would be appreciated for proving relationship)

  cat1_ids    person_id_list   no_of_days
0   (602,)        (12713,)        1.727083
4   (3, 131)      (12408,)        1.770833
5   (13,)         (12404,)        0.592361
6   (442,)        (12327,)        2.518750
7   (761,)        (12720,)        7.601389

shape => 75000x3

Edit: combinations of cat1_ids has greater influence on no_of_days as compared to person_id_list (it's domain knowledge).