PYTHON SPYDER code

0 comments

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:

  1. Print names of columns
  2. Print number of records
  3. Number of the violation in 2018
  4. Number of an violation between 2010 to 2015
  5. Number of the violation occurred in daylight in 2013
  6. Number of injuries in 2015
  7. Number of fatal injuries in 2015
  8. Report:
    1. The time, day, month, the year that had the highest number of violation
    2. The time, day, month, the year that had the highest number of violation related to alcohol
    3. The brand of car that received the highest number of violation
    4. The new year of what year had the highest number of violation
    5. Compare the number of violations in different states
    6. Look at the trend of violation
    7. Look at the trend of violation related to alcohol
  9. 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

About the Author

Follow me


{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}