Data-related tasks

[qwu102]

Completed Tasks

Last updated: November 23, 2023

• We accessed and downloaded data from each of the samples listed by Prof. Pearson from the IPUMS website.
• The variables we focused on included: census year, IPUMS sample identifier, household serial number, household weight, household cluster for variance estimation, household strata for variance estimation, group quarters status, person number in sample unit, person weight, total personal income, total family income, and wage and salary income
• We figured out how to extract the data, how to create the do-files to access and work with the data, and how to upload these .dat and do-files to OneDrive.

[qwu102]

Pending Tasks

Last updated: December 3, 2023

• [ ] Figure out how to make the OneDrive link accessible on Github
• [x] Figure out which variables to focus on (definitively)--potential variables: age, place of birth

Wednesday, Nov. 29 to Saturday, Dec. 2

• [x] Identify necessary variables for data
• [ ] Create a README.txt file as a "key" to reading our data

Saturday, Dec. 2 to Sunday, Dec. 3

• [x] Download data for each sample using the identified variables
• [ ] Write a detailed plan for data work

Monday, Dec. 4 to Friday, Dec. 8

• [ ] Work with the data to find conclusions; take notes during the process in this issue

Saturday, Dec. 9 to Sunday, Dec. 10

• [ ] Draft the Data, Results, and Conclusion sections of the report

[qwu102]

Detailed Data Plan (Dec. 6, 2023)

We are testing if the average personal & household income of specific groups increases/shows any trend over time (1950-2020):

• Black people who moved to the South
• White people who moved to the Shouth

The idea is that the South began to have better economic opportunities in the 1970s, but only those with higher income have the ability to migrate to take advantage of those opportunities. Historically, White people have been able to more freely migrate because they had a higher average income due to the racial wage gap, but in the 1970s, Black average income increased more rapidly than White average income, narrowing the racial wage gap and explaining the significant number of Black people who, along with White people, also moved form the North to the South in search of better economic opportunities.

Other Info

• Southern states include TX, OK, AR, LA, MS, AL, GA, FL, NC, TN, VA
• We need to separate the process out by sample (all 8 samples combined is too big to run some functions, like "tabulate"; we also need the mean income data from each year)

Tasks for each sample

1. Make sure .dat and .do files are downloaded and ready to use for this sample
2. Get the average personal income for Black people who moved to the South (birthplace OR residence 5 years ago is not a Southern state but residence 1 year ago is)
3. Get the average personal income for White people who moved to the South
4. Average household income, Black people...
5. Average household income, White people...
6. Record all of the numbers (use Excel for now--until 12/8 presentation)

Task Tracker

Sample	Task 1	Task 2	Task 3	Task 4	Task 5	Task 6
2020	----	----	----	----	----	----
2010	----	----	----	----	----	----
2000	----	----	----	----	----	----
1990	----	----	----	----	----	----
1980	----	----	----	----	----	----
1970	----	----	----	----	----	----
1960	----	----	----	----	----	----
1950	----	----	----	----	----	----

[kbuzard]

@ecn310/migration I see this plan for the analysis. Where is your plan for the documentation? This is going to be particularly important for your project since you have so much data in so many different files.