35RanExploration

Unemployment in India, 2020

I renamed the columns of a state-by-month table, drew a correlation heatmap, histograms by region and a sunburst of unemployment rates by region and state.

Original tutorial by Aman Kharwal: Unemployment Analysis (opens in a new tab)

What it printed in 2022

Numbers read from the saved notebook outputs. Cell numbers count every cell in the notebook, Markdown included, starting at 1.
Output	Value	Cell #
Mean estimated unemployment rate (%)	12.24	6
State-month rows	267	5

Cell # counts every cell from the top of the notebook, Markdown included, starting at 1.

The sunburst adds rates together across months, so a state's slice size has no real meaning.

The data

267 state-month rows of 2020 estimates from the tutorial author's data repository.

What I'd do differently

Average the rates or weight them by labour force instead of summing.
Plot each state over time. The spike around the April 2020 lockdown is the story.