Objectives:

Create a class that has containers as instance attributes

Read $.$csv files into container data types

Write a $.$csv file from container data types

Handle file I$/$O exceptions

You will need to download this file:

census$\_$population.csvDownload census$\_$population.csv

This file contains the Annual Estimates of the Resident Population for Incorporated Places of $50,000$ or More, Ranked by July $1,2021$ Population: April $1,2020$ to July $1,2021$

Population class $(5$ points$)$

For this project, create a class called Population that has:

a container of your choice called file$\_$import as an instance attribute.

an ordered dict called annual as an instance attribute

an ordered dict called biannual as an instance attribute

an import$\_$csv method

a biannual$\_$delta method

an annual$\_$delta method

a search$\_$by$\_$city method

an export$\_$csv method

import$\_$csv method $(5$ points$)$

Create a method of the Population class called import$\_$csv that has a filename as a parameter. This method will perform the following tasks:

Read the file using the filename parameter and load the contents into file$\_$import.

Use try$-$catch exception handling when file is not found

biannual$\_$delta method $(5$ points$)$

Create a method of the Population class called biannual$\_$delta that will perform the following tasks:

Check to see if the file$\_$import is empty

If it is not empty, use a loop to read the file$\_$import container $($do not read the file here$)$ and perform the following for each row:

Subtract the value for the Pop$\_$Est$\_$ Apr$\_2020$ from the value for the Pop$\_$Est$\_$Jul$\_2020$ and store the results in the biannual ordered dict

Count each positive result in a local accumulator variable

When the loop completes, return the accumulator variable in a return statement

annual$\_$delta method $(5$ points$)$

Create a method of the Population class called annual$\_$delta that will perform the following tasks:

Check to see if the file$\_$import is empty

If it is not empty, use a loop to read the file$\_$import container $($do not read the file here$)$ and perform the following for each row:

Subtract the value for the Pop$\_$Est$\_$Jul$\_2020$ key from the value for the Pop$\_$Est$\_$Jul$\_2021$ key and store the results in the annual ordered dict

Count each positive result in a local accumulator variable

When the loop completes, return the accumulator variable in a return statement

search$\_$by$\_$loc $(5$ points$)$

Create a method that has a city, state string as a parameter. This method will:

Create a local container of your choosing called found. Define the container in this method; it should not be an instance attribute.

Search the annual ordered dict and the biannual ordered dict for the location provided by the parameter.

if found, store the values from both order dicts for that location in the found container and return it$.$

if not found, return a container with $0$ values

export$\_$csv method $(5$ points$)$

Create a method of the Population class called export$\_$csv that has a filename as a parameter. This method will perform the following tasks:

Write the following to an output in csv format to the filename from the parameter:

Heading row: This will be the first row in the csv file and should contain the following values in each column of the csv file: Geographic Area, Bi$-$Annual Delta, Annual Delta

Data rows: This will contain the values from the annual dictionary and biannual dictionary corresponding to the heading row keys