Reducing the number of high fatality accidents
📖 Background
You work for the road safety team within the department of transport and are looking into how they can reduce the number of serious accidents. The safety team classes serious accidents as fatal accidents involving 3+ casualties. They are trying to learn more about the characteristics of these serious accidents so they can brainstorm interventions that could lower the number of deaths. They have asked for your assistance with answering a number of questions.
💾 The data
The reporting department have been collecting data on every accident that is reported. They've included this along with a lookup file for 2020's accidents.
Published by the department for transport. https://data.gov.uk/dataset/road-accidents-safety-data Contains public sector information licensed under the Open Government Licence v3.0.
library(tidyverse)
accidents <- readr::read_csv('./data/accident-data.csv')
head(accidents)lookup <- readr::read_csv('./data/road-safety-lookups.csv')
head(lookup)💪 Competition challenge
Create a report that covers the following:
- What time of day and day of the week do most serious accidents happen?
- Are there any patterns in the time of day/ day of the week when serious accidents occur?
- What characteristics stand out in serious accidents compared with other accidents?
- On what areas would you recommend the planning team focus their brainstorming efforts to reduce serious accidents?
🧑⚖️ Judging criteria
Recommendations (35%)
- Clarity of recommendations - how clear and well presented the recommendation is.
- Quality of recommendations - are appropriate analytic techniques used & are the conclusions valid?
- Number of relevant insights found for the target audience.
Story telling (30%)
- How well the data and insights are connected to the recommendation.
- How the narrative and whole report connects together.
- Balancing making the report in depth enough but also concise.
Visualizations (25%)
- Appropriateness of visualization used.
- Clarity of insight from visualization.
Upvotes (10%)
- Upvoting - most upvoted entries get the most points.
✅ Checklist before publishing into the competition
- Rename your workspace to make it descriptive of your work. N.B. you should leave the notebook name as notebook.Rmd.
- Remove redundant cells like the judging criteria so the workbook is focused on your story.
- Make sure the workbook reads well and explains how you found your insights.
- Check that all the cells run without error.