Solution: Plotting the Grouped Data
Let’s look at the solution to the above tasks.
Task 1: Flux of calls per day
We now have the column ‘date’ in our data. The emergency department needs to know the flux of calls per day for each reason mentioned in the dataset so that they can take the necessary steps to improve the service.
For this task, find the variation in the number of calls per day for three reasons in the dataset: traffic, fire and EMS.
Hint: You need to group the data for each reason on the date column and call the
count()
.
Get hands-on with 1200+ tech skills courses.