get_df_run_info.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import run_info_utils"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = run_info_utils.get_df_run_info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>all_correct_stop</th>\n",
       "      <th>batch_size</th>\n",
       "      <th>dev_set_size</th>\n",
       "      <th>experiment_name</th>\n",
       "      <th>hidden_activation</th>\n",
       "      <th>hidden_dimensions</th>\n",
       "      <th>init_all_correct_carry-0_epoch</th>\n",
       "      <th>init_all_correct_carry-12_epoch</th>\n",
       "      <th>init_all_correct_carry-1_epoch</th>\n",
       "      <th>init_all_correct_carry-2_epoch</th>\n",
       "      <th>...</th>\n",
       "      <th>learning_rate</th>\n",
       "      <th>network_input_dimension</th>\n",
       "      <th>network_output_dimension</th>\n",
       "      <th>operand_bits</th>\n",
       "      <th>operator</th>\n",
       "      <th>optimizer</th>\n",
       "      <th>result_bits</th>\n",
       "      <th>run_id</th>\n",
       "      <th>test_set_size</th>\n",
       "      <th>train_set_size</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>True</td>\n",
       "      <td>32</td>\n",
       "      <td>77</td>\n",
       "      <td>test</td>\n",
       "      <td>sigmoid</td>\n",
       "      <td>[64]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.001</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>add</td>\n",
       "      <td>Adam</td>\n",
       "      <td>8</td>\n",
       "      <td>20190304020614</td>\n",
       "      <td>77</td>\n",
       "      <td>179</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>True</td>\n",
       "      <td>32</td>\n",
       "      <td>136</td>\n",
       "      <td>test_h1_record</td>\n",
       "      <td>sigmoid</td>\n",
       "      <td>[64]</td>\n",
       "      <td>1887.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2248.0</td>\n",
       "      <td>3382.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.001</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>subtract</td>\n",
       "      <td>Adam</td>\n",
       "      <td>8</td>\n",
       "      <td>20190302201031</td>\n",
       "      <td>136</td>\n",
       "      <td>136</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>True</td>\n",
       "      <td>32</td>\n",
       "      <td>256</td>\n",
       "      <td>test_h1_record</td>\n",
       "      <td>sigmoid</td>\n",
       "      <td>[64]</td>\n",
       "      <td>764.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1177.0</td>\n",
       "      <td>2470.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.001</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>add</td>\n",
       "      <td>Adam</td>\n",
       "      <td>8</td>\n",
       "      <td>20190301043603</td>\n",
       "      <td>256</td>\n",
       "      <td>256</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>True</td>\n",
       "      <td>32</td>\n",
       "      <td>240</td>\n",
       "      <td>test_h1_record</td>\n",
       "      <td>sigmoid</td>\n",
       "      <td>[64]</td>\n",
       "      <td>2381.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1218.0</td>\n",
       "      <td>1940.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.001</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>divide</td>\n",
       "      <td>Adam</td>\n",
       "      <td>8</td>\n",
       "      <td>20190302201148</td>\n",
       "      <td>240</td>\n",
       "      <td>240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>True</td>\n",
       "      <td>32</td>\n",
       "      <td>240</td>\n",
       "      <td>test_h1_record</td>\n",
       "      <td>sigmoid</td>\n",
       "      <td>[64]</td>\n",
       "      <td>5025.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4595.0</td>\n",
       "      <td>4297.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.001</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>modulo</td>\n",
       "      <td>Adam</td>\n",
       "      <td>8</td>\n",
       "      <td>20190302201207</td>\n",
       "      <td>240</td>\n",
       "      <td>240</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 92 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   all_correct_stop  batch_size  dev_set_size experiment_name  \\\n",
       "0              True          32            77            test   \n",
       "1              True          32           136  test_h1_record   \n",
       "2              True          32           256  test_h1_record   \n",
       "3              True          32           240  test_h1_record   \n",
       "4              True          32           240  test_h1_record   \n",
       "\n",
       "  hidden_activation hidden_dimensions  init_all_correct_carry-0_epoch  \\\n",
       "0           sigmoid              [64]                             NaN   \n",
       "1           sigmoid              [64]                          1887.0   \n",
       "2           sigmoid              [64]                           764.0   \n",
       "3           sigmoid              [64]                          2381.0   \n",
       "4           sigmoid              [64]                          5025.0   \n",
       "\n",
       "   init_all_correct_carry-12_epoch  init_all_correct_carry-1_epoch  \\\n",
       "0                              NaN                             NaN   \n",
       "1                              NaN                          2248.0   \n",
       "2                              NaN                          1177.0   \n",
       "3                              NaN                          1218.0   \n",
       "4                              NaN                          4595.0   \n",
       "\n",
       "   init_all_correct_carry-2_epoch       ...        learning_rate  \\\n",
       "0                             NaN       ...                0.001   \n",
       "1                          3382.0       ...                0.001   \n",
       "2                          2470.0       ...                0.001   \n",
       "3                          1940.0       ...                0.001   \n",
       "4                          4297.0       ...                0.001   \n",
       "\n",
       "   network_input_dimension  network_output_dimension  operand_bits  operator  \\\n",
       "0                        8                         8             4       add   \n",
       "1                        8                         8             4  subtract   \n",
       "2                        8                         8             4       add   \n",
       "3                        8                         8             4    divide   \n",
       "4                        8                         8             4    modulo   \n",
       "\n",
       "   optimizer  result_bits          run_id  test_set_size  train_set_size  \n",
       "0       Adam            8  20190304020614             77             179  \n",
       "1       Adam            8  20190302201031            136             136  \n",
       "2       Adam            8  20190301043603            256             256  \n",
       "3       Adam            8  20190302201148            240             240  \n",
       "4       Adam            8  20190302201207            240             240  \n",
       "\n",
       "[5 rows x 92 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The dataframe has saved as run_info/df_run_info.xlsx.\n",
      "The dataframe has saved as run_info/df_run_info.csv.\n"
     ]
    }
   ],
   "source": [
    "run_info_utils.run_info_to_files()"
   ]
  }
 ],
 "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.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}