python spyder

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

About the Author

Follow me


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