Question

Python help. Any help is appreciated, thank you!

Write a program that asks the user for a CSV of collision data (see note below about obtaining reported collisions from NYC OpenData). Your program should then list the top three contributing factors for the primary vehicle of collisions "CONTRIBUTING FACTOR VEHICLE 1"in the file.

A sample run: Enter CSV file name: collisionsNewYears2016.csv Top three contributing factors for collisions: Driver Inattention/Distraction 136 Unspecified 119 Following To0 Closely 37 Name: CONTRIBUTING FACTOR VEHICLE 1, dtype: int64 This assignment uses collision data collected and made publicly by New York City Open Data, and can be found at: https://data.cityofnewyork.us/Public-Safety/NYPD-Motor-Vehicle-Collisions/h9gi- nx95 Since the files are quite large, use the "Filter" option and choose your birthday in 2016 and "Export" (in CSV format) all collisions for that day. We will use this data set for future programs, so, instead of downloading the test files multiple times, save a copy for future use. Hint: See Lab 8 for accessing and analyzing structured data.

Answer 1

The chosen date is 01/01/2016 and the data can be prepared and exported according to the birthday date.

https://data.cityofnewyork.us/Public-Safety/NYPD-Motor-Vehicle-Collisions/h9gi-nx95/data

From the website, use the "Filter" option to select the birthday date and "Export" option is used to save the data on the selected date as CSV file.

Make sure the downloaded CSV file is in the same folder as that of the Python file.

PROGRAM

pd 1 import pandas 2 fileName as input ("Enter CSV file name: pd.read_csv(fileName) ") 3 file 4 print ("Top three contributing factors for collisions: ") 5 top3 file['CONTRIBUTING FACTOR VEHICLE 1'.value_counts ().nlargest (3) 6 print(top3)

import pandas as pd #Library for data manipulation and analysis
fileName = input("Enter CSV file name: ") #Takes CSV file name from user
file = pd.read_csv(fileName) #Reads the given CSV file
print("Top three contributing factors for collisions: ")
top3 = file['CONTRIBUTING FACTOR VEHICLE 1'].value_counts().nlargest(3)

#Selects the required column and list the top three according to count
print(top3)

OUTPUT

Enter CSV file name: NYPD Motor Vehicle Collisions.csv Top three contributing factors for collisions: Unspecified Driver Inattention/Distraction 165 61 Fatigued/Drowsy Name: CONTRIBUTING FACTOR VEHICLE 1, dtype: int64 26