Inspiration
Our team has always been intrigued by how large-scale events influence micro-level changes in society. The US Census data provides a treasure trove of information that reflects the socio-economic shifts of the population over time. We wanted to uncover the stories hidden within this vast dataset, especially the nuances that numbers alone can't tell. The motivation was simple: understand the past to better shape the future.
The Great Recession of 2008 had a profound impact on population dynamics, especially in the Northeastern metropolitan areas. The ripple effects of economic downturns can lead to mass migrations, reshaping the demographic landscape of regions. The age group 35-44 showed a significant decrease from 2000 to 2010. This not only indicates economic factors at play but also societal choices and priorities. The aftermath of 9/11 and the U.S.'s military involvement in the Middle East played a role in shaping immigration patterns and population counts.
Process
The project began with a preliminary analysis in Excel. The dataset, although vast, was relatively clean. We started with Python's pandas library for some initial cleaning but quickly realized the potential of Tableau in visualizing intricate patterns. By reformatting headers in Excel for better compatibility with Tableau and using the CBSA code as the primary key, we stitched together different tables to paint a holistic picture.
Challenges
We faced a couple of direct challenges. Deciding which variables to focus on and which to omit required numerous iterations and discussions. Additionally, while Tableau is powerful, ensuring that our dataset was entirely compatible required some back-and-forth adjustments. Interpreting Trends: Some trends, like the decrease in the age group 35-44, required deeper dives and external research to ensure we weren't jumping to conclusions.
This project was a journey through time, events, and numbers. While the data provided the medium, the stories we uncovered gave life to this project. In understanding these patterns, we hope to inspire policymakers and researchers to craft a better future.
Log in or sign up for Devpost to join the conversation.