Summary of the Raw Data
Total No of Records
10000
Total no of Columns
31
No of Duplicate Records
328
No of Blanks Cells
0
Bad no of Records
0
| Patient ID | Name | Age | Gender | Slot_timings | Appointment_duration | Appointment_ID | Specialist | Reasons | Patient_previous_medical_record | Prev_Patient_survey | Patient_address | Patient_distance | Drug_details | Prev_no_of_dosages | No_of_purchased_dosages | Patient_previous_feedback_form | Patient_Status | Employee_or_not | Total_Taken_Appointments | No_of_Hospital_Visits | No_of_Times_Missed | Private_Hospital_Visits | Government_Hospital_Visits | Private_Hospital_Prescription | Government_Hospital_Prescription | Probability_of_visits | Probability_of_missed_visits | Appointment_Date | Appointment_Slot | LAST_UPDATED |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14638 | Suresh | 54 | Male | Evening | 15 | 253618 | Nephrologist | Kidney Problems | Previously treated for Kidney Problems | Moderately Cured | Kolkata | 20 | Diuretics | 21 | 14 | Satisfied | Will Attend | Unemployed | 11 | 8 | 3 | 5 | 3 | Diuretics | Diuretics | 0.727272727 | 0.272727273 | 14-11-2024 | 12:00-12:35 | 2026-03-24 14:51:19 |
| 19870 | Kavita | 77 | Female | Evening | 60 | 476118 | Nephrologist | Kidney Problems | Previously treated for Kidney Problems | Not Cured Well | Ahmedabad | 5.3 | Diuretics | 29 | 6 | Dissatisfied | Will Attend | Day Shift | 8 | 5 | 3 | 4 | 1 | Diuretics | Diuretics | 0.625 | 0.375 | 11-01-2024 | 13:19-14:08 | 2026-03-24 14:59:36 |
| 78045 | Priya | 16 | Male | Afternoon | 15 | 640699 | Cardiologist | Blood Pressure | Previously treated for Blood Pressure | Completely Cured | Pune | 3 | Amlodipine | 7 | 2 | Satisfied | Will Attend | Studying | 13 | 4 | 9 | 0 | 4 | No Private Hospital Visits | Amlodipine | 0.307692308 | 0.692307692 | 19-02-2020 | 14:56-15:40 | 2026-03-24 14:50:20 |
| 37664 | Neha | 56 | Male | Evening | 60 | 475192 | Endocrinologist | Diabetes | Previously treated for Diabetes | Not Cured Well | Kolkata | 13.7 | Metformin | 13 | 0 | Satisfied | Will Attend | Night Shift | 13 | 13 | 0 | 9 | 4 | Metformin | Metformin | 1 | 0 | 11-10-2021 | 08:54-09:39 | 2026-03-24 14:50:20 |
| 26135 | Ananya | 75 | Male | Afternoon | 45 | 402402 | Ophthalmologist | Eye Checkup | Previously treated for Eye Checkup | Completely Cured | Kolkata | 8.6 | Vitamin A Supplements | 24 | 3 | Dissatisfied | Will Attend | Night Shift | 15 | 15 | 0 | 3 | 12 | Vitamin A Supplements | Vitamin A Supplements | 1 | 0 | 17-02-2021 | 13:18-14:07 | 2026-03-24 14:50:20 |
| 77233 | Vikram | 70 | Female | Evening | 30 | 525726 | Endocrinologist | Diabetes | Previously treated for Diabetes | Moderately Cured | Hyderabad | 5.2 | Metformin | 24 | 11 | Neutral | Will Not Attend | Unemployed | 3 | 1 | 2 | 0 | 1 | No Private Hospital Visits | Metformin | 0.333333333 | 0.666666667 | 19-12-2023 | 16:29-17:17 | 2026-03-24 14:50:20 |
| 69113 | Amit | 72 | Male | Morning | 60 | 840693 | Cardiologist | Heart Issues | Previously treated for Heart Issues | Not Cured Well | Mumbai | 6.7 | Aspirin | 27 | 22 | Dissatisfied | Will Not Attend | Night Shift | 6 | 2 | 4 | 2 | 0 | Aspirin | No Government Hospital Visits | 0.333333333 | 0.666666667 | 24-05-2020 | 09:01-09:32 | 2026-03-24 14:50:20 |
| 75104 | Rahul | 80 | Female | Evening | 60 | 772256 | Nephrologist | Kidney Problems | Previously treated for Kidney Problems | Not Cured Well | Kolkata | 24.6 | Diuretics | 2 | 1 | Satisfied | Will Attend | Unemployed | 16 | 11 | 5 | 5 | 6 | Diuretics | Diuretics | 0.6875 | 0.3125 | 19-01-2020 | 10:20-10:34 | 2026-03-24 14:50:20 |
| 84290 | Amit | 50 | Female | Afternoon | 30 | 705190 | Nephrologist | Kidney Problems | Previously treated for Kidney Problems | Not Cured Well | Jaipur | 13.9 | Diuretics | 7 | 5 | Dissatisfied | Will Attend | Night Shift | 1 | 1 | 0 | 0 | 1 | No Private Hospital Visits | Diuretics | 1 | 0 | 25-02-2020 | 13:25-13:46 | 2026-03-24 14:50:20 |
| 23181 | Rahul | 71 | Male | Evening | 15 | 777494 | Nephrologist | Kidney Problems | Previously treated for Kidney Problems | Completely Cured | Bangalore | 20.2 | Diuretics | 15 | 11 | Dissatisfied | Will Attend | Unemployed | 4 | 2 | 2 | 1 | 1 | Diuretics | Diuretics | 0.5 | 0.5 | 05-03-2020 | 12:25-13:04 | 2026-03-24 14:50:20 |
| 66257 | Rahul | 34 | Male | Afternoon | 30 | 242084 | Cardiologist | Blood Pressure | Previously treated for Blood Pressure | Moderately Cured | Kolkata | 22.5 | Amlodipine | 13 | 12 | Neutral | Will Attend | Day Shift | 7 | 2 | 5 | 0 | 2 | No Private Hospital Visits | Amlodipine | 0.285714286 | 0.714285714 | 29-04-2021 | 12:22-13:08 | 2026-03-24 14:50:20 |
| 97964 | Pooja | 62 | Female | Evening | 15 | 467690 | Cardiologist | Blood Pressure | Previously treated for Blood Pressure | Not Cured Well | Hyderabad | 6.4 | Amlodipine | 7 | 3 | Dissatisfied | Will Attend | Unemployed | 5 | 4 | 1 | 0 | 4 | No Private Hospital Visits | Amlodipine | 0.8 | 0.2 | 14-07-2024 | 12:39-12:44 | 2026-03-24 14:50:20 |
| 54459 | Suresh | 51 | Female | Morning | 45 | 540597 | Cardiologist | Heart Issues | Previously treated for Heart Issues | Completely Cured | Pune | 6.3 | Aspirin | 18 | 2 | Satisfied | Will Attend | Night Shift | 18 | 14 | 4 | 4 | 10 | Aspirin | Aspirin | 0.777777778 | 0.222222222 | 17-11-2022 | 09:52-10:48 | 2026-03-24 14:50:20 |
| 62108 | Vikram | 15 | Female | Afternoon | 30 | 477343 | Dentist | Dental Issues | Previously treated for Dental Issues | Not Cured Well | Pune | 14 | Painkillers | 24 | 17 | Neutral | Will Not Attend | Studying | 16 | 8 | 8 | 0 | 8 | No Private Hospital Visits | Painkillers | 0.5 | 0.5 | 15-11-2023 | 15:56-16:26 | 2026-03-24 14:50:20 |
| 78180 | Pooja | 50 | Male | Evening | 45 | 508484 | Cardiologist | Heart Issues | Previously treated for Heart Issues | Completely Cured | Hyderabad | 3 | Aspirin | 16 | 7 | Dissatisfied | Will Attend | Night Shift | 8 | 5 | 3 | 2 | 3 | Aspirin | Aspirin | 0.625 | 0.375 | 12-03-2021 | 08:47-09:42 | 2026-03-24 14:50:20 |
| 35739 | Pooja | 69 | Female | Afternoon | 30 | 662520 | Cardiologist | Heart Issues | Previously treated for Heart Issues | Not Cured Well | Hyderabad | 15.6 | Aspirin | 22 | 12 | Dissatisfied | Will Attend | Unemployed | 11 | 4 | 7 | 3 | 1 | Aspirin | Aspirin | 0.363636364 | 0.636363636 | 19-11-2023 | 13:28-14:17 | 2026-03-24 14:50:20 |
| 97010 | Amit | 57 | Male | Afternoon | 30 | 137880 | Cardiologist | Heart Issues | Previously treated for Heart Issues | Completely Cured | Lucknow | 10.8 | Aspirin | 20 | 19 | Dissatisfied | Will Attend | Night Shift | 14 | 8 | 6 | 6 | 2 | Aspirin | Aspirin | 0.571428571 | 0.428571429 | 03-02-2024 | 14:17-14:38 | 2026-03-24 14:50:20 |
| 91491 | Ananya | 73 | Male | Evening | 60 | 475243 | Nephrologist | Kidney Problems | Previously treated for Kidney Problems | Not Cured Well | Ahmedabad | 9.2 | Diuretics | 18 | 16 | Neutral | Will Attend | Unemployed | 17 | 16 | 1 | 9 | 7 | Diuretics | Diuretics | 0.941176471 | 0.058823529 | 10-12-2024 | 14:43-15:23 | 2026-03-24 14:50:20 |
| 33176 | Kavita | 88 | Male | Evening | 60 | 859377 | Cardiologist | Heart Issues | Previously treated for Heart Issues | Completely Cured | Jaipur | 2.8 | Aspirin | 19 | 11 | Satisfied | Will Attend | Night Shift | 17 | 15 | 2 | 9 | 6 | Aspirin | Aspirin | 0.882352941 | 0.117647059 | 02-08-2022 | 13:24-14:21 | 2026-03-24 14:50:20 |
| 90483 | Priya | 70 | Male | Afternoon | 45 | 317911 | Cardiologist | Heart Issues | Previously treated for Heart Issues | Moderately Cured | Hyderabad | 21.8 | Aspirin | 28 | 18 | Neutral | Will Attend | Unemployed | 7 | 6 | 1 | 6 | 0 | Aspirin | No Government Hospital Visits | 0.857142857 | 0.142857143 | 02-10-2021 | 08:08-08:14 | 2026-03-24 14:50:20 |
| 31969 | Ananya | 61 | Female | Morning | 45 | 306758 | Nephrologist | Kidney Problems | Previously treated for Kidney Problems | Completely Cured | Hyderabad | 21.4 | Diuretics | 22 | 8 | Dissatisfied | Will Attend | Day Shift | 2 | 2 | 0 | 2 | 0 | Diuretics | No Government Hospital Visits | 1 | 0 | 19-01-2020 | 08:16-08:44 | 2026-03-24 14:50:20 |
| 20675 | Amit | 64 | Male | Afternoon | 60 | 935301 | Cardiologist | Blood Pressure | Previously treated for Blood Pressure | Not Cured Well | Pune | 4.1 | Amlodipine | 30 | 4 | Neutral | Will Attend | Night Shift | 12 | 6 | 6 | 4 | 2 | Amlodipine | Amlodipine | 0.5 | 0.5 | 01-09-2024 | 08:28-09:02 | 2026-03-24 14:50:20 |
| 92770 | Ananya | 73 | Male | Evening | 45 | 344086 | Cardiologist | Blood Pressure | Previously treated for Blood Pressure | Completely Cured | Lucknow | 17.3 | Amlodipine | 15 | 4 | Neutral | Will Attend | Unemployed | 7 | 5 | 2 | 4 | 1 | Amlodipine | Amlodipine | 0.714285714 | 0.285714286 | 14-07-2024 | 17:58-18:23 | 2026-03-24 14:50:20 |
| 37700 | Suresh | 86 | Female | Afternoon | 30 | 476581 | Ophthalmologist | Eye Checkup | Previously treated for Eye Checkup | Not Cured Well | Kolkata | 2.7 | Vitamin A Supplements | 17 | 7 | Satisfied | Will Attend | Day Shift | 12 | 5 | 7 | 0 | 5 | No Private Hospital Visits | Vitamin A Supplements | 0.416666667 | 0.583333333 | 28-01-2024 | 12:47-12:57 | 2026-03-24 15:11:10 |
| 73719 | Suresh | 61 | Male | Evening | 45 | 329266 | Nephrologist | Kidney Problems | Previously treated for Kidney Problems | Completely Cured | Jaipur | 1.5 | Diuretics | 13 | 9 | Satisfied | Will Attend | Unemployed | 7 | 5 | 2 | 3 | 2 | Diuretics | Diuretics | 0.714285714 | 0.285714286 | 08-12-2023 | 09:46-10:38 | 2026-03-24 14:50:20 |
| 94014 | Neha | 55 | Male | Afternoon | 45 | 797959 | Cardiologist | Blood Pressure | Previously treated for Blood Pressure | Not Cured Well | Mumbai | 7.3 | Amlodipine | 7 | 4 | Neutral | Will Attend | Unemployed | 6 | 1 | 5 | 1 | 0 | Amlodipine | No Government Hospital Visits | 0.166666667 | 0.833333333 | 31-03-2022 | 12:40-13:27 | 2026-03-24 14:50:20 |
| 78281 | Suresh | 0 | Female | Afternoon | 45 | 310368 | Dermatologist | Skin Allergy | Previously treated for Skin Allergy | Completely Cured | Chennai | 10 | Antihistamines | 14 | 11 | Neutral | Will Attend | Not Applicable | 4 | 2 | 2 | 0 | 2 | No Private Hospital Visits | Antihistamines | 0.5 | 0.5 | 02-08-2021 | 16:23-16:32 | 2026-03-24 14:50:20 |
| 78716 | Rahul | 26 | Male | Morning | 45 | 789715 | Endocrinologist | Diabetes | Previously treated for Diabetes | Completely Cured | Kolkata | 14.4 | Metformin | 12 | 12 | Dissatisfied | Will Attend | Night Shift | 3 | 3 | 0 | 3 | 0 | Metformin | No Government Hospital Visits | 1 | 0 | 23-07-2022 | 16:54-17:25 | 2026-03-24 14:50:20 |
| 22638 | Amit | 72 | Female | Evening | 30 | 317755 | Endocrinologist | Diabetes | Previously treated for Diabetes | Completely Cured | Jaipur | 10.5 | Metformin | 23 | 10 | Satisfied | Will Not Attend | Unemployed | 7 | 1 | 6 | 0 | 1 | No Private Hospital Visits | Metformin | 0.142857143 | 0.857142857 | 02-09-2023 | 09:58-10:31 | 2026-03-24 14:50:20 |
| 12216 | Ananya | 50 | Female | Morning | 60 | 166951 | Nephrologist | Kidney Problems | Previously treated for Kidney Problems | Not Cured Well | Lucknow | 11.4 | Diuretics | 10 | 0 | Dissatisfied | Will Attend | Night Shift | 17 | 4 | 13 | 4 | 0 | Diuretics | No Government Hospital Visits | 0.235294118 | 0.764705882 | 23-02-2025 | 17:10-17:57 | 2026-03-24 14:50:20 |
| 20532 | Priya | 33 | Male | Afternoon | 45 | 337834 | Endocrinologist | Diabetes | Previously treated for Diabetes | Completely Cured | Lucknow | 6.7 | Metformin | 11 | 9 | Neutral | Will Attend | Day Shift | 10 | 4 | 6 | 2 | 2 | Metformin | Metformin | 0.4 | 0.6 | 28-01-2020 | 10:19-10:31 | 2026-03-24 14:50:20 |
| 23826 | Kavita | 51 | Male | Afternoon | 60 | 366181 | Cardiologist | Blood Pressure | Previously treated for Blood Pressure | Completely Cured | Mumbai | 22.1 | Amlodipine | 18 | 6 | Neutral | Will Attend | Night Shift | 17 | 11 | 6 | 5 | 6 | Amlodipine | Amlodipine | 0.647058824 | 0.352941176 | 09-07-2020 | 11:26-11:47 | 2026-03-24 14:50:20 |
| 26245 | Suresh | 23 | Female | Morning | 30 | 446214 | Endocrinologist | Diabetes | Previously treated for Diabetes | Moderately Cured | Bangalore | 20.7 | Metformin | 5 | 1 | Dissatisfied | Will Attend | Night Shift | 7 | 5 | 2 | 1 | 4 | Metformin | Metformin | 0.714285714 | 0.285714286 | 17-08-2023 | 16:19-16:37 | 2026-03-24 14:50:20 |
| 53671 | Pooja | 16 | Female | Evening | 45 | 841884 | Dentist | Dental Issues | Previously treated for Dental Issues | Not Cured Well | Lucknow | 8 | Painkillers | 23 | 4 | Neutral | Will Attend | Studying | 13 | 5 | 8 | 0 | 5 | No Private Hospital Visits | Painkillers | 0.384615385 | 0.615384615 | 20-01-2024 | 13:08-13:17 | 2026-03-24 14:50:20 |
| 18156 | Priya | 54 | Female | Morning | 15 | 186480 | Cardiologist | Heart Issues | Previously treated for Heart Issues | Completely Cured | Bangalore | 15.8 | Aspirin | 22 | 2 | Dissatisfied | Will Not Attend | Night Shift | 19 | 4 | 15 | 3 | 1 | Aspirin | Aspirin | 0.210526316 | 0.789473684 | 24-01-2025 | 10:27-10:48 | 2026-03-24 14:50:20 |
| 39236 | Ananya | 70 | Male | Evening | 45 | 496130 | Cardiologist | Heart Issues | Previously treated for Heart Issues | Moderately Cured | Kolkata | 21 | Aspirin | 5 | 1 | Dissatisfied | Will Attend | Day Shift | 3 | 2 | 1 | 1 | 1 | Aspirin | Aspirin | 0.666666667 | 0.333333333 | 26-11-2021 | 15:49-16:10 | 2026-03-24 14:50:20 |
| 43191 | Amit | 59 | Female | Evening | 45 | 933053 | Cardiologist | Blood Pressure | Previously treated for Blood Pressure | Not Cured Well | Mumbai | 19.7 | Amlodipine | 3 | 3 | Dissatisfied | Will Attend | Unemployed | 17 | 13 | 4 | 1 | 12 | Amlodipine | Amlodipine | 0.764705882 | 0.235294118 | 17-03-2023 | 11:38-12:14 | 2026-03-24 14:50:20 |
| 80423 | Ananya | 69 | Male | Evening | 60 | 174105 | Cardiologist | Heart Issues | Previously treated for Heart Issues | Completely Cured | Bangalore | 15.4 | Aspirin | 27 | 11 | Satisfied | Cancelled | Unemployed | 3 | 3 | 0 | 3 | 0 | Aspirin | No Government Hospital Visits | 1 | 0 | 29-08-2020 | 10:21-10:36 | 2026-03-24 14:50:20 |
| 21020 | Priya | 60 | Female | Afternoon | 60 | 606280 | Nephrologist | Kidney Problems | Previously treated for Kidney Problems | Not Cured Well | Pune | 4.1 | Diuretics | 29 | 17 | Neutral | Will Attend | Day Shift | 19 | 3 | 16 | 1 | 2 | Diuretics | Diuretics | 0.157894737 | 0.842105263 | 28-11-2024 | 13:54-14:49 | 2026-03-24 14:50:20 |
| 16010 | Suresh | 61 | Female | Afternoon | 15 | 422969 | Cardiologist | Blood Pressure | Previously treated for Blood Pressure | Moderately Cured | Jaipur | 15.1 | Amlodipine | 14 | 4 | Neutral | Will Not Attend | Unemployed | 2 | 1 | 1 | 1 | 0 | Amlodipine | No Government Hospital Visits | 0.5 | 0.5 | 20-12-2020 | 09:01-09:28 | 2026-03-24 15:11:10 |
| 71575 | Rahul | 62 | Male | Afternoon | 60 | 782367 | Cardiologist | Heart Issues | Previously treated for Heart Issues | Completely Cured | Delhi | 6.8 | Aspirin | 28 | 17 | Dissatisfied | Will Attend | Night Shift | 4 | 3 | 1 | 2 | 1 | Aspirin | Aspirin | 0.75 | 0.25 | 24-09-2020 | 08:45-09:25 | 2026-03-24 14:50:20 |
| 33831 | Rahul | 68 | Male | Evening | 45 | 649114 | Cardiologist | Heart Issues | Previously treated for Heart Issues | Completely Cured | Lucknow | 18.8 | Aspirin | 14 | 7 | Satisfied | Will Attend | Day Shift | 15 | 2 | 13 | 2 | 0 | Aspirin | No Government Hospital Visits | 0.133333333 | 0.866666667 | 25-05-2022 | 15:50-16:08 | 2026-03-24 14:50:20 |
| 53567 | Rahul | 85 | Female | Evening | 45 | 876443 | Nephrologist | Kidney Problems | Previously treated for Kidney Problems | Not Cured Well | Jaipur | 24.3 | Diuretics | 24 | 19 | Satisfied | Will Attend | Day Shift | 14 | 2 | 12 | 1 | 1 | Diuretics | Diuretics | 0.142857143 | 0.857142857 | 04-12-2023 | 08:59-09:34 | 2026-03-24 14:50:20 |
| 41553 | Kavita | 83 | Male | Morning | 15 | 202240 | Cardiologist | Heart Issues | Previously treated for Heart Issues | Moderately Cured | Jaipur | 3.3 | Aspirin | 27 | 6 | Satisfied | Will Attend | Day Shift | 14 | 1 | 13 | 1 | 0 | Aspirin | No Government Hospital Visits | 0.071428571 | 0.928571429 | 16-09-2020 | 08:01-08:47 | 2026-03-24 15:11:10 |
| 12033 | Neha | 60 | Female | Afternoon | 60 | 644195 | Nephrologist | Kidney Problems | Previously treated for Kidney Problems | Not Cured Well | Delhi | 9.2 | Diuretics | 1 | 0 | Dissatisfied | Will Attend | Day Shift | 11 | 5 | 6 | 4 | 1 | Diuretics | Diuretics | 0.454545455 | 0.545454545 | 28-03-2021 | 13:12-13:30 | 2026-03-24 14:50:20 |
| 16887 | Vikram | 74 | Female | Evening | 45 | 172465 | Cardiologist | Heart Issues | Previously treated for Heart Issues | Completely Cured | Delhi | 11 | Aspirin | 26 | 1 | Neutral | Will Attend | Day Shift | 10 | 10 | 0 | 1 | 9 | Aspirin | Aspirin | 1 | 0 | 23-11-2022 | 08:42-09:24 | 2026-03-24 14:50:20 |
| 97888 | Suresh | 89 | Male | Morning | 45 | 220846 | Ophthalmologist | Eye Checkup | Previously treated for Eye Checkup | Completely Cured | Mumbai | 4 | Vitamin A Supplements | 16 | 11 | Satisfied | Will Attend | Day Shift | 15 | 4 | 11 | 0 | 4 | No Private Hospital Visits | Vitamin A Supplements | 0.266666667 | 0.733333333 | 06-02-2022 | 13:45-14:13 | 2026-03-24 14:50:20 |
| 48608 | Amit | 58 | Female | Afternoon | 30 | 915450 | Nephrologist | Kidney Problems | Previously treated for Kidney Problems | Completely Cured | Ahmedabad | 8.6 | Diuretics | 21 | 13 | Dissatisfied | Will Attend | Day Shift | 10 | 3 | 7 | 0 | 3 | No Private Hospital Visits | Diuretics | 0.3 | 0.7 | 06-08-2022 | 10:46-11:26 | 2026-03-24 14:50:20 |
| 12526 | Arjun | 61 | Male | Afternoon | 60 | 274650 | Endocrinologist | Diabetes | Previously treated for Diabetes | Not Cured Well | Kolkata | 10.7 | Metformin | 10 | 0 | Satisfied | Will Attend | Unemployed | 11 | 6 | 5 | 6 | 0 | Metformin | No Government Hospital Visits | 0.545454545 | 0.454545455 | 05-06-2020 | 11:38-11:57 | 2026-03-24 14:50:20 |
| 11001 | Amit | 75 | Male | Morning | 60 | 467504 | Ophthalmologist | Eye Checkup | Previously treated for Eye Checkup | Moderately Cured | Jaipur | 6.8 | Vitamin A Supplements | 9 | 9 | Neutral | Will Attend | Night Shift | 16 | 10 | 6 | 2 | 8 | Vitamin A Supplements | Vitamin A Supplements | 0.625 | 0.375 | 08-04-2022 | 16:27-16:41 | 2026-03-24 14:50:20 |