Below is 'Parking.csv'PlateStateLicense TypeIssue DateViolation TimeViolationFine AmountPenalty AmountInterest AmountReduction AmountPayment AmountAmount DuePrecinctCountyHNU6125NYPAS8/25/1711:54ANO PARKING-STREET CLEANING$45.00$10.00$0.00$0.00$0.00$55.0047BX632NDZINPAS8/26/1708:16ANO PARKING-STREET CLEANING$45.00$10.00$0.00$0.00$0.00$55.0047BXC68FVHNJPAS8/26/1708:20ANO PARKING-STREET CLEANING$45.00$10.00$0.00$0.00$0.00$55.0047BXNAX52CNJPAS9/24/0409:32ANO PARKING-STREET CLEANING$45.00$30.00$0.00$20.00$0.00$55.0043 0023CBDDPPAS9/24/0412:46ANO PARKING-STREET CLEANING$65.00$60.00$0.00$0.00$0.00$125.007NY059CWDDPPAS10/15/0410:16PNO PARKING-STREET CLEANING$65.00$60.00$0.00$0.00$0.00$125.0019NYNAX52CNJPAS10/18/0409:31ANO PARKING-STREET CLEANING$45.00$10.00$0.00$0.00$0.00$55.0043BXA00925DPPAS10/29/0411:02ANO PARKING-STREET CLEANING$45.00$60.00$0.00$0.00$0.00$105.0026NYCSD 1.00DPPAS4/7/0511:17ANO PARKING-STREET CLEANING$65.00$60.00$0.00$0.00$0.00$125.0013NY002YKDDPPAS9/20/0508:49ANO PARKING-STREET CLEANING$65.00$60.00$0.00$0.00$0.00$125.0013NY024DRDDPPAS4/5/0511:40ANO PARKING-STREET CLEANING$65.00$60.00$0.00$0.00$0.00$125.0019NYA00925DPPAS4/11/0511:02ANO PARKING-STREET CLEANING$45.00$10.00$0.00$0.00$0.00$55.0026NYHJV7703NYPAS8/26/1708:40ANO PARKING-STREET CLEANING$45.00$10.00$0.00$0.00$0.00$55.0047BXCXW1078NYOMS6/1/0609:52ANO PARKING-STREET CLEANING$45.00$60.00$0.00$30.00$0.00$75.00112Q0006RMDDPPAS6/15/0609:03ANO PARKING-STREET CLEANING$65.00$60.00$0.00$0.00$0.00$125.0019NYEVD5399NYPAS8/26/1708:51ANO PARKING-STREET CLEANING$45.00$10.00$0.00$0.00$0.00$55.0047BXEHT2555PAPAS12/14/6611:56ANO PARKING-STREET CLEANING$45.00$10.00$0.00$0.00$0.00$55.0067K49639JMNYCOM9/6/0708:09ANO PARKING-STREET CLEANING$45.00$10.00$0.00$0.00$0.00$55.0078KDTH1603NYPAS1/4/1008:11ANO PARKING-STREET CLEANING$45.00$60.00$70.57$0.00$0.00$175.5734NYTTD 9.00DPPAS8/31/0710:30ANO PARKING-STREET CLEANING$65.00$60.00$0.00$0.00$0.00$125.0017 51972JMNYCOM9/20/0711:31ANO PARKING-STREET CLEANING$45.00$10.00$0.00$0.00$0.00$55.0083KBFF1793MIPAS6/23/0808:43ANO PARKING-STREET CLEANING$45.00$60.00$73.21$0.00$0.00$178.2132NY29780AVNYCOM3/3/0810:05ANO PARKING-STREET CLEANING$45.00$10.00$0.00$0.00$0.00$55.00115Q49639JMNYCOM3/12/0809:05ANO PARKING-STREET CLEANING$45.00$10.00$0.00$0.00$0.00$55.0084KBML1477NYPAS6/6/0812:41PNO PARKING-STREET CLEANING$45.00$60.00$73.74$0.00$0.00$178.7481K49639JMNYCOM4/1/0808:15ANO PARKING-STREET CLEANING$45.00$10.00$0.00$0.00$0.00$55.0078K49639JMNYCOM4/18/0808:10ANO PARKING-STREET CLEANING$45.00$10.00$0.00$0.00$0.00$55.0078KBAC4439NYPAS6/26/0807:34ANO PARKING-STREET CLEANING$45.00$60.00$73.19$0.00$0.00$178.1966KBEE7356NYOMS6/17/0808:37ANO PARKING-STREET CLEANING$45.00$60.00$72.67$0.00$0.00$177.6772KBVH1758NYOMS6/21/0808:33ANO PARKING-STREET CLEANING$45.00$60.00$72.47$0.00$0.00$177.4730NYDTH1603NYPAS1/11/1008:16ANO PARKING-STREET CLEANING$45.00$60.00$70.39$0.00$0.00$175.3934NY 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 parkingtickets? The work you will do in this assignment is a variation of something done in the amazing and popular blog / Quant NY 2 . You should read the originalarticle here e. 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 entiredata 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 thosetickets that still have an amount due of over $50.00. You must download the data file for this assignment here. 2 You can use the online filter features orwhatever 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 sameformat as this į example file.In class we will learned how to read CSV files using Pandas and you should use that to read the large file above. So your collection of parking tickets can berepresented 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 containingthe following information: (number of open violations, total dollar amount due of all open violations)

