In 2020, the United States will have its first female Vice- President; so we asked ourselves how many countries have women leadership? We used data provided by the world bank that we found on Makeover Monday and supplemental data from Data World Bank that complemented our dataset.
Here are the steps that we followed:
- The question we were curious about was did the amount of women in the workforce affect the amount of women in leadership position within a parliamentary government?
- In order to learn about this we found data from Makeover Monday and a supplemental dataset from the world data bank with a series of questions that we culled to assist in our hypothesis that more women in the workforce lead to more women in leadership within parliamentary governments across the globe. We chose dataset spanning 10 years (2009-2019).Our supplemental data only had 1 year worth of questions (2018).
- We completed the ETL using Pandas within Jupyter Lab and PostgreSQL to merge our datasets. Our visualizations required two versions of our datasets.
- We created our machine learning model by using Scikit-Learn using linear regression, logistic regression table and a residual plot
- We created visualization using JavaScript D3.js. We also used HTML/CSS/Bootstrap.
- We used Tableau to perform the following visualizations:
- a. A looping time-lapse illustrating the global growth of women in parliament and workforce over a period of ten years
- b. A map containing global demographics regarding women in parliament, workforce, and company ownership along with other factors that could affect these numbers in 2018.
Observations:
- Larger percentages of women in leadership/parliament showed higher amounts of women in the workforce
- There was not a number that showed where “x” in parliament meant over 50% of women were in the work force
- There were more women in the workforce typically if the constitution had an equality clause
Our dashboard will illustrate how we arrived at our conclusions. Future directions for research would be to explore the other questions in our supplemental dataset.