Top 50.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "10ea5b32",
   "metadata": {},
   "outputs": [],
   "source": [
    "#modules\n",
    "import pandas as pd\n",
    "import seaborn as sns\n",
    "from matplotlib import pyplot as plt\n",
    "import numpy as np\n",
    "import texttable\n",
    "from tabulate import tabulate\n",
    "\n",
    "\n",
    "\n",
    " "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "023b6087",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Villa No.July</th>\n",
       "      <th>July Water Reading</th>\n",
       "      <th>Villa No. Aug</th>\n",
       "      <th>Aug Water Reading</th>\n",
       "      <th>Villa No. Sep</th>\n",
       "      <th>Sep Water Reading</th>\n",
       "      <th>Villa No. Oct</th>\n",
       "      <th>Oct Water Reading</th>\n",
       "      <th>Villa No. Nov</th>\n",
       "      <th>DIFF</th>\n",
       "      <th>Villa No. Jun</th>\n",
       "      <th>Jun Water Reading</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>2</td>\n",
       "      <td>11.0</td>\n",
       "      <td>2</td>\n",
       "      <td>11</td>\n",
       "      <td>2</td>\n",
       "      <td>16.0</td>\n",
       "      <td>2</td>\n",
       "      <td>13</td>\n",
       "      <td>2</td>\n",
       "      <td>15.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>3</td>\n",
       "      <td>20.0</td>\n",
       "      <td>3</td>\n",
       "      <td>31</td>\n",
       "      <td>3</td>\n",
       "      <td>38.0</td>\n",
       "      <td>3</td>\n",
       "      <td>31</td>\n",
       "      <td>3</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>4</td>\n",
       "      <td>38.0</td>\n",
       "      <td>4</td>\n",
       "      <td>22</td>\n",
       "      <td>4</td>\n",
       "      <td>20.0</td>\n",
       "      <td>4</td>\n",
       "      <td>20</td>\n",
       "      <td>4</td>\n",
       "      <td>22.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>10.0</td>\n",
       "      <td>5</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>692</th>\n",
       "      <td>693.0</td>\n",
       "      <td>88.0</td>\n",
       "      <td>696</td>\n",
       "      <td>17.0</td>\n",
       "      <td>690</td>\n",
       "      <td>21</td>\n",
       "      <td>691</td>\n",
       "      <td>21.0</td>\n",
       "      <td>690</td>\n",
       "      <td>19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>693</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>697</td>\n",
       "      <td>49.0</td>\n",
       "      <td>691</td>\n",
       "      <td>15</td>\n",
       "      <td>692</td>\n",
       "      <td>21.0</td>\n",
       "      <td>691</td>\n",
       "      <td>23</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>694</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>692</td>\n",
       "      <td>24</td>\n",
       "      <td>696</td>\n",
       "      <td>21.0</td>\n",
       "      <td>692</td>\n",
       "      <td>22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>695</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>696</td>\n",
       "      <td>21</td>\n",
       "      <td>697</td>\n",
       "      <td>53.0</td>\n",
       "      <td>696</td>\n",
       "      <td>19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>696</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>697</td>\n",
       "      <td>52</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>697</td>\n",
       "      <td>43</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>697 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Villa No.July  July Water Reading Villa No. Aug  Aug Water Reading  \\\n",
       "0              1.0                 0.0             1                0.0   \n",
       "1              2.0                20.0             2               11.0   \n",
       "2              3.0                 6.0             3               20.0   \n",
       "3              4.0                23.0             4               38.0   \n",
       "4              5.0                 0.0             5                5.0   \n",
       "..             ...                 ...           ...                ...   \n",
       "692          693.0                88.0           696               17.0   \n",
       "693            NaN                 NaN           697               49.0   \n",
       "694            NaN                 NaN           NaN                NaN   \n",
       "695            NaN                 NaN           NaN                NaN   \n",
       "696            NaN                 NaN           NaN                NaN   \n",
       "\n",
       "    Villa No. Sep  Sep Water Reading Villa No. Oct  Oct Water Reading  \\\n",
       "0               1                  0             1                0.0   \n",
       "1               2                 11             2               16.0   \n",
       "2               3                 31             3               38.0   \n",
       "3               4                 22             4               20.0   \n",
       "4               5                  0             5               10.0   \n",
       "..            ...                ...           ...                ...   \n",
       "692           690                 21           691               21.0   \n",
       "693           691                 15           692               21.0   \n",
       "694           692                 24           696               21.0   \n",
       "695           696                 21           697               53.0   \n",
       "696           697                 52           NaN                NaN   \n",
       "\n",
       "    Villa No. Nov  DIFF Villa No. Jun  Jun Water Reading  \n",
       "0               1     0             1                0.0  \n",
       "1               2    13             2               15.0  \n",
       "2               3    31             3                2.0  \n",
       "3               4    20             4               22.0  \n",
       "4               5     9             5               10.0  \n",
       "..            ...   ...           ...                ...  \n",
       "692           690    19           NaN                NaN  \n",
       "693           691    23           NaN                NaN  \n",
       "694           692    22           NaN                NaN  \n",
       "695           696    19           NaN                NaN  \n",
       "696           697    43           NaN                NaN  \n",
       "\n",
       "[697 rows x 12 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#excel file input\n",
    "dataset = pd.read_excel('/Users/vedantvyas/Desktop/July-November Data.xlsx')\n",
    "dataset\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "b9fe0ad3",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "+-----------------+---------------------+\n",
      "|   Villa No. Jun |   Jun Water Reading |\n",
      "+=================+=====================+\n",
      "|             387 |                 293 |\n",
      "+-----------------+---------------------+\n",
      "|              72 |                 153 |\n",
      "+-----------------+---------------------+\n",
      "|              37 |                 151 |\n",
      "+-----------------+---------------------+\n",
      "|             314 |                 144 |\n",
      "+-----------------+---------------------+\n",
      "|             126 |                 114 |\n",
      "+-----------------+---------------------+\n",
      "|             379 |                 103 |\n",
      "+-----------------+---------------------+\n",
      "|             383 |                 100 |\n",
      "+-----------------+---------------------+\n",
      "|             272 |                  99 |\n",
      "+-----------------+---------------------+\n",
      "|             157 |                  85 |\n",
      "+-----------------+---------------------+\n",
      "|             106 |                  84 |\n",
      "+-----------------+---------------------+\n",
      "|             635 |                  80 |\n",
      "+-----------------+---------------------+\n",
      "|             415 |                  78 |\n",
      "+-----------------+---------------------+\n",
      "|             256 |                  78 |\n",
      "+-----------------+---------------------+\n",
      "|             113 |                  78 |\n",
      "+-----------------+---------------------+\n",
      "|             697 |                  78 |\n",
      "+-----------------+---------------------+\n",
      "|             246 |                  69 |\n",
      "+-----------------+---------------------+\n",
      "|             136 |                  68 |\n",
      "+-----------------+---------------------+\n",
      "|             128 |                  67 |\n",
      "+-----------------+---------------------+\n",
      "|             381 |                  66 |\n",
      "+-----------------+---------------------+\n",
      "|             138 |                  66 |\n",
      "+-----------------+---------------------+\n",
      "|             191 |                  65 |\n",
      "+-----------------+---------------------+\n",
      "|              85 |                  65 |\n",
      "+-----------------+---------------------+\n",
      "|              16 |                  65 |\n",
      "+-----------------+---------------------+\n",
      "|             321 |                  63 |\n",
      "+-----------------+---------------------+\n",
      "|             281 |                  62 |\n",
      "+-----------------+---------------------+\n",
      "|             486 |                  61 |\n",
      "+-----------------+---------------------+\n",
      "|             302 |                  61 |\n",
      "+-----------------+---------------------+\n",
      "|             254 |                  61 |\n",
      "+-----------------+---------------------+\n",
      "|             451 |                  59 |\n",
      "+-----------------+---------------------+\n",
      "|             709 |                  59 |\n",
      "+-----------------+---------------------+\n",
      "|             149 |                  59 |\n",
      "+-----------------+---------------------+\n",
      "|             427 |                  58 |\n",
      "+-----------------+---------------------+\n",
      "|             160 |                  57 |\n",
      "+-----------------+---------------------+\n",
      "|              42 |                  56 |\n",
      "+-----------------+---------------------+\n",
      "|              84 |                  55 |\n",
      "+-----------------+---------------------+\n",
      "|             264 |                  54 |\n",
      "+-----------------+---------------------+\n",
      "|             183 |                  54 |\n",
      "+-----------------+---------------------+\n",
      "|             811 |                  54 |\n",
      "+-----------------+---------------------+\n",
      "|             423 |                  54 |\n",
      "+-----------------+---------------------+\n",
      "|             731 |                  53 |\n",
      "+-----------------+---------------------+\n",
      "|             341 |                  53 |\n",
      "+-----------------+---------------------+\n",
      "|             432 |                  53 |\n",
      "+-----------------+---------------------+\n",
      "|             309 |                  53 |\n",
      "+-----------------+---------------------+\n",
      "|             372 |                  52 |\n",
      "+-----------------+---------------------+\n",
      "|              36 |                  51 |\n",
      "+-----------------+---------------------+\n",
      "|             298 |                  51 |\n",
      "+-----------------+---------------------+\n",
      "|             814 |                  51 |\n",
      "+-----------------+---------------------+\n",
      "|             165 |                  51 |\n",
      "+-----------------+---------------------+\n",
      "|             161 |                  51 |\n",
      "+-----------------+---------------------+\n",
      "|             268 |                  50 |\n",
      "+-----------------+---------------------+\n"
     ]
    }
   ],
   "source": [
    "#JUNE\n",
    "#Top 50 Water Consumers\n",
    "test = dataset.sort_values(['Jun Water Reading'], ascending = [False])\n",
    "b =test[['Villa No. Jun', 'Jun Water Reading']]\n",
    "info = b.head(50)\n",
    "print(tabulate(info, headers = 'keys', tablefmt = 'grid', showindex = False))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "60cf3bd4",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "+-----------------+----------------------+\n",
      "|   Villa No.July |   July Water Reading |\n",
      "+=================+======================+\n",
      "|             331 |                  198 |\n",
      "+-----------------+----------------------+\n",
      "|              74 |                  173 |\n",
      "+-----------------+----------------------+\n",
      "|             141 |                  160 |\n",
      "+-----------------+----------------------+\n",
      "|              69 |                  142 |\n",
      "+-----------------+----------------------+\n",
      "|              78 |                  130 |\n",
      "+-----------------+----------------------+\n",
      "|              37 |                  128 |\n",
      "+-----------------+----------------------+\n",
      "|             132 |                  117 |\n",
      "+-----------------+----------------------+\n",
      "|             119 |                  101 |\n",
      "+-----------------+----------------------+\n",
      "|             108 |                   97 |\n",
      "+-----------------+----------------------+\n",
      "|             324 |                   89 |\n",
      "+-----------------+----------------------+\n",
      "|             693 |                   88 |\n",
      "+-----------------+----------------------+\n",
      "|             468 |                   82 |\n",
      "+-----------------+----------------------+\n",
      "|              16 |                   76 |\n",
      "+-----------------+----------------------+\n",
      "|             293 |                   71 |\n",
      "+-----------------+----------------------+\n",
      "|             171 |                   69 |\n",
      "+-----------------+----------------------+\n",
      "|             206 |                   68 |\n",
      "+-----------------+----------------------+\n",
      "|             131 |                   67 |\n",
      "+-----------------+----------------------+\n",
      "|             643 |                   67 |\n",
      "+-----------------+----------------------+\n",
      "|             149 |                   66 |\n",
      "+-----------------+----------------------+\n",
      "|             328 |                   65 |\n",
      "+-----------------+----------------------+\n",
      "|             222 |                   61 |\n",
      "+-----------------+----------------------+\n",
      "|             152 |                   60 |\n",
      "+-----------------+----------------------+\n",
      "|             314 |                   60 |\n",
      "+-----------------+----------------------+\n",
      "|              85 |                   59 |\n",
      "+-----------------+----------------------+\n",
      "|             357 |                   59 |\n",
      "+-----------------+----------------------+\n",
      "|              42 |                   59 |\n",
      "+-----------------+----------------------+\n",
      "|              47 |                   58 |\n",
      "+-----------------+----------------------+\n",
      "|             630 |                   57 |\n",
      "+-----------------+----------------------+\n",
      "|             121 |                   56 |\n",
      "+-----------------+----------------------+\n",
      "|             392 |                   55 |\n",
      "+-----------------+----------------------+\n",
      "|              36 |                   55 |\n",
      "+-----------------+----------------------+\n",
      "|             120 |                   55 |\n",
      "+-----------------+----------------------+\n",
      "|             274 |                   54 |\n",
      "+-----------------+----------------------+\n",
      "|             258 |                   54 |\n",
      "+-----------------+----------------------+\n",
      "|              84 |                   54 |\n",
      "+-----------------+----------------------+\n",
      "|             424 |                   54 |\n",
      "+-----------------+----------------------+\n",
      "|             591 |                   54 |\n",
      "+-----------------+----------------------+\n",
      "|             251 |                   53 |\n",
      "+-----------------+----------------------+\n",
      "|              11 |                   53 |\n",
      "+-----------------+----------------------+\n",
      "|             674 |                   52 |\n",
      "+-----------------+----------------------+\n",
      "|              12 |                   52 |\n",
      "+-----------------+----------------------+\n",
      "|             173 |                   52 |\n",
      "+-----------------+----------------------+\n",
      "|             161 |                   51 |\n",
      "+-----------------+----------------------+\n",
      "|             140 |                   51 |\n",
      "+-----------------+----------------------+\n",
      "|             365 |                   51 |\n",
      "+-----------------+----------------------+\n",
      "|             103 |                   51 |\n",
      "+-----------------+----------------------+\n",
      "|             205 |                   50 |\n",
      "+-----------------+----------------------+\n",
      "|             374 |                   50 |\n",
      "+-----------------+----------------------+\n",
      "|             107 |                   50 |\n",
      "+-----------------+----------------------+\n",
      "|             363 |                   49 |\n",
      "+-----------------+----------------------+\n"
     ]
    }
   ],
   "source": [
    "#July\n",
    "#Top 50 Water Consumers\n",
    "test = dataset.sort_values(['July Water Reading'], ascending = [False])\n",
    "b =test[['Villa No.July', 'July Water Reading']]\n",
    "info = b.head(50)\n",
    "print(tabulate(info, headers = 'keys', tablefmt = 'grid', showindex = False))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "93b67ae6",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "+-----------------+---------------------+\n",
      "| Villa No. Aug   |   Aug Water Reading |\n",
      "+=================+=====================+\n",
      "| 147             |                  97 |\n",
      "+-----------------+---------------------+\n",
      "| 149             |                  94 |\n",
      "+-----------------+---------------------+\n",
      "| 126             |                  86 |\n",
      "+-----------------+---------------------+\n",
      "| 107             |                  86 |\n",
      "+-----------------+---------------------+\n",
      "| 648             |                  85 |\n",
      "+-----------------+---------------------+\n",
      "| 256             |                  79 |\n",
      "+-----------------+---------------------+\n",
      "| 138             |                  79 |\n",
      "+-----------------+---------------------+\n",
      "| 709             |                  78 |\n",
      "+-----------------+---------------------+\n",
      "| 169             |                  76 |\n",
      "+-----------------+---------------------+\n",
      "| 373-C           |                  76 |\n",
      "+-----------------+---------------------+\n",
      "| 36              |                  74 |\n",
      "+-----------------+---------------------+\n",
      "| 272             |                  74 |\n",
      "+-----------------+---------------------+\n",
      "| 451             |                  71 |\n",
      "+-----------------+---------------------+\n",
      "| 128             |                  71 |\n",
      "+-----------------+---------------------+\n",
      "| 148             |                  70 |\n",
      "+-----------------+---------------------+\n",
      "| 85              |                  69 |\n",
      "+-----------------+---------------------+\n",
      "| 106             |                  68 |\n",
      "+-----------------+---------------------+\n",
      "| 12              |                  68 |\n",
      "+-----------------+---------------------+\n",
      "| 16              |                  67 |\n",
      "+-----------------+---------------------+\n",
      "| 415             |                  67 |\n",
      "+-----------------+---------------------+\n",
      "| 84              |                  66 |\n",
      "+-----------------+---------------------+\n",
      "| 62              |                  65 |\n",
      "+-----------------+---------------------+\n",
      "| 254             |                  64 |\n",
      "+-----------------+---------------------+\n",
      "| 176             |                  63 |\n",
      "+-----------------+---------------------+\n",
      "| 487             |                  62 |\n",
      "+-----------------+---------------------+\n",
      "| 93              |                  60 |\n",
      "+-----------------+---------------------+\n",
      "| 89              |                  60 |\n",
      "+-----------------+---------------------+\n",
      "| 66              |                  60 |\n",
      "+-----------------+---------------------+\n",
      "| 95              |                  58 |\n",
      "+-----------------+---------------------+\n",
      "| 69              |                  58 |\n",
      "+-----------------+---------------------+\n",
      "| 498             |                  58 |\n",
      "+-----------------+---------------------+\n",
      "| 190             |                  58 |\n",
      "+-----------------+---------------------+\n",
      "| 281             |                  57 |\n",
      "+-----------------+---------------------+\n",
      "| 508             |                  57 |\n",
      "+-----------------+---------------------+\n",
      "| 113             |                  57 |\n",
      "+-----------------+---------------------+\n",
      "| 120             |                  56 |\n",
      "+-----------------+---------------------+\n",
      "| 486             |                  56 |\n",
      "+-----------------+---------------------+\n",
      "| 614             |                  56 |\n",
      "+-----------------+---------------------+\n",
      "| 46              |                  55 |\n",
      "+-----------------+---------------------+\n",
      "| 801             |                  55 |\n",
      "+-----------------+---------------------+\n",
      "| 157             |                  55 |\n",
      "+-----------------+---------------------+\n",
      "| 161             |                  54 |\n",
      "+-----------------+---------------------+\n",
      "| 324             |                  54 |\n",
      "+-----------------+---------------------+\n",
      "| 495             |                  54 |\n",
      "+-----------------+---------------------+\n",
      "| 383             |                  53 |\n",
      "+-----------------+---------------------+\n",
      "| 432             |                  53 |\n",
      "+-----------------+---------------------+\n",
      "| 136             |                  53 |\n",
      "+-----------------+---------------------+\n",
      "| 657             |                  53 |\n",
      "+-----------------+---------------------+\n",
      "| 584             |                  53 |\n",
      "+-----------------+---------------------+\n",
      "| 112             |                  52 |\n",
      "+-----------------+---------------------+\n"
     ]
    }
   ],
   "source": [
    "#August\n",
    "#Top 50 Water Consumers\n",
    "test = dataset.sort_values(['Aug Water Reading'], ascending = [False])\n",
    "b =test[['Villa No. Aug', 'Aug Water Reading']]\n",
    "info = b.head(50)\n",
    "print(tabulate(info, headers = 'keys', tablefmt = 'grid', showindex = False))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "36db23fb",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "+-----------------+---------------------+\n",
      "| Villa No. Sep   |   Sep Water Reading |\n",
      "+=================+=====================+\n",
      "| 814             |                 199 |\n",
      "+-----------------+---------------------+\n",
      "| 15              |                 148 |\n",
      "+-----------------+---------------------+\n",
      "| 107             |                 106 |\n",
      "+-----------------+---------------------+\n",
      "| 147             |                 105 |\n",
      "+-----------------+---------------------+\n",
      "| 149             |                 104 |\n",
      "+-----------------+---------------------+\n",
      "| 169             |                  92 |\n",
      "+-----------------+---------------------+\n",
      "| 148             |                  92 |\n",
      "+-----------------+---------------------+\n",
      "| 36              |                  90 |\n",
      "+-----------------+---------------------+\n",
      "| 67              |                  87 |\n",
      "+-----------------+---------------------+\n",
      "| 126             |                  81 |\n",
      "+-----------------+---------------------+\n",
      "| 16              |                  78 |\n",
      "+-----------------+---------------------+\n",
      "| 272             |                  77 |\n",
      "+-----------------+---------------------+\n",
      "| 256             |                  76 |\n",
      "+-----------------+---------------------+\n",
      "| 138             |                  76 |\n",
      "+-----------------+---------------------+\n",
      "| 127             |                  75 |\n",
      "+-----------------+---------------------+\n",
      "| 373-C           |                  75 |\n",
      "+-----------------+---------------------+\n",
      "| 498             |                  74 |\n",
      "+-----------------+---------------------+\n",
      "| 85              |                  68 |\n",
      "+-----------------+---------------------+\n",
      "| 415             |                  66 |\n",
      "+-----------------+---------------------+\n",
      "| 128             |                  63 |\n",
      "+-----------------+---------------------+\n",
      "| 451             |                  62 |\n",
      "+-----------------+---------------------+\n",
      "| 383             |                  62 |\n",
      "+-----------------+---------------------+\n",
      "| 326             |                  61 |\n",
      "+-----------------+---------------------+\n",
      "| 624             |                  60 |\n",
      "+-----------------+---------------------+\n",
      "| 709             |                  59 |\n",
      "+-----------------+---------------------+\n",
      "| 684             |                  58 |\n",
      "+-----------------+---------------------+\n",
      "| 160             |                  57 |\n",
      "+-----------------+---------------------+\n",
      "| 95              |                  57 |\n",
      "+-----------------+---------------------+\n",
      "| 157             |                  57 |\n",
      "+-----------------+---------------------+\n",
      "| 62              |                  56 |\n",
      "+-----------------+---------------------+\n",
      "| 12              |                  56 |\n",
      "+-----------------+---------------------+\n",
      "| 487             |                  56 |\n",
      "+-----------------+---------------------+\n",
      "| 254             |                  56 |\n",
      "+-----------------+---------------------+\n",
      "| 113             |                  56 |\n",
      "+-----------------+---------------------+\n",
      "| 378             |                  55 |\n",
      "+-----------------+---------------------+\n",
      "| 106             |                  55 |\n",
      "+-----------------+---------------------+\n",
      "| 190             |                  55 |\n",
      "+-----------------+---------------------+\n",
      "| 495             |                  55 |\n",
      "+-----------------+---------------------+\n",
      "| 161             |                  54 |\n",
      "+-----------------+---------------------+\n",
      "| 584             |                  54 |\n",
      "+-----------------+---------------------+\n",
      "| 699             |                  54 |\n",
      "+-----------------+---------------------+\n",
      "| 653             |                  54 |\n",
      "+-----------------+---------------------+\n",
      "| 486             |                  54 |\n",
      "+-----------------+---------------------+\n",
      "| 703             |                  53 |\n",
      "+-----------------+---------------------+\n",
      "| 324             |                  53 |\n",
      "+-----------------+---------------------+\n",
      "| 669             |                  53 |\n",
      "+-----------------+---------------------+\n",
      "| 697             |                  52 |\n",
      "+-----------------+---------------------+\n",
      "| 192             |                  52 |\n",
      "+-----------------+---------------------+\n",
      "| 84              |                  51 |\n",
      "+-----------------+---------------------+\n",
      "| 8               |                  51 |\n",
      "+-----------------+---------------------+\n"
     ]
    }
   ],
   "source": [
    "#September\n",
    "#Top 50 Water Consumers\n",
    "test = dataset.sort_values(['Sep Water Reading'], ascending = [False])\n",
    "b =test[['Villa No. Sep', 'Sep Water Reading']]\n",
    "info = b.head(50)\n",
    "print(tabulate(info, headers = 'keys', tablefmt = 'grid', showindex = False))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "3630e965",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "+-----------------+---------------------+\n",
      "| Villa No. Oct   |   Oct Water Reading |\n",
      "+=================+=====================+\n",
      "| 149             |                 171 |\n",
      "+-----------------+---------------------+\n",
      "| 96              |                 129 |\n",
      "+-----------------+---------------------+\n",
      "| 709             |                 113 |\n",
      "+-----------------+---------------------+\n",
      "| 355             |                 104 |\n",
      "+-----------------+---------------------+\n",
      "| 169             |                  81 |\n",
      "+-----------------+---------------------+\n",
      "| 147             |                  80 |\n",
      "+-----------------+---------------------+\n",
      "| 126             |                  79 |\n",
      "+-----------------+---------------------+\n",
      "| 16              |                  77 |\n",
      "+-----------------+---------------------+\n",
      "| 373-C           |                  77 |\n",
      "+-----------------+---------------------+\n",
      "| 107             |                  73 |\n",
      "+-----------------+---------------------+\n",
      "| 138             |                  69 |\n",
      "+-----------------+---------------------+\n",
      "| 36              |                  69 |\n",
      "+-----------------+---------------------+\n",
      "| 415             |                  68 |\n",
      "+-----------------+---------------------+\n",
      "| 113             |                  67 |\n",
      "+-----------------+---------------------+\n",
      "| 85              |                  66 |\n",
      "+-----------------+---------------------+\n",
      "| 84              |                  65 |\n",
      "+-----------------+---------------------+\n",
      "| 272             |                  63 |\n",
      "+-----------------+---------------------+\n",
      "| 190             |                  61 |\n",
      "+-----------------+---------------------+\n",
      "| 383             |                  60 |\n",
      "+-----------------+---------------------+\n",
      "| 498             |                  60 |\n",
      "+-----------------+---------------------+\n",
      "| 735             |                  60 |\n",
      "+-----------------+---------------------+\n",
      "| 703             |                  58 |\n",
      "+-----------------+---------------------+\n",
      "| 453             |                  57 |\n",
      "+-----------------+---------------------+\n",
      "| 533             |                  56 |\n",
      "+-----------------+---------------------+\n",
      "| 298             |                  56 |\n",
      "+-----------------+---------------------+\n",
      "| 699             |                  56 |\n",
      "+-----------------+---------------------+\n",
      "| 487             |                  55 |\n",
      "+-----------------+---------------------+\n",
      "| 495             |                  54 |\n",
      "+-----------------+---------------------+\n",
      "| 12              |                  54 |\n",
      "+-----------------+---------------------+\n",
      "| 127             |                  53 |\n",
      "+-----------------+---------------------+\n",
      "| 697             |                  53 |\n",
      "+-----------------+---------------------+\n",
      "| 160             |                  53 |\n",
      "+-----------------+---------------------+\n",
      "| 95              |                  53 |\n",
      "+-----------------+---------------------+\n",
      "| 423             |                  53 |\n",
      "+-----------------+---------------------+\n",
      "| 106             |                  52 |\n",
      "+-----------------+---------------------+\n",
      "| 324             |                  52 |\n",
      "+-----------------+---------------------+\n",
      "| 486             |                  52 |\n",
      "+-----------------+---------------------+\n",
      "| 45              |                  51 |\n",
      "+-----------------+---------------------+\n",
      "| 451             |                  51 |\n",
      "+-----------------+---------------------+\n",
      "| 79              |                  51 |\n",
      "+-----------------+---------------------+\n",
      "| 128             |                  50 |\n",
      "+-----------------+---------------------+\n",
      "| 596             |                  50 |\n",
      "+-----------------+---------------------+\n",
      "| 536             |                  50 |\n",
      "+-----------------+---------------------+\n",
      "| 378             |                  50 |\n",
      "+-----------------+---------------------+\n",
      "| 256             |                  50 |\n",
      "+-----------------+---------------------+\n",
      "| 42              |                  49 |\n",
      "+-----------------+---------------------+\n",
      "| 624             |                  49 |\n",
      "+-----------------+---------------------+\n",
      "| 309             |                  49 |\n",
      "+-----------------+---------------------+\n",
      "| 69              |                  48 |\n",
      "+-----------------+---------------------+\n",
      "| 120             |                  48 |\n",
      "+-----------------+---------------------+\n"
     ]
    }
   ],
   "source": [
    "#October\n",
    "#Top 50 Water Consumers\n",
    "test = dataset.sort_values(['Oct Water Reading'], ascending = [False])\n",
    "b =test[['Villa No. Oct', 'Oct Water Reading']]\n",
    "info = b.head(50)\n",
    "print(tabulate(info, headers = 'keys', tablefmt = 'grid', showindex = False))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "2910e268",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "+-----------------+---------------------+\n",
      "| Villa No. Nov   |   Nov Water Reading |\n",
      "+=================+=====================+\n",
      "| 169             |                  93 |\n",
      "+-----------------+---------------------+\n",
      "| 126             |                  92 |\n",
      "+-----------------+---------------------+\n",
      "| 752             |                  91 |\n",
      "+-----------------+---------------------+\n",
      "| 149             |                  84 |\n",
      "+-----------------+---------------------+\n",
      "| 371             |                  81 |\n",
      "+-----------------+---------------------+\n",
      "| 127             |                  80 |\n",
      "+-----------------+---------------------+\n",
      "| 709             |                  78 |\n",
      "+-----------------+---------------------+\n",
      "| 16              |                  78 |\n",
      "+-----------------+---------------------+\n",
      "| 272             |                  77 |\n",
      "+-----------------+---------------------+\n",
      "| 387             |                  77 |\n",
      "+-----------------+---------------------+\n",
      "| 84              |                  76 |\n",
      "+-----------------+---------------------+\n",
      "| 185             |                  75 |\n",
      "+-----------------+---------------------+\n",
      "| 415             |                  73 |\n",
      "+-----------------+---------------------+\n",
      "| 147             |                  69 |\n",
      "+-----------------+---------------------+\n",
      "| 138             |                  65 |\n",
      "+-----------------+---------------------+\n",
      "| 85              |                  65 |\n",
      "+-----------------+---------------------+\n",
      "| 107             |                  63 |\n",
      "+-----------------+---------------------+\n",
      "| 113             |                  61 |\n",
      "+-----------------+---------------------+\n",
      "| 364             |                  60 |\n",
      "+-----------------+---------------------+\n",
      "| 533             |                  60 |\n",
      "+-----------------+---------------------+\n",
      "| 699             |                  59 |\n",
      "+-----------------+---------------------+\n",
      "| 74              |                  58 |\n",
      "+-----------------+---------------------+\n",
      "| 584             |                  58 |\n",
      "+-----------------+---------------------+\n",
      "| 36              |                  58 |\n",
      "+-----------------+---------------------+\n",
      "| 106             |                  58 |\n",
      "+-----------------+---------------------+\n",
      "| 20              |                  58 |\n",
      "+-----------------+---------------------+\n",
      "| 120             |                  57 |\n",
      "+-----------------+---------------------+\n",
      "| 160             |                  57 |\n",
      "+-----------------+---------------------+\n",
      "| 190             |                  56 |\n",
      "+-----------------+---------------------+\n",
      "| 378             |                  55 |\n",
      "+-----------------+---------------------+\n",
      "| 128             |                  55 |\n",
      "+-----------------+---------------------+\n",
      "| 246             |                  54 |\n",
      "+-----------------+---------------------+\n",
      "| 703             |                  54 |\n",
      "+-----------------+---------------------+\n",
      "| 373-C           |                  53 |\n",
      "+-----------------+---------------------+\n",
      "| 383             |                  53 |\n",
      "+-----------------+---------------------+\n",
      "| 256             |                  52 |\n",
      "+-----------------+---------------------+\n",
      "| 498             |                  52 |\n",
      "+-----------------+---------------------+\n",
      "| 486             |                  51 |\n",
      "+-----------------+---------------------+\n",
      "| 42              |                  51 |\n",
      "+-----------------+---------------------+\n",
      "| 312             |                  50 |\n",
      "+-----------------+---------------------+\n",
      "| 487             |                  50 |\n",
      "+-----------------+---------------------+\n",
      "| 172             |                  50 |\n",
      "+-----------------+---------------------+\n",
      "| 789             |                  50 |\n",
      "+-----------------+---------------------+\n",
      "| 423             |                  50 |\n",
      "+-----------------+---------------------+\n",
      "| 69              |                  50 |\n",
      "+-----------------+---------------------+\n",
      "| 614             |                  50 |\n",
      "+-----------------+---------------------+\n",
      "| 495             |                  50 |\n",
      "+-----------------+---------------------+\n",
      "| 45              |                  50 |\n",
      "+-----------------+---------------------+\n",
      "| 582             |                  49 |\n",
      "+-----------------+---------------------+\n",
      "| 607             |                  49 |\n",
      "+-----------------+---------------------+\n"
     ]
    }
   ],
   "source": [
    "#November\n",
    "#Top 50 Water Consumers\n",
    "test = dataset.sort_values(['DIFF'], ascending = [False])\n",
    "b =test[['Villa No. Nov', 'DIFF']]\n",
    "info = b.head(50)\n",
    "print(tabulate(info, headers = ['Villa No. Nov', 'Nov Water Reading'], tablefmt = 'grid', showindex = False))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c8987a03",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}