Embedded Files
Cost-of-Living Analysis
Cost-of-Living Analysis
Traffic Accident Analysis
Traffic Accident Analysis
This dataset represented traffic accidents within Montgomery County, Maryland; every record represents a recorded vehicle accident. The most important columns are 'crash_date/time' and 'local_case_number' (as the unique identifier).
The dataset spans from 2015 to 2024.
Data Wrangling
Data Wrangling
Checked for duplicate rows
Trimmed whitespaces from 2,336 cells
Formatted header row; used 'Find-Replace' to change spaces to underscores
Vehicle_Year column: empty cells ⇢ 'null', 14 ⇢ 2014, 15 ⇢ 2015, 1015 ⇢ 2015, 1011 ⇢ 2011
Formatted column datatypes
Medical Research Data
Medical Research Data
Medical Research (Published)
Medical Research (Published)
Using the published PDF (linked in footer of dashboard)
re-Created the table (figure) in Google Sheets
Used built-in datatypes to create geographical visual
Used Midjourney to create free-use image
Added control to filter each country
Google Trends
Google Trends
Page updated
Google Sites
Report abuse