The Jupiter

 

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 (iquantny.tumblr.com)
You should read the original article here (http://iquantny.tumblr.com/post/140432262249/parking-immunity-diplomats-owe-nyc-16-million-in)
In a nutshell we are going to 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 (https://data.cityofnewyork.us/City-Government/Open-Parking-and-Camera-Violations/nc67-uf89)
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 (file name: file2) 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)

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 Use the information in this file:
http://www.cs.columbia.edu/~cannon/1002/data/diplomatic_info.pdf

to 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.
What to hand in:

 

 

Sample Solution

orn a blank canvas and their lives are determined by varying experiences, positive interactions whilst acquiring different attributes and not due to DNA. She believed men and women were born equal and brains were malleable by culture, life experiences and desires, whereas Freud (1961) argued this and believed men and women’s brains were very different and the way they were formed was wholly down to DNA. Freud (1961) founded the study of psychoanalysis, he believed traumas and unresolved issues during childhood could be coaxed out by sensitive talk therapy. This can be seen in settings today by way of one:one counselling or through emotional literacy. Place2Be (1994) delivers school based therapeutic interventions. A large study was carried out on 47,000 children in primary schools, based on the findings of Place2Be, children’s social and emotional wellbeing had improved as perceived by their family members and teachers following interventions (White Et al., 2009). Supporting this Fox and Butler (2007) carried out a small-scale study on 219 pupils, attempting to discover whether counselling is successful in schools. The results suggested that the treatment delivered to the children, had less distress and fewer problems were observed. However, they recommended further research is required, to discover when and to who it was more of a success to. The evidence suggests that pupils receiving psychological therapies were a success however, The National Institute for Health and Care Excellence (NICE, 2010) expressed the opinion and recommended several forms of therapy as first-line interventions, not talk therapy or counselling in isolation. Another essential point regarding one:one counselling and emotional literacy is the relationship a child has with the facilitator. Mindmatters (n.d.) advocates how vital it is for children to have a trusting and caring relationship with the individual, as a result of this trust and understanding, will promote open communication. Similarly, Bowlby (1969) suggested that children come into this world with an innate response of survival; form attachments to survive. Consequently, if secure attachments are not formed this would lead to distress and negative experiences concluding that a trusting relationship is not formed between the pupil and the facilitator. Belsky and Fearon (2002) support Bowlby and state ‘poor attachment outcomes are associated with long-term adverse consequences in cognitive, adaptive, and behavioral domains’. Comparing Maslow (1968c), Bronfenbrenner (1979) Sameroff (2010) and Shonokoff an

This question has been answered.

Get Answer
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, Welcome to Compliant Papers.