visPrep.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "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>Algorithm</th>\n",
       "      <th>Type</th>\n",
       "      <th>Phase</th>\n",
       "      <th>Sub-phase</th>\n",
       "      <th>Position</th>\n",
       "      <th>MAE</th>\n",
       "      <th>RMSE</th>\n",
       "      <th>R^2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Decision Trees</td>\n",
       "      <td>Random Forest</td>\n",
       "      <td>Multioutput</td>\n",
       "      <td>Downselected, Standardized Features</td>\n",
       "      <td>QB</td>\n",
       "      <td>60.0</td>\n",
       "      <td>76.0</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Decision Trees</td>\n",
       "      <td>Random Forest</td>\n",
       "      <td>Multioutput</td>\n",
       "      <td>Downselected, Standardized Features</td>\n",
       "      <td>RB</td>\n",
       "      <td>41.1</td>\n",
       "      <td>63.0</td>\n",
       "      <td>0.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Decision Trees</td>\n",
       "      <td>Random Forest</td>\n",
       "      <td>Multioutput</td>\n",
       "      <td>Downselected, Standardized Features</td>\n",
       "      <td>TE</td>\n",
       "      <td>22.1</td>\n",
       "      <td>30.3</td>\n",
       "      <td>0.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Decision Trees</td>\n",
       "      <td>Random Forest</td>\n",
       "      <td>Multioutput</td>\n",
       "      <td>Downselected, Standardized Features</td>\n",
       "      <td>WR</td>\n",
       "      <td>36.9</td>\n",
       "      <td>53.5</td>\n",
       "      <td>0.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Decision Trees</td>\n",
       "      <td>Random Forest</td>\n",
       "      <td>Multioutput</td>\n",
       "      <td>Optimized</td>\n",
       "      <td>QB</td>\n",
       "      <td>61.4</td>\n",
       "      <td>76.8</td>\n",
       "      <td>0.37</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>Regression</td>\n",
       "      <td>Ridge</td>\n",
       "      <td>Season Total Data</td>\n",
       "      <td>Hyperparameter Optimization</td>\n",
       "      <td>All</td>\n",
       "      <td>31.6</td>\n",
       "      <td>47.3</td>\n",
       "      <td>0.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229</th>\n",
       "      <td>SVM</td>\n",
       "      <td>Kernel Ridge (Linear)</td>\n",
       "      <td>Season Total Data</td>\n",
       "      <td>Base Model</td>\n",
       "      <td>All</td>\n",
       "      <td>29.9</td>\n",
       "      <td>50.4</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>SVM</td>\n",
       "      <td>Kernel Ridge (Linear)</td>\n",
       "      <td>Season Total Data</td>\n",
       "      <td>Hyperparameter Optimization</td>\n",
       "      <td>All</td>\n",
       "      <td>29.9</td>\n",
       "      <td>50.3</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231</th>\n",
       "      <td>SVM</td>\n",
       "      <td>Kernel Ridge (Linear)</td>\n",
       "      <td>Season Total Data</td>\n",
       "      <td>Manual Feature Selection</td>\n",
       "      <td>All</td>\n",
       "      <td>29.7</td>\n",
       "      <td>50.2</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>SVM</td>\n",
       "      <td>Kernel Ridge (Linear)</td>\n",
       "      <td>Season Total Data</td>\n",
       "      <td>Standardization</td>\n",
       "      <td>All</td>\n",
       "      <td>51.7</td>\n",
       "      <td>67.7</td>\n",
       "      <td>-0.13</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>233 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          Algorithm                   Type              Phase  \\\n",
       "0    Decision Trees          Random Forest        Multioutput   \n",
       "1    Decision Trees          Random Forest        Multioutput   \n",
       "2    Decision Trees          Random Forest        Multioutput   \n",
       "3    Decision Trees          Random Forest        Multioutput   \n",
       "4    Decision Trees          Random Forest        Multioutput   \n",
       "..              ...                    ...                ...   \n",
       "228      Regression                  Ridge  Season Total Data   \n",
       "229             SVM  Kernel Ridge (Linear)  Season Total Data   \n",
       "230             SVM  Kernel Ridge (Linear)  Season Total Data   \n",
       "231             SVM  Kernel Ridge (Linear)  Season Total Data   \n",
       "232             SVM  Kernel Ridge (Linear)  Season Total Data   \n",
       "\n",
       "                               Sub-phase Position   MAE  RMSE   R^2  \n",
       "0    Downselected, Standardized Features       QB  60.0  76.0  0.38  \n",
       "1    Downselected, Standardized Features       RB  41.1  63.0  0.39  \n",
       "2    Downselected, Standardized Features       TE  22.1  30.3  0.45  \n",
       "3    Downselected, Standardized Features       WR  36.9  53.5  0.44  \n",
       "4                              Optimized       QB  61.4  76.8  0.37  \n",
       "..                                   ...      ...   ...   ...   ...  \n",
       "228          Hyperparameter Optimization      All  31.6  47.3  0.45  \n",
       "229                           Base Model      All  29.9  50.4  0.38  \n",
       "230          Hyperparameter Optimization      All  29.9  50.3  0.38  \n",
       "231             Manual Feature Selection      All  29.7  50.2  0.38  \n",
       "232                      Standardization      All  51.7  67.7 -0.13  \n",
       "\n",
       "[233 rows x 8 columns]"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "df = pd.read_excel('modelIterations.xlsx', header=[0,1,2], index=False, index_col=[0,1,2])\n",
    "\n",
    "df = df.unstack().stack(level=[0,1,2]).reset_index()\n",
    "\n",
    "df = df.rename(columns={'level_0':'Algorithm', 'level_1':'Type', 'level_2':'Phase', 'level_3':'Sub-phase', 'level_4':'Position'})\n",
    "\n",
    "df.to_csv('res.csv')\n",
    "\n",
    "df"
   ]
  }
 ],
 "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.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}