Question
Download the data file state_crime.csv . This data file contains records of different types of reported crimes. The first line of the file contains a
Download the data file state_crime.csv. This data file contains records of different types of reported crimes. The first line of the file contains a description of each column of data.
Directions
Write a python program to read the file, and produce a summary of the total reported crimes for each state. The report will look something like this, though don't worry if your list is not in alphabetical order:
State Reported Crimes Alabama 8,133,055 Alaska 1,198,047 ... Wyoming 834,588 United States 563,841,249
There are a lot of fields in the data file, but you can simplify your life by using subtotal fields, Totals.Property.All and Totals.Violent.All.
Once you have the summary, change your program so it writes the summary to a file, crime_summary.txt.
Make sure you use a dictionary for this assignment. The obvious case is to use a key of state names and the value is the accumulated count of reported crimes. There might be a place for another dictionary as well, though you only need to use one.
Be sure to add a header comment to your program and any functions, and appropriate comments before other blocks of code.
The data file is too large and can not be uploaded.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started