Question

1 Approved Answer

Posted on Sep 26, 2024

I am new to data science. I have a dateset pertaining to calls received to a hospital emergency helpline. I need to identify hidden data

I am new to data science. I have a dateset pertaining to calls received to a hospital emergency helpline. I need to identify hidden data patterns in the dataset. What would the approach to identify such hidden patterns.

Extract from dataset (To view the image in full size, right click on the image and select option - open image in new tab) image text in transcribed

calltype district eventdate vehicletype gender ero_chiefcomplaint casetype hospital name call time amby start time at scene time from scene time at hospital time handover time departure time back to base area Emergenoy call District 1 12-12-17 BLS Male Chest Pain Unavailed Calls 12-12-17 19:38 12-12-17 19:39 12-12-17 19:55 12-12-17 20:01 01-01-80 0:00 01-01-800:00 12-12-17 20:20 12-12-17 20:20 Rural Emergency call District 2 12-12-17 BLS Male Heart Problem Unavailed Calls 12-12-17 22:05 12-12-17 22:09 12-12-17 22:09 12-12-17 22:09 01-01-80 0:00 01-01-80 0:00 12-12-17 22:09 12-12-17 22:09 Rural Emergenoy call District 3 12-12-17 BLS Male Cardiac Arrest Unavailed Calls 12-12-17 22:33 12-12-17 22:35 12-12-17 22:50 12-12-17 23:00 01-01-80 0:00 01-01-80 0:00 12-12-17 23:30 12-12-17 23:30 Rural Hosp To Hosp Call District 4 12-12-17 ALS Male Heart Problem Unavailed Calls 12-12-17 22:37 12-12-17 22:37 12-12-17 22:3712-12-17 22:37 01-01-80 0:00 01-01-80 0:00 12-12-17 22:37 12-12-17 22:37 Urban Emergency call District 5 13-12-17 BLS Female Cardiac Arrest Unavailed Calls 13-12-17 0:26 13-12-17 0:26 13-12-17 0:26 13-12-170:26 13-12-17 0:26 13-12-17 0:26 01-01-80 0:00 01-01-80 0:00 13-12-17 0:26 13-12-170:26 Urban Emergency call District 1 13-12-17 ALS Male Chest Pain Unavailed Calls 13-12-17 2:02 13-12-17 2:03 13-12-17 2:10 13-12-17 2:18 01-01-80 0:00 01-01-80 0:00 13-12-17 2:26 13-12-17 2:26 Urban Emergency call District 2 13-12-17 BLS Male Cardiac Arrest Unavailed Calls 13-12-17 2:12 13-12-17 2:13 13-12-17 2:15 13-12-17 2:17 01-01-800:00 01-01-80 0:00 13-12-17 2:20 13-12-17 2:20 Urban Emergency call District 3 13-12-17 BLS Female Heart Problem Unavailed Calls 13-12-17 10:32 13-12-17 10:32 13-12-17 10:32 13-12-17 10:32 01-01-80 0:00 01-01-80 0:00 13-12-17 10:32 13-12-17 10:32 Rural Hosp To Hosp Call District 4 13-12-17 BLS Female Heart Problem Unavailed Calls 13-12-17 11:24 13-12-17 11:25 13-12-17 11:27 13-12-17 11:28 01-01-80 0:00 01-01-80 0:00 13-12-17 11:37 13-12-17 11:37 Rural Hosp To Hosp Call District 5 13-12-17 ALS Male Heart Problem Death on Arrival 13-12-17 11:35 13-12-17 11:36 13-12-17 11:56 13-12-17 12:55 01-01-80 0:00 01-01-80 0:00 13-12-17 13:00 13-12-17 13:00 Rural Emergency call District 1 13-12-17 ALS Male Heart Problem Unavailed Calls 13-12-17 12:02 13-12-17 12:02 13-12-17 12:02 13-12-17 12:02 01-01-80 0:00 01-01-800:00 13-12-17 12:02 13-12-17 12:02 Urban Hosp To Hosp Call District 2 13-12-17 BLS Male Chest Pain Unavailed Calls 13-12-17 15:39 13-12-17 15:39 13-12-17 15:42 13-12-17 15:45 01-01-80 0:00 01-01-80 0:00 13-12-17 15:48 13-12-17 15:48 Urban Emergency call District 3 3 13-12-17 BLS Male Heart Problem Unavailed Calls 13-12-17 17:43 13-12-17 17:43 13-12-17 17:43 13-12-17 17:43 01-01-80 0:00 01-01-800:00 13-12-17 17:43 13-12-17 17:43 Urban Emergency call District 4 13-12-17 BLS Male Chest Pain Others ABC 13-12-17 18:15 13-12-17 18:18 13-12-17 18:21 13-12-17 18:25 13-12-17 19:10 13-12-17 19:15 13-12-17 20:20 13-12-17 20:20 Rural Emergency call District 5 13-12-17 BLS Male Heart Problem Unavailed Calls 13-12-17 18:10 13-12-17 18:12 13-12-17 18:19 13-12-17 18:25 01-01-800:00 01-01-800:00 13-12-17 18:35 13-12-17 18:35 Rural Emergency call District 1 13-12-17 ALS Female Heart Problem Cardiac DEF 13-12-17 19:23 13-12-17 19:24 13-12-17 19:30 13-12-17 19:40 13-12-17 19:45 13-12-17 20:03 13-12-17 20:13 13-12-17 20:13 Urban Emergency call District 2 13-12-17 ALS Male Heart Problem Unavailed Calls 13-12-17 19:55 13-12-17 19:55 13-12-17 19:55 13-12-17 19:55 01-01-80 0:00 01-01-80 0:00 13-12-17 19:55 13-12-17 19:55 Rural Emergency call District 3 13-12-17 ALS Male Chest Pain Medical HGU 13-12-17 21:26 13-12-17 21:34 13-12-17 21:42 13-12-17 21:54 13-12-17 22:10 13-12-17 22:20 13-12-17 22:25 13-12-17 22:25 Urban Emergency call District 4 13-12-17 ALS Female Heart Problem Unavailed Calls 13-12-17 21:22 13-12-17 21:22 13-12-17 21:28 13-12-17 21:30 01-01-80 0:00 01-01-80 0:00 13-12-17 21:32 13-12-17 21:32 Urban age Address 28 Address 1 50 76 45 Addres22 52 34 44 55 86 65 60 36 45 65 60 35 80 46 70 calltype district eventdate vehicletype gender ero_chiefcomplaint casetype hospital name call time amby start time at scene time from scene time at hospital time handover time departure time back to base area Emergenoy call District 1 12-12-17 BLS Male Chest Pain Unavailed Calls 12-12-17 19:38 12-12-17 19:39 12-12-17 19:55 12-12-17 20:01 01-01-80 0:00 01-01-800:00 12-12-17 20:20 12-12-17 20:20 Rural Emergency call District 2 12-12-17 BLS Male Heart Problem Unavailed Calls 12-12-17 22:05 12-12-17 22:09 12-12-17 22:09 12-12-17 22:09 01-01-80 0:00 01-01-80 0:00 12-12-17 22:09 12-12-17 22:09 Rural Emergenoy call District 3 12-12-17 BLS Male Cardiac Arrest Unavailed Calls 12-12-17 22:33 12-12-17 22:35 12-12-17 22:50 12-12-17 23:00 01-01-80 0:00 01-01-80 0:00 12-12-17 23:30 12-12-17 23:30 Rural Hosp To Hosp Call District 4 12-12-17 ALS Male Heart Problem Unavailed Calls 12-12-17 22:37 12-12-17 22:37 12-12-17 22:3712-12-17 22:37 01-01-80 0:00 01-01-80 0:00 12-12-17 22:37 12-12-17 22:37 Urban Emergency call District 5 13-12-17 BLS Female Cardiac Arrest Unavailed Calls 13-12-17 0:26 13-12-17 0:26 13-12-17 0:26 13-12-170:26 13-12-17 0:26 13-12-17 0:26 01-01-80 0:00 01-01-80 0:00 13-12-17 0:26 13-12-170:26 Urban Emergency call District 1 13-12-17 ALS Male Chest Pain Unavailed Calls 13-12-17 2:02 13-12-17 2:03 13-12-17 2:10 13-12-17 2:18 01-01-80 0:00 01-01-80 0:00 13-12-17 2:26 13-12-17 2:26 Urban Emergency call District 2 13-12-17 BLS Male Cardiac Arrest Unavailed Calls 13-12-17 2:12 13-12-17 2:13 13-12-17 2:15 13-12-17 2:17 01-01-800:00 01-01-80 0:00 13-12-17 2:20 13-12-17 2:20 Urban Emergency call District 3 13-12-17 BLS Female Heart Problem Unavailed Calls 13-12-17 10:32 13-12-17 10:32 13-12-17 10:32 13-12-17 10:32 01-01-80 0:00 01-01-80 0:00 13-12-17 10:32 13-12-17 10:32 Rural Hosp To Hosp Call District 4 13-12-17 BLS Female Heart Problem Unavailed Calls 13-12-17 11:24 13-12-17 11:25 13-12-17 11:27 13-12-17 11:28 01-01-80 0:00 01-01-80 0:00 13-12-17 11:37 13-12-17 11:37 Rural Hosp To Hosp Call District 5 13-12-17 ALS Male Heart Problem Death on Arrival 13-12-17 11:35 13-12-17 11:36 13-12-17 11:56 13-12-17 12:55 01-01-80 0:00 01-01-80 0:00 13-12-17 13:00 13-12-17 13:00 Rural Emergency call District 1 13-12-17 ALS Male Heart Problem Unavailed Calls 13-12-17 12:02 13-12-17 12:02 13-12-17 12:02 13-12-17 12:02 01-01-80 0:00 01-01-800:00 13-12-17 12:02 13-12-17 12:02 Urban Hosp To Hosp Call District 2 13-12-17 BLS Male Chest Pain Unavailed Calls 13-12-17 15:39 13-12-17 15:39 13-12-17 15:42 13-12-17 15:45 01-01-80 0:00 01-01-80 0:00 13-12-17 15:48 13-12-17 15:48 Urban Emergency call District 3 3 13-12-17 BLS Male Heart Problem Unavailed Calls 13-12-17 17:43 13-12-17 17:43 13-12-17 17:43 13-12-17 17:43 01-01-80 0:00 01-01-800:00 13-12-17 17:43 13-12-17 17:43 Urban Emergency call District 4 13-12-17 BLS Male Chest Pain Others ABC 13-12-17 18:15 13-12-17 18:18 13-12-17 18:21 13-12-17 18:25 13-12-17 19:10 13-12-17 19:15 13-12-17 20:20 13-12-17 20:20 Rural Emergency call District 5 13-12-17 BLS Male Heart Problem Unavailed Calls 13-12-17 18:10 13-12-17 18:12 13-12-17 18:19 13-12-17 18:25 01-01-800:00 01-01-800:00 13-12-17 18:35 13-12-17 18:35 Rural Emergency call District 1 13-12-17 ALS Female Heart Problem Cardiac DEF 13-12-17 19:23 13-12-17 19:24 13-12-17 19:30 13-12-17 19:40 13-12-17 19:45 13-12-17 20:03 13-12-17 20:13 13-12-17 20:13 Urban Emergency call District 2 13-12-17 ALS Male Heart Problem Unavailed Calls 13-12-17 19:55 13-12-17 19:55 13-12-17 19:55 13-12-17 19:55 01-01-80 0:00 01-01-80 0:00 13-12-17 19:55 13-12-17 19:55 Rural Emergency call District 3 13-12-17 ALS Male Chest Pain Medical HGU 13-12-17 21:26 13-12-17 21:34 13-12-17 21:42 13-12-17 21:54 13-12-17 22:10 13-12-17 22:20 13-12-17 22:25 13-12-17 22:25 Urban Emergency call District 4 13-12-17 ALS Female Heart Problem Unavailed Calls 13-12-17 21:22 13-12-17 21:22 13-12-17 21:28 13-12-17 21:30 01-01-80 0:00 01-01-80 0:00 13-12-17 21:32 13-12-17 21:32 Urban age Address 28 Address 1 50 76 45 Addres22 52 34 44 55 86 65 60 36 45 65 60 35 80 46 70