Full_code_steps.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "from itertools import combinations\n",
    "from collections import defaultdict\n",
    "import time\n",
    "from tkinter import *\n",
    "from tkinter import filedialog\n",
    "import tga  # test groups automation"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "import importlib # add group count"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<module 'tga' from 'C:\\\\Users\\\\Akshay\\\\Documents\\\\testgroups\\\\tga.py'>"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "importlib.reload(tga)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## raw = tga.select_file, df1 = tga.aggregate, df2 = tga.create, df3 = tga.optimize\n",
    "\n",
    "### Please make sure that the column row is the first row in your excel sheet."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "raw = tga.select_file()"
   ]
  },
  {
   "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>calendar</th>\n",
       "      <th>payment_source</th>\n",
       "      <th>testgroup</th>\n",
       "      <th>respin_rev</th>\n",
       "      <th>pr_pack_rev</th>\n",
       "      <th>po_rev</th>\n",
       "      <th>2ndround_rev</th>\n",
       "      <th>payment_page_rev</th>\n",
       "      <th>clickbuy_rev</th>\n",
       "      <th>pr_game_rev</th>\n",
       "      <th>...</th>\n",
       "      <th>pr_pack_trans</th>\n",
       "      <th>po_trans</th>\n",
       "      <th>2ndround_trans</th>\n",
       "      <th>payment_page_trans</th>\n",
       "      <th>clickbuy_trans</th>\n",
       "      <th>pr_game_trans</th>\n",
       "      <th>piggy_trans</th>\n",
       "      <th>dbx_trans</th>\n",
       "      <th>total_trans</th>\n",
       "      <th>Segment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2019-10-16</td>\n",
       "      <td>1 Click Buy</td>\n",
       "      <td>A</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1135.75</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>176</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>97</td>\n",
       "      <td>176</td>\n",
       "      <td>GroupB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2019-10-16</td>\n",
       "      <td>2nd Round Buy In</td>\n",
       "      <td>A</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>87.38</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>65</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>65</td>\n",
       "      <td>GroupB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2019-10-16</td>\n",
       "      <td>POs</td>\n",
       "      <td>A</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2512.26</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>110</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>110</td>\n",
       "      <td>GroupB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2019-10-16</td>\n",
       "      <td>PaymentPage</td>\n",
       "      <td>A</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3178.94</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>201</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>201</td>\n",
       "      <td>GroupB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2019-10-16</td>\n",
       "      <td>Piggy</td>\n",
       "      <td>A</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>236</td>\n",
       "      <td>0</td>\n",
       "      <td>236</td>\n",
       "      <td>GroupB</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1426</th>\n",
       "      <td>2019-10-24</td>\n",
       "      <td>PaymentPage</td>\n",
       "      <td>T</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>4313.65</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>240</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>240</td>\n",
       "      <td>GroupB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1427</th>\n",
       "      <td>2019-10-24</td>\n",
       "      <td>Piggy</td>\n",
       "      <td>T</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>303</td>\n",
       "      <td>0</td>\n",
       "      <td>303</td>\n",
       "      <td>GroupB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1428</th>\n",
       "      <td>2019-10-24</td>\n",
       "      <td>Poker Recall game</td>\n",
       "      <td>T</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>93.45</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>86</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>86</td>\n",
       "      <td>GroupB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1429</th>\n",
       "      <td>2019-10-24</td>\n",
       "      <td>Poker Recall pack</td>\n",
       "      <td>T</td>\n",
       "      <td>0.00</td>\n",
       "      <td>97.03</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>27</td>\n",
       "      <td>GroupB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1430</th>\n",
       "      <td>2019-10-24</td>\n",
       "      <td>Respin</td>\n",
       "      <td>T</td>\n",
       "      <td>536.11</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>98</td>\n",
       "      <td>GroupB</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1431 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       calendar     payment_source testgroup  respin_rev  pr_pack_rev  \\\n",
       "0    2019-10-16        1 Click Buy         A        0.00         0.00   \n",
       "1    2019-10-16   2nd Round Buy In         A        0.00         0.00   \n",
       "2    2019-10-16                POs         A        0.00         0.00   \n",
       "3    2019-10-16        PaymentPage         A        0.00         0.00   \n",
       "4    2019-10-16              Piggy         A        0.00         0.00   \n",
       "...         ...                ...       ...         ...          ...   \n",
       "1426 2019-10-24        PaymentPage         T        0.00         0.00   \n",
       "1427 2019-10-24              Piggy         T        0.00         0.00   \n",
       "1428 2019-10-24  Poker Recall game         T        0.00         0.00   \n",
       "1429 2019-10-24  Poker Recall pack         T        0.00        97.03   \n",
       "1430 2019-10-24             Respin         T      536.11         0.00   \n",
       "\n",
       "       po_rev  2ndround_rev  payment_page_rev  clickbuy_rev  pr_game_rev  ...  \\\n",
       "0        0.00          0.00              0.00       1135.75         0.00  ...   \n",
       "1        0.00         87.38              0.00          0.00         0.00  ...   \n",
       "2     2512.26          0.00              0.00          0.00         0.00  ...   \n",
       "3        0.00          0.00           3178.94          0.00         0.00  ...   \n",
       "4        0.00          0.00              0.00          0.00         0.00  ...   \n",
       "...       ...           ...               ...           ...          ...  ...   \n",
       "1426     0.00          0.00           4313.65          0.00         0.00  ...   \n",
       "1427     0.00          0.00              0.00          0.00         0.00  ...   \n",
       "1428     0.00          0.00              0.00          0.00        93.45  ...   \n",
       "1429     0.00          0.00              0.00          0.00         0.00  ...   \n",
       "1430     0.00          0.00              0.00          0.00         0.00  ...   \n",
       "\n",
       "      pr_pack_trans  po_trans  2ndround_trans  payment_page_trans  \\\n",
       "0                 0         0               0                   0   \n",
       "1                 0         0              65                   0   \n",
       "2                 0       110               0                   0   \n",
       "3                 0         0               0                 201   \n",
       "4                 0         0               0                   0   \n",
       "...             ...       ...             ...                 ...   \n",
       "1426              0         0               0                 240   \n",
       "1427              0         0               0                   0   \n",
       "1428              0         0               0                   0   \n",
       "1429             27         0               0                   0   \n",
       "1430              0         0               0                   0   \n",
       "\n",
       "      clickbuy_trans  pr_game_trans  piggy_trans  dbx_trans  total_trans  \\\n",
       "0                176              0            0         97          176   \n",
       "1                  0              0            0          0           65   \n",
       "2                  0              0            0          0          110   \n",
       "3                  0              0            0          0          201   \n",
       "4                  0              0          236          0          236   \n",
       "...              ...            ...          ...        ...          ...   \n",
       "1426               0              0            0          0          240   \n",
       "1427               0              0          303          0          303   \n",
       "1428               0             86            0          0           86   \n",
       "1429               0              0            0          0           27   \n",
       "1430               0              0            0          0           98   \n",
       "\n",
       "      Segment  \n",
       "0      GroupB  \n",
       "1      GroupB  \n",
       "2      GroupB  \n",
       "3      GroupB  \n",
       "4      GroupB  \n",
       "...       ...  \n",
       "1426   GroupB  \n",
       "1427   GroupB  \n",
       "1428   GroupB  \n",
       "1429   GroupB  \n",
       "1430   GroupB  \n",
       "\n",
       "[1431 rows x 24 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "raw"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1 = tga.aggregate(raw)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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>testgroup</th>\n",
       "      <th>respin_rev</th>\n",
       "      <th>pr_pack_rev</th>\n",
       "      <th>dbx_rev</th>\n",
       "      <th>total_net_revenue</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A</td>\n",
       "      <td>4887.89</td>\n",
       "      <td>2131.61</td>\n",
       "      <td>5573.24</td>\n",
       "      <td>111586.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>B</td>\n",
       "      <td>5516.85</td>\n",
       "      <td>2305.58</td>\n",
       "      <td>5129.55</td>\n",
       "      <td>119092.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>C</td>\n",
       "      <td>4990.65</td>\n",
       "      <td>1880.85</td>\n",
       "      <td>6829.31</td>\n",
       "      <td>108797.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>E</td>\n",
       "      <td>8279.79</td>\n",
       "      <td>6958.10</td>\n",
       "      <td>0.00</td>\n",
       "      <td>147930.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>F</td>\n",
       "      <td>4803.01</td>\n",
       "      <td>2868.52</td>\n",
       "      <td>4857.46</td>\n",
       "      <td>132899.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>G</td>\n",
       "      <td>5352.87</td>\n",
       "      <td>2623.81</td>\n",
       "      <td>5917.94</td>\n",
       "      <td>115342.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>H</td>\n",
       "      <td>5143.08</td>\n",
       "      <td>2934.88</td>\n",
       "      <td>5810.14</td>\n",
       "      <td>111169.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>I</td>\n",
       "      <td>5838.39</td>\n",
       "      <td>2694.19</td>\n",
       "      <td>0.00</td>\n",
       "      <td>108782.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>J</td>\n",
       "      <td>5144.86</td>\n",
       "      <td>2003.24</td>\n",
       "      <td>4980.06</td>\n",
       "      <td>103376.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>K</td>\n",
       "      <td>5877.02</td>\n",
       "      <td>2243.26</td>\n",
       "      <td>0.00</td>\n",
       "      <td>119520.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>L</td>\n",
       "      <td>5625.17</td>\n",
       "      <td>3130.08</td>\n",
       "      <td>6472.22</td>\n",
       "      <td>119310.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>M</td>\n",
       "      <td>4685.20</td>\n",
       "      <td>5073.34</td>\n",
       "      <td>4912.07</td>\n",
       "      <td>127520.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>N</td>\n",
       "      <td>5303.47</td>\n",
       "      <td>1809.89</td>\n",
       "      <td>6112.61</td>\n",
       "      <td>119492.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>O</td>\n",
       "      <td>5641.85</td>\n",
       "      <td>1441.38</td>\n",
       "      <td>0.00</td>\n",
       "      <td>116142.68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>P</td>\n",
       "      <td>4515.34</td>\n",
       "      <td>1808.97</td>\n",
       "      <td>4884.66</td>\n",
       "      <td>105205.24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Q</td>\n",
       "      <td>5136.80</td>\n",
       "      <td>1856.55</td>\n",
       "      <td>5599.60</td>\n",
       "      <td>112091.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>R</td>\n",
       "      <td>4729.75</td>\n",
       "      <td>3148.58</td>\n",
       "      <td>6757.58</td>\n",
       "      <td>122674.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>S</td>\n",
       "      <td>5241.34</td>\n",
       "      <td>2051.02</td>\n",
       "      <td>7199.98</td>\n",
       "      <td>127893.34</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   testgroup  respin_rev  pr_pack_rev  dbx_rev  total_net_revenue\n",
       "0          A     4887.89      2131.61  5573.24          111586.57\n",
       "1          B     5516.85      2305.58  5129.55          119092.39\n",
       "2          C     4990.65      1880.85  6829.31          108797.27\n",
       "3          E     8279.79      6958.10     0.00          147930.51\n",
       "4          F     4803.01      2868.52  4857.46          132899.43\n",
       "5          G     5352.87      2623.81  5917.94          115342.11\n",
       "6          H     5143.08      2934.88  5810.14          111169.85\n",
       "7          I     5838.39      2694.19     0.00          108782.94\n",
       "8          J     5144.86      2003.24  4980.06          103376.84\n",
       "9          K     5877.02      2243.26     0.00          119520.58\n",
       "10         L     5625.17      3130.08  6472.22          119310.16\n",
       "11         M     4685.20      5073.34  4912.07          127520.54\n",
       "12         N     5303.47      1809.89  6112.61          119492.81\n",
       "13         O     5641.85      1441.38     0.00          116142.68\n",
       "14         P     4515.34      1808.97  4884.66          105205.24\n",
       "15         Q     5136.80      1856.55  5599.60          112091.75\n",
       "16         R     4729.75      3148.58  6757.58          122674.19\n",
       "17         S     5241.34      2051.02  7199.98          127893.34"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Splitsize must be <=  testgroups/2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " Creating combinations....\n",
      "\n",
      " Time taken in seconds: 29.39\n",
      "\n",
      " Aggregating....\n",
      "\n",
      " Time taken in seconds: 53.78\n",
      "\n",
      " Total number of possible combinations:  24310\n",
      "\n",
      " Creating dataframe...\n",
      "\n",
      " Creating arrays...\n",
      "\n",
      " Array operations...\n",
      "\n",
      " Adding the computed array to dataframe...\n",
      "\n",
      " All Done.\n",
      "\n",
      " Total time in minutes: 0.896\n",
      "\n",
      " Saving the excel file...\n"
     ]
    }
   ],
   "source": [
    "df2 = tga.create(df1,18,9)"
   ]
  },
  {
   "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>testgroup</th>\n",
       "      <th>respin_rev</th>\n",
       "      <th>pr_pack_rev</th>\n",
       "      <th>dbx_rev</th>\n",
       "      <th>total_net_revenue</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ABCEFGHI + JKMOPQRT</td>\n",
       "      <td>3.26</td>\n",
       "      <td>11.89</td>\n",
       "      <td>11.40</td>\n",
       "      <td>1.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ABCEFGHJ + IKMOPQRT</td>\n",
       "      <td>1.67</td>\n",
       "      <td>8.73</td>\n",
       "      <td>27.66</td>\n",
       "      <td>1.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ABCEFGHK + IJMOPQRT</td>\n",
       "      <td>3.35</td>\n",
       "      <td>9.83</td>\n",
       "      <td>11.40</td>\n",
       "      <td>3.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ABCEFGHM + IJKOPQRT</td>\n",
       "      <td>0.61</td>\n",
       "      <td>22.81</td>\n",
       "      <td>27.44</td>\n",
       "      <td>3.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ABCEFGHO + IJKMPQRT</td>\n",
       "      <td>2.81</td>\n",
       "      <td>6.15</td>\n",
       "      <td>11.40</td>\n",
       "      <td>2.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6430</th>\n",
       "      <td>AJKMOQRT + BCEFGHIP</td>\n",
       "      <td>2.41</td>\n",
       "      <td>10.41</td>\n",
       "      <td>9.15</td>\n",
       "      <td>1.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6431</th>\n",
       "      <td>AJKMPQRT + BCEFGHIO</td>\n",
       "      <td>5.00</td>\n",
       "      <td>8.73</td>\n",
       "      <td>6.80</td>\n",
       "      <td>2.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6432</th>\n",
       "      <td>AJKOPQRT + BCEFGHIM</td>\n",
       "      <td>2.80</td>\n",
       "      <td>25.39</td>\n",
       "      <td>9.24</td>\n",
       "      <td>3.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6433</th>\n",
       "      <td>AJMOPQRT + BCEFGHIK</td>\n",
       "      <td>5.54</td>\n",
       "      <td>12.41</td>\n",
       "      <td>6.80</td>\n",
       "      <td>2.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6434</th>\n",
       "      <td>AKMOPQRT + BCEFGHIJ</td>\n",
       "      <td>3.86</td>\n",
       "      <td>11.31</td>\n",
       "      <td>9.46</td>\n",
       "      <td>0.99</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6435 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                testgroup  respin_rev  pr_pack_rev  dbx_rev  total_net_revenue\n",
       "0     ABCEFGHI + JKMOPQRT        3.26        11.89    11.40               1.87\n",
       "1     ABCEFGHJ + IKMOPQRT        1.67         8.73    27.66               1.29\n",
       "2     ABCEFGHK + IJMOPQRT        3.35         9.83    11.40               3.01\n",
       "3     ABCEFGHM + IJKOPQRT        0.61        22.81    27.44               3.86\n",
       "4     ABCEFGHO + IJKMPQRT        2.81         6.15    11.40               2.65\n",
       "...                   ...         ...          ...      ...                ...\n",
       "6430  AJKMOQRT + BCEFGHIP        2.41        10.41     9.15               1.19\n",
       "6431  AJKMPQRT + BCEFGHIO        5.00         8.73     6.80               2.35\n",
       "6432  AJKOPQRT + BCEFGHIM        2.80        25.39     9.24               3.56\n",
       "6433  AJMOPQRT + BCEFGHIK        5.54        12.41     6.80               2.71\n",
       "6434  AKMOPQRT + BCEFGHIJ        3.86        11.31     9.46               0.99\n",
       "\n",
       "[6435 rows x 5 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "df3 = tga.optimize(df2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "scrolled": false
   },
   "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>testgroup</th>\n",
       "      <th>respin_rev</th>\n",
       "      <th>pr_pack_rev</th>\n",
       "      <th>dbx_rev</th>\n",
       "      <th>total_net_revenue</th>\n",
       "      <th>wtd_sum</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ACEFGOPQR + BHIJKLMNS</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.97</td>\n",
       "      <td>0.24</td>\n",
       "      <td>0.78</td>\n",
       "      <td>0.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ACEFGJOPR + BHIKLMNQS</td>\n",
       "      <td>0.02</td>\n",
       "      <td>1.56</td>\n",
       "      <td>1.77</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AEFJOPQRS + BCGHIKLMN</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.87</td>\n",
       "      <td>1.64</td>\n",
       "      <td>1.45</td>\n",
       "      <td>0.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ACEFJKPQR + BGHILMNOS</td>\n",
       "      <td>0.02</td>\n",
       "      <td>1.71</td>\n",
       "      <td>2.56</td>\n",
       "      <td>0.03</td>\n",
       "      <td>0.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ACEFJNOPR + BGHIKLMQS</td>\n",
       "      <td>0.12</td>\n",
       "      <td>1.76</td>\n",
       "      <td>1.29</td>\n",
       "      <td>0.35</td>\n",
       "      <td>0.35</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24305</th>\n",
       "      <td>ACFHJNPQR + BEGIKLMOS</td>\n",
       "      <td>7.66</td>\n",
       "      <td>16.50</td>\n",
       "      <td>26.87</td>\n",
       "      <td>3.49</td>\n",
       "      <td>9.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24306</th>\n",
       "      <td>ACHJNPQRS + BEFGIKLMO</td>\n",
       "      <td>6.75</td>\n",
       "      <td>19.84</td>\n",
       "      <td>32.65</td>\n",
       "      <td>3.96</td>\n",
       "      <td>9.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24307</th>\n",
       "      <td>ACFHNPQRS + BEGIJKLMO</td>\n",
       "      <td>7.46</td>\n",
       "      <td>16.30</td>\n",
       "      <td>32.35</td>\n",
       "      <td>1.18</td>\n",
       "      <td>9.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24308</th>\n",
       "      <td>ACFHJPQRS + BEGIKLMNO</td>\n",
       "      <td>7.78</td>\n",
       "      <td>15.51</td>\n",
       "      <td>29.55</td>\n",
       "      <td>2.70</td>\n",
       "      <td>9.66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24309</th>\n",
       "      <td>ACFJNPQRS + BEGHIKLMO</td>\n",
       "      <td>7.45</td>\n",
       "      <td>20.11</td>\n",
       "      <td>30.30</td>\n",
       "      <td>1.92</td>\n",
       "      <td>9.76</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>24310 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   testgroup  respin_rev  pr_pack_rev  dbx_rev  \\\n",
       "0      ACEFGOPQR + BHIJKLMNS        0.04         0.97     0.24   \n",
       "1      ACEFGJOPR + BHIKLMNQS        0.02         1.56     1.77   \n",
       "2      AEFJOPQRS + BCGHIKLMN        0.05         0.87     1.64   \n",
       "3      ACEFJKPQR + BGHILMNOS        0.02         1.71     2.56   \n",
       "4      ACEFJNOPR + BGHIKLMQS        0.12         1.76     1.29   \n",
       "...                      ...         ...          ...      ...   \n",
       "24305  ACFHJNPQR + BEGIKLMOS        7.66        16.50    26.87   \n",
       "24306  ACHJNPQRS + BEFGIKLMO        6.75        19.84    32.65   \n",
       "24307  ACFHNPQRS + BEGIJKLMO        7.46        16.30    32.35   \n",
       "24308  ACFHJPQRS + BEGIKLMNO        7.78        15.51    29.55   \n",
       "24309  ACFJNPQRS + BEGHIKLMO        7.45        20.11    30.30   \n",
       "\n",
       "       total_net_revenue  wtd_sum  \n",
       "0                   0.78     0.18  \n",
       "1                   0.04     0.27  \n",
       "2                   1.45     0.34  \n",
       "3                   0.03     0.35  \n",
       "4                   0.35     0.35  \n",
       "...                  ...      ...  \n",
       "24305               3.49     9.50  \n",
       "24306               3.96     9.53  \n",
       "24307               1.18     9.57  \n",
       "24308               2.70     9.66  \n",
       "24309               1.92     9.76  \n",
       "\n",
       "[24310 rows x 6 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}