337
edits
Changes
Jump to navigation
Jump to search
====11/07/2017 TUESDAY''9AM-12PM''====
*Yesterday, narrowed down columns of interest from ACS_S1501_educationattain_2016 table.
Id
Id2
Geography
Total; Estimate; Population 25 years and over
Total; Estimate; Population 25 years and over - High school graduate (includes equivalency)
Total; Margin of Error; Population 25 years and over - High school graduate (includes equivalency)
Total; Margin of Error; Population 25 years and over - High school graduate (includes equivalency)
Percent; Margin of Error; Population 25 years and over - High school graduate (includes equivalency)
Total; Estimate; Population 25 years and over - Associate's degree
Total; Margin of Error; Population 25 years and over - Associate's degree
Percent; Estimate; Population 25 years and over - Associate's degree
Percent; Margin of Error; Population 25 years and over - Associate's degree
Total; Estimate; Population 25 years and over - Bachelor's degree
Total; Margin of Error; Population 25 years and over - Bachelor's degree
Percent; Estimate; Population 25 years and over - Bachelor's degree
Percent; Margin of Error; Population 25 years and over - Bachelor's degree
Total; Estimate; Population 25 years and over - Graduate or professional degree
Total; Margin of Error; Population 25 years and over - Graduate or professional degree
Percent; Estimate; Population 25 years and over - Graduate or professional degree
Percent; Margin of Error; Population 25 years and over - Graduate or professional degree
Percent; Estimate; Percent high school graduate or higher
Percent; Margin of Error; Percent high school graduate or higher
Percent; Estimate; Percent bachelor's degree or higher
Percent; Margin of Error; Percent bachelor's degree or higher
*Complications:
**For csv files corresponding to years 2015 & 2016, all of the above columns exist.
**For csv files corresponding to years 2005 - 2014, no 'Percent' columns exist
*** Instead their 'Total' columns are percentage values
**For csv file corresponding to year 2005, columns regarding Graduate or professional degree are labeled differently.
**2012 data doesn't correspond to Population 25 years and over.
*Temporary Solution:
**Since the above problems may be specific to this set of tables, will go through csv files and adjust columns.
*Python script location:
E:\McNair\Projects\Agglomeration\ACS_Downloaded_Data\pullCertainColumns.py
→Fall 2017
* Notes on data downloaded:
** Year 2012's data is based on total population, not 25 yrs or over (case for all other tables)
2017-11-07:
*Yesterday, narrowed down columns of interest from ACS_S1501_educationattain_2016 table.
Id
Id2
Geography
Total; Estimate; Population 25 years and over
Total; Estimate; Population 25 years and over - High school graduate (includes equivalency)
Total; Margin of Error; Population 25 years and over - High school graduate (includes equivalency)
Total; Margin of Error; Population 25 years and over - High school graduate (includes equivalency)
Percent; Margin of Error; Population 25 years and over - High school graduate (includes equivalency)
Total; Estimate; Population 25 years and over - Associate's degree
Total; Margin of Error; Population 25 years and over - Associate's degree
Percent; Estimate; Population 25 years and over - Associate's degree
Percent; Margin of Error; Population 25 years and over - Associate's degree
Total; Estimate; Population 25 years and over - Bachelor's degree
Total; Margin of Error; Population 25 years and over - Bachelor's degree
Percent; Estimate; Population 25 years and over - Bachelor's degree
Percent; Margin of Error; Population 25 years and over - Bachelor's degree
Total; Estimate; Population 25 years and over - Graduate or professional degree
Total; Margin of Error; Population 25 years and over - Graduate or professional degree
Percent; Estimate; Population 25 years and over - Graduate or professional degree
Percent; Margin of Error; Population 25 years and over - Graduate or professional degree
Percent; Estimate; Percent high school graduate or higher
Percent; Margin of Error; Percent high school graduate or higher
Percent; Estimate; Percent bachelor's degree or higher
Percent; Margin of Error; Percent bachelor's degree or higher
*Complications:
**For csv files corresponding to years 2015 & 2016, all of the above columns exist.
**For csv files corresponding to years 2005 - 2014, no 'Percent' columns exist
*** Instead their 'Total' columns are percentage values
**For csv file corresponding to year 2005, columns regarding Graduate or professional degree are labeled differently.
**2012 data doesn't correspond to Population 25 years and over.
*Temporary Solution:
**Since the above problems may be specific to this set of tables, will go through csv files and adjust columns.
*Python script location:
E:\McNair\Projects\Agglomeration\ACS_Downloaded_Data\pullCertainColumns.py
</onlyinclude>
...
