availability.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "floral-syria",
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "import datetime\n",
    "\n",
    "import json\n",
    "import pandas as pd\n",
    "pd.set_option('display.max_rows', 2000)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "english-singer",
   "metadata": {},
   "source": [
    "## Get all district IDs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "opponent-pathology",
   "metadata": {},
   "outputs": [],
   "source": [
    "district_df_all = None\n",
    "for state_code in range(1,40):\n",
    "    response = requests.get(\"https://cdn-api.co-vin.in/api/v2/admin/location/districts/{}\".format(state_code))\n",
    "    district_df = pd.DataFrame(json.loads(response.text))\n",
    "    district_df = pd.json_normalize(district_df['districts'])\n",
    "    if district_df_all is None:\n",
    "        district_df_all = district_df\n",
    "    else:\n",
    "        district_df_all = pd.concat([district_df_all, district_df])\n",
    "        \n",
    "    district_df_all.district_id = district_df_all.district_id.astype(int)\n",
    "        \n",
    "district_df_all = district_df_all[[\"district_name\", \"district_id\"]].sort_values(\"district_name\")\n",
    "district_df_all.to_csv(\"districts.csv\", index=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "offshore-uniform",
   "metadata": {},
   "source": [
    "## Fix your district id "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "thorough-dollar",
   "metadata": {},
   "outputs": [],
   "source": [
    "Ahmedabad = 154\n",
    "Ahmedabad_Corporation = 770\n",
    "district_ids = [Ahmedabad, Ahmedabad_Corporation]\n",
    "next_n_days = 3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "dirty-bronze",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "checking for INP_DATE:03-05-2021 & DIST_ID:154\n",
      "checking for INP_DATE:03-05-2021 & DIST_ID:770\n"
     ]
    },
    {
     "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>date</th>\n",
       "      <th>min_age_limit</th>\n",
       "      <th>available_capacity</th>\n",
       "      <th>name</th>\n",
       "      <th>state_name</th>\n",
       "      <th>district_name</th>\n",
       "      <th>pincode</th>\n",
       "      <th>fee_type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>100</td>\n",
       "      <td>Kendriya Vidhyalaya</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380004</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>05-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>100</td>\n",
       "      <td>Kendriya Vidhyalaya</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380004</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>06-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>100</td>\n",
       "      <td>Kendriya Vidhyalaya</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380004</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>07-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>100</td>\n",
       "      <td>Kendriya Vidhyalaya</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380004</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>08-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>100</td>\n",
       "      <td>Kendriya Vidhyalaya</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380004</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>05-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>100</td>\n",
       "      <td>Khodiyar Nagari School No.-22</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380022</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>06-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>100</td>\n",
       "      <td>Khodiyar Nagari School No.-22</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380022</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>07-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>100</td>\n",
       "      <td>Khodiyar Nagari School No.-22</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380022</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>99</td>\n",
       "      <td>Municipal School No13 I Colony</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380024</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>99</td>\n",
       "      <td>Municipal School No13 I Colony</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380024</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>06-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>99</td>\n",
       "      <td>Municipal School No13 I Colony</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380024</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>08-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>99</td>\n",
       "      <td>Khodiyar Nagari School No.-22</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380022</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>98</td>\n",
       "      <td>Khodiyar Nagari School No.-22</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380022</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>06-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>97</td>\n",
       "      <td>Hina Vora School</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380050</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>05-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>96</td>\n",
       "      <td>Municipal School No13 I Colony</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380024</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>07-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>96</td>\n",
       "      <td>Ghodasar Gam School No 2</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382443</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>06-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>95</td>\n",
       "      <td>Ghodasar Gam School No 2</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382443</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>06-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>95</td>\n",
       "      <td>Balbharti</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380016</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>08-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>95</td>\n",
       "      <td>Balbharti</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380016</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>94</td>\n",
       "      <td>Kendriya Vidhyalaya</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380004</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>07-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>94</td>\n",
       "      <td>Balbharti</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380016</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>07-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>90</td>\n",
       "      <td>Hina Vora School</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380050</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>90</td>\n",
       "      <td>Khodiyar Nagari School No.-22</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380022</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>08-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>87</td>\n",
       "      <td>Ghodasar Gam School No 2</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382443</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>07-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>81</td>\n",
       "      <td>Swami Narayan School Hathijan</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382445</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>07-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>75</td>\n",
       "      <td>Kankaria Gujarati School No 1</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380022</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>08-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>68</td>\n",
       "      <td>Kankaria Gujarati School No 1</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380022</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>08-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>60</td>\n",
       "      <td>Swami Narayan School Hathijan</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382445</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>08-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>58</td>\n",
       "      <td>Khokhara Public School</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380008</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>07-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>48</td>\n",
       "      <td>Khokhara Public School</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380008</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>47</td>\n",
       "      <td>Hina Vora School</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380050</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>06-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>42</td>\n",
       "      <td>Kankaria Gujarati School No 1</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380022</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>05-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>42</td>\n",
       "      <td>Balbharti</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380016</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>05-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>40</td>\n",
       "      <td>Ghodasar Gam School No 2</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382443</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>06-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>21</td>\n",
       "      <td>Swami Narayan School Hathijan</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382445</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>2</td>\n",
       "      <td>Balbharti</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380016</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>Khokhara Public School</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380008</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>05-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>Maktampura Prathmik School</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380055</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>05-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>K G K School Kubernagar</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382340</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>06-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>Muni. Shala No. 18</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380015</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>05-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>Kankaria Gujarati School No 1</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380022</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>Dariapur Municipal School No 8</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380001</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>05-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>Sardar Patel Shala Sankul</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382345</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>05-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>School No-18 Dariapur</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380001</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>Swaminarayan Temple Maninagar</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380008</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>JOITARAM COMMUNITY HALL</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380013</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>JOITARAM COMMUNITY HALL</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380013</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>05-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>JOITARAM COMMUNITY HALL</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380013</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>06-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>JOITARAM COMMUNITY HALL</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380013</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>07-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>JOITARAM COMMUNITY HALL</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380013</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Hina Vora School</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380050</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>NEW RANIP SOCIETY</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382480</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>NEW RANIP SOCIETY</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382480</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>05-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>NEW RANIP SOCIETY</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382480</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>06-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>NEW RANIP SOCIETY</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382480</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>07-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>NEW RANIP SOCIETY</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382480</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>08-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>NEW RANIP SOCIETY</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382480</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Vejalpur Pr School No.2</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380051</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Vejalpur Pr School No.2</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380051</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>05-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Vejalpur Pr School No.2</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380051</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>06-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Vejalpur Pr School No.2</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380051</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>07-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Vejalpur Pr School No.2</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380051</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Sarvajanik School</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380055</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Sarvajanik School</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380055</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>05-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Sarvajanik School</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380055</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>06-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Sarvajanik School</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380055</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>07-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Sarvajanik School</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380055</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Khokhara Public School</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380008</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>05-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Khokhara Public School</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380008</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>06-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Khokhara Public School</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380008</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Maninagar Gujarati Shala No.-6</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380008</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Maninagar Gujarati Shala No.-6</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380008</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>05-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Maninagar Gujarati Shala No.-6</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380008</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>06-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Maninagar Gujarati Shala No.-6</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380008</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>07-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Maninagar Gujarati Shala No.-6</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380008</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>08-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Maninagar Gujarati Shala No.-6</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380008</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Maktampura Prathmik School</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380055</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Maktampura Prathmik School</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380055</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>06-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Maktampura Prathmik School</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380055</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>07-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Maktampura Prathmik School</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380055</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>MUNICIPAL SCHOOL NO 1</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380007</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>MUNICIPAL SCHOOL NO 1</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380007</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>05-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>MUNICIPAL SCHOOL NO 1</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380007</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>06-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>MUNICIPAL SCHOOL NO 1</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380007</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>07-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>MUNICIPAL SCHOOL NO 1</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380007</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>08-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>MUNICIPAL SCHOOL NO 1</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380007</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>K G K School Kubernagar</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382340</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>K G K School Kubernagar</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382340</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>06-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>K G K School Kubernagar</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382340</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>07-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>K G K School Kubernagar</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382340</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>08-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>K G K School Kubernagar</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382340</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Muni. Shala No. 18</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380015</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Muni. Shala No. 18</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380015</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>05-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Muni. Shala No. 18</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380015</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>07-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Muni. Shala No. 18</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380015</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>08-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Muni. Shala No. 18</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380015</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Sardarnagar Gujarati School</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382475</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Naroda Gujarati Muni Shala 1/2</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382330</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Naroda Gujarati Muni Shala 1/2</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382330</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>05-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Naroda Gujarati Muni Shala 1/2</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382330</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>06-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Naroda Gujarati Muni Shala 1/2</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382330</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>07-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Naroda Gujarati Muni Shala 1/2</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382330</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>08-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Naroda Gujarati Muni Shala 1/2</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382330</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Jodhpur Shala No 2</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380015</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Jodhpur Shala No 2</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380015</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>05-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Jodhpur Shala No 2</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380015</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>06-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Jodhpur Shala No 2</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380015</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>07-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Jodhpur Shala No 2</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380015</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Nikol - 2 Sankalp School</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382350</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Kankaria Gujarati School No 1</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380022</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Kankaria Gujarati School No 1</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380022</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Dariapur Municipal School No 8</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380001</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>05-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Dariapur Municipal School No 8</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380001</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>06-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Dariapur Municipal School No 8</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380001</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>07-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Dariapur Municipal School No 8</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380001</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Naranpura Mun School</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380013</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Naranpura Mun School</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380013</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>05-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Naranpura Mun School</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380013</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>06-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Naranpura Mun School</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380013</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>07-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Naranpura Mun School</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380013</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Sardar Patel Shala Sankul</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382345</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Sardar Patel Shala Sankul</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382345</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>06-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Sardar Patel Shala Sankul</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382345</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>07-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Sardar Patel Shala Sankul</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382345</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>08-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Sardar Patel Shala Sankul</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382345</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Swami Narayan School Hathijan</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382445</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Swami Narayan School Hathijan</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382445</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>05-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Swami Narayan School Hathijan</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382445</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Municipal School No 12</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380007</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Municipal School No 12</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380007</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Ranip Pagar Kendra</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382480</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Ranip Pagar Kendra</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382480</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>05-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Ranip Pagar Kendra</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382480</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>06-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Ranip Pagar Kendra</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382480</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>07-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Ranip Pagar Kendra</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382480</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>08-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Ranip Pagar Kendra</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382480</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Raikhad Gujarati School NO.4</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380001</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>School No-18 Dariapur</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380001</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>School No-18 Dariapur</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380001</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>06-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>School No-18 Dariapur</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380001</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Shakti Vidhyalay</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380015</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Shakti Vidhyalay</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380015</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>05-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Shakti Vidhyalay</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380015</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>06-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Shakti Vidhyalay</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380015</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>07-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Shakti Vidhyalay</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380015</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Ghodasar Gam School No 2</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382443</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Ghodasar Gam School No 2</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382443</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>AADINATH PRI SCHOOL VASTRAL</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382415</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>AADINATH PRI SCHOOL VASTRAL</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>382415</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Swaminarayan Temple Maninagar</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380008</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>05-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Swaminarayan Temple Maninagar</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380008</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>06-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Swaminarayan Temple Maninagar</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380008</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>07-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Swaminarayan Temple Maninagar</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380008</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Balbharti</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380016</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Municipal Gujarati Shala No 4</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380013</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Municipal Gujarati Shala No 4</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380013</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>05-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Municipal Gujarati Shala No 4</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380013</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>06-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>Municipal Gujarati Shala No 4</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380013</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>03-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>MU.SHALA NO 1 NAVAWADAJ</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380013</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>MU.SHALA NO 1 NAVAWADAJ</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380013</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>05-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>MU.SHALA NO 1 NAVAWADAJ</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380013</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>06-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>MU.SHALA NO 1 NAVAWADAJ</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380013</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>07-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>MU.SHALA NO 1 NAVAWADAJ</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380013</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>04-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>MUNI SHALA NO 18</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380015</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>05-05-2021</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>MUNI SHALA NO 18</td>\n",
       "      <td>Gujarat</td>\n",
       "      <td>Ahmedabad Corporation</td>\n",
       "      <td>380015</td>\n",
       "      <td>Free</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          date  min_age_limit  available_capacity  \\\n",
       "33  04-05-2021             18                 100   \n",
       "33  05-05-2021             18                 100   \n",
       "33  06-05-2021             18                 100   \n",
       "33  07-05-2021             18                 100   \n",
       "33  08-05-2021             18                 100   \n",
       "36  05-05-2021             18                 100   \n",
       "36  06-05-2021             18                 100   \n",
       "36  07-05-2021             18                 100   \n",
       "6   03-05-2021             18                  99   \n",
       "6   04-05-2021             18                  99   \n",
       "6   06-05-2021             18                  99   \n",
       "36  08-05-2021             18                  99   \n",
       "36  04-05-2021             18                  98   \n",
       "1   06-05-2021             18                  97   \n",
       "6   05-05-2021             18                  96   \n",
       "35  07-05-2021             18                  96   \n",
       "35  06-05-2021             18                  95   \n",
       "40  06-05-2021             18                  95   \n",
       "40  08-05-2021             18                  95   \n",
       "33  03-05-2021             18                  94   \n",
       "40  07-05-2021             18                  94   \n",
       "1   07-05-2021             18                  90   \n",
       "36  03-05-2021             18                  90   \n",
       "35  08-05-2021             18                  87   \n",
       "25  07-05-2021             18                  81   \n",
       "19  07-05-2021             18                  75   \n",
       "19  08-05-2021             18                  68   \n",
       "25  08-05-2021             18                  60   \n",
       "9   08-05-2021             18                  58   \n",
       "9   07-05-2021             18                  48   \n",
       "1   04-05-2021             18                  47   \n",
       "19  06-05-2021             18                  42   \n",
       "40  05-05-2021             18                  42   \n",
       "35  05-05-2021             18                  40   \n",
       "25  06-05-2021             18                  21   \n",
       "40  03-05-2021             18                   2   \n",
       "9   03-05-2021             18                   1   \n",
       "11  05-05-2021             18                   1   \n",
       "13  05-05-2021             18                   1   \n",
       "14  06-05-2021             18                   1   \n",
       "19  05-05-2021             18                   1   \n",
       "20  03-05-2021             18                   1   \n",
       "23  05-05-2021             18                   1   \n",
       "30  05-05-2021             18                   1   \n",
       "38  04-05-2021             18                   1   \n",
       "0   03-05-2021             18                   0   \n",
       "0   04-05-2021             18                   0   \n",
       "0   05-05-2021             18                   0   \n",
       "0   06-05-2021             18                   0   \n",
       "0   07-05-2021             18                   0   \n",
       "1   03-05-2021             18                   0   \n",
       "4   03-05-2021             18                   0   \n",
       "4   04-05-2021             18                   0   \n",
       "4   05-05-2021             18                   0   \n",
       "4   06-05-2021             18                   0   \n",
       "4   07-05-2021             18                   0   \n",
       "4   08-05-2021             18                   0   \n",
       "7   03-05-2021             18                   0   \n",
       "7   04-05-2021             18                   0   \n",
       "7   05-05-2021             18                   0   \n",
       "7   06-05-2021             18                   0   \n",
       "7   07-05-2021             18                   0   \n",
       "8   03-05-2021             18                   0   \n",
       "8   04-05-2021             18                   0   \n",
       "8   05-05-2021             18                   0   \n",
       "8   06-05-2021             18                   0   \n",
       "8   07-05-2021             18                   0   \n",
       "9   04-05-2021             18                   0   \n",
       "9   05-05-2021             18                   0   \n",
       "9   06-05-2021             18                   0   \n",
       "10  03-05-2021             18                   0   \n",
       "10  04-05-2021             18                   0   \n",
       "10  05-05-2021             18                   0   \n",
       "10  06-05-2021             18                   0   \n",
       "10  07-05-2021             18                   0   \n",
       "10  08-05-2021             18                   0   \n",
       "11  03-05-2021             18                   0   \n",
       "11  04-05-2021             18                   0   \n",
       "11  06-05-2021             18                   0   \n",
       "11  07-05-2021             18                   0   \n",
       "12  03-05-2021             18                   0   \n",
       "12  04-05-2021             18                   0   \n",
       "12  05-05-2021             18                   0   \n",
       "12  06-05-2021             18                   0   \n",
       "12  07-05-2021             18                   0   \n",
       "12  08-05-2021             18                   0   \n",
       "13  03-05-2021             18                   0   \n",
       "13  04-05-2021             18                   0   \n",
       "13  06-05-2021             18                   0   \n",
       "13  07-05-2021             18                   0   \n",
       "13  08-05-2021             18                   0   \n",
       "14  03-05-2021             18                   0   \n",
       "14  04-05-2021             18                   0   \n",
       "14  05-05-2021             18                   0   \n",
       "14  07-05-2021             18                   0   \n",
       "14  08-05-2021             18                   0   \n",
       "15  03-05-2021             18                   0   \n",
       "16  03-05-2021             18                   0   \n",
       "16  04-05-2021             18                   0   \n",
       "16  05-05-2021             18                   0   \n",
       "16  06-05-2021             18                   0   \n",
       "16  07-05-2021             18                   0   \n",
       "16  08-05-2021             18                   0   \n",
       "17  03-05-2021             18                   0   \n",
       "17  04-05-2021             18                   0   \n",
       "17  05-05-2021             18                   0   \n",
       "17  06-05-2021             18                   0   \n",
       "17  07-05-2021             18                   0   \n",
       "18  03-05-2021             18                   0   \n",
       "19  03-05-2021             18                   0   \n",
       "19  04-05-2021             18                   0   \n",
       "20  04-05-2021             18                   0   \n",
       "20  05-05-2021             18                   0   \n",
       "20  06-05-2021             18                   0   \n",
       "20  07-05-2021             18                   0   \n",
       "21  03-05-2021             18                   0   \n",
       "21  04-05-2021             18                   0   \n",
       "21  05-05-2021             18                   0   \n",
       "21  06-05-2021             18                   0   \n",
       "21  07-05-2021             18                   0   \n",
       "23  03-05-2021             18                   0   \n",
       "23  04-05-2021             18                   0   \n",
       "23  06-05-2021             18                   0   \n",
       "23  07-05-2021             18                   0   \n",
       "23  08-05-2021             18                   0   \n",
       "25  03-05-2021             18                   0   \n",
       "25  04-05-2021             18                   0   \n",
       "25  05-05-2021             18                   0   \n",
       "26  03-05-2021             18                   0   \n",
       "26  04-05-2021             18                   0   \n",
       "28  03-05-2021             18                   0   \n",
       "28  04-05-2021             18                   0   \n",
       "28  05-05-2021             18                   0   \n",
       "28  06-05-2021             18                   0   \n",
       "28  07-05-2021             18                   0   \n",
       "28  08-05-2021             18                   0   \n",
       "29  03-05-2021             18                   0   \n",
       "30  03-05-2021             18                   0   \n",
       "30  04-05-2021             18                   0   \n",
       "30  06-05-2021             18                   0   \n",
       "34  03-05-2021             18                   0   \n",
       "34  04-05-2021             18                   0   \n",
       "34  05-05-2021             18                   0   \n",
       "34  06-05-2021             18                   0   \n",
       "34  07-05-2021             18                   0   \n",
       "35  03-05-2021             18                   0   \n",
       "35  04-05-2021             18                   0   \n",
       "37  03-05-2021             18                   0   \n",
       "37  04-05-2021             18                   0   \n",
       "38  03-05-2021             18                   0   \n",
       "38  05-05-2021             18                   0   \n",
       "38  06-05-2021             18                   0   \n",
       "38  07-05-2021             18                   0   \n",
       "40  04-05-2021             18                   0   \n",
       "41  03-05-2021             18                   0   \n",
       "41  04-05-2021             18                   0   \n",
       "41  05-05-2021             18                   0   \n",
       "41  06-05-2021             18                   0   \n",
       "42  03-05-2021             18                   0   \n",
       "42  04-05-2021             18                   0   \n",
       "42  05-05-2021             18                   0   \n",
       "42  06-05-2021             18                   0   \n",
       "42  07-05-2021             18                   0   \n",
       "44  04-05-2021             18                   0   \n",
       "44  05-05-2021             18                   0   \n",
       "\n",
       "                              name state_name          district_name  pincode  \\\n",
       "33             Kendriya Vidhyalaya    Gujarat  Ahmedabad Corporation   380004   \n",
       "33             Kendriya Vidhyalaya    Gujarat  Ahmedabad Corporation   380004   \n",
       "33             Kendriya Vidhyalaya    Gujarat  Ahmedabad Corporation   380004   \n",
       "33             Kendriya Vidhyalaya    Gujarat  Ahmedabad Corporation   380004   \n",
       "33             Kendriya Vidhyalaya    Gujarat  Ahmedabad Corporation   380004   \n",
       "36   Khodiyar Nagari School No.-22    Gujarat  Ahmedabad Corporation   380022   \n",
       "36   Khodiyar Nagari School No.-22    Gujarat  Ahmedabad Corporation   380022   \n",
       "36   Khodiyar Nagari School No.-22    Gujarat  Ahmedabad Corporation   380022   \n",
       "6   Municipal School No13 I Colony    Gujarat  Ahmedabad Corporation   380024   \n",
       "6   Municipal School No13 I Colony    Gujarat  Ahmedabad Corporation   380024   \n",
       "6   Municipal School No13 I Colony    Gujarat  Ahmedabad Corporation   380024   \n",
       "36   Khodiyar Nagari School No.-22    Gujarat  Ahmedabad Corporation   380022   \n",
       "36   Khodiyar Nagari School No.-22    Gujarat  Ahmedabad Corporation   380022   \n",
       "1                 Hina Vora School    Gujarat  Ahmedabad Corporation   380050   \n",
       "6   Municipal School No13 I Colony    Gujarat  Ahmedabad Corporation   380024   \n",
       "35        Ghodasar Gam School No 2    Gujarat  Ahmedabad Corporation   382443   \n",
       "35        Ghodasar Gam School No 2    Gujarat  Ahmedabad Corporation   382443   \n",
       "40                       Balbharti    Gujarat  Ahmedabad Corporation   380016   \n",
       "40                       Balbharti    Gujarat  Ahmedabad Corporation   380016   \n",
       "33             Kendriya Vidhyalaya    Gujarat  Ahmedabad Corporation   380004   \n",
       "40                       Balbharti    Gujarat  Ahmedabad Corporation   380016   \n",
       "1                 Hina Vora School    Gujarat  Ahmedabad Corporation   380050   \n",
       "36   Khodiyar Nagari School No.-22    Gujarat  Ahmedabad Corporation   380022   \n",
       "35        Ghodasar Gam School No 2    Gujarat  Ahmedabad Corporation   382443   \n",
       "25   Swami Narayan School Hathijan    Gujarat  Ahmedabad Corporation   382445   \n",
       "19   Kankaria Gujarati School No 1    Gujarat  Ahmedabad Corporation   380022   \n",
       "19   Kankaria Gujarati School No 1    Gujarat  Ahmedabad Corporation   380022   \n",
       "25   Swami Narayan School Hathijan    Gujarat  Ahmedabad Corporation   382445   \n",
       "9           Khokhara Public School    Gujarat  Ahmedabad Corporation   380008   \n",
       "9           Khokhara Public School    Gujarat  Ahmedabad Corporation   380008   \n",
       "1                 Hina Vora School    Gujarat  Ahmedabad Corporation   380050   \n",
       "19   Kankaria Gujarati School No 1    Gujarat  Ahmedabad Corporation   380022   \n",
       "40                       Balbharti    Gujarat  Ahmedabad Corporation   380016   \n",
       "35        Ghodasar Gam School No 2    Gujarat  Ahmedabad Corporation   382443   \n",
       "25   Swami Narayan School Hathijan    Gujarat  Ahmedabad Corporation   382445   \n",
       "40                       Balbharti    Gujarat  Ahmedabad Corporation   380016   \n",
       "9           Khokhara Public School    Gujarat  Ahmedabad Corporation   380008   \n",
       "11      Maktampura Prathmik School    Gujarat  Ahmedabad Corporation   380055   \n",
       "13         K G K School Kubernagar    Gujarat  Ahmedabad Corporation   382340   \n",
       "14              Muni. Shala No. 18    Gujarat  Ahmedabad Corporation   380015   \n",
       "19   Kankaria Gujarati School No 1    Gujarat  Ahmedabad Corporation   380022   \n",
       "20  Dariapur Municipal School No 8    Gujarat  Ahmedabad Corporation   380001   \n",
       "23       Sardar Patel Shala Sankul    Gujarat  Ahmedabad Corporation   382345   \n",
       "30           School No-18 Dariapur    Gujarat  Ahmedabad Corporation   380001   \n",
       "38   Swaminarayan Temple Maninagar    Gujarat  Ahmedabad Corporation   380008   \n",
       "0          JOITARAM COMMUNITY HALL    Gujarat  Ahmedabad Corporation   380013   \n",
       "0          JOITARAM COMMUNITY HALL    Gujarat  Ahmedabad Corporation   380013   \n",
       "0          JOITARAM COMMUNITY HALL    Gujarat  Ahmedabad Corporation   380013   \n",
       "0          JOITARAM COMMUNITY HALL    Gujarat  Ahmedabad Corporation   380013   \n",
       "0          JOITARAM COMMUNITY HALL    Gujarat  Ahmedabad Corporation   380013   \n",
       "1                 Hina Vora School    Gujarat  Ahmedabad Corporation   380050   \n",
       "4                NEW RANIP SOCIETY    Gujarat  Ahmedabad Corporation   382480   \n",
       "4                NEW RANIP SOCIETY    Gujarat  Ahmedabad Corporation   382480   \n",
       "4                NEW RANIP SOCIETY    Gujarat  Ahmedabad Corporation   382480   \n",
       "4                NEW RANIP SOCIETY    Gujarat  Ahmedabad Corporation   382480   \n",
       "4                NEW RANIP SOCIETY    Gujarat  Ahmedabad Corporation   382480   \n",
       "4                NEW RANIP SOCIETY    Gujarat  Ahmedabad Corporation   382480   \n",
       "7          Vejalpur Pr School No.2    Gujarat  Ahmedabad Corporation   380051   \n",
       "7          Vejalpur Pr School No.2    Gujarat  Ahmedabad Corporation   380051   \n",
       "7          Vejalpur Pr School No.2    Gujarat  Ahmedabad Corporation   380051   \n",
       "7          Vejalpur Pr School No.2    Gujarat  Ahmedabad Corporation   380051   \n",
       "7          Vejalpur Pr School No.2    Gujarat  Ahmedabad Corporation   380051   \n",
       "8                Sarvajanik School    Gujarat  Ahmedabad Corporation   380055   \n",
       "8                Sarvajanik School    Gujarat  Ahmedabad Corporation   380055   \n",
       "8                Sarvajanik School    Gujarat  Ahmedabad Corporation   380055   \n",
       "8                Sarvajanik School    Gujarat  Ahmedabad Corporation   380055   \n",
       "8                Sarvajanik School    Gujarat  Ahmedabad Corporation   380055   \n",
       "9           Khokhara Public School    Gujarat  Ahmedabad Corporation   380008   \n",
       "9           Khokhara Public School    Gujarat  Ahmedabad Corporation   380008   \n",
       "9           Khokhara Public School    Gujarat  Ahmedabad Corporation   380008   \n",
       "10  Maninagar Gujarati Shala No.-6    Gujarat  Ahmedabad Corporation   380008   \n",
       "10  Maninagar Gujarati Shala No.-6    Gujarat  Ahmedabad Corporation   380008   \n",
       "10  Maninagar Gujarati Shala No.-6    Gujarat  Ahmedabad Corporation   380008   \n",
       "10  Maninagar Gujarati Shala No.-6    Gujarat  Ahmedabad Corporation   380008   \n",
       "10  Maninagar Gujarati Shala No.-6    Gujarat  Ahmedabad Corporation   380008   \n",
       "10  Maninagar Gujarati Shala No.-6    Gujarat  Ahmedabad Corporation   380008   \n",
       "11      Maktampura Prathmik School    Gujarat  Ahmedabad Corporation   380055   \n",
       "11      Maktampura Prathmik School    Gujarat  Ahmedabad Corporation   380055   \n",
       "11      Maktampura Prathmik School    Gujarat  Ahmedabad Corporation   380055   \n",
       "11      Maktampura Prathmik School    Gujarat  Ahmedabad Corporation   380055   \n",
       "12           MUNICIPAL SCHOOL NO 1    Gujarat  Ahmedabad Corporation   380007   \n",
       "12           MUNICIPAL SCHOOL NO 1    Gujarat  Ahmedabad Corporation   380007   \n",
       "12           MUNICIPAL SCHOOL NO 1    Gujarat  Ahmedabad Corporation   380007   \n",
       "12           MUNICIPAL SCHOOL NO 1    Gujarat  Ahmedabad Corporation   380007   \n",
       "12           MUNICIPAL SCHOOL NO 1    Gujarat  Ahmedabad Corporation   380007   \n",
       "12           MUNICIPAL SCHOOL NO 1    Gujarat  Ahmedabad Corporation   380007   \n",
       "13         K G K School Kubernagar    Gujarat  Ahmedabad Corporation   382340   \n",
       "13         K G K School Kubernagar    Gujarat  Ahmedabad Corporation   382340   \n",
       "13         K G K School Kubernagar    Gujarat  Ahmedabad Corporation   382340   \n",
       "13         K G K School Kubernagar    Gujarat  Ahmedabad Corporation   382340   \n",
       "13         K G K School Kubernagar    Gujarat  Ahmedabad Corporation   382340   \n",
       "14              Muni. Shala No. 18    Gujarat  Ahmedabad Corporation   380015   \n",
       "14              Muni. Shala No. 18    Gujarat  Ahmedabad Corporation   380015   \n",
       "14              Muni. Shala No. 18    Gujarat  Ahmedabad Corporation   380015   \n",
       "14              Muni. Shala No. 18    Gujarat  Ahmedabad Corporation   380015   \n",
       "14              Muni. Shala No. 18    Gujarat  Ahmedabad Corporation   380015   \n",
       "15     Sardarnagar Gujarati School    Gujarat  Ahmedabad Corporation   382475   \n",
       "16  Naroda Gujarati Muni Shala 1/2    Gujarat  Ahmedabad Corporation   382330   \n",
       "16  Naroda Gujarati Muni Shala 1/2    Gujarat  Ahmedabad Corporation   382330   \n",
       "16  Naroda Gujarati Muni Shala 1/2    Gujarat  Ahmedabad Corporation   382330   \n",
       "16  Naroda Gujarati Muni Shala 1/2    Gujarat  Ahmedabad Corporation   382330   \n",
       "16  Naroda Gujarati Muni Shala 1/2    Gujarat  Ahmedabad Corporation   382330   \n",
       "16  Naroda Gujarati Muni Shala 1/2    Gujarat  Ahmedabad Corporation   382330   \n",
       "17              Jodhpur Shala No 2    Gujarat  Ahmedabad Corporation   380015   \n",
       "17              Jodhpur Shala No 2    Gujarat  Ahmedabad Corporation   380015   \n",
       "17              Jodhpur Shala No 2    Gujarat  Ahmedabad Corporation   380015   \n",
       "17              Jodhpur Shala No 2    Gujarat  Ahmedabad Corporation   380015   \n",
       "17              Jodhpur Shala No 2    Gujarat  Ahmedabad Corporation   380015   \n",
       "18        Nikol - 2 Sankalp School    Gujarat  Ahmedabad Corporation   382350   \n",
       "19   Kankaria Gujarati School No 1    Gujarat  Ahmedabad Corporation   380022   \n",
       "19   Kankaria Gujarati School No 1    Gujarat  Ahmedabad Corporation   380022   \n",
       "20  Dariapur Municipal School No 8    Gujarat  Ahmedabad Corporation   380001   \n",
       "20  Dariapur Municipal School No 8    Gujarat  Ahmedabad Corporation   380001   \n",
       "20  Dariapur Municipal School No 8    Gujarat  Ahmedabad Corporation   380001   \n",
       "20  Dariapur Municipal School No 8    Gujarat  Ahmedabad Corporation   380001   \n",
       "21            Naranpura Mun School    Gujarat  Ahmedabad Corporation   380013   \n",
       "21            Naranpura Mun School    Gujarat  Ahmedabad Corporation   380013   \n",
       "21            Naranpura Mun School    Gujarat  Ahmedabad Corporation   380013   \n",
       "21            Naranpura Mun School    Gujarat  Ahmedabad Corporation   380013   \n",
       "21            Naranpura Mun School    Gujarat  Ahmedabad Corporation   380013   \n",
       "23       Sardar Patel Shala Sankul    Gujarat  Ahmedabad Corporation   382345   \n",
       "23       Sardar Patel Shala Sankul    Gujarat  Ahmedabad Corporation   382345   \n",
       "23       Sardar Patel Shala Sankul    Gujarat  Ahmedabad Corporation   382345   \n",
       "23       Sardar Patel Shala Sankul    Gujarat  Ahmedabad Corporation   382345   \n",
       "23       Sardar Patel Shala Sankul    Gujarat  Ahmedabad Corporation   382345   \n",
       "25   Swami Narayan School Hathijan    Gujarat  Ahmedabad Corporation   382445   \n",
       "25   Swami Narayan School Hathijan    Gujarat  Ahmedabad Corporation   382445   \n",
       "25   Swami Narayan School Hathijan    Gujarat  Ahmedabad Corporation   382445   \n",
       "26          Municipal School No 12    Gujarat  Ahmedabad Corporation   380007   \n",
       "26          Municipal School No 12    Gujarat  Ahmedabad Corporation   380007   \n",
       "28              Ranip Pagar Kendra    Gujarat  Ahmedabad Corporation   382480   \n",
       "28              Ranip Pagar Kendra    Gujarat  Ahmedabad Corporation   382480   \n",
       "28              Ranip Pagar Kendra    Gujarat  Ahmedabad Corporation   382480   \n",
       "28              Ranip Pagar Kendra    Gujarat  Ahmedabad Corporation   382480   \n",
       "28              Ranip Pagar Kendra    Gujarat  Ahmedabad Corporation   382480   \n",
       "28              Ranip Pagar Kendra    Gujarat  Ahmedabad Corporation   382480   \n",
       "29    Raikhad Gujarati School NO.4    Gujarat  Ahmedabad Corporation   380001   \n",
       "30           School No-18 Dariapur    Gujarat  Ahmedabad Corporation   380001   \n",
       "30           School No-18 Dariapur    Gujarat  Ahmedabad Corporation   380001   \n",
       "30           School No-18 Dariapur    Gujarat  Ahmedabad Corporation   380001   \n",
       "34                Shakti Vidhyalay    Gujarat  Ahmedabad Corporation   380015   \n",
       "34                Shakti Vidhyalay    Gujarat  Ahmedabad Corporation   380015   \n",
       "34                Shakti Vidhyalay    Gujarat  Ahmedabad Corporation   380015   \n",
       "34                Shakti Vidhyalay    Gujarat  Ahmedabad Corporation   380015   \n",
       "34                Shakti Vidhyalay    Gujarat  Ahmedabad Corporation   380015   \n",
       "35        Ghodasar Gam School No 2    Gujarat  Ahmedabad Corporation   382443   \n",
       "35        Ghodasar Gam School No 2    Gujarat  Ahmedabad Corporation   382443   \n",
       "37     AADINATH PRI SCHOOL VASTRAL    Gujarat  Ahmedabad Corporation   382415   \n",
       "37     AADINATH PRI SCHOOL VASTRAL    Gujarat  Ahmedabad Corporation   382415   \n",
       "38   Swaminarayan Temple Maninagar    Gujarat  Ahmedabad Corporation   380008   \n",
       "38   Swaminarayan Temple Maninagar    Gujarat  Ahmedabad Corporation   380008   \n",
       "38   Swaminarayan Temple Maninagar    Gujarat  Ahmedabad Corporation   380008   \n",
       "38   Swaminarayan Temple Maninagar    Gujarat  Ahmedabad Corporation   380008   \n",
       "40                       Balbharti    Gujarat  Ahmedabad Corporation   380016   \n",
       "41   Municipal Gujarati Shala No 4    Gujarat  Ahmedabad Corporation   380013   \n",
       "41   Municipal Gujarati Shala No 4    Gujarat  Ahmedabad Corporation   380013   \n",
       "41   Municipal Gujarati Shala No 4    Gujarat  Ahmedabad Corporation   380013   \n",
       "41   Municipal Gujarati Shala No 4    Gujarat  Ahmedabad Corporation   380013   \n",
       "42         MU.SHALA NO 1 NAVAWADAJ    Gujarat  Ahmedabad Corporation   380013   \n",
       "42         MU.SHALA NO 1 NAVAWADAJ    Gujarat  Ahmedabad Corporation   380013   \n",
       "42         MU.SHALA NO 1 NAVAWADAJ    Gujarat  Ahmedabad Corporation   380013   \n",
       "42         MU.SHALA NO 1 NAVAWADAJ    Gujarat  Ahmedabad Corporation   380013   \n",
       "42         MU.SHALA NO 1 NAVAWADAJ    Gujarat  Ahmedabad Corporation   380013   \n",
       "44                MUNI SHALA NO 18    Gujarat  Ahmedabad Corporation   380015   \n",
       "44                MUNI SHALA NO 18    Gujarat  Ahmedabad Corporation   380015   \n",
       "\n",
       "   fee_type  \n",
       "33     Free  \n",
       "33     Free  \n",
       "33     Free  \n",
       "33     Free  \n",
       "33     Free  \n",
       "36     Free  \n",
       "36     Free  \n",
       "36     Free  \n",
       "6      Free  \n",
       "6      Free  \n",
       "6      Free  \n",
       "36     Free  \n",
       "36     Free  \n",
       "1      Free  \n",
       "6      Free  \n",
       "35     Free  \n",
       "35     Free  \n",
       "40     Free  \n",
       "40     Free  \n",
       "33     Free  \n",
       "40     Free  \n",
       "1      Free  \n",
       "36     Free  \n",
       "35     Free  \n",
       "25     Free  \n",
       "19     Free  \n",
       "19     Free  \n",
       "25     Free  \n",
       "9      Free  \n",
       "9      Free  \n",
       "1      Free  \n",
       "19     Free  \n",
       "40     Free  \n",
       "35     Free  \n",
       "25     Free  \n",
       "40     Free  \n",
       "9      Free  \n",
       "11     Free  \n",
       "13     Free  \n",
       "14     Free  \n",
       "19     Free  \n",
       "20     Free  \n",
       "23     Free  \n",
       "30     Free  \n",
       "38     Free  \n",
       "0      Free  \n",
       "0      Free  \n",
       "0      Free  \n",
       "0      Free  \n",
       "0      Free  \n",
       "1      Free  \n",
       "4      Free  \n",
       "4      Free  \n",
       "4      Free  \n",
       "4      Free  \n",
       "4      Free  \n",
       "4      Free  \n",
       "7      Free  \n",
       "7      Free  \n",
       "7      Free  \n",
       "7      Free  \n",
       "7      Free  \n",
       "8      Free  \n",
       "8      Free  \n",
       "8      Free  \n",
       "8      Free  \n",
       "8      Free  \n",
       "9      Free  \n",
       "9      Free  \n",
       "9      Free  \n",
       "10     Free  \n",
       "10     Free  \n",
       "10     Free  \n",
       "10     Free  \n",
       "10     Free  \n",
       "10     Free  \n",
       "11     Free  \n",
       "11     Free  \n",
       "11     Free  \n",
       "11     Free  \n",
       "12     Free  \n",
       "12     Free  \n",
       "12     Free  \n",
       "12     Free  \n",
       "12     Free  \n",
       "12     Free  \n",
       "13     Free  \n",
       "13     Free  \n",
       "13     Free  \n",
       "13     Free  \n",
       "13     Free  \n",
       "14     Free  \n",
       "14     Free  \n",
       "14     Free  \n",
       "14     Free  \n",
       "14     Free  \n",
       "15     Free  \n",
       "16     Free  \n",
       "16     Free  \n",
       "16     Free  \n",
       "16     Free  \n",
       "16     Free  \n",
       "16     Free  \n",
       "17     Free  \n",
       "17     Free  \n",
       "17     Free  \n",
       "17     Free  \n",
       "17     Free  \n",
       "18     Free  \n",
       "19     Free  \n",
       "19     Free  \n",
       "20     Free  \n",
       "20     Free  \n",
       "20     Free  \n",
       "20     Free  \n",
       "21     Free  \n",
       "21     Free  \n",
       "21     Free  \n",
       "21     Free  \n",
       "21     Free  \n",
       "23     Free  \n",
       "23     Free  \n",
       "23     Free  \n",
       "23     Free  \n",
       "23     Free  \n",
       "25     Free  \n",
       "25     Free  \n",
       "25     Free  \n",
       "26     Free  \n",
       "26     Free  \n",
       "28     Free  \n",
       "28     Free  \n",
       "28     Free  \n",
       "28     Free  \n",
       "28     Free  \n",
       "28     Free  \n",
       "29     Free  \n",
       "30     Free  \n",
       "30     Free  \n",
       "30     Free  \n",
       "34     Free  \n",
       "34     Free  \n",
       "34     Free  \n",
       "34     Free  \n",
       "34     Free  \n",
       "35     Free  \n",
       "35     Free  \n",
       "37     Free  \n",
       "37     Free  \n",
       "38     Free  \n",
       "38     Free  \n",
       "38     Free  \n",
       "38     Free  \n",
       "40     Free  \n",
       "41     Free  \n",
       "41     Free  \n",
       "41     Free  \n",
       "41     Free  \n",
       "42     Free  \n",
       "42     Free  \n",
       "42     Free  \n",
       "42     Free  \n",
       "42     Free  \n",
       "44     Free  \n",
       "44     Free  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "base = datetime.datetime.today()\n",
    "date_list = [base + datetime.timedelta(days=x) for x in range(next_n_days)]\n",
    "date_str = [x.strftime(\"%d-%m-%Y\") for x in date_list]\n",
    "INP_DATE = date_str[-1]\n",
    "\n",
    "all_date_df = None\n",
    "\n",
    "for DIST_ID in district_ids:\n",
    "    print(f\"checking for INP_DATE:{INP_DATE} & DIST_ID:{DIST_ID}\")\n",
    "    URL = \"https://cdn-api.co-vin.in/api/v2/appointment/sessions/public/calendarByDistrict?district_id={}&date={}\".format(DIST_ID, INP_DATE)\n",
    "    response = requests.get(URL)\n",
    "    data = json.loads(response.text)['centers']\n",
    "    df = pd.DataFrame(data)\n",
    "    df = df.explode(\"sessions\")\n",
    "    df['min_age_limit'] = df.sessions.apply(lambda x: x['min_age_limit'])\n",
    "    df['available_capacity'] = df.sessions.apply(lambda x: x['available_capacity'])\n",
    "    df['date'] = df.sessions.apply(lambda x: x['date'])\n",
    "    df = df[[\"date\", \"min_age_limit\", \"available_capacity\", \"pincode\", \"name\", \"state_name\", \"district_name\", \"block_name\", \"fee_type\"]]\n",
    "    if all_date_df is not None:\n",
    "        all_date_df = pd.concat([all_date_df, df])\n",
    "    else:\n",
    "        all_date_df = df\n",
    "            \n",
    "df = df.drop([\"block_name\"], axis=1).sort_values([\"min_age_limit\", \"available_capacity\"], ascending=[True, False])\n",
    "df[df.min_age_limit < 45]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "correct-minority",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "alike-template",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "collective-canvas",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}