This link you can find the database in this first file to download it
Using the following database
https://catalog.data.gov/dataset/traffic-violations-56dda
answer to the following questions:
- Print names of columns
- Print number of records
- Number of the violation in 2018
- Number of an violation between 2010 to 2015
- Number of the violation occurred in daylight in 2013
- Number of injuries in 2015
- Number of fatal injuries in 2015
- Report:
- The time, day, month, the year that had the highest number of violation
- The time, day, month, the year that had the highest number of violation related to alcohol
- The brand of car that received the highest number of violation
- The new year of what year had the highest number of violation
- Compare the number of violations in different states
- Look at the trend of violation
- Look at the trend of violation related to alcohol
- Visualize the result and prepare a report on your findings. Your report should be emailed in a word document
Also the attached file is the file I want you to keep working on and please make each question in a separate section also dont forget to add the question above each code. And chaning what need to be changed if there is a need


0 comments