Still my largest roadblock here has been my inability to subtract from different csv files, while I was able to make formulas for the equations needed to be calculated, I’m not sure how to type the code properly. I definitely didn’t complete my desired milestones; however, I did read through documentation on pulling in census API information. I attempted to not use the csv module but I ended up spending more time attempting to recreate my program than achieve anything in additon. My visualizations have been stalled because I haven’t been able to incorporate information that I need, namely subtracting from two different files.
Already Completed
- Create main menu with 5 options: main menu, using module data, add data, help, and exit
- Create functions for each of the 5 options
- Create while loop for cycling through options
- Handle bad file name input
- Allow user to select county
For Tuesday
- Handle bad input for selected county
- Find a method to print just inflow categories (US & Foreign; US; Same State; Different State; Foreign; Non-Migrants)
- Find a method to print just outflow categories (US & Foreign; US; Same State; Different State; Foreign; Non-Migrants)
For Thursday
- Create working function to calculate AGI for net migration
- Create working function to calculate household size: Exemptions/Returns
- Create working function to calculate AGI per Return: (AGI * 1000)/Returns
For Tuesday (4/25)
- Devise method to find top three counties flowing into selected county that have a matching outflow counties
Until 4/29
- Print out inflow, outflow, and net migration numbers for top three inflow counties with matching outflow counties
- Calculate net migration information by subtracting inflow and outflow returns and exemption numbers
- Print out numbers neatly for inflow, outflow, and net for selected county
- Visualization for top county inflow
- Visualization for county net migration
- Add Census API to bring in basic info about county (population, households, median income)
- Make sure code is clean, commented