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 ...
Post a Comment
Read more

Edinburgh Fringe 2019

I am currently conducting a long-distance love affair with the Edinburgh Festival Fringe. It's tough going, but it's worth it to keep our relationship alive. This year my work was shortlisted for the Allen Wright Award for journalism at the Fringe. I spoke to three performers about their shows for publication in The Skinny and her sister magazine Fest: Sophie Duker The Skinny July 2019 Duker runs a monthly comedy night in London, and is taking her debut full-length show to the Fringe. We spoke about 'wokeness', being a token, and the creative process. Magical Bones Fest July 2019 Bones is a professional dancer-turned-magician, who combines his passions in a unique magical style. We spoke about history, race and what magic really is. Isma Almas Fest August 2019 Almas' show about adoption started making waves in Edinburgh, so my editor asked me to speak with her on a 48-hour deadline. We had a lovely chat, I learned a lot about the adoption process, and we made...
Post a Comment
Read more