This project involved an analysis of mock census data for a fictional small town in order to provide data-driven policy recommendations to local government authorities. The goals were to advise on:
- Optimal use of an unoccupied plot of land
- Public spending priority between employment retraining, elderly care, education, or infrastructure
Decisions were made by examining population trends, occupations, transit needs, income levels, age distribution, household sizes and other key indicators within the provided dataset.
The mock census data was structured to emulate the 1881 UK census, providing details on 9426 individuals including:
- Age
- Gender
- Occupation
- Marital status
- Religion
- Relationship to head of household
- Presence of infirmities
- Data Cleaning: Handled missing values and formatting issues
- Exploratory Data Analysis: Conducted overview analysis of demographics, occupations, incomes, religious affiliations and family structures
- Visualizations: Generated plots highlighting insights
- Recommendations: Proposed land use and spending priorities based on evidence
census_cleaning_and_ insights_analysis.ipynb: Covers steps taken to clean the data as well as exploratory analysis and visualizationsFinal_Recommendations.pdf: Final land use and spending recommendations with discussion and plots
- Construct train station to service likely student & workforce commuter demand
- Prioritize school infrastructure investment given age distribution and large household sizes
- Limited evidence to support housing, religious or medical builds at this time
For any questions, please contact inquiries.tokosi@gmail.com