Approach U.S. Census Bureau ACS 2024 educational attainment

Author

Andre Thomson

Approach

I selected the U.S. Census Bureau ACS 2024 educational attainment dataset directly from the publishing agency. My original source is: https://api.census.gov/data/2024/acs/acs5?get=NAME,B15003_001E,B15003_017E,B15003_021E,B15003_022E,B15003_023E,B15003_025E&for=state:*

The source has several measurements in separate columns, which is why I can use pivot_longer() without first inventing a wide table. I will keep the original download in data/raw, check the imported column names and missing values, then reshape selected related measurements into a tidy table. I will work from that table to build a small summary and chart. I will check the number of rows before and after pivoting and document any excluded records.

This dataset was selected independently. It does not use another student’s dataset, code, or discussion analysis.