Name: Below is 'Parking.csv'PlateStateLicense TypeIssue DateViolation TimeVi
Uploaded: 2024-03-20T06:51:23.000Z
Channel: Bartleby
Description: Below is 'Parking.csv'PlateStateLicense TypeIssue DateViolation TimeViolationFine AmountPenalty AmountInterest AmountReduction AmountPayment AmountAmount DuePrecinctCountyHNU6125NYPAS8/25/1711:54ANO PARKING-STREET CLEANING$45.00$10.00$0.00$0.00$0.00$

To use the Pandas library, we need to import it in our code. We can read a csv file using read_csv() which is available in Pandas. Please refer to the following steps for the complete solution to the problem above.Please refer to the following code with comments for the better understanding of the solution to the problem above. Comments are for your understanding and can be discarded. CODE for Problem 1 => import pandas as pd #importing pandas df = pd.read_csv('Parking.csv') #reading the csv file and storing it into df as a dataframe CODE for Problem 2 => def total_information(df,plate): #function which takes a data frame and a plate number number_violations = 0 #defining variable to count the number of open violations amount_due = 0 #defining variable to calculate the total amount due df.columns = df.columns.str.replace(' ','_') #removing the spaces from the columns name because pandas cannot handle column names with spaces for i in range(len(df)): #iterating through the dataframe's length if df['Plate'][i] == plate: #if any of the plate in the dataframe matches with the parameter plate number_violations+=1 #increment the number of violations by 1 amount_due+= (float)(df['Amount_Due'][i][1:]) #add the amount due to calculate the total. Ignoring the $ symbol. mytuple = (number_violations,amount_due) #forming the tuple as required in the question return mytuple #returning the tuple Please refer to the following images for the sample output of the code above -

Answered: Problem 1 Use pandas to read…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Topic Video

Question

Below is 'Parking.csv'

