src/Testing.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import sys  \n",
    "import os\n",
    "from itertools import cycle,product\n",
    "import import_ipynb\n",
    "import datetime as dt\n",
    "import warnings\n",
    "warnings.filterwarnings('error')\n",
    "%load_ext autoreload\n",
    "%autoreload 2\n",
    "import P2P_functions as p2p\n",
    "import Classes_definition as cp2p\n",
    "import copy\n",
    "from pandas.plotting import register_matplotlib_converters\n",
    "register_matplotlib_converters()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1=pd.read_csv('df_50_50_DE_0.25_100_cuts.csv',index_col=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['index', 'SCR', 'SSR', 'EFC', 'Demand_peak', 'Inj_peak', 'avg_dod',\n",
       "       'Total_load', 'TotalPV', 'bill', 'Imported', 'Exported', 'Batt_revenue',\n",
       "       'Batt_penetration', 'PV_penetration', 'seed', 'hh', 'EPARI', 'ADMD',\n",
       "       'ADME', 'EBI', 'Comm', 'jains', 'gini', 'PI', 'daily_peak_lower',\n",
       "       'SCR_hh', 'SSR_hh', 'EFC_hh', 'Demand_peak_hh', 'Inj_peak_hh',\n",
       "       'avg_dod_hh', 'bill_hh', 'Imported_hh', 'Exported_hh',\n",
       "       'Batt_revenue_hh'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>index</th>\n",
       "      <th>SCR</th>\n",
       "      <th>SSR</th>\n",
       "      <th>EFC</th>\n",
       "      <th>Demand_peak</th>\n",
       "      <th>Inj_peak</th>\n",
       "      <th>avg_dod</th>\n",
       "      <th>Total_load</th>\n",
       "      <th>TotalPV</th>\n",
       "      <th>bill</th>\n",
       "      <th>...</th>\n",
       "      <th>SCR_hh</th>\n",
       "      <th>SSR_hh</th>\n",
       "      <th>EFC_hh</th>\n",
       "      <th>Demand_peak_hh</th>\n",
       "      <th>Inj_peak_hh</th>\n",
       "      <th>avg_dod_hh</th>\n",
       "      <th>bill_hh</th>\n",
       "      <th>Imported_hh</th>\n",
       "      <th>Exported_hh</th>\n",
       "      <th>Batt_revenue_hh</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>No</td>\n",
       "      <td>51.161976</td>\n",
       "      <td>51.020219</td>\n",
       "      <td>NaN</td>\n",
       "      <td>151.963</td>\n",
       "      <td>235.123847</td>\n",
       "      <td>NaN</td>\n",
       "      <td>445550.533983</td>\n",
       "      <td>444316.018156</td>\n",
       "      <td>60239.722009</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>6.546173</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>990.350979</td>\n",
       "      <td>4419.411112</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>PV</td>\n",
       "      <td>51.161976</td>\n",
       "      <td>51.020219</td>\n",
       "      <td>NaN</td>\n",
       "      <td>151.963</td>\n",
       "      <td>235.123847</td>\n",
       "      <td>NaN</td>\n",
       "      <td>445550.533983</td>\n",
       "      <td>444316.018156</td>\n",
       "      <td>60239.722009</td>\n",
       "      <td>...</td>\n",
       "      <td>23.526474</td>\n",
       "      <td>37.170256</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>6.849208</td>\n",
       "      <td>5.127024</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>422.072364</td>\n",
       "      <td>2777.709788</td>\n",
       "      <td>6622.180670</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>PV_batt</td>\n",
       "      <td>51.161976</td>\n",
       "      <td>51.020219</td>\n",
       "      <td>NaN</td>\n",
       "      <td>151.963</td>\n",
       "      <td>235.123847</td>\n",
       "      <td>NaN</td>\n",
       "      <td>445550.533983</td>\n",
       "      <td>444316.018156</td>\n",
       "      <td>60239.722009</td>\n",
       "      <td>...</td>\n",
       "      <td>30.823961</td>\n",
       "      <td>55.468745</td>\n",
       "      <td>291.235361</td>\n",
       "      <td>5.743428</td>\n",
       "      <td>5.809514</td>\n",
       "      <td>0.797905</td>\n",
       "      <td>6.814558</td>\n",
       "      <td>2067.350874</td>\n",
       "      <td>6168.001851</td>\n",
       "      <td>346.510751</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>No</td>\n",
       "      <td>47.908610</td>\n",
       "      <td>47.775866</td>\n",
       "      <td>NaN</td>\n",
       "      <td>150.758</td>\n",
       "      <td>238.261045</td>\n",
       "      <td>NaN</td>\n",
       "      <td>445550.533983</td>\n",
       "      <td>444316.018156</td>\n",
       "      <td>75876.655090</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>6.546173</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1237.435111</td>\n",
       "      <td>4419.411112</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>PV</td>\n",
       "      <td>47.908610</td>\n",
       "      <td>47.775866</td>\n",
       "      <td>NaN</td>\n",
       "      <td>150.758</td>\n",
       "      <td>238.261045</td>\n",
       "      <td>NaN</td>\n",
       "      <td>445550.533983</td>\n",
       "      <td>444316.018156</td>\n",
       "      <td>75876.655090</td>\n",
       "      <td>...</td>\n",
       "      <td>23.526474</td>\n",
       "      <td>37.170256</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>6.849208</td>\n",
       "      <td>5.127024</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>512.871514</td>\n",
       "      <td>2777.709788</td>\n",
       "      <td>6622.180670</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 36 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     index        SCR        SSR  EFC  Demand_peak    Inj_peak  avg_dod  \\\n",
       "0       No  51.161976  51.020219  NaN      151.963  235.123847      NaN   \n",
       "1       PV  51.161976  51.020219  NaN      151.963  235.123847      NaN   \n",
       "2  PV_batt  51.161976  51.020219  NaN      151.963  235.123847      NaN   \n",
       "3       No  47.908610  47.775866  NaN      150.758  238.261045      NaN   \n",
       "4       PV  47.908610  47.775866  NaN      150.758  238.261045      NaN   \n",
       "\n",
       "      Total_load        TotalPV          bill  ...     SCR_hh     SSR_hh  \\\n",
       "0  445550.533983  444316.018156  60239.722009  ...   0.000000   0.000000   \n",
       "1  445550.533983  444316.018156  60239.722009  ...  23.526474  37.170256   \n",
       "2  445550.533983  444316.018156  60239.722009  ...  30.823961  55.468745   \n",
       "3  445550.533983  444316.018156  75876.655090  ...   0.000000   0.000000   \n",
       "4  445550.533983  444316.018156  75876.655090  ...  23.526474  37.170256   \n",
       "\n",
       "       EFC_hh  Demand_peak_hh  Inj_peak_hh  avg_dod_hh      bill_hh  \\\n",
       "0    0.000000        6.546173     0.000000    0.000000   990.350979   \n",
       "1    0.000000        6.849208     5.127024    0.000000   422.072364   \n",
       "2  291.235361        5.743428     5.809514    0.797905     6.814558   \n",
       "3    0.000000        6.546173     0.000000    0.000000  1237.435111   \n",
       "4    0.000000        6.849208     5.127024    0.000000   512.871514   \n",
       "\n",
       "   Imported_hh  Exported_hh  Batt_revenue_hh  \n",
       "0  4419.411112     0.000000         0.000000  \n",
       "1  2777.709788  6622.180670         0.000000  \n",
       "2  2067.350874  6168.001851       346.510751  \n",
       "3  4419.411112     0.000000         0.000000  \n",
       "4  2777.709788  6622.180670         0.000000  \n",
       "\n",
       "[5 rows x 36 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(90, 36)"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "15*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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></th>\n",
       "      <th></th>\n",
       "      <th>SCR</th>\n",
       "      <th>SSR</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <th>seed</th>\n",
       "      <th>Comm</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"30\" valign=\"top\">No</th>\n",
       "      <th rowspan=\"2\" valign=\"top\">0</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">1</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">2</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">3</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">4</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">5</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">6</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">7</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">8</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">9</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">10</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">11</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">12</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">13</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">14</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"30\" valign=\"top\">PV_batt</th>\n",
       "      <th rowspan=\"2\" valign=\"top\">0</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">1</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">2</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">3</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">4</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">5</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">6</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">7</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">8</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">9</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">10</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">11</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">12</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">13</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">14</th>\n",
       "      <th>P2P</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SC</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>90 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   SCR  SSR\n",
       "index   seed Comm          \n",
       "No      0    P2P     1    1\n",
       "             SC      1    1\n",
       "        1    P2P     1    1\n",
       "             SC      1    1\n",
       "        2    P2P     1    1\n",
       "             SC      1    1\n",
       "        3    P2P     1    1\n",
       "             SC      1    1\n",
       "        4    P2P     1    1\n",
       "             SC      1    1\n",
       "        5    P2P     1    1\n",
       "             SC      1    1\n",
       "        6    P2P     1    1\n",
       "             SC      1    1\n",
       "        7    P2P     1    1\n",
       "             SC      1    1\n",
       "        8    P2P     1    1\n",
       "             SC      1    1\n",
       "        9    P2P     1    1\n",
       "             SC      1    1\n",
       "        10   P2P     1    1\n",
       "             SC      1    1\n",
       "        11   P2P     1    1\n",
       "             SC      1    1\n",
       "        12   P2P     1    1\n",
       "             SC      1    1\n",
       "        13   P2P     1    1\n",
       "             SC      1    1\n",
       "        14   P2P     1    1\n",
       "             SC      1    1\n",
       "...                ...  ...\n",
       "PV_batt 0    P2P     1    1\n",
       "             SC      1    1\n",
       "        1    P2P     1    1\n",
       "             SC      1    1\n",
       "        2    P2P     1    1\n",
       "             SC      1    1\n",
       "        3    P2P     1    1\n",
       "             SC      1    1\n",
       "        4    P2P     1    1\n",
       "             SC      1    1\n",
       "        5    P2P     1    1\n",
       "             SC      1    1\n",
       "        6    P2P     1    1\n",
       "             SC      1    1\n",
       "        7    P2P     1    1\n",
       "             SC      1    1\n",
       "        8    P2P     1    1\n",
       "             SC      1    1\n",
       "        9    P2P     1    1\n",
       "             SC      1    1\n",
       "        10   P2P     1    1\n",
       "             SC      1    1\n",
       "        11   P2P     1    1\n",
       "             SC      1    1\n",
       "        12   P2P     1    1\n",
       "             SC      1    1\n",
       "        13   P2P     1    1\n",
       "             SC      1    1\n",
       "        14   P2P     1    1\n",
       "             SC      1    1\n",
       "\n",
       "[90 rows x 2 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.groupby(['index','seed','Comm']).count().loc[:,['SCR','SSR']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "alenv",
   "language": "python",
   "name": "alenv"
  },
  "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.7.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}