University of Florida Processing Datasets Programming Report

https://raw.githubusercontent.com/nytimes/covid-19-data/master/us-counties.csv

1.Write a function that reads in the dataset from the file and extracts all records for a particular state, say, Virginia, in another output file. Use the csv module to read and write files. The output file should have the name: va-counties.csv

2.Write a function that calculates the total number of cases and deaths in a state for a particular day, say January 1/31/2021. Pass the state and date as an argument to your function.

3.Use the previous problem’s function to plot the deaths for January 2021 for each day of the month for Virginia.

4.Write a function that reads in the original csv file and draws a histogram plot of the top ten states showing the states and the number of cases and number of deaths for a specified day.

CANNOT USE PANDA OR NUMPY

HW-5
Processing Datasets
Due Date:4/11/2021
(Using csv and Matplotlib Modules. You are not allowed to use Pandas for this assignment.)
Purpose: This assignment provides you practice in processing datasets using the csv module and
graphing them using Matplotlib. You may have to use the built-in data structures of Lists and Dictionary
and apply techniques you learned before the midterm.
HW-5
Processing Datasets
Due Date:4/11/2021
Background
The New York Times releases a series of data files with cumulative counts of coronavirus cases in the United States,
at the state and county level, over time. It compiles this time series data from state and local governments and health
departments to provide a complete record of the ongoing outbreak. Since late January, The Times has tracked
coronavirus cases in real-time.
The CSV link for counties is: https://raw.githubusercontent.com/nytimes/covid-19-data/master/us-counties.csv
Homework
You will write a program (several functions and plots) that processes this data set using Python’s csv
module and will plot your results and produce different types of visualizations using Matplotlib.
•
You can use Spyder and Jupyter Notebooks during development, but use Juypter Notebooks to
show your code and final submission results. Annotate your code and describe what you are
doing.
1. Write a function that reads in the dataset from the file and extracts all records for a particular
state, say, Virginia, in another output file. Use the csv module to read and write files. The output
file should have the name: va-counties.csv
2. Write a function that calculates the total number of cases and deaths in a state for a particular
day, say January 1/31/2021. Pass the state and date as an argument to your function.
3. Use the previous problem’s function to plot the deaths for January 2021 for each day of the
month for Virginia.
4. Write a function that reads in the original csv file and draws a histogram plot of the top ten
states showing the states and the number of cases and number of deaths for a specified day.