Plate	State	License Type	Issue Date	Violation Time	Violation	Fine Amount	Penalty Amount	Interest Amount	Reduction Amount	Payment Amount	Amount Due	Precinct	County
HNU6125	NY	PAS	8/25/17	11:54A	NO PARKING-STREET CLEANING	$45.00	$10.00	$0.00	$0.00	$0.00	$55.00	47	BX
632NDZ	IN	PAS	8/26/17	08:16A	NO PARKING-STREET CLEANING	$45.00	$10.00	$0.00	$0.00	$0.00	$55.00	47	BX
C68FVH	NJ	PAS	8/26/17	08:20A	NO PARKING-STREET CLEANING	$45.00	$10.00	$0.00	$0.00	$0.00	$55.00	47	BX
NAX52C	NJ	PAS	9/24/04	09:32A	NO PARKING-STREET CLEANING	$45.00	$30.00	$0.00	$20.00	$0.00	$55.00	43
0023CBD	DP	PAS	9/24/04	12:46A	NO PARKING-STREET CLEANING	$65.00	$60.00	$0.00	$0.00	$0.00	$125.00	7	NY
059CWD	DP	PAS	10/15/04	10:16P	NO PARKING-STREET CLEANING	$65.00	$60.00	$0.00	$0.00	$0.00	$125.00	19	NY
NAX52C	NJ	PAS	10/18/04	09:31A	NO PARKING-STREET CLEANING	$45.00	$10.00	$0.00	$0.00	$0.00	$55.00	43	BX
A00925	DP	PAS	10/29/04	11:02A	NO PARKING-STREET CLEANING	$45.00	$60.00	$0.00	$0.00	$0.00	$105.00	26	NY
CSD 1.00	DP	PAS	4/7/05	11:17A	NO PARKING-STREET CLEANING	$65.00	$60.00	$0.00	$0.00	$0.00	$125.00	13	NY
002YKD	DP	PAS	9/20/05	08:49A	NO PARKING-STREET CLEANING	$65.00	$60.00	$0.00	$0.00	$0.00	$125.00	13	NY
024DRD	DP	PAS	4/5/05	11:40A	NO PARKING-STREET CLEANING	$65.00	$60.00	$0.00	$0.00	$0.00	$125.00	19	NY
A00925	DP	PAS	4/11/05	11:02A	NO PARKING-STREET CLEANING	$45.00	$10.00	$0.00	$0.00	$0.00	$55.00	26	NY
HJV7703	NY	PAS	8/26/17	08:40A	NO PARKING-STREET CLEANING	$45.00	$10.00	$0.00	$0.00	$0.00	$55.00	47	BX
CXW1078	NY	OMS	6/1/06	09:52A	NO PARKING-STREET CLEANING	$45.00	$60.00	$0.00	$30.00	$0.00	$75.00	112	Q
0006RMD	DP	PAS	6/15/06	09:03A	NO PARKING-STREET CLEANING	$65.00	$60.00	$0.00	$0.00	$0.00	$125.00	19	NY
EVD5399	NY	PAS	8/26/17	08:51A	NO PARKING-STREET CLEANING	$45.00	$10.00	$0.00	$0.00	$0.00	$55.00	47	BX
EHT2555	PA	PAS	12/14/66	11:56A	NO PARKING-STREET CLEANING	$45.00	$10.00	$0.00	$0.00	$0.00	$55.00	67	K
49639JM	NY	COM	9/6/07	08:09A	NO PARKING-STREET CLEANING	$45.00	$10.00	$0.00	$0.00	$0.00	$55.00	78	K
DTH1603	NY	PAS	1/4/10	08:11A	NO PARKING-STREET CLEANING	$45.00	$60.00	$70.57	$0.00	$0.00	$175.57	34	NY
TTD 9.00	DP	PAS	8/31/07	10:30A	NO PARKING-STREET CLEANING	$65.00	$60.00	$0.00	$0.00	$0.00	$125.00	17
51972JM	NY	COM	9/20/07	11:31A	NO PARKING-STREET CLEANING	$45.00	$10.00	$0.00	$0.00	$0.00	$55.00	83	K
BFF1793	MI	PAS	6/23/08	08:43A	NO PARKING-STREET CLEANING	$45.00	$60.00	$73.21	$0.00	$0.00	$178.21	32	NY
29780AV	NY	COM	3/3/08	10:05A	NO PARKING-STREET CLEANING	$45.00	$10.00	$0.00	$0.00	$0.00	$55.00	115	Q
49639JM	NY	COM	3/12/08	09:05A	NO PARKING-STREET CLEANING	$45.00	$10.00	$0.00	$0.00	$0.00	$55.00	84	K
BML1477	NY	PAS	6/6/08	12:41P	NO PARKING-STREET CLEANING	$45.00	$60.00	$73.74	$0.00	$0.00	$178.74	81	K
49639JM	NY	COM	4/1/08	08:15A	NO PARKING-STREET CLEANING	$45.00	$10.00	$0.00	$0.00	$0.00	$55.00	78	K
49639JM	NY	COM	4/18/08	08:10A	NO PARKING-STREET CLEANING	$45.00	$10.00	$0.00	$0.00	$0.00	$55.00	78	K
BAC4439	NY	PAS	6/26/08	07:34A	NO PARKING-STREET CLEANING	$45.00	$60.00	$73.19	$0.00	$0.00	$178.19	66	K
BEE7356	NY	OMS	6/17/08	08:37A	NO PARKING-STREET CLEANING	$45.00	$60.00	$72.67	$0.00	$0.00	$177.67	72	K
BVH1758	NY	OMS	6/21/08	08:33A	NO PARKING-STREET CLEANING	$45.00	$60.00	$72.47	$0.00	$0.00	$177.47	30	NY
DTH1603	NY	PAS	1/11/10	08:16A	NO PARKING-STREET CLEANING	$45.00	$60.00	$70.39	$0.00	$0.00	$175.39	34	NY

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 / Quant NY 2 . You should read the original
article here e. 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. 2 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 į example file.
In class we will learned how to read CSV files using Pandas and you should use that to read the large file above. So 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)

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.