best_individual_analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "best_individual = [\n",
    "    [['Break', 'Break', 'Break', 'Break', 'Break', 'Break', 'Break', 'Break'], \n",
    "     ['Subject_2', 'Subject_2', 'Subject_2', 'Break', 'Subject_2', 'Subject_2', 'Subject_2', 'Subject_2'], \n",
    "     ['Subject_9', 'Subject_9', 'Subject_9', 'Subject_9', 'Subject_2', 'Subject_2', 'Subject_9', 'Subject_9'], \n",
    "     ['Subject_9', 'Subject_30', 'Subject_9', 'Break', 'Break', 'Subject_9', 'Subject_30', 'Subject_9'], \n",
    "     ['Subject_30', 'Subject_30', 'Subject_30', 'Break', 'Subject_30', 'Subject_30', 'Subject_30', 'Subject_30']],\n",
    "    [['Subject_6', 'Subject_6', 'Subject_6', 'Break', 'Subject_6', 'Subject_6', 'Subject_6', 'Subject_6'], \n",
    "     ['Subject_29', 'Subject_29', 'Subject_29', 'Subject_29', 'Break', 'Subject_29', 'Subject_29', 'Subject_29'], \n",
    "     ['Subject_6', 'Subject_6', 'Subject_6', 'Subject_29', 'Break', 'Subject_29', 'Subject_6', 'Subject_6'], \n",
    "     ['Subject_6', 'Subject_9', 'Subject_6', 'Subject_9', 'Break', 'Subject_6', 'Subject_6', 'Subject_6'], \n",
    "     ['Subject_9', 'Subject_9', 'Subject_9', 'Break', 'Subject_9', 'Subject_9', 'Subject_9', 'Subject_9']],\n",
    "    [['Subject_20', 'Subject_20', 'Subject_20', 'Subject_20', 'Subject_20', 'Subject_20', 'Subject_20', 'Subject_20'], \n",
    "     ['Subject_4', 'Subject_4', 'Subject_4', 'Subject_4', 'Break', 'Subject_4', 'Subject_23', 'Subject_4'], \n",
    "     ['Subject_23', 'Subject_23', 'Subject_29', 'Break', 'Subject_23', 'Subject_23', 'Subject_29', 'Subject_23'], \n",
    "     ['Subject_4', 'Subject_4', 'Subject_23', 'Subject_23', 'Break', 'Subject_4', 'Subject_4', 'Subject_4'], \n",
    "     ['Subject_29', 'Subject_23', 'Subject_29', 'Subject_29', 'Break', 'Subject_29', 'Subject_29', 'Subject_29']],\n",
    "    [['Subject_17', 'Subject_17', 'Subject_17', 'Subject_17', 'Subject_17', 'Subject_17', 'Subject_17', 'Subject_17'], \n",
    "     ['Subject_7', 'Subject_7', 'Subject_7', 'Subject_7', 'Break', 'Subject_7', 'Subject_7', 'Subject_7'], \n",
    "     ['Subject_12', 'Subject_12', 'Subject_12', 'Subject_12', 'Break', 'Subject_12', 'Subject_12', 'Subject_12'], \n",
    "     ['Subject_7', 'Subject_12', 'Subject_12', 'Subject_12', 'Subject_12', 'Subject_12', 'Subject_7', 'Subject_7'], \n",
    "     ['Subject_10', 'Subject_10', 'Subject_10', 'Subject_10', 'Subject_10', 'Subject_10', 'Subject_10', 'Subject_10']],\n",
    "    [['Subject_15', 'Subject_7', 'Subject_7', 'Subject_7', 'Subject_15', 'Subject_7', 'Subject_15', 'Break'], \n",
    "     ['Subject_20', 'Subject_20', 'Subject_20', 'Subject_20', 'Break', 'Subject_20', 'Subject_20', 'Subject_20'], \n",
    "     ['Subject_7', 'Subject_7', 'Subject_7', 'Subject_7', 'Break', 'Subject_7', 'Subject_7', 'Subject_7'], \n",
    "     ['Subject_20', 'Subject_20', 'Subject_20', 'Break', 'Break', 'Subject_20', 'Subject_20', 'Subject_20'], \n",
    "     ['Subject_15', 'Subject_15', 'Subject_15', 'Subject_15', 'Break', 'Subject_15', 'Subject_15', 'Subject_7']],\n",
    "    [['Subject_13', 'Subject_13', 'Subject_13', 'Break', 'Subject_13', 'Subject_13', 'Subject_13', 'Subject_13'], \n",
    "     ['Subject_14', 'Subject_14', 'Subject_14', 'Break', 'Subject_14', 'Subject_14', 'Subject_14', 'Subject_14'], \n",
    "     ['Subject_15', 'Subject_15', 'Subject_15', 'Break', 'Subject_15', 'Subject_15', 'Subject_15', 'Subject_15'], \n",
    "     ['Subject_14', 'Subject_14', 'Subject_15', 'Break', 'Break', 'Subject_15', 'Subject_15', 'Subject_14'], \n",
    "     ['Subject_13', 'Subject_13', 'Subject_13', 'Break', 'Subject_13', 'Subject_13', 'Subject_13', 'Subject_13']],\n",
    "    [['Subject_29', 'Subject_29', 'Subject_29', 'Subject_29', 'Subject_29', 'Subject_29', 'Subject_29', 'Break'], \n",
    "     ['Break', 'Break', 'Break', 'Break', 'Subject_29', 'Break', 'Break', 'Break'], \n",
    "     ['Subject_21', 'Subject_21', 'Subject_21', 'Break', 'Subject_21', 'Subject_21', 'Subject_21', 'Subject_21'], \n",
    "     ['Subject_21', 'Subject_22', 'Subject_21', 'Subject_21', 'Break', 'Subject_21', 'Subject_21', 'Subject_21'], \n",
    "     ['Subject_22', 'Subject_22', 'Subject_22', 'Break', 'Subject_22', 'Subject_22', 'Subject_22', 'Subject_22']],\n",
    "    [['Subject_10', 'Subject_3', 'Subject_1', 'Break', 'Break', 'Subject_1', 'Subject_10', 'Subject_10'], \n",
    "     ['Subject_1', 'Subject_1', 'Subject_1', 'Subject_1', 'Break', 'Subject_1', 'Subject_1', 'Subject_1'], \n",
    "     ['Subject_17', 'Subject_17', 'Subject_17', 'Subject_17', 'Subject_3', 'Subject_17', 'Subject_17', 'Subject_17'], \n",
    "     ['Subject_10', 'Subject_10', 'Subject_10', 'Subject_10', 'Break', 'Subject_10', 'Subject_10', 'Subject_10'], \n",
    "     ['Subject_3', 'Subject_3', 'Subject_3', 'Break', 'Subject_3', 'Subject_17', 'Subject_3', 'Subject_3']],\n",
    "    [['Subject_22', 'Subject_22', 'Subject_22', 'Break', 'Break', 'Subject_22', 'Subject_22', 'Subject_22'], \n",
    "     ['Subject_22', 'Subject_21', 'Subject_21', 'Break', 'Subject_22', 'Subject_21', 'Subject_21', 'Subject_21'], \n",
    "     ['Subject_22', 'Subject_22', 'Subject_22', 'Break', 'Subject_22', 'Subject_22', 'Subject_22', 'Subject_22'], \n",
    "     ['Subject_2', 'Subject_2', 'Subject_2', 'Break', 'Subject_2', 'Subject_2', 'Subject_2', 'Subject_2'], \n",
    "     ['Subject_21', 'Subject_21', 'Subject_2', 'Subject_21', 'Subject_2', 'Subject_2', 'Subject_21', 'Subject_2']],\n",
    "    [['Subject_16', 'Subject_16', 'Subject_16', 'Subject_16', 'Break', 'Subject_16', 'Subject_16', 'Subject_16'], \n",
    "     ['Subject_8', 'Subject_17', 'Subject_17', 'Break', 'Subject_17', 'Subject_8', 'Subject_17', 'Subject_8'], \n",
    "     ['Subject_8', 'Subject_8', 'Subject_8', 'Break', 'Break', 'Subject_8', 'Subject_8', 'Subject_8'], \n",
    "     ['Subject_8', 'Subject_8', 'Subject_17', 'Break', 'Subject_8', 'Subject_17', 'Subject_16', 'Subject_17'], \n",
    "     ['Subject_17', 'Subject_17', 'Subject_17', 'Break', 'Subject_16', 'Subject_16', 'Subject_17', 'Subject_17']]\n",
    "]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Create dataframe where each Row is a Turn and each Column is a Block - from Monday_Block1 to Friday_Block8"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Combine the blocks for each day into a single row\n",
    "combined_data = [sum(day, []) for day in best_individual]\n",
    "\n",
    "# Define the column names\n",
    "days = [\"Monday\", \"Tuesday\", \"Wednesday\", \"Thursday\", \"Friday\"]\n",
    "columns = [f\"{day}_Block{i+1}\" for day in days for i in range(8)]\n",
    "\n",
    "# Create the DataFrame\n",
    "df = pd.DataFrame(combined_data, columns=columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(10, 40)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>Monday_Block1</th>\n",
       "      <th>Monday_Block2</th>\n",
       "      <th>Monday_Block3</th>\n",
       "      <th>Monday_Block4</th>\n",
       "      <th>Monday_Block5</th>\n",
       "      <th>Monday_Block6</th>\n",
       "      <th>Monday_Block7</th>\n",
       "      <th>Monday_Block8</th>\n",
       "      <th>Tuesday_Block1</th>\n",
       "      <th>Tuesday_Block2</th>\n",
       "      <th>...</th>\n",
       "      <th>Thursday_Block7</th>\n",
       "      <th>Thursday_Block8</th>\n",
       "      <th>Friday_Block1</th>\n",
       "      <th>Friday_Block2</th>\n",
       "      <th>Friday_Block3</th>\n",
       "      <th>Friday_Block4</th>\n",
       "      <th>Friday_Block5</th>\n",
       "      <th>Friday_Block6</th>\n",
       "      <th>Friday_Block7</th>\n",
       "      <th>Friday_Block8</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Break</td>\n",
       "      <td>Break</td>\n",
       "      <td>Break</td>\n",
       "      <td>Break</td>\n",
       "      <td>Break</td>\n",
       "      <td>Break</td>\n",
       "      <td>Break</td>\n",
       "      <td>Break</td>\n",
       "      <td>Subject_2</td>\n",
       "      <td>Subject_2</td>\n",
       "      <td>...</td>\n",
       "      <td>Subject_30</td>\n",
       "      <td>Subject_9</td>\n",
       "      <td>Subject_30</td>\n",
       "      <td>Subject_30</td>\n",
       "      <td>Subject_30</td>\n",
       "      <td>Break</td>\n",
       "      <td>Subject_30</td>\n",
       "      <td>Subject_30</td>\n",
       "      <td>Subject_30</td>\n",
       "      <td>Subject_30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Subject_6</td>\n",
       "      <td>Subject_6</td>\n",
       "      <td>Subject_6</td>\n",
       "      <td>Break</td>\n",
       "      <td>Subject_6</td>\n",
       "      <td>Subject_6</td>\n",
       "      <td>Subject_6</td>\n",
       "      <td>Subject_6</td>\n",
       "      <td>Subject_29</td>\n",
       "      <td>Subject_29</td>\n",
       "      <td>...</td>\n",
       "      <td>Subject_6</td>\n",
       "      <td>Subject_6</td>\n",
       "      <td>Subject_9</td>\n",
       "      <td>Subject_9</td>\n",
       "      <td>Subject_9</td>\n",
       "      <td>Break</td>\n",
       "      <td>Subject_9</td>\n",
       "      <td>Subject_9</td>\n",
       "      <td>Subject_9</td>\n",
       "      <td>Subject_9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Subject_20</td>\n",
       "      <td>Subject_20</td>\n",
       "      <td>Subject_20</td>\n",
       "      <td>Subject_20</td>\n",
       "      <td>Subject_20</td>\n",
       "      <td>Subject_20</td>\n",
       "      <td>Subject_20</td>\n",
       "      <td>Subject_20</td>\n",
       "      <td>Subject_4</td>\n",
       "      <td>Subject_4</td>\n",
       "      <td>...</td>\n",
       "      <td>Subject_4</td>\n",
       "      <td>Subject_4</td>\n",
       "      <td>Subject_29</td>\n",
       "      <td>Subject_23</td>\n",
       "      <td>Subject_29</td>\n",
       "      <td>Subject_29</td>\n",
       "      <td>Break</td>\n",
       "      <td>Subject_29</td>\n",
       "      <td>Subject_29</td>\n",
       "      <td>Subject_29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Subject_17</td>\n",
       "      <td>Subject_17</td>\n",
       "      <td>Subject_17</td>\n",
       "      <td>Subject_17</td>\n",
       "      <td>Subject_17</td>\n",
       "      <td>Subject_17</td>\n",
       "      <td>Subject_17</td>\n",
       "      <td>Subject_17</td>\n",
       "      <td>Subject_7</td>\n",
       "      <td>Subject_7</td>\n",
       "      <td>...</td>\n",
       "      <td>Subject_7</td>\n",
       "      <td>Subject_7</td>\n",
       "      <td>Subject_10</td>\n",
       "      <td>Subject_10</td>\n",
       "      <td>Subject_10</td>\n",
       "      <td>Subject_10</td>\n",
       "      <td>Subject_10</td>\n",
       "      <td>Subject_10</td>\n",
       "      <td>Subject_10</td>\n",
       "      <td>Subject_10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Subject_15</td>\n",
       "      <td>Subject_7</td>\n",
       "      <td>Subject_7</td>\n",
       "      <td>Subject_7</td>\n",
       "      <td>Subject_15</td>\n",
       "      <td>Subject_7</td>\n",
       "      <td>Subject_15</td>\n",
       "      <td>Break</td>\n",
       "      <td>Subject_20</td>\n",
       "      <td>Subject_20</td>\n",
       "      <td>...</td>\n",
       "      <td>Subject_20</td>\n",
       "      <td>Subject_20</td>\n",
       "      <td>Subject_15</td>\n",
       "      <td>Subject_15</td>\n",
       "      <td>Subject_15</td>\n",
       "      <td>Subject_15</td>\n",
       "      <td>Break</td>\n",
       "      <td>Subject_15</td>\n",
       "      <td>Subject_15</td>\n",
       "      <td>Subject_7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Subject_13</td>\n",
       "      <td>Subject_13</td>\n",
       "      <td>Subject_13</td>\n",
       "      <td>Break</td>\n",
       "      <td>Subject_13</td>\n",
       "      <td>Subject_13</td>\n",
       "      <td>Subject_13</td>\n",
       "      <td>Subject_13</td>\n",
       "      <td>Subject_14</td>\n",
       "      <td>Subject_14</td>\n",
       "      <td>...</td>\n",
       "      <td>Subject_15</td>\n",
       "      <td>Subject_14</td>\n",
       "      <td>Subject_13</td>\n",
       "      <td>Subject_13</td>\n",
       "      <td>Subject_13</td>\n",
       "      <td>Break</td>\n",
       "      <td>Subject_13</td>\n",
       "      <td>Subject_13</td>\n",
       "      <td>Subject_13</td>\n",
       "      <td>Subject_13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Subject_29</td>\n",
       "      <td>Subject_29</td>\n",
       "      <td>Subject_29</td>\n",
       "      <td>Subject_29</td>\n",
       "      <td>Subject_29</td>\n",
       "      <td>Subject_29</td>\n",
       "      <td>Subject_29</td>\n",
       "      <td>Break</td>\n",
       "      <td>Break</td>\n",
       "      <td>Break</td>\n",
       "      <td>...</td>\n",
       "      <td>Subject_21</td>\n",
       "      <td>Subject_21</td>\n",
       "      <td>Subject_22</td>\n",
       "      <td>Subject_22</td>\n",
       "      <td>Subject_22</td>\n",
       "      <td>Break</td>\n",
       "      <td>Subject_22</td>\n",
       "      <td>Subject_22</td>\n",
       "      <td>Subject_22</td>\n",
       "      <td>Subject_22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Subject_10</td>\n",
       "      <td>Subject_3</td>\n",
       "      <td>Subject_1</td>\n",
       "      <td>Break</td>\n",
       "      <td>Break</td>\n",
       "      <td>Subject_1</td>\n",
       "      <td>Subject_10</td>\n",
       "      <td>Subject_10</td>\n",
       "      <td>Subject_1</td>\n",
       "      <td>Subject_1</td>\n",
       "      <td>...</td>\n",
       "      <td>Subject_10</td>\n",
       "      <td>Subject_10</td>\n",
       "      <td>Subject_3</td>\n",
       "      <td>Subject_3</td>\n",
       "      <td>Subject_3</td>\n",
       "      <td>Break</td>\n",
       "      <td>Subject_3</td>\n",
       "      <td>Subject_17</td>\n",
       "      <td>Subject_3</td>\n",
       "      <td>Subject_3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Subject_22</td>\n",
       "      <td>Subject_22</td>\n",
       "      <td>Subject_22</td>\n",
       "      <td>Break</td>\n",
       "      <td>Break</td>\n",
       "      <td>Subject_22</td>\n",
       "      <td>Subject_22</td>\n",
       "      <td>Subject_22</td>\n",
       "      <td>Subject_22</td>\n",
       "      <td>Subject_21</td>\n",
       "      <td>...</td>\n",
       "      <td>Subject_2</td>\n",
       "      <td>Subject_2</td>\n",
       "      <td>Subject_21</td>\n",
       "      <td>Subject_21</td>\n",
       "      <td>Subject_2</td>\n",
       "      <td>Subject_21</td>\n",
       "      <td>Subject_2</td>\n",
       "      <td>Subject_2</td>\n",
       "      <td>Subject_21</td>\n",
       "      <td>Subject_2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Subject_16</td>\n",
       "      <td>Subject_16</td>\n",
       "      <td>Subject_16</td>\n",
       "      <td>Subject_16</td>\n",
       "      <td>Break</td>\n",
       "      <td>Subject_16</td>\n",
       "      <td>Subject_16</td>\n",
       "      <td>Subject_16</td>\n",
       "      <td>Subject_8</td>\n",
       "      <td>Subject_17</td>\n",
       "      <td>...</td>\n",
       "      <td>Subject_16</td>\n",
       "      <td>Subject_17</td>\n",
       "      <td>Subject_17</td>\n",
       "      <td>Subject_17</td>\n",
       "      <td>Subject_17</td>\n",
       "      <td>Break</td>\n",
       "      <td>Subject_16</td>\n",
       "      <td>Subject_16</td>\n",
       "      <td>Subject_17</td>\n",
       "      <td>Subject_17</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 40 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  Monday_Block1 Monday_Block2 Monday_Block3 Monday_Block4 Monday_Block5  \\\n",
       "0         Break         Break         Break         Break         Break   \n",
       "1     Subject_6     Subject_6     Subject_6         Break     Subject_6   \n",
       "2    Subject_20    Subject_20    Subject_20    Subject_20    Subject_20   \n",
       "3    Subject_17    Subject_17    Subject_17    Subject_17    Subject_17   \n",
       "4    Subject_15     Subject_7     Subject_7     Subject_7    Subject_15   \n",
       "5    Subject_13    Subject_13    Subject_13         Break    Subject_13   \n",
       "6    Subject_29    Subject_29    Subject_29    Subject_29    Subject_29   \n",
       "7    Subject_10     Subject_3     Subject_1         Break         Break   \n",
       "8    Subject_22    Subject_22    Subject_22         Break         Break   \n",
       "9    Subject_16    Subject_16    Subject_16    Subject_16         Break   \n",
       "\n",
       "  Monday_Block6 Monday_Block7 Monday_Block8 Tuesday_Block1 Tuesday_Block2  \\\n",
       "0         Break         Break         Break      Subject_2      Subject_2   \n",
       "1     Subject_6     Subject_6     Subject_6     Subject_29     Subject_29   \n",
       "2    Subject_20    Subject_20    Subject_20      Subject_4      Subject_4   \n",
       "3    Subject_17    Subject_17    Subject_17      Subject_7      Subject_7   \n",
       "4     Subject_7    Subject_15         Break     Subject_20     Subject_20   \n",
       "5    Subject_13    Subject_13    Subject_13     Subject_14     Subject_14   \n",
       "6    Subject_29    Subject_29         Break          Break          Break   \n",
       "7     Subject_1    Subject_10    Subject_10      Subject_1      Subject_1   \n",
       "8    Subject_22    Subject_22    Subject_22     Subject_22     Subject_21   \n",
       "9    Subject_16    Subject_16    Subject_16      Subject_8     Subject_17   \n",
       "\n",
       "   ... Thursday_Block7 Thursday_Block8 Friday_Block1 Friday_Block2  \\\n",
       "0  ...      Subject_30       Subject_9    Subject_30    Subject_30   \n",
       "1  ...       Subject_6       Subject_6     Subject_9     Subject_9   \n",
       "2  ...       Subject_4       Subject_4    Subject_29    Subject_23   \n",
       "3  ...       Subject_7       Subject_7    Subject_10    Subject_10   \n",
       "4  ...      Subject_20      Subject_20    Subject_15    Subject_15   \n",
       "5  ...      Subject_15      Subject_14    Subject_13    Subject_13   \n",
       "6  ...      Subject_21      Subject_21    Subject_22    Subject_22   \n",
       "7  ...      Subject_10      Subject_10     Subject_3     Subject_3   \n",
       "8  ...       Subject_2       Subject_2    Subject_21    Subject_21   \n",
       "9  ...      Subject_16      Subject_17    Subject_17    Subject_17   \n",
       "\n",
       "  Friday_Block3 Friday_Block4 Friday_Block5 Friday_Block6 Friday_Block7  \\\n",
       "0    Subject_30         Break    Subject_30    Subject_30    Subject_30   \n",
       "1     Subject_9         Break     Subject_9     Subject_9     Subject_9   \n",
       "2    Subject_29    Subject_29         Break    Subject_29    Subject_29   \n",
       "3    Subject_10    Subject_10    Subject_10    Subject_10    Subject_10   \n",
       "4    Subject_15    Subject_15         Break    Subject_15    Subject_15   \n",
       "5    Subject_13         Break    Subject_13    Subject_13    Subject_13   \n",
       "6    Subject_22         Break    Subject_22    Subject_22    Subject_22   \n",
       "7     Subject_3         Break     Subject_3    Subject_17     Subject_3   \n",
       "8     Subject_2    Subject_21     Subject_2     Subject_2    Subject_21   \n",
       "9    Subject_17         Break    Subject_16    Subject_16    Subject_17   \n",
       "\n",
       "  Friday_Block8  \n",
       "0    Subject_30  \n",
       "1     Subject_9  \n",
       "2    Subject_29  \n",
       "3    Subject_10  \n",
       "4     Subject_7  \n",
       "5    Subject_13  \n",
       "6    Subject_22  \n",
       "7     Subject_3  \n",
       "8     Subject_2  \n",
       "9    Subject_17  \n",
       "\n",
       "[10 rows x 40 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "#df.to_excel(\"best_individual.xlsx\", index= True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Count of Blocks per Subject for each Turn, and Breaks"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "# List of unique subjects including 'Break'\n",
    "unique_subjects = set()\n",
    "for turn in combined_data:\n",
    "    unique_subjects.update(turn)\n",
    "\n",
    "# Count the occurrences of each subject in each Turn\n",
    "subject_counts = []\n",
    "for turn in combined_data:\n",
    "    turn_count = {subject: turn.count(subject) for subject in unique_subjects}\n",
    "    subject_counts.append(turn_count)\n",
    "\n",
    "# Display the counts in a readable format\n",
    "subject_counts_df = pd.DataFrame(subject_counts)\n",
    "subject_counts_df = subject_counts_df.fillna(0).astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>Subject_4</th>\n",
       "      <th>Subject_16</th>\n",
       "      <th>Subject_1</th>\n",
       "      <th>Subject_10</th>\n",
       "      <th>Subject_21</th>\n",
       "      <th>Subject_3</th>\n",
       "      <th>Subject_20</th>\n",
       "      <th>Subject_14</th>\n",
       "      <th>Subject_22</th>\n",
       "      <th>Subject_17</th>\n",
       "      <th>...</th>\n",
       "      <th>Subject_29</th>\n",
       "      <th>Subject_7</th>\n",
       "      <th>Subject_6</th>\n",
       "      <th>Subject_12</th>\n",
       "      <th>Subject_30</th>\n",
       "      <th>Subject_13</th>\n",
       "      <th>Subject_15</th>\n",
       "      <th>Subject_2</th>\n",
       "      <th>Subject_9</th>\n",
       "      <th>Break</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\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>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>10</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\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>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>8</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>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\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>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\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>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</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>14</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>8</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>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</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>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>0</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>11</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0</td>\n",
       "      <td>10</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>12</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>0</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Subject_4  Subject_16  Subject_1  Subject_10  Subject_21  Subject_3  \\\n",
       "0          0           0          0           0           0          0   \n",
       "1          0           0          0           0           0          0   \n",
       "2         11           0          0           0           0          0   \n",
       "3          0           0          0           8           0          0   \n",
       "4          0           0          0           0           0          0   \n",
       "5          0           0          0           0           0          0   \n",
       "6          0           0          0           0          13          0   \n",
       "7          0           0          9          10           0          8   \n",
       "8          0           0          0           0           9          0   \n",
       "9          0          10          0           0           0          0   \n",
       "\n",
       "   Subject_20  Subject_14  Subject_22  Subject_17  ...  Subject_29  Subject_7  \\\n",
       "0           0           0           0           0  ...           0          0   \n",
       "1           0           0           0           0  ...           9          0   \n",
       "2           8           0           0           0  ...           8          0   \n",
       "3           0           0           0           8  ...           0         10   \n",
       "4          13           0           0           0  ...           0         12   \n",
       "5           0          10           0           0  ...           0          0   \n",
       "6           0           0           8           0  ...           8          0   \n",
       "7           0           0           0           8  ...           0          0   \n",
       "8           0           0          15           0  ...           0          0   \n",
       "9           0           0           0          12  ...           0          0   \n",
       "\n",
       "   Subject_6  Subject_12  Subject_30  Subject_13  Subject_15  Subject_2  \\\n",
       "0          0           0           9           0           0          9   \n",
       "1         17           0           0           0           0          0   \n",
       "2          0           0           0           0           0          0   \n",
       "3          0          12           0           0           0          0   \n",
       "4          0           0           0           0           9          0   \n",
       "5          0           0           0          14          10          0   \n",
       "6          0           0           0           0           0          0   \n",
       "7          0           0           0           0           0          0   \n",
       "8          0           0           0           0           0         11   \n",
       "9          0           0           0           0           0          0   \n",
       "\n",
       "   Subject_9  Break  \n",
       "0         10     12  \n",
       "1          9      5  \n",
       "2          0      4  \n",
       "3          0      2  \n",
       "4          0      6  \n",
       "5          0      6  \n",
       "6          0     11  \n",
       "7          0      5  \n",
       "8          0      5  \n",
       "9          0      6  \n",
       "\n",
       "[10 rows x 22 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "subject_counts_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Days without Breaks for each Turn"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[1, 0, 1, 3, 0, 0, 0, 1, 1, 0]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Define a function to count the number of days without 'Break' for each turn\n",
    "def count_days_without_break(turn):\n",
    "    days_without_break = 0\n",
    "    for i in range(0, 40, 8):  # Iterate through each day (8 blocks)\n",
    "        if 'Break' not in turn[i:i+8]:\n",
    "            days_without_break += 1\n",
    "    return days_without_break\n",
    "\n",
    "# Apply the function to each turn and store the results\n",
    "days_without_break_counts = [count_days_without_break(turn) for turn in combined_data]\n",
    "\n",
    "# Display the results\n",
    "days_without_break_counts"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Overlaps"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{}"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "overlaps = {}\n",
    "for col in df.columns:\n",
    "    value_counts = df[col].value_counts()\n",
    "    for value, count in value_counts.items():\n",
    "        if value != \"Break\" and count > 1:\n",
    "            if col not in overlaps:\n",
    "                overlaps[col] = []\n",
    "            overlaps[col].append(value)\n",
    "\n",
    "# Display the overlaps\n",
    "overlaps"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "There are no overlaps in our individual!"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "cifo_env",
   "language": "python",
   "name": "cifo_env"
  },
  "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.10.11"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}