Makeover Monday, 2017 Week 01 - Australia’s Gender Pay Gap
For this week, we are presented with a list of the top 50 highest paying jobs in Australia, broken down by gender. The data was collected by the Australian government and published in an article by Women’s Agenda.
There is no makeover here as there is no visualisation in the original article. The challenge is to present the information in a way that is better than simply listing it.
Explore the Data
import pandas as pd
aust_income = pd.read_excel('./Australian Taxable Income.xlsx')
aust_income = aust_income.sort_values(['Occupation', 'Gender'])
aust_income.head(2)
| Gender Rank | Occupation | Gender | Individuals | Average Taxable Income $ | |
|---|---|---|---|---|---|
| 0 | 795 | Abattoir process worker; Meat process worker; ... | Female | 5961 | 36359 |
| 1 | 881 | Abattoir process worker; Meat process worker; ... | Male | 17241 | 40954 |
The dataset contains 2,197 rows. Each row contains the following information about each occupation
- Gender Rank; the rank of the occupation, sorted by gender and descending average taxable income
- Individuals; number of people for the gender, in the occupation
- Average Taxable Income $; the average, assumed to be annual average taxable income
Interesting things to note: - There are occupations that are confined to a single gender (Boxer, hunting guide (amongst others) for males only, Mothercraft nurse applies for females only)
Ways to Present the Data
- For the top 50 paying jobs, demonstrate the pay discrepancy between males and females.
- For the top 50 most popular jobs sorted by gender, demonstrate the pay discrepency between males and females.
- Display the top 50 jobs based on the pay discrepancy between males and females.
Review of Makeovers
The following are some of the makeovers that I really like, with the reasons why.
Lilach Manheim presented the wage gap by calculating the time it will take a man to earn a woman’s wage if they were in the same career.
Matt Chambers utilised a bar chart to demonstrate the extent of the differences between men and women wages within the same occupation.
My favourite has to be the one created by Joe Cristo. He calculated the differences and charted jobs where women were paid more than men, and showed the large discrepancy there. His key message was that there are far more jobs in the top 50 paying ones where women are paid less than men.
There were many submissions that presented the wage gap using barbell charts.
My Makeover
My goal was to highlight the wage discrepancy for the careers that affect the women most, which I have defined as the top 50 most common careers for Australian women. You can find the interactive version here.
