Skip to main content

Data Science

I am starting to dip my toe into the world of Data Science. I am teaching myself Python and SQL, and following a Masters course in Data Science at the Technical University of Dublin. Below are sample projects I have produced for job interviews etc.

Brooklyn motor vehicle collisions case study

An investigation of motor vehicle collisions in Brooklyn 2014-2017. Aim is to reduce vehicle collisions and deaths.

Executive summary

  • 190,981 motor vehicle collisions in Brooklyn in 2014-2017
    • 207 resulted in deaths
  • Driver Inattention is biggest factor in motor vehicle collisions
    • Involved in 55,971 collisions
  • Complex intersections on Atlantic Avenue and zip code 11207 are more dangerous areas
  • Accidents are more frequent around typical rush hours
    • 8am and 4pm Monday to Friday

Approach taken

  • Data filtered by date (2014-2017) and borough (Brooklyn)
  • Deaths:
    • Data filtered by factors (no NULL and no Unspecified)
    • If no factors recorded, unclear how to avoid these deaths
  • Time / date
    • Analysed by week day and by hour
    • Inspected data for Mon-Fri and weekends separately
  • Location
    • Analysed by longitude and latitude, cross-street and zip code

Key findings on accident patterns

  • Most common factor associated with all collisions
    • Driver inattention
  • Most common factors associated with deadly collisions
    • Driver inattention, Failure to Yield Right-of-Way, Disregard of Traffic Control
    • Driver inattention could lead to these other factors
  • Collisions are most common during rush hour Mon-Fri
  • Collisions are most common on road intersections

Recommendations to reduce collisions

  • Reduce distracted driving
    • Driver Distraction/Inattention is the factor most often reported in all collisions, and in collisions that cause deaths. Other factors (Failure to yield, Ignored traffic control measures) may also be attributed to driver distraction. 
    • Recommend a data-driven distracted driving campaign to alert the public
    • New York launched a distracted driving campaign on April 9 2019
  • Reduce speeds at complex intersections
    • Collisions are most common at road intersections
    • The single biggest collision hotspot is a complex road intersection with multiple landmarks nearby
    • Reducing speed limits at these points may help reduce collisions and deaths

Appendix



Comments

  1. Atanas8 December 2020 at 12:13

    Nice work. You find this interesting Python Interview Practice repo https://github.com/Anyulund/Python-Interview-Practice/blob/master/Data-Science-Interview-Questions.ipynb

    ReplyDelete

Post a Comment

Popular posts from this blog

Cultural Journalism

I lived in Edinburgh for 6 years, and spent every summer attending the Edinburgh Festival Fringe. When the biggest performing arts festival in the world lands on your doorstep, you have to go out and see what's happening. I started out as a roaming reviewer, then progressed to editor and features writer for multiple publications. Through this work I started up a great relationship with The Skinny and Fest, which continues to this day . Fest  - August 2019 Interviews with Magical Bones and Isma Almas . The Skinny  - 2011 to present Comedy reviews, previews, interviews, and the odd foray into Tech and Magic in one of Scotland's best and most widely-read cultural magazines. Interviews:  David Baddiel ,  Derren Brown ,  Sara Pascoe ,  Sofie Hagen Edinburgh Magic Festival Apps and books Many more Broadway Baby  - Comedy editor, August 2013 I scheduled shows for a team of 100 reviewers, edited their pieces in the safety of the office, then broke free and reviewed a few sh
Post a Comment
Read more

Pleased to meet you

Let's talk:    jenni.ajderian@gmail.com Mild-mannered copywriter by day, crime-fighting data analyst by night. Currently protecting the mean streets of Dublin from bad content. Shortlisted for the Allen Wright Award 2019 "She's one of the good ones" -  FringePig "Best. Review. Ever." -  @ObjectiveTalent "This interview has won #edfringe" -  @FredRAlexander "I think this is the nicest review I've ever received." -  @DouglasSits "Do you give lessons? Jus askin..." -  @RockyFlintstone Experienced wordy type with a penchant for technology. I've worked with words since 2010, and have moved from student newspapers and cultural magazines to technical writing and copywriting. I can work in Agile, as part of a team, remotely, on-site, solo, in airports, in kitchens, you name it. Find me on LinkedIn , or have a look around this blog for more details of my experience. If you're looking for a writer for a
Post a Comment
Read more