data_overview.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from slugify import slugify\n",
    "import json\n",
    "import math\n",
    "\n",
    "def formatINR(number):\n",
    "    s, *d = str(number).partition(\".\")\n",
    "    r = \",\".join([s[x-2:x] for x in range(-3, -len(s), -2)][::-1] + [s[-3:]])\n",
    "    return \"\".join([r] + d)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "# read data\n",
    "\n",
    "raw_data = pd.read_excel('/home/abhinav/sink/D4D/overview_data.xlsx', engine='openpyxl')\n",
    "indicators = pd.read_excel('/home/abhinav/sink/D4D/Indicators.xlsx', engine='openpyxl')\n",
    "dist_meta_data = {\"morigaon\":{\"Title\": \"Morigaon\", \"About\": \"Morigaon district is an administrative district in the state of Assam in India. The district headquarters is located at Morigaon. The ancient place of occult Mayong is located in this district as well as Pobitora Wildlife Sanctuary.\", \"link\": \"https://morigaon.gov.in/\"}, \"nagaon\":{\"Title\": \"Nagaon\", \"About\": \"Nagaon is an administrative district in the Indian state of Assam. The undivided district was the most populous in the state as per 2011 census. The eastern, western, and southern fringes of the newly organized district were once ruled by different small feudal kings or their agents. It was a newly organized village system-hence called “Nagaon”, Na meaning new.\", \"link\": \"https://nagaon.assam.gov.in/\"} }\n",
    "dept_meta_data = {'panchayat-and-rural-development': {'Title': \"Panchayat and Rural Development\", 'Desc':'The Panchayat & Rural Development Department largely works to enhance livelihood opportunities, address chronic poverty, provides social security and works for economic inclusion of rural poor families. The Panchayat & Rural Development Department has been implementing a number of programmes in the rural area of the State by empowering rural poor through power of rights based law, aiming to transform the geography of poverty in the State.', 'schemes':['mgnrega']}, \n",
    "             'public-health-engineering': {'Title': \"Public Health Engineering\", 'Desc':'The Public Health Engineering Department has a mission to enhance quality of life of the people by ensuring sustainable safe drinking water and sanitation facilities and services along with promoting hygiene practices according to their choices and affordability.', 'schemes':['jjm']}}\n",
    "scheme_meta_data = {\"mgnrega\": {\"Name\": \"Mahatma Gandhi National Rural Employment Guarantee Act (MGNREGA)\", \"Title\": \"MGNREGA\", \"Desc\": \"The objective of MGNREGS is to enhance livelihood security of the rural masses. The scheme is meant to provide at least 100 days of wage employment per financial year (FY) to every rural household whose adult members are willing to do unskilled manual work. This is one of the world’s largest public sector employment programmes that provides guaranteed income through employment.\", \"dept_slug\":\"panchayat-and-rural-development\", \"logo\": \"/logo/mgnrega.webp\"},\n",
    "                    \"jjm\": {\"Name\": \"Jal Jeevan Mission (JJM)\", \"Title\": \"JJM\", \"Desc\": \"The National Rural Drinking Water Programme / Jal Jeevan Mission is an initiative of the Government of India under the Ministry of Jal Shakti. It aims to provide safe and adequate drinking water to all households in rural India through provision of individual household tap connections by the year 2024.\", \"dept_slug\":\"public-health-engineering\", \"logo\": \"/logo/nhm.png\"}}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Merge indicator data into data file \n",
    "data = pd.merge(raw_data,indicators[['indicator_slug','indicator_name','indicator_type', 'indicator_selected', 'indicator_overview', 'indicator_explorer', 'indicator_dept', 'indicator_district', 'indicator_unit']],on='indicator_slug', how='left')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>district_name</th>\n",
       "      <th>district_code</th>\n",
       "      <th>financial_year</th>\n",
       "      <th>scheme_name</th>\n",
       "      <th>indicator_slug</th>\n",
       "      <th>indicator_report</th>\n",
       "      <th>indicator_value</th>\n",
       "      <th>date_of_update</th>\n",
       "      <th>indicator_name</th>\n",
       "      <th>indicator_type</th>\n",
       "      <th>...</th>\n",
       "      <th>indicator_overview</th>\n",
       "      <th>indicator_explorer</th>\n",
       "      <th>indicator_dept</th>\n",
       "      <th>indicator_district</th>\n",
       "      <th>indicator_unit</th>\n",
       "      <th>district_slug</th>\n",
       "      <th>scheme_slug</th>\n",
       "      <th>dept_slug</th>\n",
       "      <th>dept_name</th>\n",
       "      <th>indicator_type_title</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6789</th>\n",
       "      <td>Morigaon</td>\n",
       "      <td>26</td>\n",
       "      <td>2023-2024</td>\n",
       "      <td>MGNREGA</td>\n",
       "      <td>awppd</td>\n",
       "      <td>Outlays &amp; Outcomes</td>\n",
       "      <td>1665.53</td>\n",
       "      <td>2023-11-08</td>\n",
       "      <td>Average wage per personday</td>\n",
       "      <td>district_performance</td>\n",
       "      <td>...</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>rupees</td>\n",
       "      <td>morigaon</td>\n",
       "      <td>mgnrega</td>\n",
       "      <td>panchayat-and-rural-development</td>\n",
       "      <td>Panchayat and Rural Development</td>\n",
       "      <td>District Performance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6791</th>\n",
       "      <td>Nagaon</td>\n",
       "      <td>27</td>\n",
       "      <td>2023-2024</td>\n",
       "      <td>MGNREGA</td>\n",
       "      <td>awppd</td>\n",
       "      <td>Outlays &amp; Outcomes</td>\n",
       "      <td>3093.39</td>\n",
       "      <td>2023-11-08</td>\n",
       "      <td>Average wage per personday</td>\n",
       "      <td>district_performance</td>\n",
       "      <td>...</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>rupees</td>\n",
       "      <td>nagaon</td>\n",
       "      <td>mgnrega</td>\n",
       "      <td>panchayat-and-rural-development</td>\n",
       "      <td>Panchayat and Rural Development</td>\n",
       "      <td>District Performance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6999</th>\n",
       "      <td>Morigaon</td>\n",
       "      <td>26</td>\n",
       "      <td>2023-2024</td>\n",
       "      <td>MGNREGA</td>\n",
       "      <td>cppdy</td>\n",
       "      <td>Outlays &amp; Outcomes</td>\n",
       "      <td>2109.59</td>\n",
       "      <td>2023-11-08</td>\n",
       "      <td>Cost per personday</td>\n",
       "      <td>district_performance</td>\n",
       "      <td>...</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>rupees</td>\n",
       "      <td>morigaon</td>\n",
       "      <td>mgnrega</td>\n",
       "      <td>panchayat-and-rural-development</td>\n",
       "      <td>Panchayat and Rural Development</td>\n",
       "      <td>District Performance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7001</th>\n",
       "      <td>Nagaon</td>\n",
       "      <td>27</td>\n",
       "      <td>2023-2024</td>\n",
       "      <td>MGNREGA</td>\n",
       "      <td>cppdy</td>\n",
       "      <td>Outlays &amp; Outcomes</td>\n",
       "      <td>3343.14</td>\n",
       "      <td>2023-11-08</td>\n",
       "      <td>Cost per personday</td>\n",
       "      <td>district_performance</td>\n",
       "      <td>...</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>rupees</td>\n",
       "      <td>nagaon</td>\n",
       "      <td>mgnrega</td>\n",
       "      <td>panchayat-and-rural-development</td>\n",
       "      <td>Panchayat and Rural Development</td>\n",
       "      <td>District Performance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10569</th>\n",
       "      <td>Morigaon</td>\n",
       "      <td>26</td>\n",
       "      <td>2023-2024</td>\n",
       "      <td>MGNREGA</td>\n",
       "      <td>tpdue</td>\n",
       "      <td>Financial Statement</td>\n",
       "      <td>19.29</td>\n",
       "      <td>2023-11-08</td>\n",
       "      <td>Total Payment Due</td>\n",
       "      <td>district_performance</td>\n",
       "      <td>...</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>yes</td>\n",
       "      <td>no</td>\n",
       "      <td>rupees lakhs</td>\n",
       "      <td>morigaon</td>\n",
       "      <td>mgnrega</td>\n",
       "      <td>panchayat-and-rural-development</td>\n",
       "      <td>Panchayat and Rural Development</td>\n",
       "      <td>District Performance</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      district_name  district_code financial_year scheme_name indicator_slug  \\\n",
       "6789       Morigaon             26      2023-2024     MGNREGA          awppd   \n",
       "6791         Nagaon             27      2023-2024     MGNREGA          awppd   \n",
       "6999       Morigaon             26      2023-2024     MGNREGA          cppdy   \n",
       "7001         Nagaon             27      2023-2024     MGNREGA          cppdy   \n",
       "10569      Morigaon             26      2023-2024     MGNREGA          tpdue   \n",
       "\n",
       "          indicator_report  indicator_value date_of_update  \\\n",
       "6789    Outlays & Outcomes          1665.53     2023-11-08   \n",
       "6791    Outlays & Outcomes          3093.39     2023-11-08   \n",
       "6999    Outlays & Outcomes          2109.59     2023-11-08   \n",
       "7001    Outlays & Outcomes          3343.14     2023-11-08   \n",
       "10569  Financial Statement            19.29     2023-11-08   \n",
       "\n",
       "                   indicator_name        indicator_type  ...  \\\n",
       "6789   Average wage per personday  district_performance  ...   \n",
       "6791   Average wage per personday  district_performance  ...   \n",
       "6999           Cost per personday  district_performance  ...   \n",
       "7001           Cost per personday  district_performance  ...   \n",
       "10569           Total Payment Due  district_performance  ...   \n",
       "\n",
       "      indicator_overview indicator_explorer indicator_dept indicator_district  \\\n",
       "6789                 yes                yes            yes                 no   \n",
       "6791                 yes                yes            yes                 no   \n",
       "6999                 yes                yes            yes                 no   \n",
       "7001                 yes                yes            yes                 no   \n",
       "10569                yes                yes            yes                 no   \n",
       "\n",
       "      indicator_unit district_slug scheme_slug  \\\n",
       "6789          rupees      morigaon     mgnrega   \n",
       "6791          rupees        nagaon     mgnrega   \n",
       "6999          rupees      morigaon     mgnrega   \n",
       "7001          rupees        nagaon     mgnrega   \n",
       "10569   rupees lakhs      morigaon     mgnrega   \n",
       "\n",
       "                             dept_slug                        dept_name  \\\n",
       "6789   panchayat-and-rural-development  Panchayat and Rural Development   \n",
       "6791   panchayat-and-rural-development  Panchayat and Rural Development   \n",
       "6999   panchayat-and-rural-development  Panchayat and Rural Development   \n",
       "7001   panchayat-and-rural-development  Panchayat and Rural Development   \n",
       "10569  panchayat-and-rural-development  Panchayat and Rural Development   \n",
       "\n",
       "       indicator_type_title  \n",
       "6789   District Performance  \n",
       "6791   District Performance  \n",
       "6999   District Performance  \n",
       "7001   District Performance  \n",
       "10569  District Performance  \n",
       "\n",
       "[5 rows x 21 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# filter data for overview page indicators and structure the column values.\n",
    "# filter data for financial year latest\n",
    "\n",
    "data = data[data.indicator_overview == 'yes']\n",
    "data = data[data.financial_year == '2023-2024']\n",
    "\n",
    "def get_dept_slug(x):\n",
    "    \n",
    "    for key in dept_meta_data:\n",
    "        if x in dept_meta_data[key]['schemes']:\n",
    "            return key\n",
    "        \n",
    "def get_dept_name(x):\n",
    "    \n",
    "    for key in dept_meta_data:\n",
    "        if x in dept_meta_data[key]['schemes']:\n",
    "            return dept_meta_data[key][\"Title\"]   \n",
    "        \n",
    "def get_type_title(x):\n",
    "    \n",
    "    if x == \"district_profile\":\n",
    "        return \"District Profile\"\n",
    "    elif x == \"district_performance\":\n",
    "        return \"District Performance\"\n",
    "    elif x == \"target\":\n",
    "        return \"Targets\"\n",
    "    else:\n",
    "        return x\n",
    "\n",
    "data['district_name'] = data['district_name'].map(lambda x: x.title())\n",
    "data['district_slug'] = data['district_name'].map(lambda x: slugify(x))\n",
    "data['scheme_slug'] = data['scheme_name'].map(lambda x: slugify(x))\n",
    "\n",
    "data['dept_slug'] = data['scheme_slug'].map(lambda x: get_dept_slug(x))\n",
    "data['dept_name'] = data['scheme_slug'].map(lambda x: get_dept_name(x))\n",
    "\n",
    "data['indicator_type_title'] = data['indicator_type'].map(lambda x: get_type_title(x))  \n",
    "\n",
    "# filter data for morigaon and nagaon district\n",
    "data = data[data['district_name'].isin([\"Morigaon\", \"Nagaon\"])] \n",
    "    \n",
    "\n",
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Overview Page Generator\n",
    "\n",
    "base_json = {}\n",
    "\n",
    "for index, row in data.iterrows():\n",
    "    \n",
    "    # insert district\n",
    "    if  row.district_slug not in base_json:\n",
    "        base_json[row.district_slug] = {\n",
    "        \"distTitle\": row.district_name,\n",
    "        \"depts\" :\n",
    "        {\n",
    "            row.dept_slug : \n",
    "            {\"deptTitle\": row.dept_name,\n",
    "                \"schemes\" :\n",
    "                {\n",
    "                    row.scheme_slug : \n",
    "                    {\n",
    "                        \"schemeTitle\": scheme_meta_data[row.scheme_slug]['Name'],\n",
    "                        \"schemeDesc\": scheme_meta_data[row.scheme_slug]['Desc'],\n",
    "                        \"lastUpdated\": str(row.date_of_update),\n",
    "                        \"targetTitle\": \"Targets\",\n",
    "                        \"targets\": [] if row.indicator_type != \"target\" else [\n",
    "                        {\n",
    "                            \"value\": round(row.indicator_value*100, 2),\n",
    "                            \"label\": row.indicator_name,\n",
    "                            \"description\": row.indicator_name,\n",
    "                            \"type\": \"progress\",\n",
    "                            \"min\": 0,\n",
    "                            \"max\": 100\n",
    "                        }\n",
    "                        ],\n",
    "                        \"profileTitle\": \"District Profile\",\n",
    "                        \"profiles\": [] if row.indicator_type != \"district_profile\" else [\n",
    "                        {\n",
    "                            \"value\": str(round(row.indicator_value, 2)) + \" \" + (\"INR\" if row.indicator_unit == \"rupees\" else \"INR in Lakhs\" if row.indicator_unit == \"rupees lakhs\" else \n",
    "                                                            \"%\" if row.indicator_unit == \"percentage\" else \"\"),\n",
    "                            \"label\": row.indicator_name,\n",
    "                            \"description\": row.indicator_name\n",
    "                        }\n",
    "                        ],\n",
    "                        \"performanceTitle\": \"District Performance\",\n",
    "                        \"performances\": [] if row.indicator_type != \"district_performance\" else [\n",
    "                        {\n",
    "                            \"value\": str(round(row.indicator_value, 2)) + \" \" + (\"INR\" if row.indicator_unit == \"rupees\" else \"INR in Lakhs\" if row.indicator_unit == \"rupees lakhs\" else \n",
    "                                                            \"%\" if row.indicator_unit == \"percentage\" else \"\"),\n",
    "                            \"label\": row.indicator_name,\n",
    "                            \"description\": row.indicator_name,\n",
    "                            \"type\": \"number\"\n",
    "                        }\n",
    "                        ],\n",
    "                    }\n",
    "                }\n",
    "            }\n",
    "        }\n",
    "    }\n",
    "\n",
    "\n",
    "            \n",
    "    elif  row.dept_slug not in base_json[row.district_slug][\"depts\"]:\n",
    "        \n",
    "        base_json[row.district_slug][\"depts\"][row.dept_slug] ={\n",
    "                \"deptTitle\": row.dept_name,\n",
    "                \"schemes\" :\n",
    "                {\n",
    "                    row.scheme_slug : \n",
    "                    {\n",
    "                        \"schemeTitle\": scheme_meta_data[row.scheme_slug]['Name'],\n",
    "                        \"schemeDesc\": scheme_meta_data[row.scheme_slug]['Desc'],\n",
    "                        \"lastUpdated\": str(row.date_of_update),\n",
    "                        \"targetTitle\": \"Targets\",\n",
    "                        \"targets\": [] if row.indicator_type != \"target\" else [\n",
    "                        {\n",
    "                            \"value\": round(row.indicator_value*100, 2),\n",
    "                            \"label\": row.indicator_name,\n",
    "                            \"description\": row.indicator_name,\n",
    "                            \"type\": \"progress\",\n",
    "                            \"min\": 0,\n",
    "                            \"max\": 100\n",
    "                        }\n",
    "                        ],\n",
    "                        \"profileTitle\": \"District Profile\",\n",
    "                        \"profiles\": [] if row.indicator_type != \"district_profile\" else [\n",
    "                        {\n",
    "                            \"value\": str(round(row.indicator_value, 2)) + \" \" + (\"INR\" if row.indicator_unit == \"rupees\" else \"INR in Lakhs\" if row.indicator_unit == \"rupees lakhs\" else \n",
    "                                                            \"%\" if row.indicator_unit == \"percentage\" else \"\"),\n",
    "                            \"label\": row.indicator_name,\n",
    "                            \"description\": row.indicator_name\n",
    "                        }\n",
    "                        ],\n",
    "                        \"performanceTitle\": \"District Performance\",\n",
    "                        \"performances\": [] if row.indicator_type != \"district_performance\" else [\n",
    "                        {\n",
    "                            \"value\": str(round(row.indicator_value, 2)) + \" \" + (\"INR\" if row.indicator_unit == \"rupees\" else \"INR in Lakhs\" if row.indicator_unit == \"rupees lakhs\" else \n",
    "                                                            \"%\" if row.indicator_unit == \"percentage\" else \"\"),\n",
    "                            \"label\": row.indicator_name,\n",
    "                            \"description\": row.indicator_name,\n",
    "                            \"type\": \"number\"\n",
    "                        }\n",
    "                        ],\n",
    "                    }\n",
    "                }\n",
    "            }\n",
    "        \n",
    "    elif  row.scheme_slug not in base_json[row.district_slug][\"depts\"][row.dept_slug][\"schemes\"]:\n",
    "        \n",
    "        base_json[row.district_slug][\"depts\"][row.dept_slug][\"schemes\"][row.scheme_slug] = {\n",
    "                        \"schemeTitle\": scheme_meta_data[row.scheme_slug]['Name'],\n",
    "                        \"schemeDesc\": scheme_meta_data[row.scheme_slug]['Desc'],\n",
    "                        \"lastUpdated\": str(row.date_of_update),\n",
    "                        \"targetTitle\": \"Targets\",\n",
    "                        \"targets\": [] if row.indicator_type != \"target\" else [\n",
    "                        {\n",
    "                            \"value\": round(row.indicator_value*100, 2),\n",
    "                            \"label\": row.indicator_name,\n",
    "                            \"description\": row.indicator_name,\n",
    "                            \"type\": \"progress\",\n",
    "                            \"min\": 0,\n",
    "                            \"max\": 100\n",
    "                        }\n",
    "                        ],\n",
    "                        \"profileTitle\": \"District Profile\",\n",
    "                        \"profiles\": [] if row.indicator_type != \"district_profile\" else [\n",
    "                        {\n",
    "                            \"value\": str(round(row.indicator_value, 2)) + \" \" + (\"INR\" if row.indicator_unit == \"rupees\" else \"INR in Lakhs\" if row.indicator_unit == \"rupees lakhs\" else \n",
    "                                                            \"%\" if row.indicator_unit == \"percentage\" else \"\"),\n",
    "                            \"label\": row.indicator_name,\n",
    "                            \"description\": row.indicator_name\n",
    "                        }\n",
    "                        ],\n",
    "                        \"performanceTitle\": \"District Performance\",\n",
    "                        \"performances\": [] if row.indicator_type != \"district_performance\" else [\n",
    "                        {\n",
    "                            \"value\": str(round(row.indicator_value, 2)) + \" \" + (\"INR\" if row.indicator_unit == \"rupees\" else \"INR in Lakhs\" if row.indicator_unit == \"rupees lakhs\" else \n",
    "                                                            \"%\" if row.indicator_unit == \"percentage\" else \"\"),\n",
    "                            \"label\": row.indicator_name,\n",
    "                            \"description\": row.indicator_name,\n",
    "                            \"type\": \"number\"\n",
    "                        }\n",
    "                        ],\n",
    "                    }\n",
    "    else:\n",
    "        if row.indicator_type == \"target\" :\n",
    "            base_json[row.district_slug][\"depts\"][row.dept_slug][\"schemes\"][row.scheme_slug][\"targets\"].append(\n",
    "                {\"value\": round(row.indicator_value*100, 2),\"label\": row.indicator_name,\"description\": row.indicator_name, \"type\": \"progress\", \"min\":0, \"max\":100}\n",
    "                )\n",
    "        elif  row.indicator_type == \"district_profile\":   \n",
    "            base_json[row.district_slug][\"depts\"][row.dept_slug][\"schemes\"][row.scheme_slug][\"profiles\"].append(\n",
    "                {\n",
    "                    \"value\": str(round(row.indicator_value, 2)) + \" \" + (\"INR\" if row.indicator_unit == \"rupees\" else \"INR in Lakhs\" if row.indicator_unit == \"rupees lakhs\" else \n",
    "                                                    \"%\" if row.indicator_unit == \"percentage\" else \"\"),\n",
    "                    \"label\": row.indicator_name,\n",
    "                    \"description\": row.indicator_name\n",
    "                }\n",
    "            )\n",
    "        else:\n",
    "            base_json[row.district_slug][\"depts\"][row.dept_slug][\"schemes\"][row.scheme_slug][\"performances\"].append(\n",
    "                {\n",
    "                    \"value\": str(round(row.indicator_value, 2)) + \" \" + (\"INR\" if row.indicator_unit == \"rupees\" else \"INR in Lakhs\" if row.indicator_unit == \"rupees lakhs\" else \n",
    "                                                    \"%\" if row.indicator_unit == \"percentage\" else \"\"),\n",
    "                    \"label\": row.indicator_name,\n",
    "                    \"description\": row.indicator_name,\n",
    "                    \"type\": \"number\"\n",
    "                }\n",
    "            )\n",
    "            \n",
    "        \n",
    "\n",
    "        \n",
    "with open('overview_data.json', 'w') as fp:\n",
    "    json.dump(base_json, fp, indent=4)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "opub_back_env",
   "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.6.9"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}