Contributors:
- Colton Lapp (USDC '24 - [email protected])
The goal of this project is to analyze the demographic breakdown of technologists within the Federal Government, using the publicly available "FedScope Employment Data." This analysis will help provide insights into the age distribution and other demographic characteristics of Federal employees working in technology roles.
The data used in this project consists of large datasets that include anonymized individual-level information for all employees in the Federal Workforce (excluding contractors). The data is available on a quarterly basis up until 2010, and annually from 2010 back to 1998.
By downloading, combining, and filtering this data, we can create time series trends to observe changes in the Federal Workforce over time.
The data can be downloaded from the OPM Open Data website. To prepare the data for analysis:
- Download every file titled "FedScope Employment Cube."
- Move the downloaded zip folders to the
data/raw_datadirectory. - Unzip the files.
- Rename each file following the format: FedScope_{Month}Year (e.g., FedScope_Dec2023).
This repository provides scripts and tools to process this data and generate meaningful visualizations and analysis.