Link to Data File (Parking.csv): https://data.cityofnewyork.us/City-Government/Open-Parking-and-Camera-Violations/nc67-uf89 In this assignment, you will analyze a large public data set in an effort to answer one of the burning questions of our time: Who isn't paying their parking tickets? The work you will do in this assignment is a variation of something done in the amazing and popular blog I Quant NY (Links to an external site.). You should read the original article here (Links to an external site.). In a nutshell, we are going look at New York City parking ticket data and determine which country's diplomats owe and how much. The entire data set is available online but it's way too big for our purposes so you will trim it down to only include tickets for street cleaning violations and only those tickets that still have an amount due of over $50.00. You must download the data file for this assignment here. (Links to an external site.)You can use the online filter features or whatever your favorite spreadsheet editor is to remove the undesired tickets and information but the result should be a large CSV file that is in the same format as this Download this example file. your collection of parking tickets can be represented as a single DataFrame. Problem 1 Use pandas to read Parking.csv and store the entire dataset as a DataFrame. Problem 2 Write a Python function that takes as input a DataFrame containing all of the ticket information and a plate string and returns a tuple containing the following information: (number of open violations, total dollar amount due of all open violations) Problem 3 Write a Python function to determine which car owes the most money. Your function should take a DataFrame containing the parking ticket information as input and should return a tuple containing the following information (plate number, total amount due) associated with whichever car owes the most money. Problem 4 Determine how much money diplomatic cars from Egypt owe in total. Also determine which particular car (which plate) from Egypt owes the most money and how much. Finally, determine in which year between 1995-2019 Egypt owed the most money and how much was it. NB: The second & third letters on the plate are country codes that the government created for these licenses plate. Egypt second & third letter on the plate is : TH
Link to Data File (Parking.csv): https://data.cityofnewyork.us/City-Government/Open-Parking-and-Camera-Violations/nc67-uf89
In this assignment, you will analyze a large public data set in an effort to answer one of the burning questions of our time: Who isn't paying their parking tickets? The work you will do in this assignment is a variation of something done in the amazing and popular blog I Quant NY (Links to an external site.). You should read the original article here (Links to an external site.). In a nutshell, we are going look at New York City parking ticket data and determine which country's diplomats owe and how much. The entire data set is available online but it's way too big for our purposes so you will trim it down to only include tickets for street cleaning violations and only those tickets that still have an amount due of over $50.00. You must download the data file for this assignment here. (Links to an external site.)You can use the online filter features or whatever your favorite spreadsheet editor is to remove the undesired tickets and information but the result should be a large CSV file that is in the same format as this Download this example file.
your collection of parking tickets can be represented as a single DataFrame.
Problem 1 Use pandas to read Parking.csv and store the entire dataset as a DataFrame.
Problem 2 Write a Python function that takes as input a DataFrame containing all of the ticket information and a plate string and returns a tuple containing the following information: (number of open violations, total dollar amount due of all open violations)
Problem 3 Write a Python function to determine which car owes the most money. Your function should take a DataFrame containing the parking ticket information as input and should return a tuple containing the following information (plate number, total amount due) associated with whichever car owes the most money.
Problem 4 Determine how much money diplomatic cars from Egypt owe in total. Also determine which particular car (which plate) from Egypt owes the most money and how much. Finally, determine in which year between 1995-2019 Egypt owed the most money and how much was it.
NB: The second & third letters on the plate are country codes that the government created for these licenses plate. Egypt second & third letter on the plate is : TH
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
