Mtn Analysis.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "da798bd0",
   "metadata": {},
   "source": [
    "# Buypower & Mtn Partner Reconciliation\n",
    "\n",
    "## Tasks to run\n",
    "\n",
    "#### 1. Merge the different sp file together   ----------------------------------  2. Clean the data by deleting empty columns\n",
    "#### 3. Pick the month and day into a diffferent col -----------------------  4. Remove the minus (debit)\n",
    "#### 5. Analyse the sales trend ---------------------------------------------------  6. Visualise your report\n",
    "#### 7. Analyse the disco with the most sales and which day?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "2418700e",
   "metadata": {},
   "outputs": [],
   "source": [
    "## Import py libraries \n",
    "\n",
    "import pandas as pd\n",
    "from glob import glob\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "200c8bc9",
   "metadata": {},
   "source": [
    "### Read the list of files in the directory"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "ee7f7dc2",
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['./downloads/monnify_trans\\\\JAN_DEC13_monnify.csv',\n",
       " './downloads/monnify_trans\\\\Transaction_Report_20210101-20210131.csv',\n",
       " './downloads/monnify_trans\\\\Transaction_Report_20210201-20210228.csv',\n",
       " './downloads/monnify_trans\\\\Transaction_Report_20210301-20210331.csv',\n",
       " './downloads/monnify_trans\\\\Transaction_Report_20210401-20210430.csv',\n",
       " './downloads/monnify_trans\\\\Transaction_Report_20210501-20210531.csv',\n",
       " './downloads/monnify_trans\\\\Transaction_Report_20210601-20210630.csv',\n",
       " './downloads/monnify_trans\\\\Transaction_Report_20210701-20210731.csv',\n",
       " './downloads/monnify_trans\\\\Transaction_Report_20210801-20210831.csv',\n",
       " './downloads/monnify_trans\\\\Transaction_Report_20210901-20210930.csv',\n",
       " './downloads/monnify_trans\\\\Transaction_Report_20211001-20211031.csv',\n",
       " './downloads/monnify_trans\\\\Transaction_Report_20211101-20211130.csv',\n",
       " './downloads/monnify_trans\\\\Transaction_Report_20211201-20211214.csv']"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_files = sorted(glob('./downloads/monnify_trans/*.csv'))\n",
    "data_files"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "21d8c514",
   "metadata": {},
   "source": [
    "### Merge the files together"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "7ba49a0c",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-3-94f6f88c6511>:1: DtypeWarning: Columns (13,14) have mixed types.Specify dtype option on import or set low_memory=False.\n",
      "  merge_data = pd.concat(pd.read_csv(df).assign(filename = df)\n"
     ]
    },
    {
     "ename": "ParserError",
     "evalue": "Error tokenizing data. C error: Expected 12 fields in line 2512, saw 13\n",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mParserError\u001b[0m                               Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-3-94f6f88c6511>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m merge_data = pd.concat(pd.read_csv(df).assign(filename = df) \n\u001b[0m\u001b[0;32m      2\u001b[0m                       for df in data_files)\n\u001b[0;32m      3\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m      4\u001b[0m \u001b[0mmerge_data\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\anaconda3\\lib\\site-packages\\pandas\\core\\reshape\\concat.py\u001b[0m in \u001b[0;36mconcat\u001b[1;34m(objs, axis, join, ignore_index, keys, levels, names, verify_integrity, sort, copy)\u001b[0m\n\u001b[0;32m    283\u001b[0m     \u001b[0mValueError\u001b[0m\u001b[1;33m:\u001b[0m \u001b[0mIndexes\u001b[0m \u001b[0mhave\u001b[0m \u001b[0moverlapping\u001b[0m \u001b[0mvalues\u001b[0m\u001b[1;33m:\u001b[0m \u001b[1;33m[\u001b[0m\u001b[1;34m'a'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    284\u001b[0m     \"\"\"\n\u001b[1;32m--> 285\u001b[1;33m     op = _Concatenator(\n\u001b[0m\u001b[0;32m    286\u001b[0m         \u001b[0mobjs\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    287\u001b[0m         \u001b[0maxis\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0maxis\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\anaconda3\\lib\\site-packages\\pandas\\core\\reshape\\concat.py\u001b[0m in \u001b[0;36m__init__\u001b[1;34m(self, objs, axis, join, keys, levels, names, ignore_index, verify_integrity, copy, sort)\u001b[0m\n\u001b[0;32m    337\u001b[0m             \u001b[0mobjs\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;33m[\u001b[0m\u001b[0mobjs\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mk\u001b[0m\u001b[1;33m]\u001b[0m \u001b[1;32mfor\u001b[0m \u001b[0mk\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mkeys\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    338\u001b[0m         \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 339\u001b[1;33m             \u001b[0mobjs\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mlist\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mobjs\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    340\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    341\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0mlen\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mobjs\u001b[0m\u001b[1;33m)\u001b[0m \u001b[1;33m==\u001b[0m \u001b[1;36m0\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m<ipython-input-3-94f6f88c6511>\u001b[0m in \u001b[0;36m<genexpr>\u001b[1;34m(.0)\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m merge_data = pd.concat(pd.read_csv(df).assign(filename = df) \n\u001b[0m\u001b[0;32m      2\u001b[0m                       for df in data_files)\n\u001b[0;32m      3\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m      4\u001b[0m \u001b[0mmerge_data\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\anaconda3\\lib\\site-packages\\pandas\\io\\parsers.py\u001b[0m in \u001b[0;36mread_csv\u001b[1;34m(filepath_or_buffer, sep, delimiter, header, names, index_col, usecols, squeeze, prefix, mangle_dupe_cols, dtype, engine, converters, true_values, false_values, skipinitialspace, skiprows, skipfooter, nrows, na_values, keep_default_na, na_filter, verbose, skip_blank_lines, parse_dates, infer_datetime_format, keep_date_col, date_parser, dayfirst, cache_dates, iterator, chunksize, compression, thousands, decimal, lineterminator, quotechar, quoting, doublequote, escapechar, comment, encoding, dialect, error_bad_lines, warn_bad_lines, delim_whitespace, low_memory, memory_map, float_precision, storage_options)\u001b[0m\n\u001b[0;32m    608\u001b[0m     \u001b[0mkwds\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mupdate\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mkwds_defaults\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    609\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 610\u001b[1;33m     \u001b[1;32mreturn\u001b[0m \u001b[0m_read\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mkwds\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    611\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    612\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\anaconda3\\lib\\site-packages\\pandas\\io\\parsers.py\u001b[0m in \u001b[0;36m_read\u001b[1;34m(filepath_or_buffer, kwds)\u001b[0m\n\u001b[0;32m    466\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    467\u001b[0m     \u001b[1;32mwith\u001b[0m \u001b[0mparser\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 468\u001b[1;33m         \u001b[1;32mreturn\u001b[0m \u001b[0mparser\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mread\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mnrows\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    469\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    470\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\anaconda3\\lib\\site-packages\\pandas\\io\\parsers.py\u001b[0m in \u001b[0;36mread\u001b[1;34m(self, nrows)\u001b[0m\n\u001b[0;32m   1055\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0mread\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mnrows\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;32mNone\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   1056\u001b[0m         \u001b[0mnrows\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mvalidate_integer\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"nrows\"\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mnrows\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 1057\u001b[1;33m         \u001b[0mindex\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mcolumns\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mcol_dict\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_engine\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mread\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mnrows\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m   1058\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   1059\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0mindex\u001b[0m \u001b[1;32mis\u001b[0m \u001b[1;32mNone\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32m~\\anaconda3\\lib\\site-packages\\pandas\\io\\parsers.py\u001b[0m in \u001b[0;36mread\u001b[1;34m(self, nrows)\u001b[0m\n\u001b[0;32m   2059\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0mread\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mnrows\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;32mNone\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   2060\u001b[0m         \u001b[1;32mtry\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 2061\u001b[1;33m             \u001b[0mdata\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_reader\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mread\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mnrows\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m   2062\u001b[0m         \u001b[1;32mexcept\u001b[0m \u001b[0mStopIteration\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   2063\u001b[0m             \u001b[1;32mif\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_first_chunk\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mpandas\\_libs\\parsers.pyx\u001b[0m in \u001b[0;36mpandas._libs.parsers.TextReader.read\u001b[1;34m()\u001b[0m\n",
      "\u001b[1;32mpandas\\_libs\\parsers.pyx\u001b[0m in \u001b[0;36mpandas._libs.parsers.TextReader._read_low_memory\u001b[1;34m()\u001b[0m\n",
      "\u001b[1;32mpandas\\_libs\\parsers.pyx\u001b[0m in \u001b[0;36mpandas._libs.parsers.TextReader._read_rows\u001b[1;34m()\u001b[0m\n",
      "\u001b[1;32mpandas\\_libs\\parsers.pyx\u001b[0m in \u001b[0;36mpandas._libs.parsers.TextReader._tokenize_rows\u001b[1;34m()\u001b[0m\n",
      "\u001b[1;32mpandas\\_libs\\parsers.pyx\u001b[0m in \u001b[0;36mpandas._libs.parsers.raise_parser_error\u001b[1;34m()\u001b[0m\n",
      "\u001b[1;31mParserError\u001b[0m: Error tokenizing data. C error: Expected 12 fields in line 2512, saw 13\n"
     ]
    }
   ],
   "source": [
    "merge_data = pd.concat(pd.read_csv(df).assign(filename = df) \n",
    "                      for df in data_files)\n",
    "\n",
    "merge_data"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9249cbf0",
   "metadata": {},
   "source": [
    "### Delete the empty and unnecessary columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "480fd589",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "delete_column = ['From Handler Name','Initiated By','On Behalf Of','Provider Category','Information','Note/Message','External Amount','Currency.1','External FX Rate','External Service Provider','Currency.2','Discount','Currency.3','Promotion','Currency.4','Coupon','Currency.5','Balance','Currency.6']\n",
    "merge_data = merge_data.drop(columns = delete_column)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "cbebbdcd",
   "metadata": {},
   "source": [
    "### Create new columns Month and Day"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "81aedac7",
   "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>Id</th>\n",
       "      <th>External Transaction Id</th>\n",
       "      <th>Date</th>\n",
       "      <th>Status</th>\n",
       "      <th>Type</th>\n",
       "      <th>From</th>\n",
       "      <th>From Name</th>\n",
       "      <th>To</th>\n",
       "      <th>To Name</th>\n",
       "      <th>To Handler Name</th>\n",
       "      <th>Amount</th>\n",
       "      <th>Currency</th>\n",
       "      <th>Fee</th>\n",
       "      <th>filename</th>\n",
       "      <th>Day</th>\n",
       "      <th>Month</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>246093265</td>\n",
       "      <td>246093265</td>\n",
       "      <td>2021-07-31 23:40:00</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2348103049429/MSISDN</td>\n",
       "      <td>Patricia Ibrahim</td>\n",
       "      <td>FRI:02146172298@startimes.sp/SP</td>\n",
       "      <td>Startimes</td>\n",
       "      <td>Startimes Cable</td>\n",
       "      <td>90.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>1.35</td>\n",
       "      <td>./downloads/all_mtn_success\\3823082_2021-07-01...</td>\n",
       "      <td>31</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>246092688</td>\n",
       "      <td>246092688</td>\n",
       "      <td>2021-07-31 23:39:00</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2348103049429/MSISDN</td>\n",
       "      <td>Patricia Ibrahim</td>\n",
       "      <td>FRI:02146172298@startimes.sp/SP</td>\n",
       "      <td>Startimes</td>\n",
       "      <td>Startimes Cable</td>\n",
       "      <td>90.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>1.35</td>\n",
       "      <td>./downloads/all_mtn_success\\3823082_2021-07-01...</td>\n",
       "      <td>31</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>246092126</td>\n",
       "      <td>246092126</td>\n",
       "      <td>2021-07-31 23:38:00</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2348103049429/MSISDN</td>\n",
       "      <td>Patricia Ibrahim</td>\n",
       "      <td>FRI:02146172298@startimes.sp/SP</td>\n",
       "      <td>Startimes</td>\n",
       "      <td>Startimes Cable</td>\n",
       "      <td>90.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>1.35</td>\n",
       "      <td>./downloads/all_mtn_success\\3823082_2021-07-01...</td>\n",
       "      <td>31</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>246091622</td>\n",
       "      <td>246091622</td>\n",
       "      <td>2021-07-31 23:37:00</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2348103049429/MSISDN</td>\n",
       "      <td>Patricia Ibrahim</td>\n",
       "      <td>FRI:02146172298@startimes.sp/SP</td>\n",
       "      <td>Startimes</td>\n",
       "      <td>Startimes Cable</td>\n",
       "      <td>90.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>1.35</td>\n",
       "      <td>./downloads/all_mtn_success\\3823082_2021-07-01...</td>\n",
       "      <td>31</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>246090761</td>\n",
       "      <td>246090761</td>\n",
       "      <td>2021-07-31 23:36:00</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2348103049429/MSISDN</td>\n",
       "      <td>Patricia Ibrahim</td>\n",
       "      <td>FRI:02146172298@startimes.sp/SP</td>\n",
       "      <td>Startimes</td>\n",
       "      <td>Startimes Cable</td>\n",
       "      <td>90.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>1.35</td>\n",
       "      <td>./downloads/all_mtn_success\\3823082_2021-07-01...</td>\n",
       "      <td>31</td>\n",
       "      <td>7</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1806</th>\n",
       "      <td>309013279</td>\n",
       "      <td>309013279</td>\n",
       "      <td>2021-10-01 08:36:00</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2348063582638/MSISDN</td>\n",
       "      <td>USMAN MUSTAPHA</td>\n",
       "      <td>FRI:58000082352@kedco.sp/SP</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>500.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>8.00</td>\n",
       "      <td>./downloads/all_mtn_success\\3966792_2021-10-01...</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1807</th>\n",
       "      <td>309008964</td>\n",
       "      <td>309008964</td>\n",
       "      <td>2021-10-01 08:30:00</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2347032618376/MSISDN</td>\n",
       "      <td>ASHIRU SURAJO</td>\n",
       "      <td>FRI:0137200143345@kedco.sp/SP</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>450.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>7.20</td>\n",
       "      <td>./downloads/all_mtn_success\\3966792_2021-10-01...</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1808</th>\n",
       "      <td>308977882</td>\n",
       "      <td>308977882</td>\n",
       "      <td>2021-10-01 07:39:01</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2348062212190/MSISDN</td>\n",
       "      <td>AMINU MUSTAPHA</td>\n",
       "      <td>FRI:0137200025443@kedco.sp/SP</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>16.00</td>\n",
       "      <td>./downloads/all_mtn_success\\3966792_2021-10-01...</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1809</th>\n",
       "      <td>308951156</td>\n",
       "      <td>308951156</td>\n",
       "      <td>2021-10-01 06:11:00</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2348140050513/MSISDN</td>\n",
       "      <td>Airtime Networks Teller23</td>\n",
       "      <td>FRI:30530250049@kedco.sp/SP</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>32.00</td>\n",
       "      <td>./downloads/all_mtn_success\\3966792_2021-10-01...</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1810</th>\n",
       "      <td>308939187</td>\n",
       "      <td>308939187</td>\n",
       "      <td>2021-10-01 01:39:00</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2348066010915/MSISDN</td>\n",
       "      <td>AUWAL ABBAS</td>\n",
       "      <td>FRI:0137200024743@kedco.sp/SP</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>500.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>8.00</td>\n",
       "      <td>./downloads/all_mtn_success\\3966792_2021-10-01...</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>123406 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Id External Transaction Id                 Date      Status  \\\n",
       "0     246093265               246093265  2021-07-31 23:40:00  Successful   \n",
       "1     246092688               246092688  2021-07-31 23:39:00  Successful   \n",
       "2     246092126               246092126  2021-07-31 23:38:00  Successful   \n",
       "3     246091622               246091622  2021-07-31 23:37:00  Successful   \n",
       "4     246090761               246090761  2021-07-31 23:36:00  Successful   \n",
       "...         ...                     ...                  ...         ...   \n",
       "1806  309013279               309013279  2021-10-01 08:36:00  Successful   \n",
       "1807  309008964               309008964  2021-10-01 08:30:00  Successful   \n",
       "1808  308977882               308977882  2021-10-01 07:39:01  Successful   \n",
       "1809  308951156               308951156  2021-10-01 06:11:00  Successful   \n",
       "1810  308939187               308939187  2021-10-01 01:39:00  Successful   \n",
       "\n",
       "                  Type                      From                  From Name  \\\n",
       "0     External payment  FRI:2348103049429/MSISDN           Patricia Ibrahim   \n",
       "1     External payment  FRI:2348103049429/MSISDN           Patricia Ibrahim   \n",
       "2     External payment  FRI:2348103049429/MSISDN           Patricia Ibrahim   \n",
       "3     External payment  FRI:2348103049429/MSISDN           Patricia Ibrahim   \n",
       "4     External payment  FRI:2348103049429/MSISDN           Patricia Ibrahim   \n",
       "...                ...                       ...                        ...   \n",
       "1806  External payment  FRI:2348063582638/MSISDN             USMAN MUSTAPHA   \n",
       "1807  External payment  FRI:2347032618376/MSISDN              ASHIRU SURAJO   \n",
       "1808  External payment  FRI:2348062212190/MSISDN             AMINU MUSTAPHA   \n",
       "1809  External payment  FRI:2348140050513/MSISDN  Airtime Networks Teller23   \n",
       "1810  External payment  FRI:2348066010915/MSISDN                AUWAL ABBAS   \n",
       "\n",
       "                                   To              To Name  \\\n",
       "0     FRI:02146172298@startimes.sp/SP            Startimes   \n",
       "1     FRI:02146172298@startimes.sp/SP            Startimes   \n",
       "2     FRI:02146172298@startimes.sp/SP            Startimes   \n",
       "3     FRI:02146172298@startimes.sp/SP            Startimes   \n",
       "4     FRI:02146172298@startimes.sp/SP            Startimes   \n",
       "...                               ...                  ...   \n",
       "1806      FRI:58000082352@kedco.sp/SP  KEDCO - Electricity   \n",
       "1807    FRI:0137200143345@kedco.sp/SP  KEDCO - Electricity   \n",
       "1808    FRI:0137200025443@kedco.sp/SP  KEDCO - Electricity   \n",
       "1809      FRI:30530250049@kedco.sp/SP  KEDCO - Electricity   \n",
       "1810    FRI:0137200024743@kedco.sp/SP  KEDCO - Electricity   \n",
       "\n",
       "          To Handler Name  Amount Currency    Fee  \\\n",
       "0         Startimes Cable    90.0      NGN   1.35   \n",
       "1         Startimes Cable    90.0      NGN   1.35   \n",
       "2         Startimes Cable    90.0      NGN   1.35   \n",
       "3         Startimes Cable    90.0      NGN   1.35   \n",
       "4         Startimes Cable    90.0      NGN   1.35   \n",
       "...                   ...     ...      ...    ...   \n",
       "1806  KEDCO - Electricity   500.0      NGN   8.00   \n",
       "1807  KEDCO - Electricity   450.0      NGN   7.20   \n",
       "1808  KEDCO - Electricity  1000.0      NGN  16.00   \n",
       "1809  KEDCO - Electricity  2000.0      NGN  32.00   \n",
       "1810  KEDCO - Electricity   500.0      NGN   8.00   \n",
       "\n",
       "                                               filename  Day  Month  \n",
       "0     ./downloads/all_mtn_success\\3823082_2021-07-01...   31      7  \n",
       "1     ./downloads/all_mtn_success\\3823082_2021-07-01...   31      7  \n",
       "2     ./downloads/all_mtn_success\\3823082_2021-07-01...   31      7  \n",
       "3     ./downloads/all_mtn_success\\3823082_2021-07-01...   31      7  \n",
       "4     ./downloads/all_mtn_success\\3823082_2021-07-01...   31      7  \n",
       "...                                                 ...  ...    ...  \n",
       "1806  ./downloads/all_mtn_success\\3966792_2021-10-01...    1     10  \n",
       "1807  ./downloads/all_mtn_success\\3966792_2021-10-01...    1     10  \n",
       "1808  ./downloads/all_mtn_success\\3966792_2021-10-01...    1     10  \n",
       "1809  ./downloads/all_mtn_success\\3966792_2021-10-01...    1     10  \n",
       "1810  ./downloads/all_mtn_success\\3966792_2021-10-01...    1     10  \n",
       "\n",
       "[123406 rows x 16 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merge_data['Day'] = merge_data['Date'].str[8:10]\n",
    "merge_data['Month'] = merge_data['Date'].str[5:7]\n",
    "\n",
    "merge_data[['Month','Day']] = merge_data[['Month','Day']].astype('int32')\n",
    "\n",
    "merge_data\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d187139b",
   "metadata": {},
   "source": [
    "### Check for debit in the Amount column"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "5961909e",
   "metadata": {
    "scrolled": true
   },
   "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>Id</th>\n",
       "      <th>External Transaction Id</th>\n",
       "      <th>Date</th>\n",
       "      <th>Status</th>\n",
       "      <th>Type</th>\n",
       "      <th>From</th>\n",
       "      <th>From Name</th>\n",
       "      <th>To</th>\n",
       "      <th>To Name</th>\n",
       "      <th>To Handler Name</th>\n",
       "      <th>Amount</th>\n",
       "      <th>Currency</th>\n",
       "      <th>Fee</th>\n",
       "      <th>filename</th>\n",
       "      <th>Day</th>\n",
       "      <th>Month</th>\n",
       "      <th>Debit</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>246093265</td>\n",
       "      <td>246093265</td>\n",
       "      <td>2021-07-31 23:40:00</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2348103049429/MSISDN</td>\n",
       "      <td>Patricia Ibrahim</td>\n",
       "      <td>FRI:02146172298@startimes.sp/SP</td>\n",
       "      <td>Startimes</td>\n",
       "      <td>Startimes Cable</td>\n",
       "      <td>90.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>1.35</td>\n",
       "      <td>./downloads/all_mtn_success\\3823082_2021-07-01...</td>\n",
       "      <td>31</td>\n",
       "      <td>7</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>246092688</td>\n",
       "      <td>246092688</td>\n",
       "      <td>2021-07-31 23:39:00</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2348103049429/MSISDN</td>\n",
       "      <td>Patricia Ibrahim</td>\n",
       "      <td>FRI:02146172298@startimes.sp/SP</td>\n",
       "      <td>Startimes</td>\n",
       "      <td>Startimes Cable</td>\n",
       "      <td>90.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>1.35</td>\n",
       "      <td>./downloads/all_mtn_success\\3823082_2021-07-01...</td>\n",
       "      <td>31</td>\n",
       "      <td>7</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>246092126</td>\n",
       "      <td>246092126</td>\n",
       "      <td>2021-07-31 23:38:00</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2348103049429/MSISDN</td>\n",
       "      <td>Patricia Ibrahim</td>\n",
       "      <td>FRI:02146172298@startimes.sp/SP</td>\n",
       "      <td>Startimes</td>\n",
       "      <td>Startimes Cable</td>\n",
       "      <td>90.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>1.35</td>\n",
       "      <td>./downloads/all_mtn_success\\3823082_2021-07-01...</td>\n",
       "      <td>31</td>\n",
       "      <td>7</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>246091622</td>\n",
       "      <td>246091622</td>\n",
       "      <td>2021-07-31 23:37:00</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2348103049429/MSISDN</td>\n",
       "      <td>Patricia Ibrahim</td>\n",
       "      <td>FRI:02146172298@startimes.sp/SP</td>\n",
       "      <td>Startimes</td>\n",
       "      <td>Startimes Cable</td>\n",
       "      <td>90.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>1.35</td>\n",
       "      <td>./downloads/all_mtn_success\\3823082_2021-07-01...</td>\n",
       "      <td>31</td>\n",
       "      <td>7</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>246090761</td>\n",
       "      <td>246090761</td>\n",
       "      <td>2021-07-31 23:36:00</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2348103049429/MSISDN</td>\n",
       "      <td>Patricia Ibrahim</td>\n",
       "      <td>FRI:02146172298@startimes.sp/SP</td>\n",
       "      <td>Startimes</td>\n",
       "      <td>Startimes Cable</td>\n",
       "      <td>90.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>1.35</td>\n",
       "      <td>./downloads/all_mtn_success\\3823082_2021-07-01...</td>\n",
       "      <td>31</td>\n",
       "      <td>7</td>\n",
       "      <td>False</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1806</th>\n",
       "      <td>309013279</td>\n",
       "      <td>309013279</td>\n",
       "      <td>2021-10-01 08:36:00</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2348063582638/MSISDN</td>\n",
       "      <td>USMAN MUSTAPHA</td>\n",
       "      <td>FRI:58000082352@kedco.sp/SP</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>500.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>8.00</td>\n",
       "      <td>./downloads/all_mtn_success\\3966792_2021-10-01...</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1807</th>\n",
       "      <td>309008964</td>\n",
       "      <td>309008964</td>\n",
       "      <td>2021-10-01 08:30:00</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2347032618376/MSISDN</td>\n",
       "      <td>ASHIRU SURAJO</td>\n",
       "      <td>FRI:0137200143345@kedco.sp/SP</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>450.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>7.20</td>\n",
       "      <td>./downloads/all_mtn_success\\3966792_2021-10-01...</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1808</th>\n",
       "      <td>308977882</td>\n",
       "      <td>308977882</td>\n",
       "      <td>2021-10-01 07:39:01</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2348062212190/MSISDN</td>\n",
       "      <td>AMINU MUSTAPHA</td>\n",
       "      <td>FRI:0137200025443@kedco.sp/SP</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>16.00</td>\n",
       "      <td>./downloads/all_mtn_success\\3966792_2021-10-01...</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1809</th>\n",
       "      <td>308951156</td>\n",
       "      <td>308951156</td>\n",
       "      <td>2021-10-01 06:11:00</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2348140050513/MSISDN</td>\n",
       "      <td>Airtime Networks Teller23</td>\n",
       "      <td>FRI:30530250049@kedco.sp/SP</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>32.00</td>\n",
       "      <td>./downloads/all_mtn_success\\3966792_2021-10-01...</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1810</th>\n",
       "      <td>308939187</td>\n",
       "      <td>308939187</td>\n",
       "      <td>2021-10-01 01:39:00</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2348066010915/MSISDN</td>\n",
       "      <td>AUWAL ABBAS</td>\n",
       "      <td>FRI:0137200024743@kedco.sp/SP</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>500.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>8.00</td>\n",
       "      <td>./downloads/all_mtn_success\\3966792_2021-10-01...</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>123406 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Id External Transaction Id                 Date      Status  \\\n",
       "0     246093265               246093265  2021-07-31 23:40:00  Successful   \n",
       "1     246092688               246092688  2021-07-31 23:39:00  Successful   \n",
       "2     246092126               246092126  2021-07-31 23:38:00  Successful   \n",
       "3     246091622               246091622  2021-07-31 23:37:00  Successful   \n",
       "4     246090761               246090761  2021-07-31 23:36:00  Successful   \n",
       "...         ...                     ...                  ...         ...   \n",
       "1806  309013279               309013279  2021-10-01 08:36:00  Successful   \n",
       "1807  309008964               309008964  2021-10-01 08:30:00  Successful   \n",
       "1808  308977882               308977882  2021-10-01 07:39:01  Successful   \n",
       "1809  308951156               308951156  2021-10-01 06:11:00  Successful   \n",
       "1810  308939187               308939187  2021-10-01 01:39:00  Successful   \n",
       "\n",
       "                  Type                      From                  From Name  \\\n",
       "0     External payment  FRI:2348103049429/MSISDN           Patricia Ibrahim   \n",
       "1     External payment  FRI:2348103049429/MSISDN           Patricia Ibrahim   \n",
       "2     External payment  FRI:2348103049429/MSISDN           Patricia Ibrahim   \n",
       "3     External payment  FRI:2348103049429/MSISDN           Patricia Ibrahim   \n",
       "4     External payment  FRI:2348103049429/MSISDN           Patricia Ibrahim   \n",
       "...                ...                       ...                        ...   \n",
       "1806  External payment  FRI:2348063582638/MSISDN             USMAN MUSTAPHA   \n",
       "1807  External payment  FRI:2347032618376/MSISDN              ASHIRU SURAJO   \n",
       "1808  External payment  FRI:2348062212190/MSISDN             AMINU MUSTAPHA   \n",
       "1809  External payment  FRI:2348140050513/MSISDN  Airtime Networks Teller23   \n",
       "1810  External payment  FRI:2348066010915/MSISDN                AUWAL ABBAS   \n",
       "\n",
       "                                   To              To Name  \\\n",
       "0     FRI:02146172298@startimes.sp/SP            Startimes   \n",
       "1     FRI:02146172298@startimes.sp/SP            Startimes   \n",
       "2     FRI:02146172298@startimes.sp/SP            Startimes   \n",
       "3     FRI:02146172298@startimes.sp/SP            Startimes   \n",
       "4     FRI:02146172298@startimes.sp/SP            Startimes   \n",
       "...                               ...                  ...   \n",
       "1806      FRI:58000082352@kedco.sp/SP  KEDCO - Electricity   \n",
       "1807    FRI:0137200143345@kedco.sp/SP  KEDCO - Electricity   \n",
       "1808    FRI:0137200025443@kedco.sp/SP  KEDCO - Electricity   \n",
       "1809      FRI:30530250049@kedco.sp/SP  KEDCO - Electricity   \n",
       "1810    FRI:0137200024743@kedco.sp/SP  KEDCO - Electricity   \n",
       "\n",
       "          To Handler Name  Amount Currency    Fee  \\\n",
       "0         Startimes Cable    90.0      NGN   1.35   \n",
       "1         Startimes Cable    90.0      NGN   1.35   \n",
       "2         Startimes Cable    90.0      NGN   1.35   \n",
       "3         Startimes Cable    90.0      NGN   1.35   \n",
       "4         Startimes Cable    90.0      NGN   1.35   \n",
       "...                   ...     ...      ...    ...   \n",
       "1806  KEDCO - Electricity   500.0      NGN   8.00   \n",
       "1807  KEDCO - Electricity   450.0      NGN   7.20   \n",
       "1808  KEDCO - Electricity  1000.0      NGN  16.00   \n",
       "1809  KEDCO - Electricity  2000.0      NGN  32.00   \n",
       "1810  KEDCO - Electricity   500.0      NGN   8.00   \n",
       "\n",
       "                                               filename  Day  Month  Debit  \n",
       "0     ./downloads/all_mtn_success\\3823082_2021-07-01...   31      7  False  \n",
       "1     ./downloads/all_mtn_success\\3823082_2021-07-01...   31      7  False  \n",
       "2     ./downloads/all_mtn_success\\3823082_2021-07-01...   31      7  False  \n",
       "3     ./downloads/all_mtn_success\\3823082_2021-07-01...   31      7  False  \n",
       "4     ./downloads/all_mtn_success\\3823082_2021-07-01...   31      7  False  \n",
       "...                                                 ...  ...    ...    ...  \n",
       "1806  ./downloads/all_mtn_success\\3966792_2021-10-01...    1     10  False  \n",
       "1807  ./downloads/all_mtn_success\\3966792_2021-10-01...    1     10  False  \n",
       "1808  ./downloads/all_mtn_success\\3966792_2021-10-01...    1     10  False  \n",
       "1809  ./downloads/all_mtn_success\\3966792_2021-10-01...    1     10  False  \n",
       "1810  ./downloads/all_mtn_success\\3966792_2021-10-01...    1     10  False  \n",
       "\n",
       "[123406 rows x 17 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merge_data['Amount'] = pd.to_numeric(merge_data['Amount'])\n",
    "merge_data = merge_data.assign(Debit=lambda merge_data: merge_data['Amount'] < 1)\n",
    "\n",
    "merge_data "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "293b9dd5",
   "metadata": {},
   "outputs": [],
   "source": [
    "merge_data.to_csv('./downloads/all_mtn_success/d1.csv', index= 'true')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "36b605ad",
   "metadata": {},
   "source": [
    "### Bring out credit rows only "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "e8e898ec",
   "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>Id</th>\n",
       "      <th>External Transaction Id</th>\n",
       "      <th>Date</th>\n",
       "      <th>Status</th>\n",
       "      <th>Type</th>\n",
       "      <th>From</th>\n",
       "      <th>From Name</th>\n",
       "      <th>To</th>\n",
       "      <th>To Name</th>\n",
       "      <th>To Handler Name</th>\n",
       "      <th>Amount</th>\n",
       "      <th>Currency</th>\n",
       "      <th>Fee</th>\n",
       "      <th>filename</th>\n",
       "      <th>Day</th>\n",
       "      <th>Month</th>\n",
       "      <th>Debit</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>246093265</td>\n",
       "      <td>246093265</td>\n",
       "      <td>2021-07-31 23:40:00</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2348103049429/MSISDN</td>\n",
       "      <td>Patricia Ibrahim</td>\n",
       "      <td>FRI:02146172298@startimes.sp/SP</td>\n",
       "      <td>Startimes</td>\n",
       "      <td>Startimes Cable</td>\n",
       "      <td>90.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>1.35</td>\n",
       "      <td>./downloads/all_mtn_success\\3823082_2021-07-01...</td>\n",
       "      <td>31</td>\n",
       "      <td>7</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>246092688</td>\n",
       "      <td>246092688</td>\n",
       "      <td>2021-07-31 23:39:00</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2348103049429/MSISDN</td>\n",
       "      <td>Patricia Ibrahim</td>\n",
       "      <td>FRI:02146172298@startimes.sp/SP</td>\n",
       "      <td>Startimes</td>\n",
       "      <td>Startimes Cable</td>\n",
       "      <td>90.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>1.35</td>\n",
       "      <td>./downloads/all_mtn_success\\3823082_2021-07-01...</td>\n",
       "      <td>31</td>\n",
       "      <td>7</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>246092126</td>\n",
       "      <td>246092126</td>\n",
       "      <td>2021-07-31 23:38:00</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2348103049429/MSISDN</td>\n",
       "      <td>Patricia Ibrahim</td>\n",
       "      <td>FRI:02146172298@startimes.sp/SP</td>\n",
       "      <td>Startimes</td>\n",
       "      <td>Startimes Cable</td>\n",
       "      <td>90.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>1.35</td>\n",
       "      <td>./downloads/all_mtn_success\\3823082_2021-07-01...</td>\n",
       "      <td>31</td>\n",
       "      <td>7</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>246091622</td>\n",
       "      <td>246091622</td>\n",
       "      <td>2021-07-31 23:37:00</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2348103049429/MSISDN</td>\n",
       "      <td>Patricia Ibrahim</td>\n",
       "      <td>FRI:02146172298@startimes.sp/SP</td>\n",
       "      <td>Startimes</td>\n",
       "      <td>Startimes Cable</td>\n",
       "      <td>90.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>1.35</td>\n",
       "      <td>./downloads/all_mtn_success\\3823082_2021-07-01...</td>\n",
       "      <td>31</td>\n",
       "      <td>7</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>246090761</td>\n",
       "      <td>246090761</td>\n",
       "      <td>2021-07-31 23:36:00</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2348103049429/MSISDN</td>\n",
       "      <td>Patricia Ibrahim</td>\n",
       "      <td>FRI:02146172298@startimes.sp/SP</td>\n",
       "      <td>Startimes</td>\n",
       "      <td>Startimes Cable</td>\n",
       "      <td>90.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>1.35</td>\n",
       "      <td>./downloads/all_mtn_success\\3823082_2021-07-01...</td>\n",
       "      <td>31</td>\n",
       "      <td>7</td>\n",
       "      <td>False</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1806</th>\n",
       "      <td>309013279</td>\n",
       "      <td>309013279</td>\n",
       "      <td>2021-10-01 08:36:00</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2348063582638/MSISDN</td>\n",
       "      <td>USMAN MUSTAPHA</td>\n",
       "      <td>FRI:58000082352@kedco.sp/SP</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>500.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>8.00</td>\n",
       "      <td>./downloads/all_mtn_success\\3966792_2021-10-01...</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1807</th>\n",
       "      <td>309008964</td>\n",
       "      <td>309008964</td>\n",
       "      <td>2021-10-01 08:30:00</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2347032618376/MSISDN</td>\n",
       "      <td>ASHIRU SURAJO</td>\n",
       "      <td>FRI:0137200143345@kedco.sp/SP</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>450.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>7.20</td>\n",
       "      <td>./downloads/all_mtn_success\\3966792_2021-10-01...</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1808</th>\n",
       "      <td>308977882</td>\n",
       "      <td>308977882</td>\n",
       "      <td>2021-10-01 07:39:01</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2348062212190/MSISDN</td>\n",
       "      <td>AMINU MUSTAPHA</td>\n",
       "      <td>FRI:0137200025443@kedco.sp/SP</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>16.00</td>\n",
       "      <td>./downloads/all_mtn_success\\3966792_2021-10-01...</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1809</th>\n",
       "      <td>308951156</td>\n",
       "      <td>308951156</td>\n",
       "      <td>2021-10-01 06:11:00</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2348140050513/MSISDN</td>\n",
       "      <td>Airtime Networks Teller23</td>\n",
       "      <td>FRI:30530250049@kedco.sp/SP</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>32.00</td>\n",
       "      <td>./downloads/all_mtn_success\\3966792_2021-10-01...</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1810</th>\n",
       "      <td>308939187</td>\n",
       "      <td>308939187</td>\n",
       "      <td>2021-10-01 01:39:00</td>\n",
       "      <td>Successful</td>\n",
       "      <td>External payment</td>\n",
       "      <td>FRI:2348066010915/MSISDN</td>\n",
       "      <td>AUWAL ABBAS</td>\n",
       "      <td>FRI:0137200024743@kedco.sp/SP</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>500.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>8.00</td>\n",
       "      <td>./downloads/all_mtn_success\\3966792_2021-10-01...</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>123239 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Id External Transaction Id                 Date      Status  \\\n",
       "0     246093265               246093265  2021-07-31 23:40:00  Successful   \n",
       "1     246092688               246092688  2021-07-31 23:39:00  Successful   \n",
       "2     246092126               246092126  2021-07-31 23:38:00  Successful   \n",
       "3     246091622               246091622  2021-07-31 23:37:00  Successful   \n",
       "4     246090761               246090761  2021-07-31 23:36:00  Successful   \n",
       "...         ...                     ...                  ...         ...   \n",
       "1806  309013279               309013279  2021-10-01 08:36:00  Successful   \n",
       "1807  309008964               309008964  2021-10-01 08:30:00  Successful   \n",
       "1808  308977882               308977882  2021-10-01 07:39:01  Successful   \n",
       "1809  308951156               308951156  2021-10-01 06:11:00  Successful   \n",
       "1810  308939187               308939187  2021-10-01 01:39:00  Successful   \n",
       "\n",
       "                  Type                      From                  From Name  \\\n",
       "0     External payment  FRI:2348103049429/MSISDN           Patricia Ibrahim   \n",
       "1     External payment  FRI:2348103049429/MSISDN           Patricia Ibrahim   \n",
       "2     External payment  FRI:2348103049429/MSISDN           Patricia Ibrahim   \n",
       "3     External payment  FRI:2348103049429/MSISDN           Patricia Ibrahim   \n",
       "4     External payment  FRI:2348103049429/MSISDN           Patricia Ibrahim   \n",
       "...                ...                       ...                        ...   \n",
       "1806  External payment  FRI:2348063582638/MSISDN             USMAN MUSTAPHA   \n",
       "1807  External payment  FRI:2347032618376/MSISDN              ASHIRU SURAJO   \n",
       "1808  External payment  FRI:2348062212190/MSISDN             AMINU MUSTAPHA   \n",
       "1809  External payment  FRI:2348140050513/MSISDN  Airtime Networks Teller23   \n",
       "1810  External payment  FRI:2348066010915/MSISDN                AUWAL ABBAS   \n",
       "\n",
       "                                   To              To Name  \\\n",
       "0     FRI:02146172298@startimes.sp/SP            Startimes   \n",
       "1     FRI:02146172298@startimes.sp/SP            Startimes   \n",
       "2     FRI:02146172298@startimes.sp/SP            Startimes   \n",
       "3     FRI:02146172298@startimes.sp/SP            Startimes   \n",
       "4     FRI:02146172298@startimes.sp/SP            Startimes   \n",
       "...                               ...                  ...   \n",
       "1806      FRI:58000082352@kedco.sp/SP  KEDCO - Electricity   \n",
       "1807    FRI:0137200143345@kedco.sp/SP  KEDCO - Electricity   \n",
       "1808    FRI:0137200025443@kedco.sp/SP  KEDCO - Electricity   \n",
       "1809      FRI:30530250049@kedco.sp/SP  KEDCO - Electricity   \n",
       "1810    FRI:0137200024743@kedco.sp/SP  KEDCO - Electricity   \n",
       "\n",
       "          To Handler Name  Amount Currency    Fee  \\\n",
       "0         Startimes Cable    90.0      NGN   1.35   \n",
       "1         Startimes Cable    90.0      NGN   1.35   \n",
       "2         Startimes Cable    90.0      NGN   1.35   \n",
       "3         Startimes Cable    90.0      NGN   1.35   \n",
       "4         Startimes Cable    90.0      NGN   1.35   \n",
       "...                   ...     ...      ...    ...   \n",
       "1806  KEDCO - Electricity   500.0      NGN   8.00   \n",
       "1807  KEDCO - Electricity   450.0      NGN   7.20   \n",
       "1808  KEDCO - Electricity  1000.0      NGN  16.00   \n",
       "1809  KEDCO - Electricity  2000.0      NGN  32.00   \n",
       "1810  KEDCO - Electricity   500.0      NGN   8.00   \n",
       "\n",
       "                                               filename  Day  Month  Debit  \n",
       "0     ./downloads/all_mtn_success\\3823082_2021-07-01...   31      7  False  \n",
       "1     ./downloads/all_mtn_success\\3823082_2021-07-01...   31      7  False  \n",
       "2     ./downloads/all_mtn_success\\3823082_2021-07-01...   31      7  False  \n",
       "3     ./downloads/all_mtn_success\\3823082_2021-07-01...   31      7  False  \n",
       "4     ./downloads/all_mtn_success\\3823082_2021-07-01...   31      7  False  \n",
       "...                                                 ...  ...    ...    ...  \n",
       "1806  ./downloads/all_mtn_success\\3966792_2021-10-01...    1     10  False  \n",
       "1807  ./downloads/all_mtn_success\\3966792_2021-10-01...    1     10  False  \n",
       "1808  ./downloads/all_mtn_success\\3966792_2021-10-01...    1     10  False  \n",
       "1809  ./downloads/all_mtn_success\\3966792_2021-10-01...    1     10  False  \n",
       "1810  ./downloads/all_mtn_success\\3966792_2021-10-01...    1     10  False  \n",
       "\n",
       "[123239 rows x 17 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merge_credit_data = merge_data.loc[merge_data['Debit'] == False]\n",
    "merge_credit_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "65dc6841",
   "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>Id</th>\n",
       "      <th>External Transaction Id</th>\n",
       "      <th>Date</th>\n",
       "      <th>Status</th>\n",
       "      <th>Type</th>\n",
       "      <th>From</th>\n",
       "      <th>From Name</th>\n",
       "      <th>To</th>\n",
       "      <th>To Name</th>\n",
       "      <th>To Handler Name</th>\n",
       "      <th>Amount</th>\n",
       "      <th>Currency</th>\n",
       "      <th>Fee</th>\n",
       "      <th>filename</th>\n",
       "      <th>Day</th>\n",
       "      <th>Month</th>\n",
       "      <th>Debit</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2575</th>\n",
       "      <td>235271012</td>\n",
       "      <td>YDFS235271012</td>\n",
       "      <td>2021-07-22 15:36:45</td>\n",
       "      <td>Successful</td>\n",
       "      <td>Withdrawal</td>\n",
       "      <td>FRI:3823082/MM</td>\n",
       "      <td>Startimes Cable</td>\n",
       "      <td>FRI:0723229267@044150149/BANK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1840000.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>./downloads/all_mtn_success\\3823082_2021-07-01...</td>\n",
       "      <td>22</td>\n",
       "      <td>7</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4351</th>\n",
       "      <td>230132366</td>\n",
       "      <td>YDFS230132366</td>\n",
       "      <td>2021-07-17 12:21:12</td>\n",
       "      <td>Successful</td>\n",
       "      <td>Withdrawal</td>\n",
       "      <td>FRI:3823082/MM</td>\n",
       "      <td>Startimes Cable</td>\n",
       "      <td>FRI:0723229267@044150149/BANK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1320000.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>./downloads/all_mtn_success\\3823082_2021-07-01...</td>\n",
       "      <td>17</td>\n",
       "      <td>7</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5454</th>\n",
       "      <td>224762097</td>\n",
       "      <td>YDFS224762097</td>\n",
       "      <td>2021-07-12 09:25:53</td>\n",
       "      <td>Successful</td>\n",
       "      <td>Withdrawal</td>\n",
       "      <td>FRI:3823082/MM</td>\n",
       "      <td>Startimes Cable</td>\n",
       "      <td>FRI:0723229267@044150149/BANK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1100000.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>./downloads/all_mtn_success\\3823082_2021-07-01...</td>\n",
       "      <td>12</td>\n",
       "      <td>7</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6560</th>\n",
       "      <td>217904033</td>\n",
       "      <td>YDFS217904033</td>\n",
       "      <td>2021-07-04 09:33:55</td>\n",
       "      <td>Successful</td>\n",
       "      <td>Withdrawal</td>\n",
       "      <td>FRI:3823082/MM</td>\n",
       "      <td>Startimes Cable</td>\n",
       "      <td>FRI:0723229267@044150149/BANK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1350000.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>./downloads/all_mtn_success\\3823082_2021-07-01...</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>600</th>\n",
       "      <td>274724794</td>\n",
       "      <td>YDFS274724794</td>\n",
       "      <td>2021-08-29 21:58:24</td>\n",
       "      <td>Successful</td>\n",
       "      <td>Withdrawal</td>\n",
       "      <td>FRI:3823082/MM</td>\n",
       "      <td>Startimes Cable</td>\n",
       "      <td>FRI:0723229267@044150149/BANK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1350000.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>./downloads/all_mtn_success\\3823082_2021-08-01...</td>\n",
       "      <td>29</td>\n",
       "      <td>8</td>\n",
       "      <td>True</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1149</th>\n",
       "      <td>282818257</td>\n",
       "      <td>YDFS282818257</td>\n",
       "      <td>2021-09-07 13:33:37</td>\n",
       "      <td>Successful</td>\n",
       "      <td>Withdrawal</td>\n",
       "      <td>FRI:3966792/MM</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>FRI:0723229267@044150149/BANK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-645000.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>./downloads/all_mtn_success\\3966792_2021-09-01...</td>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1605</th>\n",
       "      <td>278217340</td>\n",
       "      <td>YDFS278217340</td>\n",
       "      <td>2021-09-02 12:50:50</td>\n",
       "      <td>Successful</td>\n",
       "      <td>Withdrawal</td>\n",
       "      <td>FRI:3966792/MM</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>FRI:0723229267@044150149/BANK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-550000.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>./downloads/all_mtn_success\\3966792_2021-09-01...</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>435</th>\n",
       "      <td>327432497</td>\n",
       "      <td>YDFS327432497</td>\n",
       "      <td>2021-10-19 09:28:44</td>\n",
       "      <td>Successful</td>\n",
       "      <td>Withdrawal</td>\n",
       "      <td>FRI:3966792/MM</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>FRI:0723229267@044150149/BANK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-350000.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>./downloads/all_mtn_success\\3966792_2021-10-01...</td>\n",
       "      <td>19</td>\n",
       "      <td>10</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>763</th>\n",
       "      <td>322398774</td>\n",
       "      <td>YDFS322398774</td>\n",
       "      <td>2021-10-14 16:39:53</td>\n",
       "      <td>Successful</td>\n",
       "      <td>Withdrawal</td>\n",
       "      <td>FRI:3966792/MM</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>FRI:0723229267@044150149/BANK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-1150000.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>./downloads/all_mtn_success\\3966792_2021-10-01...</td>\n",
       "      <td>14</td>\n",
       "      <td>10</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1562</th>\n",
       "      <td>311399472</td>\n",
       "      <td>YDFS311399472</td>\n",
       "      <td>2021-10-03 21:41:26</td>\n",
       "      <td>Successful</td>\n",
       "      <td>Withdrawal</td>\n",
       "      <td>FRI:3966792/MM</td>\n",
       "      <td>KEDCO - Electricity</td>\n",
       "      <td>FRI:0723229267@044150149/BANK</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-860000.0</td>\n",
       "      <td>NGN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>./downloads/all_mtn_success\\3966792_2021-10-01...</td>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>167 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Id External Transaction Id                 Date      Status  \\\n",
       "2575  235271012           YDFS235271012  2021-07-22 15:36:45  Successful   \n",
       "4351  230132366           YDFS230132366  2021-07-17 12:21:12  Successful   \n",
       "5454  224762097           YDFS224762097  2021-07-12 09:25:53  Successful   \n",
       "6560  217904033           YDFS217904033  2021-07-04 09:33:55  Successful   \n",
       "600   274724794           YDFS274724794  2021-08-29 21:58:24  Successful   \n",
       "...         ...                     ...                  ...         ...   \n",
       "1149  282818257           YDFS282818257  2021-09-07 13:33:37  Successful   \n",
       "1605  278217340           YDFS278217340  2021-09-02 12:50:50  Successful   \n",
       "435   327432497           YDFS327432497  2021-10-19 09:28:44  Successful   \n",
       "763   322398774           YDFS322398774  2021-10-14 16:39:53  Successful   \n",
       "1562  311399472           YDFS311399472  2021-10-03 21:41:26  Successful   \n",
       "\n",
       "            Type            From            From Name  \\\n",
       "2575  Withdrawal  FRI:3823082/MM      Startimes Cable   \n",
       "4351  Withdrawal  FRI:3823082/MM      Startimes Cable   \n",
       "5454  Withdrawal  FRI:3823082/MM      Startimes Cable   \n",
       "6560  Withdrawal  FRI:3823082/MM      Startimes Cable   \n",
       "600   Withdrawal  FRI:3823082/MM      Startimes Cable   \n",
       "...          ...             ...                  ...   \n",
       "1149  Withdrawal  FRI:3966792/MM  KEDCO - Electricity   \n",
       "1605  Withdrawal  FRI:3966792/MM  KEDCO - Electricity   \n",
       "435   Withdrawal  FRI:3966792/MM  KEDCO - Electricity   \n",
       "763   Withdrawal  FRI:3966792/MM  KEDCO - Electricity   \n",
       "1562  Withdrawal  FRI:3966792/MM  KEDCO - Electricity   \n",
       "\n",
       "                                 To To Name To Handler Name     Amount  \\\n",
       "2575  FRI:0723229267@044150149/BANK     NaN             NaN -1840000.0   \n",
       "4351  FRI:0723229267@044150149/BANK     NaN             NaN -1320000.0   \n",
       "5454  FRI:0723229267@044150149/BANK     NaN             NaN -1100000.0   \n",
       "6560  FRI:0723229267@044150149/BANK     NaN             NaN -1350000.0   \n",
       "600   FRI:0723229267@044150149/BANK     NaN             NaN -1350000.0   \n",
       "...                             ...     ...             ...        ...   \n",
       "1149  FRI:0723229267@044150149/BANK     NaN             NaN  -645000.0   \n",
       "1605  FRI:0723229267@044150149/BANK     NaN             NaN  -550000.0   \n",
       "435   FRI:0723229267@044150149/BANK     NaN             NaN  -350000.0   \n",
       "763   FRI:0723229267@044150149/BANK     NaN             NaN -1150000.0   \n",
       "1562  FRI:0723229267@044150149/BANK     NaN             NaN  -860000.0   \n",
       "\n",
       "     Currency  Fee                                           filename  Day  \\\n",
       "2575      NGN  NaN  ./downloads/all_mtn_success\\3823082_2021-07-01...   22   \n",
       "4351      NGN  NaN  ./downloads/all_mtn_success\\3823082_2021-07-01...   17   \n",
       "5454      NGN  NaN  ./downloads/all_mtn_success\\3823082_2021-07-01...   12   \n",
       "6560      NGN  NaN  ./downloads/all_mtn_success\\3823082_2021-07-01...    4   \n",
       "600       NGN  NaN  ./downloads/all_mtn_success\\3823082_2021-08-01...   29   \n",
       "...       ...  ...                                                ...  ...   \n",
       "1149      NGN  NaN  ./downloads/all_mtn_success\\3966792_2021-09-01...    7   \n",
       "1605      NGN  NaN  ./downloads/all_mtn_success\\3966792_2021-09-01...    2   \n",
       "435       NGN  NaN  ./downloads/all_mtn_success\\3966792_2021-10-01...   19   \n",
       "763       NGN  NaN  ./downloads/all_mtn_success\\3966792_2021-10-01...   14   \n",
       "1562      NGN  NaN  ./downloads/all_mtn_success\\3966792_2021-10-01...    3   \n",
       "\n",
       "      Month  Debit  \n",
       "2575      7   True  \n",
       "4351      7   True  \n",
       "5454      7   True  \n",
       "6560      7   True  \n",
       "600       8   True  \n",
       "...     ...    ...  \n",
       "1149      9   True  \n",
       "1605      9   True  \n",
       "435      10   True  \n",
       "763      10   True  \n",
       "1562     10   True  \n",
       "\n",
       "[167 rows x 17 columns]"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merge_debit_data = merge_data.loc[merge_data['Debit'] == True]\n",
    "merge_debit_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "88aaeab6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "181175625.0"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merge_credit_data['Amount'].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "8ae43f81",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "-172798000.0"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merge_debit_data['Amount'].sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a9a975f9",
   "metadata": {},
   "source": [
    "### Analyse the daily Amount and fee trend"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "b879c3c1",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\BUYPOWER\\anaconda3\\lib\\site-packages\\pandas\\core\\frame.py:3191: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  self[k1] = value[k2]\n",
      "<ipython-input-29-f3e73af48fca>:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  merge_data['Amount'] = pd.to_numeric(merge_data['Amount'])\n",
      "<ipython-input-29-f3e73af48fca>:3: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  merge_data['Month'] = pd.to_datetime(merge_data['Month'])\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>Amount</th>\n",
       "      <th>Fee</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Day</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1604860.0</td>\n",
       "      <td>24587.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1661250.0</td>\n",
       "      <td>25257.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1583905.0</td>\n",
       "      <td>24709.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1608530.0</td>\n",
       "      <td>24933.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1273239.0</td>\n",
       "      <td>19703.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1773732.0</td>\n",
       "      <td>26921.68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2066235.0</td>\n",
       "      <td>33982.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>443888.0</td>\n",
       "      <td>6148.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2920610.0</td>\n",
       "      <td>47163.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2122660.0</td>\n",
       "      <td>35108.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1518843.0</td>\n",
       "      <td>23272.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1253852.0</td>\n",
       "      <td>19734.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1821785.0</td>\n",
       "      <td>27404.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1725530.0</td>\n",
       "      <td>25281.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1801565.0</td>\n",
       "      <td>26963.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2019285.0</td>\n",
       "      <td>32976.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1594640.0</td>\n",
       "      <td>24800.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1603899.0</td>\n",
       "      <td>23824.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1299239.0</td>\n",
       "      <td>19925.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1547328.0</td>\n",
       "      <td>24382.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1915780.0</td>\n",
       "      <td>30507.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1096477.0</td>\n",
       "      <td>16389.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1717521.0</td>\n",
       "      <td>28799.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1271682.0</td>\n",
       "      <td>19134.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1320472.0</td>\n",
       "      <td>19937.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1475690.0</td>\n",
       "      <td>21610.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1515975.0</td>\n",
       "      <td>23461.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1604534.0</td>\n",
       "      <td>23003.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1666825.0</td>\n",
       "      <td>27365.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>1640760.0</td>\n",
       "      <td>25139.39</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Amount       Fee\n",
       "Day                     \n",
       "1    1604860.0  24587.61\n",
       "2    1661250.0  25257.61\n",
       "3    1583905.0  24709.33\n",
       "4    1608530.0  24933.36\n",
       "5    1273239.0  19703.76\n",
       "6    1773732.0  26921.68\n",
       "7    2066235.0  33982.97\n",
       "8     443888.0   6148.59\n",
       "9    2920610.0  47163.48\n",
       "10   2122660.0  35108.64\n",
       "11   1518843.0  23272.08\n",
       "12   1253852.0  19734.82\n",
       "13   1821785.0  27404.55\n",
       "14   1725530.0  25281.90\n",
       "15   1801565.0  26963.51\n",
       "16   2019285.0  32976.33\n",
       "17   1594640.0  24800.45\n",
       "18   1603899.0  23824.55\n",
       "19   1299239.0  19925.62\n",
       "20   1547328.0  24382.34\n",
       "21   1915780.0  30507.04\n",
       "22   1096477.0  16389.98\n",
       "23   1717521.0  28799.23\n",
       "24   1271682.0  19134.16\n",
       "25   1320472.0  19937.22\n",
       "26   1475690.0  21610.65\n",
       "27   1515975.0  23461.28\n",
       "28   1604534.0  23003.90\n",
       "29   1666825.0  27365.57\n",
       "30   1640760.0  25139.39"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merge_data[['Id','Debit']] = merge_data[['Id','Debit']].astype('str')\n",
    "merge_data['Amount'] = pd.to_numeric(merge_data['Amount'])\n",
    "merge_data['Month'] = pd.to_datetime(merge_data['Month'])\n",
    "daily_vis = merge_data.groupby('Day').sum()\n",
    "daily_vis"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e21153b6",
   "metadata": {},
   "source": [
    "### Visualise your report"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "725a405d",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:xlabel='Day'>"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXUAAAESCAYAAAACDEUqAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAAAguklEQVR4nO3de5wU9Znv8c8zMDAotwhj5OoQA5pFdKIjUWNWiDEiJsc1XpbES27KyUVNzsYkbPI6iZvX7sbsySaIuhKzaCJRSEIiupHoGsULKiggV1EXDMooUTIacCJ3n/PH79dYNl3dPdDM9NR8369Xv+iqfubXT9ev6umqX1UX5u6IiEg21HR0AiIiUjkq6iIiGaKiLiKSISrqIiIZoqIuIpIhKuoiIhnSoUXdzG42s1fNbFWZ8ReY2dNmttrMbj/Q+YmIdDbWkdepm9nfAq3Are5+dInYkcCvgA+7++tmdqi7v9oeeYqIdBYduqfu7g8DryXnmdkRZnaPmS0xs0fM7Kj40mXADe7+evxbFXQRkTzVOKZ+E3CFux8PXAX8R5w/ChhlZo+a2UIzm9BhGYqIVKnuHZ1Akpn1Bk4Gfm1mudk947/dgZHAOGAo8IiZHe3uf2nnNEVEqlZVFXXCkcNf3L2xwGvNwEJ33wn80cyeJRT5J9sxPxGRqlZVwy/uvoVQsM8HsODY+PJcYHycP5AwHPN8R+QpIlKtOvqSxlnA48CRZtZsZp8HLgQ+b2bLgdXA2TH8XqDFzJ4G5gNfd/eWjshbRKRadegljSIiUllVNfwiIiL7R0VdRCRDOuzql4EDB3pDQ0NHvb2ISKe0ZMmSP7t7fdrrJYu6mdUBDxOuF+8OzHH37+bFGHAtMBF4E/iMuy8t1m5DQwOLFy8u/QlERGQPM3uh2Ovl7KlvJ9xvpdXMaoEFZvZ7d1+YiDmTcM34SOADwI3xXxERaUclx9Q9aI2TtfGRf8nM2YSbcnks9v3NbFBlUxURkVLKOlFqZt3MbBnwKnCfuy/KCxkCbEhMN8d5IiLSjso6Ueruu4FGM+sP3BHvuZK8B7oV+rP8GWY2GZgMMHz48LZnKyKd3s6dO2lubmbbtm0dnUpVq6urY+jQodTW1rbp79p09Yu7/8XMHgQmAMmi3gwMS0wPBV4u8Pc3Ee7CSFNTk371JNIFNTc306dPHxoaGkjcuE8S3J2Wlhaam5sZMWJEm/625PCLmdXHPXTMrBfwEeCZvLC7gEvivVpOBDa7+8Y2ZSIiXcK2bdsYMGCACnoRZsaAAQP26WimnD31QcDPzawb4UvgV+7+OzP7AoC7TwfmES5nXEu4pPGzbc5ERLoMFfTS9nUZlXP1ywp3f7+7H+PuR7v79+L86bGg566Q+bK7H+HuY9xdF6CLSFW74447MDOeeSZ/4KH9TJ06lTfffLOibVbb/dTlAGmYcvee5+uvOasDMxF5p+S6WQnlrt+zZs3ilFNOYfbs2Vx99dUVzaFcU6dO5aKLLuKggw6qWJu694uIdDmtra08+uijzJgxg9mzZwPw4IMPcuqpp3LBBRcwatQopkyZwm233cbYsWMZM2YM69atA+CFF17gtNNO45hjjuG0007jxRdfBOAzn/kMc+bM2fMevXv33tPuuHHjOO+88zjqqKO48MILcXemTZvGyy+/zPjx4xk/fnzFPpuKuoh0OXPnzmXChAmMGjWKQw45hKVLw11Nli9fzrXXXsvKlSuZOXMmzz33HE888QSXXnop1113HQCXX345l1xyCStWrODCCy/kyiuvLPl+Tz31FFOnTuXpp5/m+eef59FHH+XKK69k8ODBzJ8/n/nz51fss6moi0iXM2vWLCZNmgTApEmTmDVrFgAnnHACgwYNomfPnhxxxBF89KMfBWDMmDGsX78egMcff5xPfepTAFx88cUsWLCg5PuNHTuWoUOHUlNTQ2Nj4562DgSNqYtIl9LS0sIDDzzAqlWrMDN2796NmTFx4kR69uy5J66mpmbPdE1NDbt27SrYXu4qle7du/PWW28B4TrzHTt27IlJttutW7fUtipBe+oi0qXMmTOHSy65hBdeeIH169ezYcMGRowYUdYeN8DJJ5+8Zxz+tttu45RTTgHCnWeXLFkCwJ133snOnTtLttWnTx/eeOONffwkhamoi0iXMmvWLM4555x3zDv33HO5/fbby/r7adOmccstt3DMMccwc+ZMrr32WgAuu+wyHnroIcaOHcuiRYs4+OCDS7Y1efJkzjzzzIqeKO2w/6O0qanJdT/19qNLGqVarFmzhve9730dnUanUGhZmdkSd29K+xvtqYuIZIiKuohIhqioi4hkiIq6iEiGqKiLiGSIirqISIboF6Ui0uV069aNMWPG7JmeO3cuDQ0NHZdQBamoi0jHurpfhdvbXDKkV69eLFu2rLLvWyU0/CIiAixZsoRTTz2V448/njPOOIONG8P/yLlu3TomTJjA8ccfz4c+9KEO/U81yqGiLiJdztatW2lsbKSxsZFzzjmHnTt3csUVVzBnzhyWLFnC5z73Ob797W8D4af81113HUuWLOGHP/whX/rSlzo4++I0/CIiXU7+8MuqVatYtWoVp59+OgC7d+9m0KBBtLa28thjj3H++efvid2+fXt7p9smKuoi0uW5O6NHj+bxxx9/x/wtW7bQv3//TjX+ruEXEenyjjzySDZt2rSnqO/cuZPVq1fTt29fRowYwa9//WsgFP/ly5d3ZKolqaiLSJfXo0cP5syZwze/+U2OPfZYGhsbeeyxx4Bwz/QZM2Zw7LHHMnr0aO68884OzrY4Db+ISMcq4xLESmttbd1rXmNjIw8//PBe80eMGME999zTHmlVhPbURUQyREVdRCRDVNRFRDKkZFE3s2FmNt/M1pjZajP7SoGYcWa22cyWxcd3Dky6IpIFHfXfaHYm+7qMyjlRugv4mrsvNbM+wBIzu8/dn86Le8TdP7ZPWYhIl1FXV0dLSwsDBgzAzDo6nark7rS0tFBXV9fmvy1Z1N19I7AxPn/DzNYAQ4D8oi4iUtLQoUNpbm5m06ZNHZ1KVaurq2Po0KFt/rs2XdJoZg3A+4FFBV4+ycyWAy8DV7n76jZnIyKZV1tby4gRIzo6jcwqu6ibWW/gN8BX3X1L3stLgcPdvdXMJgJzgZEF2pgMTAYYPnz4vuYsIiIpyrr6xcxqCQX9Nnf/bf7r7r7F3Vvj83lArZkNLBB3k7s3uXtTfX39fqYuIiL5yrn6xYAZwBp3/1FKzGExDjMbG9ttqWSiIiJSWjnDLx8ELgZWmtmyOO9bwHAAd58OnAd80cx2AVuBSa5rlkRE2l05V78sAIped+Tu1wPXVyopERHZN/pFqYhIhqioi4hkiIq6iEiGqKiLiGSIirqISIaoqIuIZIiKuohIhqioi4hkiIq6iEiGqKiLiGSIirqISIaoqIuIZIiKuohIhqioi4hkiIq6iEiGqKiLiGSIirqISIaoqIuIZIiKuohIhqioi4hkiIq6iEiGqKiLiGRI945OQKpPw5S79zxff81ZHZiJiLSV9tRFRDJERV1EJENU1EVEMkRj6lVG49kisj9K7qmb2TAzm29ma8xstZl9pUCMmdk0M1trZivM7LgDk66IiBRTzp76LuBr7r7UzPoAS8zsPnd/OhFzJjAyPj4A3Bj/FRGRdlSyqLv7RmBjfP6Gma0BhgDJon42cKu7O7DQzPqb2aD4tyKdlobDpLNp04lSM2sA3g8syntpCLAhMd0c54mISDsqu6ibWW/gN8BX3X1L/ssF/sQLtDHZzBab2eJNmza1LVMRESmprKJuZrWEgn6bu/+2QEgzMCwxPRR4OT/I3W9y9yZ3b6qvr9+XfEVEpIhyrn4xYAawxt1/lBJ2F3BJvArmRGCzxtNFRNpfOVe/fBC4GFhpZsvivG8BwwHcfTowD5gIrAXeBD5b8UxFRKSkcq5+WUDhMfNkjANfrlRSIiKyb3SbABGRDNFtAkS6MF2Hnz3aUxcRyRAVdRGRDFFRFxHJEBV1EZEMUVEXEckQXf0iVUtXZoi0nfbURUQyRHvq0uXoCECyTHvqIiIZoj31dqA9QxFpL9pTFxHJEBV1EZEM0fCLZIKGuEQC7amLyAHRMOXud3zZSvtQURcRyRAVdRGRDNGYuojIAdTe53s6XVHXCTERkXQafhERqSL7e4JZRV1EJENU1EVEMqQqxtSrYZy8GnKQrkXrXOdVzX1XFUX9QKnmBS/ZlFvntL5JR9Hwi4hIhpQs6mZ2s5m9amarUl4fZ2abzWxZfHyn8mmKiEg5yhl++RlwPXBrkZhH3P1jFclIRPaLhh27tpJ76u7+MPBaO+QiIiL7qVInSk8ys+XAy8BV7r66Qu1KJ6CTg5IFWTnCqURRXwoc7u6tZjYRmAuMLBRoZpOByQDDhw+vwFuLiEjSfl/94u5b3L01Pp8H1JrZwJTYm9y9yd2b6uvr9/etRUQkz37vqZvZYcAr7u5mNpbwRdGy35mJiOynrAyptEXJom5ms4BxwEAzawa+C9QCuPt04Dzgi2a2C9gKTHJ3P2AZi4hIqpJF3d0/WeL16wmXPIqISAfTL0pFRDJERV1EJENU1EVEMkRFXUQkQ1TURUQyREVdRCRDVNRFRDJERV1EJEMy/d/ZiUj2dMWf/reFirpIJ6BCJuXS8IuISIaoqO+jhil3v2PvSUT2nbanylFRFxHJEI2pS7vS2LDIgaU9dRGRDFFRFxHJEBV1EZEMUVEXEckQFXURkQxRURcRyRAVdRGRDFFRFxHJEBV1EZEMUVEXEckQ3SZARMqiWzx0DtpTFxHJEBV1EZEMKVnUzexmM3vVzFalvG5mNs3M1prZCjM7rvJpiohIOcrZU/8ZMKHI62cCI+NjMnDj/qclIiL7omRRd/eHgdeKhJwN3OrBQqC/mQ2qVIIiIlK+SoypDwE2JKab4zwREWlnlSjqVmCeFww0m2xmi81s8aZNmyrw1iIiklSJot4MDEtMDwVeLhTo7je5e5O7N9XX11fgrUVEJKkSRf0u4JJ4FcyJwGZ331iBdkVEpI1K/qLUzGYB44CBZtYMfBeoBXD36cA8YCKwFngT+OyBSlZERIorWdTd/ZMlXnfgyxXLSERE9pl+USoikiEq6iIiGaKiLiKSISrqIiIZoqIuIpIhKuoiIhmioi4ikiEq6iIiGaKiLiKSISrqIiIZoqIuIpIhKuoiIhmioi4ikiEq6iIiGaKiLiKSISrqIiIZoqIuIpIhKuoiIhmioi4ikiEq6iIiGaKiLiKSISrqIiIZoqIuIpIhKuoiIhmioi4ikiEq6iIiGVJWUTezCWb2rJmtNbMpBV4fZ2abzWxZfHyn8qmKiEgp3UsFmFk34AbgdKAZeNLM7nL3p/NCH3H3jx2AHEVEpEzl7KmPBda6+/PuvgOYDZx9YNMSEZF9UU5RHwJsSEw3x3n5TjKz5Wb2ezMbXZHsRESkTUoOvwBWYJ7nTS8FDnf3VjObCMwFRu7VkNlkYDLA8OHD25apiIiUVM6eejMwLDE9FHg5GeDuW9y9NT6fB9Sa2cD8htz9Jndvcvem+vr6/UhbREQKKaeoPwmMNLMRZtYDmATclQwws8PMzOLzsbHdlkonKyIixZUcfnH3XWZ2OXAv0A242d1Xm9kX4uvTgfOAL5rZLmArMMnd84doRETkACtnTD03pDIvb970xPPrgesrm5qU0jDl7j3P119zVgdmIiLVQr8oFRHJEBV1EZEMUVEXEckQFXURkQxRURcRyRAVdRGRDFFRFxHJEBV1EZEMUVEXEckQFXURkQxRURcRyRAVdRGRDFFRFxHJEBV1EZEMUVEXEckQFXURkQxRURcRyRAVdRGRDFFRFxHJEBV1EZEMUVEXEckQFXURkQxRURcRyRAVdRGRDFFRFxHJEBV1EZEMUVEXEcmQsoq6mU0ws2fNbK2ZTSnwupnZtPj6CjM7rvKpSsVc3e/th4hkSvdSAWbWDbgBOB1oBp40s7vc/elE2JnAyPj4AHBj/Ff2R7LoXr256+ZQLbK+LLL++bqIkkUdGAusdffnAcxsNnA2kCzqZwO3ursDC82sv5kNcveNbc6oLStWZ4tNxmdxozmQy2JfYsuJP1CFrDMui7bojNtTNeTcDutmOUV9CLAhMd3M3nvhhWKGAG0v6rJvtJclIoCFnesiAWbnA2e4+6Vx+mJgrLtfkYi5G/i+uy+I0/cD33D3JXltTQYmx8kjgWcLvOVA4M9l5t/ZYqslj2qIrZY8qiG2WvLobLHVkkd7xx7u7vWpf+XuRR/AScC9iel/BP4xL+YnwCcT088Cg0q1nfJ+i7MaWy15VENsteRRDbHVkkdni62WPKohNvko5+qXJ4GRZjbCzHoAk4C78mLuAi6JV8GcCGz2fRlPFxGR/VJyTN3dd5nZ5cC9QDfgZndfbWZfiK9PB+YBE4G1wJvAZw9cyiIikqacE6W4+zxC4U7Om5547sCXK5TTTRmOrZY8qiG2WvKohthqyaOzxVZLHtUQu0fJE6UiItJ5lLWn3h7MzAjDO+buO8uI707IvwbY5u5vlRm73d13l9F+L+Atd99eRru5vFtLtFkL9AQM+GtazvntxpwLLpO43HrG2J3uvqNEDrn4vZZbWh+Y2QCgLsa3pMWaWR3QP/7Zq7m2U2J7A71jHlvd/fVieZhZH+CgOH+Hu/+5WM6J9+jv7s1F2j0I6BPn1wB/dvdtRZZFL8JVCQCt7v56Srv9E/3SPfbNxpTYmthmd8I696ci+RpQH2O3uftridwKbhNmdijQC3jT3TelxcbPNgBwYGPeulEovl9cdjWE9bmlRGzv+Hm2ufurxXKOr/UFDnH39UXa7Q30Tcx/xd23FlkWBwOHErarze7ekhe71d09rvP5/ddcJI8a4N1ALbDb3V8qM3ZrSp/scPddaf1X1L6cXa30I36IO4HNwB9y84rEvx9YDKwmnMi9rEjscMIPpZYCS4CryshnGPAScEuctgIxg2O+TwIrgTtKtPle4A/Ac8DDwKiUuFNizKL4+TYDE1NiDwK+DzwDLAOmF8o1Ed8L+BfC1UmLgEuL9UGcf0xcdiuB3wL98mLvj3F1wBfictsCNBRoNxfbH7gFWBHzuI1QfNPi+wHTYv8tAuYQfgeRut7EfG4nbDRp7fYFfgr8CXgcuAc4vsiy6AP8OK5PjwJfTWl3IPC72OZC4BXgvpTY7sDfxf57ArifcMVZObG/APqkbBOTE/OXAstj/72rQOznY+wXCb8x2dN/KW1/Ni7fn8dcHo/L+pACsZ8DegDXxfkLY/8NKxB7WeI964DZif5La/fm2H+PEoaIjyuyLPoD1wKrgEeAr+TFLo6frXfsv8fiZ3sFuC+2cVxe25fG+ecCT8XPdz9hO87Po1DsLwjrYbJOLQW+ntZ/JetXRxf0XNEETgTGA4+nFdJE/FDgfXlF+7AibfeIz98VF/IRJQrfP8WF/bMiRX0IsKbMz9cf+BWJ4gwcXMbfHQY8D3RLef2EXA5xI5gLfKJIe6cDi+LzAcDvgSEF+mBhYnnNAM6L098E/j2lv3rEvjiKsHG9p0jf9gJOTOR1DeF3DmnxNcllAHydcCuK1PWGUBjnEzbKbimxfYF/BS4oY32sBT4N/CIR17NQbIHlfiPwyZRlfBiwABiZ2OAfSIkdQvhyPTROfxr4Qco2sQIYTSh6n0gstx8XiF0NNMT2RwF35/ovpe1VwBHACYmY78d+LLRtDiWxDcU8pqfE5tbHDxKKY67/8mNXEta1fwHOL1EfVgOHx+V1ayKuR0oOgwv0398XaPtwwpfacXl9+AnCulco9oS4/AbG+RcD/4+969TC2P8zgHOT/VeqPlbFXRo9WAj8ldCBpeKb3X1NnHyDUPgKXowf294Rhz4GA9uBYkMURxH21m4BDi4StwuoNbODzax3vEdOmnrgaHefZ2Z9zazO3f9aJD53z50zgNWePly0C6iJwx65Pde1RZodRlhZALYSVrJzIbUP6ggb12/i9FzCF5MT9piTsbvc/UXgVULRtiLtbovzcp/zeeKyTol34C0z62dmRxH68blCse7u8XD1a4ST9wMJG0AyNjfs+FZ8/h4zOzQecidzaE3E9iVsrD82s8FmNtjdtxfKIV7aa/F5A/BxwpFcoc+2g/ADkyYzG0H4Ud78lFgD3u1x6IJwRHdWfP5SYptoJawHhxMKwx1x/p3AmR6GEZ6J894A/ggM8DBk0EI4AjRyC3/v7W090M/dn4wftVuc1ytl2zw09ssAMzuat3eI8mP/CAwws4Gx/y5P9F/aNt8NGBX7pD4l3+cI96U6B5hmZoeb2TB335HS7mG5z57ov7kF2t4Sc34X4dfzJ5rZSOBvCHv2+W2vi20P8Dh8GOfltqmdiTq1NfbByYQ99D39RwlVUdQTdtH2nI4GRrj7yrSAOL65BngQ+J27b0iJ6wt8i1AMehE2+jTbCEXvAeC/KX4Z5yDgTTP7Wczh3+P4ZTF1hMtEZxaJWUk4ongdeAjY4O4risQ/A3w4vvcgYAJ7fxkm+8AJY5oep18jHGIXis3JLbP8+Wl9eyjwKcKhdsH4+P49gO8Qji6OJ/zgba/Y+FuKjxOW83OEgrArL9YSz3cQ9pbuBP7NzAYlYnfzzmVxBOFLcA4ww8xOS/t8sYjl9rZX+Nvj9O/IwcOY+L8SjoDuJfwOZEZKvq3ACjM718yGAH9PKCj5RgMjCF/g9Yn+e71A/GjC9pP79XduByJtO8xtb0vNrCa2/W4K9+HoRGwd4YeLdxL2bH9aIHZ4XH/PJQxX/Q+Ey6oL5PAewpDLbsJymAP8wMwGp8QuJByFnEvYZn5iZh9Nyxf2nL84CVju7tsT/ZeMH+Xu9xP67xrgv4ALgFsLxL6XcPSxyswuMLPhMff+MaYfoU49RBj+WU3Yoy/Wf3srtPveUQ/i+K2XOLxIxOcOaU4us/1DCOPaaePZFxAOTw04n/Cjqu5F2ssdQg0mjHudkBJ3GuEIoSFOXwt8r0SuhxHG8oq9/3DeHuvrQdgj+1SR+BrCuPdThC+ia4F/LtIHhxBOeOZeexfwp1z/FOovwrjzg8TDzmJ9Sxi7/AnxkLLcdQG4AvhRSuwwwpddf2AM8CJhz6mmQGwN0DfRzv8Fbk9pty/hXMS34nQT4Uu02OerA34JTCry2Q4mFICmOP1x4IlCsXF6JGHs/37gG8ALee95OGH89QRCkSjWf3ttP2n9l7a9xfifAj8sd9sk7IFPzYtdTrin1GBCMRsANMb+OybRf7l2T8r1S6KdbwOzC7Q7lnD08Szx1/CEL5bmEp+tjjBsekHKssjl3JPwRXFcfO0sEr8GzW+bUNznEb64rirQhwNiH59MOPFbsP9St/NihaW9H8D7kitwidh+hL3k1CJW4G+6Af8MfCHl9R/FlWgd8DLh8OqGMtqtie1OTnn9COB/EtOnA3OLtGfAhcBvSrzvRcCNiRwuTW4sZeQ9NX/5xT54Kj4/mFAg6+P0McCTxforLuP7SYzJFoolDGt8A/hlW9cFwl7PysT03/B2kWwiHEKviY8dhJOKfctsd1leu7llUUfYCxubmH4eqCuyLAYQTuLVFVnGfYAtidf6AH8pczmcCPy+wDZxYZw+iDC2nhuDP5b4hZEfm7cu/4Gwx1p0e4t9OIXEF2Gxtgv1X4Gcjyfsoa+Oj+2EcfU+Zba7LKXdOsJO2l79V2RZDIz917PY5yvWh2XkfDJwd9687sD3CEc2SwlDbu/ov2KPqrmkMeoG9IjjSuYpl+fF12cQTnr+Kl4u9aYXuOwvjrM54SqCQ4FxhBMOe3H3fwD+If7dOOAr7l7wR1XxUriehEPiwwh7419J+VwbgJfM7EjC2NsZhDHpNN0JRwrFhl4AXgC+kcjldELhSRWHF14jFKxxhD2FpG6EcwXdCMvtDuByM7uJMMQ0My821181hKGXwYQV+Sgz2+HxMrBEbO6yrU8SjhpOieOWW939lQJt5+JHx89bRzjU/0MitiaRxzJ3f0/i877o7mOLtDs8Lo86wjDMfXnt1sZYI4xtnmtm6wlfHi3uvq3AssituxMJG+E23im5jA141sz+F+EKibMIh99p+b6bMPTXh7dPfOa2if8kbBO/jEOJO2LOV5rZfxKuGLk1L3Z2bvuJuQwjHKEdbWbu7usLtN2PMOb7aeB/A39rZu+NbWwq0PY2QkF6kTCseRFwb0oeT7n7yET/bXD3k2Ls7XmxWwl7va/Fdj8N3JPS7jbCuaHzzewlwp76JsLwTX7sXz0M+ZxFOEm9PZFP/rLoQ9hO1pjZOYQrtM4EHkjJYyvhnMIOwtHfVYTzNPWE7WcLYUh0POHIsQdwRbL/KKVU1W+vB+Ew5yXePllxUZHYcYSxxicI32SLgPEpsY2E4Ybc48oy8xkPzCry+kjCXtBSwqHVl0u0dyxho10aO6ZHkdh+cVnUlpHn1YQz9suA60rE1hDGIVfFZXZciT64kFA87oqf9RfEq1AKxF5MOBH1R0LxfYZ4KJwXuw74TMwhd4nbAuDfUvJYR9hYZxM2mIWEDaVXqfWG8EW3gHBSL63dWxJ5/JS4V5ayLIwwXLSY8KVyVInYG4lXLhRbzwmXrS2IOdwNDE3J92LC0NMq8tZlCm8THyYMcd0R42+N60Ch2I/E/lsXH08T98ALxC8k7JjkLkl9jHCZ7g9SYj8KzCKs/48RfinZs0gelui/hwjbQ1q7N8d5j8W+6VFkWeT6ZBFh+HFUidgbgHPKqD2nEbbvh2MedxF2bgrlfDph+GklYT26PFGnlvF2nboizu+b33+laoJ+USoikiHVdvWLiIjsBxV1EZEMUVEXEckQFXURkQxRURcRyZBqu05d5IAzs92ES8pqCZec/Zzwo61it4UQ6RRU1KUr2urujbDnXtW3E66F/m5HJiVSCRp+kS7Nwx0PJxN+NWtm1mBmj5jZ0vg4GcDMZprZ2bm/M7Pb4q9ARaqKfnwkXY6Ztbp777x5rxNuu/wG4X8f2hZvozrL3ZvM7FTg/7j738Wfey8j3D87/w6CIh1Kwy8iQe62qrXA9WbWSLgvyCgAd3/IzG6IwzWfINxsTQVdqo6KunR5ZvYeQgF/lTCu/grhXh41hBtB5cwk3NdlEuHmSiJVR0VdurR4d7zpwPXu7nFopdnDfxD8ad75P3H9jHBzpj+5++r2z1akNBV16Yp6mdky3r6kcSbhXvoA/wH8xszOJ/w/k3v+20F3f8XM1hD/azORaqQTpSJlivetX0m4ZfHmjs5HpBBd0ihSBjP7COEe8depoEs10566iEiGaE9dRCRDVNRFRDJERV1EJENU1EVEMkRFXUQkQ1TURUQy5P8DC8+W4acG6fAAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "\n",
    "daily_vis.plot.bar(rot=1, fig= 9)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "f3d4178d",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-11-bc0fc528eadf>:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  merge_data['Day'] = pd.to_datetime(merge_data['Day'])\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>Fee</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>To Name</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>AEDC</th>\n",
       "      <td>49467.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EEDC</th>\n",
       "      <td>231896.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EKEDC</th>\n",
       "      <td>17047.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IBEDC</th>\n",
       "      <td>13991.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IKEDC</th>\n",
       "      <td>23876.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>JED</th>\n",
       "      <td>163100.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KAEDCO</th>\n",
       "      <td>33762.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>KEDCO - Electricity</th>\n",
       "      <td>38965.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PHEDC</th>\n",
       "      <td>58410.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Startimes</th>\n",
       "      <td>121913.01</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           Fee\n",
       "To Name                       \n",
       "AEDC                  49467.70\n",
       "EEDC                 231896.04\n",
       "EKEDC                 17047.90\n",
       "IBEDC                 13991.60\n",
       "IKEDC                 23876.60\n",
       "JED                  163100.64\n",
       "KAEDCO                33762.00\n",
       "KEDCO - Electricity   38965.96\n",
       "PHEDC                 58410.15\n",
       "Startimes            121913.01"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merge_data['Day'] = pd.to_datetime(merge_data['Day'])\n",
    "sp_vis = merge_data.groupby('To Name').sum()\n",
    "sp_vis"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "5cd7e27a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:xlabel='To Name'>"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZIAAAEVCAYAAADKN2OaAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAAAqZUlEQVR4nO3de5xVdb3/8ddbIPEuIt7ABNPMOwWp55RpWUpZP7OjiZVSaZSZ1ely1CztaJaWpUdPUhYeL5mldMGyVMTKVFLBCxcDwfsoAgIimhCXz++Pz3czm80wDLOGZsD38/GYx8x891prf/e6fD/f21pbEYGZmVl7bdTZGTAzs/WbA4mZmVXiQGJmZpU4kJiZWSUOJGZmVokDiZmZVdK9szPQ0bbddtvo379/Z2fDzGy9MmHChBciok971t3gAkn//v0ZP358Z2fDzGy9Iump9q7rri0zM6vEgcTMzCpxIDEzs0o2uDESM7OOtGTJEpqamli0aFFnZ6VD9OzZk379+tGjR48O26YDiZlZK5qamthiiy3o378/kjo7O5VEBHPnzqWpqYkBAwZ02HbdtWVm1opFixbRu3fv9T6IAEiid+/eHd66ciAxM1uDDSGI1KyLz+KuLTOzLq5bt27su+++K/7/7W9/S1e68dqBpJP0P+Pmytt48oIjOyAnZrY2OuLardeW63iTTTbhoYce6tD37Uju2jIzWw9NmDCBQw45hEGDBnHEEUcwc+ZMAB577DGGDBnCoEGDOPjgg5k6deo6z4sDiZlZF/fqq68ycOBABg4cyNFHH82SJUs47bTTGDVqFBMmTOCTn/wkZ511FgDDhw/nsssuY8KECVx00UV89rOfXef5c9eWmVkX19i1NXnyZCZPnsx73vMeAJYtW8aOO+7Iyy+/zD333MOxxx67YtnFixev8/w5kJiZrWcigr333ptx48atlP7SSy+x9dZb/8vHU9y1ZWa2ntljjz2YM2fOikCyZMkSpkyZwpZbbsmAAQO48cYbgQw4Dz/88DrPjwOJmdl65nWvex2jRo3i9NNPZ//992fgwIHcc889AFx33XWMHDmS/fffn7333pvRo0ev8/y4a8vMbC10xrT7l19+eZW0gQMHcuedd66SPmDAAG655ZZ/RbZWcIvEzMwqcSAxM7NKHEjMzKwSBxIzszWIiM7OQodZF5/FgcTMrBU9e/Zk7ty5G0QwqX0fSc+ePTt0u561ZWbWin79+tHU1MScOXM6OysdovYNiR3JgcTMrBU9evTo0G8T3BC5a8vMzCpxIDEzs0ocSMzMrBIHEjMzq8SBxMzMKnEgMTOzShxIzMysEgcSMzOrxIHEzMwqcSAxM7NK1hhIJO0s6U+S/i5piqQvlPRtJI2RNL387lW3zpmSZkiaJumIuvRBkiaV1y6VpJK+saRflvR7JfWvW2dYeY/pkoZ16Kc3M7PK2tIiWQp8OSL2BA4CTpW0F3AGMDYidgfGlv8prw0F9gaGAJdL6la2NQIYDuxefoaU9JOA+RGxG3AxcGHZ1jbAOcCBwAHAOfUBy8zMOt8aA0lEzIyIB8rfC4G/A32Bo4Cry2JXAx8sfx8F/CIiFkfEE8AM4ABJOwJbRsS4yOcxX9OwTm1bo4DDSmvlCGBMRMyLiPnAGJqDj5mZdQFrNUZSupzeDNwLbB8RMyGDDbBdWawv8Ezdak0lrW/5uzF9pXUiYimwAOjdyrYa8zVc0nhJ4zeURz2bma0v2hxIJG0O/Ar4YkS81NqiLaRFK+ntXac5IeKKiBgcEYP79OnTStbMzKyjtSmQSOpBBpHrIuLXJXlW6a6i/J5d0puAnetW7wc8V9L7tZC+0jqSugNbAfNa2ZaZmXURbZm1JWAk8PeI+EHdSzcBtVlUw4DRdelDy0ysAeSg+n2l+2uhpIPKNk9sWKe2rWOAO8o4yq3A4ZJ6lUH2w0uamZl1EW35hsS3AScAkyQ9VNK+BlwA3CDpJOBp4FiAiJgi6QbgEXLG16kRsaysdwpwFbAJ8MfyAxmorpU0g2yJDC3bmifpPOD+sty5ETGvfR/VzMzWhTUGkoi4i5bHKgAOW8065wPnt5A+HtinhfRFlEDUwmtXAleuKZ9mZtY5fGe7mZlV4kBiZmaVOJCYmVklDiRmZlaJA4mZmVXiQGJmZpU4kJiZWSUOJGZmVokDiZmZVeJAYmZmlTiQmJlZJQ4kZmZWiQOJmZlV4kBiZmaVOJCYmVklDiRmZlaJA4mZmVXiQGJmZpU4kJiZWSUOJGZmVokDiZmZVeJAYmZmlTiQmJlZJQ4kZmZWiQOJmZlV4kBiZmaVOJCYmVkl3Ts7A2bWrP8ZN1fexpMXHNkBOTFrO7dIzMysEgcSMzOrxIHEzMwqcSAxM7NKHEjMzKwSBxIzM6vEgcTMzCpxIDEzs0rWGEgkXSlptqTJdWnflPSspIfKz/vqXjtT0gxJ0yQdUZc+SNKk8tqlklTSN5b0y5J+r6T+desMkzS9/AzrsE9tZmYdpi0tkquAIS2kXxwRA8vPHwAk7QUMBfYu61wuqVtZfgQwHNi9/NS2eRIwPyJ2Ay4GLizb2gY4BzgQOAA4R1Kvtf6EZma2Tq0xkETEncC8Nm7vKOAXEbE4Ip4AZgAHSNoR2DIixkVEANcAH6xb5+ry9yjgsNJaOQIYExHzImI+MIaWA5qZmXWiKmMkn5M0sXR91VoKfYFn6pZpKml9y9+N6SutExFLgQVA71a2tQpJwyWNlzR+zpw5FT6SmZmtrfYGkhHAG4CBwEzg+yVdLSwbraS3d52VEyOuiIjBETG4T58+rWTbzMw6WrsCSUTMiohlEbEc+Ak5hgHZati5btF+wHMlvV8L6SutI6k7sBXZlba6bZmZWRfSrkBSxjxqjgZqM7puAoaWmVgDyEH1+yJiJrBQ0kFl/ONEYHTdOrUZWccAd5RxlFuBwyX1Kl1nh5c0MzPrQtb4fSSSrgcOBbaV1ETOpDpU0kCyq+lJ4NMAETFF0g3AI8BS4NSIWFY2dQo5A2wT4I/lB2AkcK2kGWRLZGjZ1jxJ5wH3l+XOjYi2Dvqbmdm/yBoDSUQc30LyyFaWPx84v4X08cA+LaQvAo5dzbauBK5cUx7NzKzz+M52MzOrxIHEzMwqcSAxM7NKHEjMzKwSBxIzM6vEgcTMzCpxIDEzs0ocSMzMrBIHEjMzq8SBxMzMKnEgMTOzShxIzMysEgcSMzOrxIHEzMwqcSAxM7NKHEjMzKwSBxIzM6vEgcTMzCpxIDEzs0rW+J3tZmbWufqfcXPlbTx5wZEdkJOWuUViZmaVOJCYmVklDiRmZlaJA4mZmVXiQGJmZpU4kJiZWSUOJGZmVokDiZmZVeJAYmZmlTiQmJlZJQ4kZmZWiQOJmZlV4kBiZmaVOJCYmVklDiRmZlbJGgOJpCslzZY0uS5tG0ljJE0vv3vVvXampBmSpkk6oi59kKRJ5bVLJamkbyzplyX9Xkn969YZVt5juqRhHfapzcysw7SlRXIVMKQh7QxgbETsDowt/yNpL2AosHdZ53JJ3co6I4DhwO7lp7bNk4D5EbEbcDFwYdnWNsA5wIHAAcA59QHLzMy6hjUGkoi4E5jXkHwUcHX5+2rgg3Xpv4iIxRHxBDADOEDSjsCWETEuIgK4pmGd2rZGAYeV1soRwJiImBcR84ExrBrQzMysk7V3jGT7iJgJUH5vV9L7As/ULddU0vqWvxvTV1onIpYCC4DerWzLzMy6kI4ebFcLadFKenvXWflNpeGSxksaP2fOnDZl1MzMOkZ7A8ms0l1F+T27pDcBO9ct1w94rqT3ayF9pXUkdQe2IrvSVretVUTEFRExOCIG9+nTp50fyczM2qO9geQmoDaLahgwui59aJmJNYAcVL+vdH8tlHRQGf84sWGd2raOAe4o4yi3AodL6lUG2Q8vaWZm1oV0X9MCkq4HDgW2ldREzqS6ALhB0knA08CxABExRdINwCPAUuDUiFhWNnUKOQNsE+CP5QdgJHCtpBlkS2Ro2dY8SecB95flzo2IxkF/MzPrZGsMJBFx/GpeOmw1y58PnN9C+nhgnxbSF1ECUQuvXQlcuaY8mplZ5/Gd7WZmVokDiZmZVeJAYmZmlTiQmJlZJQ4kZmZWiQOJmZlV4kBiZmaVOJCYmVklDiRmZlaJA4mZmVXiQGJmZpU4kJiZWSUOJGZmVokDiZmZVeJAYmZmlTiQmJlZJQ4kZmZWiQOJmZlV4kBiZmaVOJCYmVklDiRmZlaJA4mZmVXiQGJmZpU4kJiZWSUOJGZmVokDiZmZVeJAYmZmlTiQmJlZJQ4kZmZWiQOJmZlV4kBiZmaVOJCYmVkl3Ts7A2ZmXVn/M26utP6TFxzZQTnputwiMTOzShxIzMysEgcSMzOrpFIgkfSkpEmSHpI0vqRtI2mMpOnld6+65c+UNEPSNElH1KUPKtuZIelSSSrpG0v6ZUm/V1L/Kvk1M7OO1xEtkndGxMCIGFz+PwMYGxG7A2PL/0jaCxgK7A0MAS6X1K2sMwIYDuxefoaU9JOA+RGxG3AxcGEH5NfMzDrQuujaOgq4uvx9NfDBuvRfRMTiiHgCmAEcIGlHYMuIGBcRAVzTsE5tW6OAw2qtFTMz6xqqBpIAbpM0QdLwkrZ9RMwEKL+3K+l9gWfq1m0qaX3L343pK60TEUuBBUDvxkxIGi5pvKTxc+bMqfiRzMxsbVS9j+RtEfGcpO2AMZKmtrJsSy2JaCW9tXVWToi4ArgCYPDgwau83qjqvHB4bcwNNzNri0otkoh4rvyeDfwGOACYVbqrKL9nl8WbgJ3rVu8HPFfS+7WQvtI6kroDWwHzquTZzMw6VrsDiaTNJG1R+xs4HJgM3AQMK4sNA0aXv28ChpaZWAPIQfX7SvfXQkkHlfGPExvWqW3rGOCOMo5iZmZdRJWure2B35Sx7+7AzyPiFkn3AzdIOgl4GjgWICKmSLoBeARYCpwaEcvKtk4BrgI2Af5YfgBGAtdKmkG2RIZWyK+Zma0D7Q4kEfE4sH8L6XOBw1azzvnA+S2kjwf2aSF9ESUQmZlZ1+Q7283MrBIHEjMzq8SBxMzMKnEgMTOzSvzFVmbWJfnG4fWHWyRmZlaJA4mZmVXiQGJmZpU4kJiZWSUebDezVVQd6PYg92uLWyRmZlaJA4mZmVXiQGJmZpU4kJiZWSUOJGZmVokDiZmZVeJAYmZmlTiQmJlZJb4h0azwTXhm7eMWiZmZVeJAYmZmlTiQmJlZJQ4kZmZWiQOJmZlV4llbr3H+Xmwzq8otEjMzq8SBxMzMKnHXlnU6d6+Zrd/cIjEzs0ocSMzMrBIHEjMzq8SBxMzMKnEgMTOzShxIzMysEgcSMzOrxIHEzMwqWS8CiaQhkqZJmiHpjM7Oj5mZNevygURSN+CHwHuBvYDjJe3VubkyM7OaLh9IgAOAGRHxeET8E/gFcFQn58nMzApFRGfnoVWSjgGGRMTJ5f8TgAMj4nN1ywwHhpd/9wCmVXzbbYEXKm6jI3SFfHSFPEDXyEdXyAN0jXx0hTxA18hHV8gDVM/HLhHRpz0rrg8PbVQLaStFv4i4Ariiw95QGh8Rgztqe+tzPrpCHrpKPrpCHrpKPrpCHrpKPrpCHjo7H+tD11YTsHPd//2A5zopL2Zm1mB9CCT3A7tLGiDpdcBQ4KZOzpOZmRVdvmsrIpZK+hxwK9ANuDIipqzjt+2wbrKKukI+ukIeoGvkoyvkAbpGPrpCHqBr5KMr5AE6MR9dfrDdzMy6tvWha8vMzLowBxLb4EjaVdJBkrb8F7+vGv4fIOkN5abadfm+m67L7VvHUdHZ+ehoXX6MpKuRtB9wHLA3uf9+EBF3dEI+NgPeQ96wuTtwO3BdRLz8r85LXZ4GAYcD+wCvAhdGxPR19F7dImJZ+VsREZK+BRwD/IOc7Xcx8Kd18f4tKXnYDfge8CZgEfAX4H+BGVW2XQqfXhExr9xLdTjQF9gJmCDpR8C4iFha5X3WNUkHACcC+5GzL78ZEVM7N1cdo+483AlYEBGvSNooIpbXLfY64ARJ7yCv278BF0TErM7Ic0skbQTQkO9WOZA0kNSbPMBvIe9XGRURc8pr/YBTgIXAj4FlQEjqFRHz10FetgH2BHYF/hYR02snK1lgHkcWVDeS99vsBjzU0fmoy09P4A1kIfAScGut4JL0JuA/gbnA74DNgO0kPbY2J2QL77lpRPxD0iHACcA2wBuBiZJ+AtwdEf+UdCp53AZHxMulNbJNCxdye/PRndzHHwDeSR6T7YAbyHPkibJ/TgEejoijy3oD2vFeewJzgA8DRwKbAjuST3X4JrkfngU+DTwOfBy4BPgW8Jt2fsQOI2l74HjyGtqZzPe1wMbAp4BZwBfIStClki6KiNs6KbvtUgK7gI3KhKBLgLGSbgVOB54rLcW7JY2tVXqA04APAT8DLiLP5e3JfdIZn4FoGCivv14kbd6WyulrNpBI2oUseAeVpB+SJ/+lwG3kgRXwTknXRMTvgY8AO0VEhz6iRdLOZA12b+DPZGH8f2Sh/QjwIvCBcsPRdyUNJqdBnx0R95dtqPGEqJCf3jTvm/kRcb2k7wJfJPfNy2S36OGSLo+IacDny7JfqNvOWhXipbB+X/lsW5AX2W3kxTeErIUfDiwgC/NzgeuAH5EB9y8liPSIiJfIYNeW912RT0lbkLMDPwwcCOxAHpuvA7cAJ5fP/w3gFeBLwBWSjiaP334l/7XtPrEWn7+Wj2vLz2BgNhmgX65rbUwB5ta19kaW8/k4/gWBRNLGZNDej2wV3VTOgZqPl9duAp4h92FP4BPAJhHx9bLcg5J2JJ+f96eIWLKu894ekjYny4aHatcbsBX57L89JL0NGE3OLB1NnpsvAn8nz4WXJH2G3BdDgeURcXm5ZieuozzXAp3qgthKr9fKi3JbxdbkObVM0vHAZ8lje5WkH6wpmLwmAomktwM7R8T15f9vAP8NXEMWCneWZuhLwNiI+GDdul8DzpJ0C/kIgttKeo+1OfHLxTeAvMB2IGvt2wM/B+YBTwNPkV1CPYFHySbv7WX9jwKfknQbsDkZ0O4vteB/Vqz1H0oWWtcBZ5M13lvIrpnaPTsvAb+OiFoh2Rc4H/iKpNPIWvNV5bUeEbGkMU+17qjSPXgC0IcMALcDF5TPfgR50+kngRcjovbIhwnAQXXdID+X9A/gXEnXl336c4DacVldIGvIxw4RcZukXmQr8wFgLFlzvgW4DGiKiBdKoXc38ExEPFC29d/AV4HPATcDu0bE3Iaut7VtFY0lz5W7gM0i4sWynR0jYibZ6vyP+n0N/BV4q6SdIqJDbtgt++RNZIG5J3l8BVwN9CDv8ZoPXFwCwfckvRc4FPhURDSV7dS6fPoAM0vaphHxD/LYf6Zsf50UqmtSunK2AZZGxIv1xw6gVE4eBgZKWkZWZH5NlgePkufETsD15f9dgaXAGcAu5PlxMdkK2wy4q9Z9RMNTOtYizyKPwfLSIjqZ7Cm5IYrGbUvamiw7ni3HY1/gHLIC9DAZNO4hu6Yvi4gb6t6rVRt8ICk1zK8B+0uaVgqAx8juiI83LD4FGFA7SJEPibyCrJ3uRxaWC6G5sGpjHvqStZHfA4uB8WSNpTcwFXh/Q3NyO7K2269uMzeQF/QxZBB6qeRj0RreuzGAjSZr+scDp5In4xfIC3oB2W99YUSc17CpCWU/IGmTiHhW0g/JJnov8kJ8peRplX1TaszXAW8nx3aGk9023cgnO58ZEV+T9CAwLyJmlPVqTeuHyudHUvdSO/8reTFvSnabbFr3flpNENml5PlgMmi9h6wcfAbYNCIukPRGMqBcEhFza+9JthRfJQvXmufJ43kMMJK8UGkoiNoaRGoX/kNkt9VNwO8kvZs8hn+X9HFgEnnMILtXIc+j3ciK0VqRtBXlGXURsaCkDQW+X7b7KDnG8xxZMN4JXFMXTIcBHy6Vra2AjSOiqb6SU7p5XiCPF2QlBbLy1Jt2FqjtUa7vjcheneUlTyeUl/4QEY9I+jzwNrIiIWBL4GPk9TuHPN/vA+4gW48DyFr8WPK63RoYHxH3lq6+c8t7vp68ltdqDKKFFsYhwBYR8buyyM1kj0Aox0/3IrtD3wf8kbzOLyEDxv+WtH8HboyIYyR9EjiLvA4EfFk5SeSR8tNqebfBBxKyBtCH7I88F3g/GUjeJOlAsp/2DcBPyYc9bgZsXRvzKDXRxWQr4UWgf10Nq3upDaypxjmPrMX+v/pESU+V7f5bKaj2IWvh10laRJ6MNUvJVssgsrDYStLGEbG4rmBdyWoC2ILys0P5rJ8GXoqIH5aT9UngvZJ2Jwv9fuTg8USyqQvNhcAUMogsBf5J9offX07AlQpTsoum9qibB4C7IuKuks+D67Y5E/i6pIElj0j6UETMkLRJqS0uLdufWwqoZWRh91ZJd0XEoroacNS1amr5eH35ezwwpLRMPlI+L2WfbQ5cUypj2wGTI+ITkuZSKhul4rdc0nxyEHU+sFzS7nXdTrVxkucj4tXGY1Sv1tVABpJdyXGQF8igO7e2vqTpwNYlANS67zYnz6UW36OhhXQ0sEdEXFBeHkYWMqcCI0rafLKr8CMN29mCLPRrwRaydr4X8EFgHM2FzuK6z/Qqef6+u/zfnTxnnidbIzNb2zdtVVpRC8pxaXHQuOSpti9q18gs8hh+UtJ5ZLkwhJy4cTd5fm5JnpOHkGXFRPJ8OossqLcg99umZHDsJinIAfV/AB8lKzxNJX/dgOV1eap9hm40B7n6PNcH235kl+DWJe/TyTGyr5DB45dkK/l5stUxJiL6SfoQ2U37R+BoYGdJXyGDx91k2fA/wL1kS+V0sqU+gla8FgLJcrJAHgF8VtIeZGHZFzgPmEzWtl6IiCWlu2RXcibMxhGxmDwpAH5FBqR7gNtLENkH6C3pb2XZVUTEq5J6lQJlX/IAjY+IMZJqrZ4nyIHT2qDjfDJYbA68UgrGTcrfU0pwOxH4STQPeH8AeCAini3bWF0Ae4I88Y8kL5YPl3yGpOdL+nbkhT+VbJ09K6m7pC0iYmEpmP6h7F9dTp6Yx0l6ICKeLO9zKDArIv5e2wclC48Db5F0DVkgvYG8OCELlHnleI2LlScxvEQG24dLIdGbrCVvBXy75OFFNXd1DSNranc1Hou6fOxOFqKfrdXGyzLzyYLuajKI1ILRPLLA3oHmwm9f4LFyPlwGXCTpbLImtx/Z4voZed61xTTynF1Ets6a6l8s+38R0L0cs43JVvcPaaFmL+n1ZLff20vQ/BzZ2qCcU8vJSRsfklQ7nx4Dtpd0JFlZ2IsM1teW/dKr7i0WlX3xBrLg2qXuveu7icYA35L0voj4Q0k7iSzAXmnjvqnVzvciW2ADyWPxM/L8uIwcK5rV0Mpf0RUtaQeyq6mW3+fIAnQ+2drYjwzgm5I19LeSA+R9ydbLvmQZcDwZOKeQwX9IebsANiFbD8sl9SDLmX3J8+dySePJa/5B4GOSvhXZbblSBaxWSVXOBDueDEgHka3Sd5KtnOvIlt2/l8AyiQzcI8r5sT3NTwW+ixxThAweZwGjGwJZj4gYDYyWtADYaXWV1ZrXQiB5F3BtRCySdD5Z8/wJWZv4VEQ81bB8E9AfmFBq+28nD35ExIOSbgeGKadg7kjWQi5cXRCp83eyW2kSeeLOK+kLgCsi4tcNy88lx1A2juaBrv8gu7UgT4ATS8EgslZ3H9ndA6wxgC0lC+tv107gYg7ZdXF0CyfOXPLifTByjGEY2U++WUSMLC2LsyS9XPbhFsCZdevPKHl5irzoJ5HBfA/gx8oBySbyAns0Vp0J9zhZaDxcLq7aAPicyL7tU8iB3nvKfr2rbK9RLR9Pk8fhUGBP5WSGWo1+ARkI/lIuxtrg5DzqCr3SKvgA2a0F2Xo7DvgBWfC8QBbic1rIxyrqCo5XyO6TOZL6RMScEgC3ixzYfhH4s3Jcrw8ZMC9dzcU+h+Zu0i+SY4K1grxH+fzfIFs+w8pnebK8djZZUE4FJpXjvoBsEW0MLCkVsF5k18pkSYslnRwRP6W56+1jZT98DfiopE+T18+rwPByrrZ1wsg+ZBfNT8j9ewd5PfckW8dbALNKq/oSsvB/TNKXy7l+NlnjPpM8p58lx8QOIwvqbmQrJchr6umyvxeXff08GeivjOwKrR2zZ8lrdhHZQvitpMfJrtC7yeC7SzkW25OB68tkwLpMOcllasnXIWSPwfXkBKCewHfI1sV/lv1wOPCx0jLvWd63H1nW1O/LZ2BFl/BsSd2U3V+3AccCfymtoKPI6+kNpZWyI1m2DGstiMBrI5AcAmwq6Utkf/hB5EGdTs7KaQwk08iunbnl9beRF+i4csJ8R9JbyMHpR1m5ttqa+4DfRsTYhvQmslbcaDbwZuBgSS+StdopZJOVyAHiR8nWxOKS/nDkbKV6qwtgs8guifeXVthlpca2kDwh92HVqcTTgfeVVtS7yAvvBxHxdHn9E2T3xh7kxf1gQ236HmC/yKmyTwL3ly6g6ZK+DBwcET8qrYGdyAK/O7BjRDxTPssoSWPJi3M8cEYJIoqICZImRY5ttaY+H0+VffdOchztOyXPT5OtsppupRU0izxeo8tx6QuMjIj/gxwfknQdWctbuIZ8tOZJMmgvI2c3PU4GljGSziQLk62AR+r3cUuFcSmkt1GOe2xLtgJqr70kaVBE3FXOpxsl/SbyfpWFwNcj4s6GvM0tn3t5NHchHUd2rVDyNkx5r8TmZOE5ipyxNUrStLIPnyj5X7wWQQSyB2FeRHy6IX1haa1sX5Y5mbxP5X7lhJDzJf0nOT52SUQ8WZafQVaydi/7+GyyV+IfwBcj4k+lVXcFGaSuI2cS7lyC6StkT8V0MtD8kwxOPcju3KeBK8kAvQj4N7KLbzl53n2ebOndHxGflTSJbAm/CNwsaVz5DE+QlYB5sKJlNlDSPeUYLyK/U2SypHmS3hQ5OeVFsgK2DVmuLCMnrnxfOZnoD2SgepasRE4mA9bTUcYI1+S1EEgCeAdZK7uavEAPJGvER5ZC6z1kreB75BS+S8jawDPk2MkYaO5rjRxkfIC18zeyD74xkEwHBinHa3Yh+2b/XLb/BfJEm04Grf+pb0GVLqTvruF9VxfA5pO1n8vIPtM9JZ1O7p8FwHuU4w/vJmud3yG7P84kx2nmkBfH7XX5CVqffjqOvLdgNFmI7EHWqruRJ3Gtb707cIOkh8iWzf2SvkAel/vKz2ORs35WKjzbEEQa8zGbHH84XtJI4ErlQOuzZOvmXZKWk4X6j0pF4mqyr3siML2Wj4b9UCWIULa9JzmGNYCsJLxY9/q99QvX9kErhfFEskXw3oZujAPIbtwPkwXMwWQt9cfk+b8nWbjUm0NWcj5WCrNDyUBxE0BE3CHpMbKi8QLZknmilk9yrOEjZO15rrJbZ1xbdkr5nK9KCuUA8ZZkpe7OyO8leoEs4LcmK18HlNb3TuRx35msVNW6q7uR5/BXyWP2M7KVvSlZRrybvKl1EVnw12Zq/ZwMAO8iu1p/RV4fI8mAeiB5nt5Klh+fJIPM/LK/lpT3GUtWvobUFdoPkz0Oe5Wfd5RlX6a5hQcZ0HvXtaJn0tytOJesNE8ted+2fObZZBdo7Tr5PnBRC9fNPNbCBh1ISvNtI+DkWkEqaRzZnPw3stn2YbI/eAzZRXIz2U3Q0SYCJyvHBY4kB3x/Q9aOv0DWhmaQ3TdNkVM4h6xmW2tjdQFsGnnz3o8lnURORPgV2Xf8NFnj2p9SS1GOhXwnIr5dIS8TyQFHyJP+otId9mayYLy21G5HkPtmIvBkXcE3j2yVrGQtarIt5eNZcgLGFeRg88nktOYzyQvuRbIluCIfUaZFrgulht+bvNCfKa29Wouv8Z6XFX+3YR/8tWzz5FK7HlnWfUv52Z68DkaSFZtdyQLtIEmzyPGEt5JTgB8kC8bdyILqbrKyUt8aXkSe00cBfSWNIis9W5EtltvJCtN2wPWSjomI8W3YRRuRhek08hy9kSzo/1xen0nWvncmj/ODwE+jjH+V/fYq2U08LnJc61HgcrJW/gGyhf80eW7sU1abT1Y0P0FWgEaRBXUv8rwcT04geaV8vtq04lpwPxs4W9K1ZG3/MfLm0m+QAWI/mp/C8OXy/p8jA9wOJX062XL6W/l/AvAOSW8mA/9TlJmN5LVcCw6/BX4TEfNLIP7vkj/Fmrvk22SDDiTFDsA0Nc/bbgL+K9YwbXYdeIoMXt8nT9CJ5Hzup8la37rSUgD7Fdlt9S5J25R+0y+RLY3JEXETGVg62jM01wR/TbZ8xpPjIbPrlru3ccV1nI8HYcVU6v8tP5A1z3+p0jr7L7IPvjaPvz5g1M/kWZt7Ux4huzb/Srbs3kgWUjsCN0fEaXV5uIwMpJeSrbLNyQD+e2BiRDxXKh9vIisbu5Kti/q7s79EttpGlHXfSZY3JwOzI6I24DtV0gjgI5JmlS7M1tTuaXgGuDciLml4fQbNM95mkfcJLSgtoQMpLXty4s09ZCAYV/ZDrSV6HxlEu5GBo9ZlOa687+zSJfjxkp9o6VisJu0E5QSH3cjZVe8ng2n9VP89gT+V99ydnCW4UcnbwTSPx11JTrg5iDyf/4fmWWDnwopgsaJ1UV/haEcFbLX8GPkNnPJRIbPJftBaALulDResbUCUN59dFBFHSNqbHPTelmwRL44cNK5NJ9+O5pl6u5K14D3JFsmZZIvgTrJydC85+Hw0OallROmm/SZwSjTP4KtNlf8D8PvIO7t7Rk6COYgc5L+xdIvVBq9FBqutgKmRY2G17XwVGBTlBtm6z/luMoh9iAwop5HdxT3J1tPpkVPJtyFbLTPIsYxbI+LA+m5SddDjdRryV9+i7E3zwPpfyIH1l8kK3VdontgxkazcbAv0iYg/d2SeOsJroUXymla6G3p2dj6s0z1DuS8pcvr4cHLq7IPk8+I2KWMP3chW81UlIHyXHM+6i+yOep4cl7iDHLB+EFZMKf+opAlkrXlK5GB27V6J+hsna90vtbT55e8tS/5qU2ZPJrt9byJbUS+WbUF263xd0gfJcYp+ZBfOH0seN4+8sfB0sgB+oqE2Po+VxwEOLL8liTLc1NFBpAfw5tK1uAXZdf04OVHh82S34fcj4irlZJRZEfFY3Sa6zIMdG7lFYvYaJ+mv5KM1LpN0FrBvRAxVPu7kHcC5dQO6tZv+ziHvhB9RWg4iC/tnycLxpIgYoubH0dRu4j0R+HREvK2uRfImcrr0qdHGZ5OVwfQ7yAA3lZxp9FCsOmuxfp0Oex5deynv9foM2Zp7GLitrZ+5K3OLxMwmALtI6k8+NuZzJX02ZXBcObvx38mnUP9Q0myaZwjVbrybWpb5Nc1PMViulW9mGwOcJOkzdeMkg4HXtVSgliC1UTQ8eDByBttbWvowqwsYnR1ESh5+R/O9YBuMjda8iJlt4O4jB35PJp+hVXt44jPkNPjjyK6jvwK3l8L9KZofmVMrR/5Jznh6gnzM//mli6j25IWvRN4Q+BVyevlY5cMQh5OD+qso66/y9NqyvY2UN9dtVPK0Yp127QVrN7dIzOxeclB7KFD/OJ2FZFfVmIj4Wf0KkmZSHpJZBr97koPc/1X+PxO4UNIvyVlJfcgnNveMvLnuq5TB7mh+pM9a6egxDGs/BxIze5J8VMlPye82OTsixpTB94XkPSaNXiCfxfVpMki8mZyufDvkzbLKLxt7O3lvx7Rofhz+RhHxODmWYhsAD7abGeWmwzeSz2/6GnB5RPxE0qfIWVgPko/YeBv53TETaX5I5ERysPv21ga7W3jPTh/8to7hQGJmKB9H84OIuEb5jX/fJe8VuZd8ZMo/yUH5x8k7uNsUMGpjFw4YGzYHEjND+Z3jkyOf2IvyseULo5UHT5Yg0Y1slXT4fRe2/nAgMbMVWupuqk3BpXzXiQOGNXIgMTNglS+hMmszBxIzM6vENySamVklDiRmZlaJA4mZmVXiQGLWAkm9JT1Ufp6X9Gzd/69rZb2ryrIbl/+3LY8EN9tg+REpZi2I/P7sgQCSvgm8HBEXtXH1ZeRX0Y5YJ5kz62LcIjFrI0mHSXpQ0iRJV9ZaHS24hHz0+koVNUmblyfePlC2cVRJ7y9pqqSfSpos6TpJ75Z0t6Tpkg4oy21W3vf+ko+j1ukHNmsjBxKztulJfoPdcRGxL9maP2U1yz5NfuHSCQ3pi4CjI+It5HeYf7/u8ee7kd+5vR/5JN6PkA88/Ar57CuAs4A7IuKtZf3vSdqs+kczq8aBxKxtupFf1/po+f9q8tsDV+fbwFdZ+RoT8G1JE8mn5Pal+cm6T0TEpHLX+BRgbLnDfBLQvyxzOHBGeS7Wn8ng9vpqH8usOo+RmLXNK2uzcETMKAX+h+uSP0o+cn1QRCwpg/A9y2uL65ZbXvf/cpqvUwH/ERHT1i7rZuuWWyRmbdMT6C9pt/L/CcBf1rDO+WTXVM1WwOwSRN5J81fVttWtwGm17jBJb17L9c3WCQcSs7ZZBHwCuFHSJLKl8KPWVoiIKcADdUnXAYMljSdbJ1PXMg/nAT3Ir7GdXP4363R+1paZmVXiFomZmVXiQGJmZpU4kJiZWSUOJGZmVokDiZmZVeJAYmZmlTiQmJlZJQ4kZmZWyf8HlyVBg3qwkpwAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "sp_vis.plot.bar(rot= 9)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 198,
   "id": "f4c22c37",
   "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>To Name</th>\n",
       "      <th>AEDC</th>\n",
       "      <th>EEDC</th>\n",
       "      <th>EKEDC</th>\n",
       "      <th>IBEDC</th>\n",
       "      <th>IKEDC</th>\n",
       "      <th>JED</th>\n",
       "      <th>KAEDCO</th>\n",
       "      <th>KEDCO - Electricity</th>\n",
       "      <th>PHEDC</th>\n",
       "      <th>Startimes</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1000.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>2150.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>900.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>2500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5000.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>900.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>800.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>900.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1700.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>500.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>900.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>190.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>2500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>500.0</td>\n",
       "      <td>900.0</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>950.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>2200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2000.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>800.0</td>\n",
       "      <td>190.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>160.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2000.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>900.0</td>\n",
       "      <td>950.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2900.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>600.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>160.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>500.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>2500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>3000.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>160.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>500.0</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>900.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1700.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>200.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>600.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>450.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1700.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>500.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>1900.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>2200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>3000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>11800.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>190.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1000.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>2200.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>1100.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>160.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>3000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>470.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>2700.0</td>\n",
       "      <td>900.0</td>\n",
       "      <td>900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2900.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>500.0</td>\n",
       "      <td>7500.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>1900.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>500.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>4000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>600.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>20000.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1900.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>2500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2000.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>900.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>300.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1000.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>2500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>900.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>2800.0</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>950.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>1700.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>600.0</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>7000.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>2200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>6500.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>190.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>900.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>160.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>40000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>450.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1000.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>2800.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>300.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>3000.0</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>1900.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>90.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2000.0</td>\n",
       "      <td>600.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>550.0</td>\n",
       "      <td>900.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>320.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2000.0</td>\n",
       "      <td>2000.0</td>\n",
       "      <td>1500.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>750.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>480.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>1700.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "To Name     AEDC      EEDC    EKEDC    IBEDC    IKEDC     JED  KAEDCO  \\\n",
       "0         1000.0     500.0   1000.0   2150.0   1000.0   100.0  1500.0   \n",
       "1         5000.0     500.0   1000.0    900.0   1000.0   800.0  1000.0   \n",
       "2          500.0    1000.0   5000.0    900.0   1000.0   190.0  1000.0   \n",
       "3          500.0     900.0   1400.0   6000.0    400.0   200.0  1000.0   \n",
       "4         2000.0     500.0   5000.0   2000.0    800.0   190.0  1500.0   \n",
       "5         2000.0     500.0   1500.0   1000.0    900.0   950.0  2000.0   \n",
       "6         2900.0    2000.0   2500.0   1000.0   1000.0   600.0  1000.0   \n",
       "7          500.0    1500.0   2000.0    500.0   5000.0   200.0  1000.0   \n",
       "8         3000.0    2000.0   2000.0  10000.0    300.0   100.0  2000.0   \n",
       "9          500.0    1400.0   1000.0   1000.0    100.0   500.0   900.0   \n",
       "10         200.0    3000.0   2000.0    600.0   1000.0   450.0  5000.0   \n",
       "11         500.0    3000.0   1500.0   1900.0    500.0   500.0   500.0   \n",
       "12        1000.0    1000.0  10000.0    500.0   1000.0   180.0  1000.0   \n",
       "13        3000.0    1000.0  11800.0   1000.0   2000.0   190.0  1000.0   \n",
       "14        1000.0     400.0   2200.0    500.0   3000.0   500.0  1100.0   \n",
       "15        3000.0    1000.0   2000.0   1400.0  10000.0   470.0  1000.0   \n",
       "16        2900.0    3000.0  10000.0   5000.0   1000.0   500.0  1000.0   \n",
       "17         500.0    7500.0  10000.0   1900.0    500.0  1000.0  1000.0   \n",
       "18         500.0    1000.0   4000.0   1000.0    500.0   200.0  1000.0   \n",
       "19         600.0    2000.0  20000.0   2000.0   3000.0  1000.0  1900.0   \n",
       "20        2000.0    2000.0   5000.0   1000.0    900.0   500.0  1000.0   \n",
       "21        1000.0     500.0   2000.0   3000.0    150.0  1000.0  1000.0   \n",
       "22         900.0    1000.0   2800.0   1400.0    100.0  2000.0  1500.0   \n",
       "23         600.0    6000.0   5000.0   7000.0    100.0   500.0   500.0   \n",
       "24        1000.0    1000.0   6500.0   2000.0   1000.0   190.0  1000.0   \n",
       "25       40000.0    1000.0   1000.0   1000.0   1000.0   450.0  1000.0   \n",
       "26        1000.0    2000.0   3000.0   1000.0   2000.0   500.0  2800.0   \n",
       "27        3000.0  100000.0   1000.0   1500.0   1900.0   500.0  1000.0   \n",
       "28        2000.0     600.0   1000.0    500.0   1500.0   550.0   900.0   \n",
       "29        2000.0    2000.0   1500.0   1000.0   2500.0   750.0   500.0   \n",
       "\n",
       "To Name KEDCO - Electricity   PHEDC Startimes  \n",
       "0                     900.0  1000.0    2500.0  \n",
       "1                     900.0  1000.0    1700.0  \n",
       "2                   10000.0  2000.0    2500.0  \n",
       "3                     950.0  1000.0    2200.0  \n",
       "4                    5000.0  1000.0     160.0  \n",
       "5                     500.0  1500.0     900.0  \n",
       "6                     500.0  1500.0     160.0  \n",
       "7                    1000.0   500.0    2500.0  \n",
       "8                    5000.0   500.0     160.0  \n",
       "9                    3000.0  1000.0    1700.0  \n",
       "10                    500.0  1000.0    1700.0  \n",
       "11                   1000.0   500.0    2200.0  \n",
       "12                   2000.0  1000.0      90.0  \n",
       "13                    500.0  1000.0     900.0  \n",
       "14                   1000.0  1000.0     160.0  \n",
       "15                   2700.0   900.0     900.0  \n",
       "16                   1000.0  1000.0     900.0  \n",
       "17                   1400.0  1000.0     400.0  \n",
       "18                   1000.0  1000.0     200.0  \n",
       "19                   1000.0  1000.0    2500.0  \n",
       "20                    500.0   500.0     300.0  \n",
       "21                    500.0  1000.0    2500.0  \n",
       "22                    950.0  2000.0    1700.0  \n",
       "23                    400.0  1000.0    2200.0  \n",
       "24                    900.0  1000.0     160.0  \n",
       "25                    400.0  1000.0     600.0  \n",
       "26                   2500.0  2000.0     300.0  \n",
       "27                   1000.0  1000.0      90.0  \n",
       "28                    200.0  1000.0     320.0  \n",
       "29                    480.0   500.0    1700.0  "
      ]
     },
     "execution_count": 198,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test = merge_data.pivot(columns= 'To Name', values= 'Amount')\n",
    "test.head(30)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4bedba37",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 163,
   "id": "3e245729",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "\n",
    "## days = range(12, 22)\n",
    "## plt.bar(days, data_vis)\n",
    "## plt.xticks(days)\n",
    "## plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c29394e1",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "d3f67b46",
   "metadata": {},
   "outputs": [],
   "source": [
    "merge_data.to_csv('./downloads/partner_mtn/mtn_rep.csv', index= 'true')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "387f16ad",
   "metadata": {},
   "outputs": [],
   "source": [
    "S = 'Name'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "bce83a87",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Name'"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "S[0]+S[1:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "83aa6b29",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4763d90a",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "33656214",
   "metadata": {},
   "outputs": [],
   "source": [
    " \n"
   ]
  }
 ],
 "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.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}