{
"cells": [
{
"cell_type": "markdown",
"id": "5a9b9e36",
"metadata": {},
"source": [
"## Name : ADVAIT GURUNATH CHAVAN\n",
"## Contact No : +91 70214 55852\n",
"## Mail ID : advaitchavan135@gmail.com \n",
"\n",
"\n",
"## Oasis Infobyte Data Science Internship\n",
"## Task 2 : Unemployment Analysis with Python"
]
},
{
"cell_type": "markdown",
"id": "c0c6d027",
"metadata": {},
"source": [
"
"
]
},
{
"cell_type": "markdown",
"id": "881c9779",
"metadata": {},
"source": [
"### 1. Importing the necessary dependencies"
]
},
{
"cell_type": "code",
"execution_count": 1,
"id": "7a5c6de8",
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd\n",
"import matplotlib.pyplot as plt\n",
"import seaborn as sns\n",
"from warnings import filterwarnings\n",
"filterwarnings(action='ignore')\n",
"import calendar\n",
"import datetime as dt\n",
"import plotly.io as plio\n",
"plio.templates\n",
"import plotly.express as px\n",
"import plotly.graph_objects as go\n",
"import plotly.figure_factory as ff\n",
"\n",
"from IPython.display import HTML,display"
]
},
{
"cell_type": "markdown",
"id": "73f4bd50",
"metadata": {},
"source": [
"### 2. Exploring the dataset"
]
},
{
"cell_type": "code",
"execution_count": 2,
"id": "4c7be8dc",
"metadata": {},
"outputs": [],
"source": [
"unemp = pd.read_csv('Unemployment in India.csv')"
]
},