I have to find the effective time and day to send emails to the doctors.
We have doctors belonging to a specific hospital ....also we have the date/time when they opened the mail . But certain doctors have not opened the mail and we observed that the mail sent timing is not proper.
So I decided to use the following steps:
I have identified the doctors in a hospital who opened the mail earlier, so I could recommend the same timing and day to other doctors in the same hospital who hasn't opened the mail yet.
The problem with this approach is I have huge number of hospital details in the list , so clustering based on hospitals using k-modes seems not correct and appropriate.
How to proceed further? The ultimate goal is to prescribe the desired time and day to sales rep while sending mails to the doctors.