
{
"cell_type": "code",
"execution_count": 3,
"id": "3003a2d6",
"metadata": {
"scrolled": false
},
"outputs": [
{
"data": {
"text/html": [
"
| \n", " | Region | \n", "Date | \n", "Frequency | \n", "Estimated Unemployment Rate (%) | \n", "Estimated Employed | \n", "Estimated Labour Participation Rate (%) | \n", "Area | \n", "
|---|---|---|---|---|---|---|---|
| 0 | \n", "Andhra Pradesh | \n", "31-05-2019 | \n", "Monthly | \n", "3.65 | \n", "11999139.0 | \n", "43.24 | \n", "Rural | \n", "
| 1 | \n", "Andhra Pradesh | \n", "30-06-2019 | \n", "Monthly | \n", "3.05 | \n", "11755881.0 | \n", "42.05 | \n", "Rural | \n", "
| 2 | \n", "Andhra Pradesh | \n", "31-07-2019 | \n", "Monthly | \n", "3.75 | \n", "12086707.0 | \n", "43.50 | \n", "Rural | \n", "
| 3 | \n", "Andhra Pradesh | \n", "31-08-2019 | \n", "Monthly | \n", "3.32 | \n", "12285693.0 | \n", "43.97 | \n", "Rural | \n", "
| 4 | \n", "Andhra Pradesh | \n", "30-09-2019 | \n", "Monthly | \n", "5.17 | \n", "12256762.0 | \n", "44.68 | \n", "Rural | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 749 | \n", "West Bengal | \n", "29-02-2020 | \n", "Monthly | \n", "7.55 | \n", "10871168.0 | \n", "44.09 | \n", "Urban | \n", "
| 750 | \n", "West Bengal | \n", "31-03-2020 | \n", "Monthly | \n", "6.67 | \n", "10806105.0 | \n", "43.34 | \n", "Urban | \n", "
| 751 | \n", "West Bengal | \n", "30-04-2020 | \n", "Monthly | \n", "15.63 | \n", "9299466.0 | \n", "41.20 | \n", "Urban | \n", "
| 752 | \n", "West Bengal | \n", "31-05-2020 | \n", "Monthly | \n", "15.22 | \n", "9240903.0 | \n", "40.67 | \n", "Urban | \n", "
| 753 | \n", "West Bengal | \n", "30-06-2020 | \n", "Monthly | \n", "9.86 | \n", "9088931.0 | \n", "37.57 | \n", "Urban | \n", "
754 rows × 7 columns
\n", "| \n", " | Region | \n", "Date | \n", "Frequency | \n", "Estimated Unemployment Rate (%) | \n", "Estimated Employed | \n", "Estimated Labour Participation Rate (%) | \n", "Area | \n", "
|---|---|---|---|---|---|---|---|
| 359 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| 360 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| 361 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| 362 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| 363 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| 364 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| 365 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| 366 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| 367 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| 368 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| 369 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| 370 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| 371 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| 372 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| \n", " | Region | \n", "Date | \n", "Frequency | \n", "Estimated Unemployment Rate (%) | \n", "Estimated Employed | \n", "Estimated Labour Participation Rate (%) | \n", "Area | \n", "
|---|---|---|---|---|---|---|---|
| 0 | \n", "Andhra Pradesh | \n", "31-05-2019 | \n", "Monthly | \n", "3.65 | \n", "11999139.0 | \n", "43.24 | \n", "Rural | \n", "
| 1 | \n", "Andhra Pradesh | \n", "30-06-2019 | \n", "Monthly | \n", "3.05 | \n", "11755881.0 | \n", "42.05 | \n", "Rural | \n", "
| 2 | \n", "Andhra Pradesh | \n", "31-07-2019 | \n", "Monthly | \n", "3.75 | \n", "12086707.0 | \n", "43.50 | \n", "Rural | \n", "
| 3 | \n", "Andhra Pradesh | \n", "31-08-2019 | \n", "Monthly | \n", "3.32 | \n", "12285693.0 | \n", "43.97 | \n", "Rural | \n", "
| 4 | \n", "Andhra Pradesh | \n", "30-09-2019 | \n", "Monthly | \n", "5.17 | \n", "12256762.0 | \n", "44.68 | \n", "Rural | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 749 | \n", "West Bengal | \n", "29-02-2020 | \n", "Monthly | \n", "7.55 | \n", "10871168.0 | \n", "44.09 | \n", "Urban | \n", "
| 750 | \n", "West Bengal | \n", "31-03-2020 | \n", "Monthly | \n", "6.67 | \n", "10806105.0 | \n", "43.34 | \n", "Urban | \n", "
| 751 | \n", "West Bengal | \n", "30-04-2020 | \n", "Monthly | \n", "15.63 | \n", "9299466.0 | \n", "41.20 | \n", "Urban | \n", "
| 752 | \n", "West Bengal | \n", "31-05-2020 | \n", "Monthly | \n", "15.22 | \n", "9240903.0 | \n", "40.67 | \n", "Urban | \n", "
| 753 | \n", "West Bengal | \n", "30-06-2020 | \n", "Monthly | \n", "9.86 | \n", "9088931.0 | \n", "37.57 | \n", "Urban | \n", "
740 rows × 7 columns
\n", "| \n", " | Region | \n", "Date | \n", "Frequency | \n", "Estimated Unemployment Rate (%) | \n", "Estimated Employed | \n", "Estimated Labour Participation Rate (%) | \n", "Area | \n", "Month | \n", "Month_num | \n", "Month_name | \n", "Year_num | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "Andhra Pradesh | \n", "2019-05-31 | \n", "Monthly | \n", "3.65 | \n", "11999139.0 | \n", "43.24 | \n", "Rural | \n", "5 | \n", "5 | \n", "May | \n", "2019 | \n", "
| 1 | \n", "Andhra Pradesh | \n", "2019-06-30 | \n", "Monthly | \n", "3.05 | \n", "11755881.0 | \n", "42.05 | \n", "Rural | \n", "6 | \n", "6 | \n", "Jun | \n", "2019 | \n", "
| 2 | \n", "Andhra Pradesh | \n", "2019-07-31 | \n", "Monthly | \n", "3.75 | \n", "12086707.0 | \n", "43.50 | \n", "Rural | \n", "7 | \n", "7 | \n", "Jul | \n", "2019 | \n", "
| 3 | \n", "Andhra Pradesh | \n", "2019-08-31 | \n", "Monthly | \n", "3.32 | \n", "12285693.0 | \n", "43.97 | \n", "Rural | \n", "8 | \n", "8 | \n", "Aug | \n", "2019 | \n", "
| 4 | \n", "Andhra Pradesh | \n", "2019-09-30 | \n", "Monthly | \n", "5.17 | \n", "12256762.0 | \n", "44.68 | \n", "Rural | \n", "9 | \n", "9 | \n", "Sep | \n", "2019 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 749 | \n", "West Bengal | \n", "2020-02-29 | \n", "Monthly | \n", "7.55 | \n", "10871168.0 | \n", "44.09 | \n", "Urban | \n", "2 | \n", "2 | \n", "Feb | \n", "2020 | \n", "
| 750 | \n", "West Bengal | \n", "2020-03-31 | \n", "Monthly | \n", "6.67 | \n", "10806105.0 | \n", "43.34 | \n", "Urban | \n", "3 | \n", "3 | \n", "Mar | \n", "2020 | \n", "
| 751 | \n", "West Bengal | \n", "2020-04-30 | \n", "Monthly | \n", "15.63 | \n", "9299466.0 | \n", "41.20 | \n", "Urban | \n", "4 | \n", "4 | \n", "Apr | \n", "2020 | \n", "
| 752 | \n", "West Bengal | \n", "2020-05-31 | \n", "Monthly | \n", "15.22 | \n", "9240903.0 | \n", "40.67 | \n", "Urban | \n", "5 | \n", "5 | \n", "May | \n", "2020 | \n", "
| 753 | \n", "West Bengal | \n", "2020-06-30 | \n", "Monthly | \n", "9.86 | \n", "9088931.0 | \n", "37.57 | \n", "Urban | \n", "6 | \n", "6 | \n", "Jun | \n", "2020 | \n", "
740 rows × 11 columns
\n", "Estimated Unemployment Rate (%): This represents the actual unemployment rate you want to calculate. It's the percentage of the labor force that is currently unemployed and seeking employment.
\n", "\n", "\n", "###Estimated Employed: This is the number of people who are currently employed.
\n", "\n", "###Estimated Labour Participation Rate (%): This represents the percentage of the working-age population that is either employed or actively seeking employment. It includes both employed and unemployed individuals.
" ] }, { "cell_type": "code", "execution_count": 25, "id": "762f89de", "metadata": {}, "outputs": [ { "data": { "text/html": [ "| \n", " | Estimated Unemployment Rate (%) | \n", "Estimated Employed | \n", "Estimated Labour Participation Rate (%) | \n", "
|---|---|---|---|
| count | \n", "740.00 | \n", "740.00 | \n", "740.00 | \n", "
| mean | \n", "11.79 | \n", "7204460.03 | \n", "42.63 | \n", "
| std | \n", "10.72 | \n", "8087988.43 | \n", "8.11 | \n", "
| min | \n", "0.00 | \n", "49420.00 | \n", "13.33 | \n", "
| 25% | \n", "4.66 | \n", "1190404.50 | \n", "38.06 | \n", "
| 50% | \n", "8.35 | \n", "4744178.50 | \n", "41.16 | \n", "
| 75% | \n", "15.89 | \n", "11275489.50 | \n", "45.50 | \n", "
| max | \n", "76.74 | \n", "45777509.00 | \n", "72.57 | \n", "
| \n", " | Region | \n", "Estimated Unemployment Rate (%) | \n", "Estimated Employed | \n", "Estimated Labour Participation Rate (%) | \n", "
|---|---|---|---|---|
| 0 | \n", "Andhra Pradesh | \n", "7.48 | \n", "8154093.18 | \n", "39.38 | \n", "
| 1 | \n", "Assam | \n", "6.43 | \n", "5354772.15 | \n", "44.87 | \n", "
| 2 | \n", "Bihar | \n", "18.92 | \n", "12366189.14 | \n", "38.15 | \n", "
| 3 | \n", "Chandigarh | \n", "15.99 | \n", "316831.25 | \n", "39.34 | \n", "
| 4 | \n", "Chhattisgarh | \n", "9.24 | \n", "4303498.57 | \n", "42.81 | \n", "
| 5 | \n", "Delhi | \n", "16.50 | \n", "2627512.86 | \n", "38.93 | \n", "
| 6 | \n", "Goa | \n", "9.27 | \n", "226308.33 | \n", "39.25 | \n", "
| 7 | \n", "Gujarat | \n", "6.66 | \n", "11402012.79 | \n", "46.10 | \n", "
| 8 | \n", "Haryana | \n", "26.28 | \n", "3557072.46 | \n", "42.74 | \n", "
| 9 | \n", "Himachal Pradesh | \n", "18.54 | \n", "1059823.71 | \n", "44.22 | \n", "
| 10 | \n", "Jammu & Kashmir | \n", "16.19 | \n", "1799931.67 | \n", "41.03 | \n", "
| 11 | \n", "Jharkhand | \n", "20.58 | \n", "4469240.43 | \n", "41.67 | \n", "
| 12 | \n", "Karnataka | \n", "6.68 | \n", "10667119.29 | \n", "41.35 | \n", "
| 13 | \n", "Kerala | \n", "10.12 | \n", "4425899.50 | \n", "34.87 | \n", "
| 14 | \n", "Madhya Pradesh | \n", "7.41 | \n", "11115484.32 | \n", "38.82 | \n", "
| 15 | \n", "Maharashtra | \n", "7.56 | \n", "19990195.86 | \n", "42.30 | \n", "
| 16 | \n", "Meghalaya | \n", "4.80 | \n", "689736.81 | \n", "57.08 | \n", "
| 17 | \n", "Odisha | \n", "5.66 | \n", "6545746.96 | \n", "38.93 | \n", "
| 18 | \n", "Puducherry | \n", "10.22 | \n", "212278.08 | \n", "38.99 | \n", "
| 19 | \n", "Punjab | \n", "12.03 | \n", "4539362.00 | \n", "41.14 | \n", "
| 20 | \n", "Rajasthan | \n", "14.06 | \n", "10041064.75 | \n", "39.97 | \n", "
| 21 | \n", "Sikkim | \n", "7.25 | \n", "106880.71 | \n", "46.07 | \n", "
| 22 | \n", "Tamil Nadu | \n", "9.28 | \n", "12269546.75 | \n", "40.87 | \n", "
| 23 | \n", "Telangana | \n", "7.74 | \n", "7939662.75 | \n", "53.00 | \n", "
| 24 | \n", "Tripura | \n", "28.35 | \n", "717002.64 | \n", "61.82 | \n", "
| 25 | \n", "Uttar Pradesh | \n", "12.55 | \n", "28094832.18 | \n", "39.43 | \n", "
| 26 | \n", "Uttarakhand | \n", "6.58 | \n", "1390228.11 | \n", "33.78 | \n", "
| 27 | \n", "West Bengal | \n", "8.12 | \n", "17198538.00 | \n", "45.42 | \n", "
| \n", " | Area | \n", "Estimated Unemployment Rate (%) | \n", "Estimated Employed | \n", "Estimated Labour Participation Rate (%) | \n", "
|---|---|---|---|---|
| 0 | \n", "Rural | \n", "10.32 | \n", "10192852.57 | \n", "44.46 | \n", "
| 1 | \n", "Urban | \n", "13.17 | \n", "4388625.58 | \n", "40.90 | \n", "
| \n", " | Year_num | \n", "Month_num | \n", "Month_name | \n", "Estimated Unemployment Rate (%) | \n", "Estimated Employed | \n", "Estimated Labour Participation Rate (%) | \n", "
|---|---|---|---|---|---|---|
| 0 | \n", "2019 | \n", "5 | \n", "May | \n", "8.87 | \n", "7410148.44 | \n", "43.90 | \n", "
| 1 | \n", "2019 | \n", "6 | \n", "Jun | \n", "9.30 | \n", "7358641.57 | \n", "43.75 | \n", "
| 2 | \n", "2019 | \n", "7 | \n", "Jul | \n", "9.03 | \n", "7404425.31 | \n", "43.71 | \n", "
| 3 | \n", "2019 | \n", "8 | \n", "Aug | \n", "9.64 | \n", "7539815.19 | \n", "43.65 | \n", "
| 4 | \n", "2019 | \n", "9 | \n", "Sep | \n", "9.05 | \n", "7739463.96 | \n", "44.30 | \n", "
| 5 | \n", "2019 | \n", "10 | \n", "Oct | \n", "9.90 | \n", "7298382.40 | \n", "44.00 | \n", "
| 6 | \n", "2019 | \n", "11 | \n", "Nov | \n", "9.87 | \n", "7273660.64 | \n", "44.11 | \n", "
| 7 | \n", "2019 | \n", "12 | \n", "Dec | \n", "9.50 | \n", "7377387.83 | \n", "43.67 | \n", "
| 8 | \n", "2020 | \n", "1 | \n", "Jan | \n", "9.95 | \n", "7677344.42 | \n", "44.05 | \n", "
| 9 | \n", "2020 | \n", "2 | \n", "Feb | \n", "9.96 | \n", "7603996.28 | \n", "43.72 | \n", "
| 10 | \n", "2020 | \n", "3 | \n", "Mar | \n", "10.70 | \n", "7516581.13 | \n", "43.08 | \n", "
| 11 | \n", "2020 | \n", "4 | \n", "Apr | \n", "23.64 | \n", "5283319.90 | \n", "35.14 | \n", "
| 12 | \n", "2020 | \n", "5 | \n", "May | \n", "24.88 | \n", "5879363.02 | \n", "38.50 | \n", "
| 13 | \n", "2020 | \n", "6 | \n", "Jun | \n", "11.90 | \n", "7387008.66 | \n", "40.55 | \n", "
| \n", " | Year_num | \n", "Month_num | \n", "Month_name | \n", "Estimated Unemployment Rate (%) | \n", "Estimated Employed | \n", "Estimated Labour Participation Rate (%) | \n", "Year_num_Month | \n", "
|---|---|---|---|---|---|---|---|
| 3 | \n", "2019 | \n", "8 | \n", "Aug | \n", "9.64 | \n", "7539815.19 | \n", "43.65 | \n", "2019 - Aug | \n", "
| 7 | \n", "2019 | \n", "12 | \n", "Dec | \n", "9.50 | \n", "7377387.83 | \n", "43.67 | \n", "2019 - Dec | \n", "
| 2 | \n", "2019 | \n", "7 | \n", "Jul | \n", "9.03 | \n", "7404425.31 | \n", "43.71 | \n", "2019 - Jul | \n", "
| 1 | \n", "2019 | \n", "6 | \n", "Jun | \n", "9.30 | \n", "7358641.57 | \n", "43.75 | \n", "2019 - Jun | \n", "
| 0 | \n", "2019 | \n", "5 | \n", "May | \n", "8.87 | \n", "7410148.44 | \n", "43.90 | \n", "2019 - May | \n", "
| 6 | \n", "2019 | \n", "11 | \n", "Nov | \n", "9.87 | \n", "7273660.64 | \n", "44.11 | \n", "2019 - Nov | \n", "
| 5 | \n", "2019 | \n", "10 | \n", "Oct | \n", "9.90 | \n", "7298382.40 | \n", "44.00 | \n", "2019 - Oct | \n", "
| 4 | \n", "2019 | \n", "9 | \n", "Sep | \n", "9.05 | \n", "7739463.96 | \n", "44.30 | \n", "2019 - Sep | \n", "
| 11 | \n", "2020 | \n", "4 | \n", "Apr | \n", "23.64 | \n", "5283319.90 | \n", "35.14 | \n", "2020 - Apr | \n", "
| 9 | \n", "2020 | \n", "2 | \n", "Feb | \n", "9.96 | \n", "7603996.28 | \n", "43.72 | \n", "2020 - Feb | \n", "
| 8 | \n", "2020 | \n", "1 | \n", "Jan | \n", "9.95 | \n", "7677344.42 | \n", "44.05 | \n", "2020 - Jan | \n", "
| 13 | \n", "2020 | \n", "6 | \n", "Jun | \n", "11.90 | \n", "7387008.66 | \n", "40.55 | \n", "2020 - Jun | \n", "
| 10 | \n", "2020 | \n", "3 | \n", "Mar | \n", "10.70 | \n", "7516581.13 | \n", "43.08 | \n", "2020 - Mar | \n", "
| 12 | \n", "2020 | \n", "5 | \n", "May | \n", "24.88 | \n", "5879363.02 | \n", "38.50 | \n", "2020 - May | \n", "
| \n", " | Year_num | \n", "Estimated Unemployment Rate (%) | \n", "Estimated Employed | \n", "Estimated Labour Participation Rate (%) | \n", "
|---|---|---|---|---|
| 0 | \n", "2019 | \n", "9.4 | \n", "7422976.47 | \n", "43.89 | \n", "
| 1 | \n", "2020 | \n", "15.1 | \n", "6901356.57 | \n", "40.89 | \n", "
| \n", " | Estimated Unemployment Rate (%) | \n", "Estimated Employed | \n", "Estimated Labour Participation Rate (%) | \n", "Month | \n", "Month_num | \n", "Year_num | \n", "
|---|---|---|---|---|---|---|
| Estimated Unemployment Rate (%) | \n", "1.000000 | \n", "-0.222876 | \n", "0.002558 | \n", "-0.122938 | \n", "-0.122938 | \n", "0.262602 | \n", "
| Estimated Employed | \n", "-0.222876 | \n", "1.000000 | \n", "0.011300 | \n", "0.011285 | \n", "0.011285 | \n", "-0.031841 | \n", "
| Estimated Labour Participation Rate (%) | \n", "0.002558 | \n", "0.011300 | \n", "1.000000 | \n", "0.087257 | \n", "0.087257 | \n", "-0.182460 | \n", "
| Month | \n", "-0.122938 | \n", "0.011285 | \n", "0.087257 | \n", "1.000000 | \n", "1.000000 | \n", "-0.768484 | \n", "
| Month_num | \n", "-0.122938 | \n", "0.011285 | \n", "0.087257 | \n", "1.000000 | \n", "1.000000 | \n", "-0.768484 | \n", "
| Year_num | \n", "0.262602 | \n", "-0.031841 | \n", "-0.182460 | \n", "-0.768484 | \n", "-0.768484 | \n", "1.000000 | \n", "
From the pieplot, avg. unemployment rate(%) bar plot and box plots we can infer the following:-
\n", "####The top 5 regions(states) in India having the highest unemployement rate (%) during COVID-19 lockdown are:
\n", "####1. Tripura = 28.35%
\n", "####2. Haryana = 26.28%
\n", "####3. Jharkhand = 20.59%
\n", "####4. Bihar = 18.92%
\n", "####5. Himachal Pradesh = 18.54%
" ] }, { "cell_type": "markdown", "id": "23f904de", "metadata": {}, "source": [ "#### [B] Estimated Employed Count" ] }, { "cell_type": "code", "execution_count": 55, "id": "318d808f", "metadata": {}, "outputs": [ { "data": { "application/vnd.plotly.v1+json": { "config": { "plotlyServerURL": "https://plot.ly" }, "data": [ { "alignmentgroup": "True", "hovertemplate": "Region=%{x}From the pieplot, avg. employed count bar plot and box plots we can infer the following:-
\n", "####The top 5 regions(states) in India having the highest employed count during COVID-19 lockdown are:
\n", "####1. Uttar Pradesh = 28.09 Million
\n", "####2. Maharashtra = 19.99 Million
\n", "####3. West Bengal = 17.19 Million
\n", "####4. Bihar = 12.37 Million
\n", "####5. Tamil Nadu = 12.27 Million
" ] }, { "cell_type": "markdown", "id": "1e8ae6cd", "metadata": {}, "source": [ "#### [C] Estimated Labour Participation Rate (%)" ] }, { "cell_type": "code", "execution_count": 61, "id": "e72fd239", "metadata": {}, "outputs": [ { "data": { "application/vnd.plotly.v1+json": { "config": { "plotlyServerURL": "https://plot.ly" }, "data": [ { "alignmentgroup": "True", "hovertemplate": "Region=%{x}From the pieplot, avg. labour participation rate(%) bar plot and box plots we can infer the following:-
\n", "####The top 5 regions(states) in India having the highest labour participation rate (%) during COVID-19 lockdown are:
\n", "####1. Tripura = 61.82%
\n", "####2. Meghalaya = 57.08%
\n", "####3. Telangana = 53.00%
\n", "####4. Gujarat = 46.10%
\n", "####5. Sikkim = 46.07%
" ] }, { "cell_type": "code", "execution_count": null, "id": "c760d42e", "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3 (ipykernel)", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.9.13" } }, "nbformat": 4, "nbformat_minor": 5 }