notebooks/simple_48_well_with_platemap.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "dfb4ea80-bf96-4548-8dcc-b24ff5b8b636",
   "metadata": {},
   "outputs": [],
   "source": [
    "from dotenv import load_dotenv\n",
    "load_dotenv()\n",
    "\n",
    "from functools import reduce\n",
    "from pathlib import Path\n",
    "\n",
    "import pandas as pd\n",
    "from platechain import parse_plates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "cdb3205d-5503-4c28-872d-f94995b4d6ca",
   "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>Unnamed: 0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A</td>\n",
       "      <td>0.065</td>\n",
       "      <td>0.063</td>\n",
       "      <td>0.061</td>\n",
       "      <td>0.07</td>\n",
       "      <td>0.061</td>\n",
       "      <td>0.06</td>\n",
       "      <td>0.065</td>\n",
       "      <td>0.064</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>B</td>\n",
       "      <td>0.188</td>\n",
       "      <td>0.164</td>\n",
       "      <td>0.213</td>\n",
       "      <td>0.219</td>\n",
       "      <td>0.161</td>\n",
       "      <td>0.176</td>\n",
       "      <td>0.184</td>\n",
       "      <td>0.172</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>C</td>\n",
       "      <td>0.207</td>\n",
       "      <td>0.19</td>\n",
       "      <td>0.218</td>\n",
       "      <td>0.19</td>\n",
       "      <td>0.211</td>\n",
       "      <td>0.182</td>\n",
       "      <td>0.215</td>\n",
       "      <td>0.211</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>D</td>\n",
       "      <td>0.076</td>\n",
       "      <td>0.081</td>\n",
       "      <td>0.093</td>\n",
       "      <td>0.071</td>\n",
       "      <td>0.081</td>\n",
       "      <td>0.075</td>\n",
       "      <td>0.106</td>\n",
       "      <td>0.071</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>E</td>\n",
       "      <td>0.076</td>\n",
       "      <td>0.069</td>\n",
       "      <td>0.082</td>\n",
       "      <td>0.099</td>\n",
       "      <td>0.094</td>\n",
       "      <td>0.072</td>\n",
       "      <td>0.086</td>\n",
       "      <td>0.064</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>F</td>\n",
       "      <td>0.08</td>\n",
       "      <td>0.067</td>\n",
       "      <td>0.077</td>\n",
       "      <td>0.067</td>\n",
       "      <td>0.068</td>\n",
       "      <td>0.066</td>\n",
       "      <td>0.069</td>\n",
       "      <td>0.074</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>A</td>\n",
       "      <td>Sample 1</td>\n",
       "      <td>Sample 2</td>\n",
       "      <td>Sample 3</td>\n",
       "      <td>Sample 4</td>\n",
       "      <td>Sample 5</td>\n",
       "      <td>Sample 6</td>\n",
       "      <td>Sample 7</td>\n",
       "      <td>Sample 8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>B</td>\n",
       "      <td>Sample 9</td>\n",
       "      <td>Sample 10</td>\n",
       "      <td>Sample 11</td>\n",
       "      <td>Sample 12</td>\n",
       "      <td>Sample 13</td>\n",
       "      <td>Sample 14</td>\n",
       "      <td>Sample 15</td>\n",
       "      <td>Sample 16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>C</td>\n",
       "      <td>Sample 17</td>\n",
       "      <td>Sample 18</td>\n",
       "      <td>Sample 19</td>\n",
       "      <td>Sample 20</td>\n",
       "      <td>Sample 21</td>\n",
       "      <td>Sample 22</td>\n",
       "      <td>Sample 23</td>\n",
       "      <td>Sample 24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>D</td>\n",
       "      <td>Sample 25</td>\n",
       "      <td>Sample 26</td>\n",
       "      <td>Sample 27</td>\n",
       "      <td>Sample 28</td>\n",
       "      <td>Sample 29</td>\n",
       "      <td>Sample 30</td>\n",
       "      <td>Sample 31</td>\n",
       "      <td>Sample 32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>E</td>\n",
       "      <td>Sample 33</td>\n",
       "      <td>Sample 34</td>\n",
       "      <td>Sample 35</td>\n",
       "      <td>Sample 36</td>\n",
       "      <td>Sample 37</td>\n",
       "      <td>Sample 38</td>\n",
       "      <td>Sample 39</td>\n",
       "      <td>Sample 40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>F</td>\n",
       "      <td>Sample 41</td>\n",
       "      <td>Sample 42</td>\n",
       "      <td>Sample 43</td>\n",
       "      <td>Sample 44</td>\n",
       "      <td>Sample 45</td>\n",
       "      <td>Sample 46</td>\n",
       "      <td>Sample 47</td>\n",
       "      <td>Sample 48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Sample Wavelength (nm)</td>\n",
       "      <td>540</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Reference Wavelength (nm)</td>\n",
       "      <td>-1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Smart Validation</td>\n",
       "      <td>Pass</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Plate Well Assignment</td>\n",
       "      <td>Pass</td>\n",
       "      <td>Measured values of assigned wells indicate cor...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Plate Orientation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Replicates</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Standards</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Unnamed: 0          1  \\\n",
       "0                           A      0.065   \n",
       "1                           B      0.188   \n",
       "2                           C      0.207   \n",
       "3                           D      0.076   \n",
       "4                           E      0.076   \n",
       "5                           F       0.08   \n",
       "6                         NaN        NaN   \n",
       "7                         NaN        NaN   \n",
       "8                         NaN        NaN   \n",
       "9                         NaN        NaN   \n",
       "10                        NaN        NaN   \n",
       "11                        NaN          1   \n",
       "12                          A   Sample 1   \n",
       "13                          B   Sample 9   \n",
       "14                          C  Sample 17   \n",
       "15                          D  Sample 25   \n",
       "16                          E  Sample 33   \n",
       "17                          F  Sample 41   \n",
       "18                        NaN        NaN   \n",
       "19                        NaN        NaN   \n",
       "20                        NaN        NaN   \n",
       "21                        NaN        NaN   \n",
       "22                        NaN        NaN   \n",
       "23     Sample Wavelength (nm)        540   \n",
       "24  Reference Wavelength (nm)         -1   \n",
       "25                        NaN        NaN   \n",
       "26                        NaN        NaN   \n",
       "27                        NaN        NaN   \n",
       "28           Smart Validation       Pass   \n",
       "29      Plate Well Assignment       Pass   \n",
       "30          Plate Orientation        NaN   \n",
       "31                 Replicates        NaN   \n",
       "32                  Standards        NaN   \n",
       "\n",
       "                                                    2          3          4  \\\n",
       "0                                               0.063      0.061       0.07   \n",
       "1                                               0.164      0.213      0.219   \n",
       "2                                                0.19      0.218       0.19   \n",
       "3                                               0.081      0.093      0.071   \n",
       "4                                               0.069      0.082      0.099   \n",
       "5                                               0.067      0.077      0.067   \n",
       "6                                                 NaN        NaN        NaN   \n",
       "7                                                 NaN        NaN        NaN   \n",
       "8                                                 NaN        NaN        NaN   \n",
       "9                                                 NaN        NaN        NaN   \n",
       "10                                                NaN        NaN        NaN   \n",
       "11                                                  2          3          4   \n",
       "12                                           Sample 2   Sample 3   Sample 4   \n",
       "13                                          Sample 10  Sample 11  Sample 12   \n",
       "14                                          Sample 18  Sample 19  Sample 20   \n",
       "15                                          Sample 26  Sample 27  Sample 28   \n",
       "16                                          Sample 34  Sample 35  Sample 36   \n",
       "17                                          Sample 42  Sample 43  Sample 44   \n",
       "18                                                NaN        NaN        NaN   \n",
       "19                                                NaN        NaN        NaN   \n",
       "20                                                NaN        NaN        NaN   \n",
       "21                                                NaN        NaN        NaN   \n",
       "22                                                NaN        NaN        NaN   \n",
       "23                                                NaN        NaN        NaN   \n",
       "24                                                NaN        NaN        NaN   \n",
       "25                                                NaN        NaN        NaN   \n",
       "26                                                NaN        NaN        NaN   \n",
       "27                                                NaN        NaN        NaN   \n",
       "28                                                NaN        NaN        NaN   \n",
       "29  Measured values of assigned wells indicate cor...        NaN        NaN   \n",
       "30                                                NaN        NaN        NaN   \n",
       "31                                                NaN        NaN        NaN   \n",
       "32                                                NaN        NaN        NaN   \n",
       "\n",
       "            5          6          7          8  \n",
       "0       0.061       0.06      0.065      0.064  \n",
       "1       0.161      0.176      0.184      0.172  \n",
       "2       0.211      0.182      0.215      0.211  \n",
       "3       0.081      0.075      0.106      0.071  \n",
       "4       0.094      0.072      0.086      0.064  \n",
       "5       0.068      0.066      0.069      0.074  \n",
       "6         NaN        NaN        NaN        NaN  \n",
       "7         NaN        NaN        NaN        NaN  \n",
       "8         NaN        NaN        NaN        NaN  \n",
       "9         NaN        NaN        NaN        NaN  \n",
       "10        NaN        NaN        NaN        NaN  \n",
       "11          5          6          7          8  \n",
       "12   Sample 5   Sample 6   Sample 7   Sample 8  \n",
       "13  Sample 13  Sample 14  Sample 15  Sample 16  \n",
       "14  Sample 21  Sample 22  Sample 23  Sample 24  \n",
       "15  Sample 29  Sample 30  Sample 31  Sample 32  \n",
       "16  Sample 37  Sample 38  Sample 39  Sample 40  \n",
       "17  Sample 45  Sample 46  Sample 47  Sample 48  \n",
       "18        NaN        NaN        NaN        NaN  \n",
       "19        NaN        NaN        NaN        NaN  \n",
       "20        NaN        NaN        NaN        NaN  \n",
       "21        NaN        NaN        NaN        NaN  \n",
       "22        NaN        NaN        NaN        NaN  \n",
       "23        NaN        NaN        NaN        NaN  \n",
       "24        NaN        NaN        NaN        NaN  \n",
       "25        NaN        NaN        NaN        NaN  \n",
       "26        NaN        NaN        NaN        NaN  \n",
       "27        NaN        NaN        NaN        NaN  \n",
       "28        NaN        NaN        NaN        NaN  \n",
       "29        NaN        NaN        NaN        NaN  \n",
       "30        NaN        NaN        NaN        NaN  \n",
       "31        NaN        NaN        NaN        NaN  \n",
       "32        NaN        NaN        NaN        NaN  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "byonoy_df = pd.read_csv(Path.cwd().parent / 'examples/dummy_48_well_example.csv')\n",
    "# Dataframe contains both results and platemap information\n",
    "byonoy_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "b6eb3700-21a2-4674-b7da-5ed5e51f5d08",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[    row  column well  value\n",
       " 0     1       1  A01  0.065\n",
       " 1     1       2  A02  0.063\n",
       " 2     1       3  A03  0.061\n",
       " 3     1       4  A04   0.07\n",
       " 4     1       5  A05  0.061\n",
       " 5     1       6  A06   0.06\n",
       " 6     1       7  A07  0.065\n",
       " 7     1       8  A08  0.064\n",
       " 8     2       1  B01  0.188\n",
       " 9     2       2  B02  0.164\n",
       " 10    2       3  B03  0.213\n",
       " 11    2       4  B04  0.219\n",
       " 12    2       5  B05  0.161\n",
       " 13    2       6  B06  0.176\n",
       " 14    2       7  B07  0.184\n",
       " 15    2       8  B08  0.172\n",
       " 16    3       1  C01  0.207\n",
       " 17    3       2  C02   0.19\n",
       " 18    3       3  C03  0.218\n",
       " 19    3       4  C04   0.19\n",
       " 20    3       5  C05  0.211\n",
       " 21    3       6  C06  0.182\n",
       " 22    3       7  C07  0.215\n",
       " 23    3       8  C08  0.211\n",
       " 24    4       1  D01  0.076\n",
       " 25    4       2  D02  0.081\n",
       " 26    4       3  D03  0.093\n",
       " 27    4       4  D04  0.071\n",
       " 28    4       5  D05  0.081\n",
       " 29    4       6  D06  0.075\n",
       " 30    4       7  D07  0.106\n",
       " 31    4       8  D08  0.071\n",
       " 32    5       1  E01  0.076\n",
       " 33    5       2  E02  0.069\n",
       " 34    5       3  E03  0.082\n",
       " 35    5       4  E04  0.099\n",
       " 36    5       5  E05  0.094\n",
       " 37    5       6  E06  0.072\n",
       " 38    5       7  E07  0.086\n",
       " 39    5       8  E08  0.064\n",
       " 40    6       1  F01   0.08\n",
       " 41    6       2  F02  0.067\n",
       " 42    6       3  F03  0.077\n",
       " 43    6       4  F04  0.067\n",
       " 44    6       5  F05  0.068\n",
       " 45    6       6  F06  0.066\n",
       " 46    6       7  F07  0.069\n",
       " 47    6       8  F08  0.074,\n",
       "     row  column well      value\n",
       " 0     1       1  A01   Sample 1\n",
       " 1     1       2  A02   Sample 2\n",
       " 2     1       3  A03   Sample 3\n",
       " 3     1       4  A04   Sample 4\n",
       " 4     1       5  A05   Sample 5\n",
       " 5     1       6  A06   Sample 6\n",
       " 6     1       7  A07   Sample 7\n",
       " 7     1       8  A08   Sample 8\n",
       " 8     2       1  B01   Sample 9\n",
       " 9     2       2  B02  Sample 10\n",
       " 10    2       3  B03  Sample 11\n",
       " 11    2       4  B04  Sample 12\n",
       " 12    2       5  B05  Sample 13\n",
       " 13    2       6  B06  Sample 14\n",
       " 14    2       7  B07  Sample 15\n",
       " 15    2       8  B08  Sample 16\n",
       " 16    3       1  C01  Sample 17\n",
       " 17    3       2  C02  Sample 18\n",
       " 18    3       3  C03  Sample 19\n",
       " 19    3       4  C04  Sample 20\n",
       " 20    3       5  C05  Sample 21\n",
       " 21    3       6  C06  Sample 22\n",
       " 22    3       7  C07  Sample 23\n",
       " 23    3       8  C08  Sample 24\n",
       " 24    4       1  D01  Sample 25\n",
       " 25    4       2  D02  Sample 26\n",
       " 26    4       3  D03  Sample 27\n",
       " 27    4       4  D04  Sample 28\n",
       " 28    4       5  D05  Sample 29\n",
       " 29    4       6  D06  Sample 30\n",
       " 30    4       7  D07  Sample 31\n",
       " 31    4       8  D08  Sample 32\n",
       " 32    5       1  E01  Sample 33\n",
       " 33    5       2  E02  Sample 34\n",
       " 34    5       3  E03  Sample 35\n",
       " 35    5       4  E04  Sample 36\n",
       " 36    5       5  E05  Sample 37\n",
       " 37    5       6  E06  Sample 38\n",
       " 38    5       7  E07  Sample 39\n",
       " 39    5       8  E08  Sample 40\n",
       " 40    6       1  F01  Sample 41\n",
       " 41    6       2  F02  Sample 42\n",
       " 42    6       3  F03  Sample 43\n",
       " 43    6       4  F04  Sample 44\n",
       " 44    6       5  F05  Sample 45\n",
       " 45    6       6  F06  Sample 46\n",
       " 46    6       7  F07  Sample 47\n",
       " 47    6       8  F08  Sample 48]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Can optionally add number of plates, number of rows, and number of columns here. \n",
    "res = parse_plates(byonoy_df)\n",
    "res"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "5483371e-62f5-42f1-9ef6-13ae2cc5bef5",
   "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>row</th>\n",
       "      <th>column</th>\n",
       "      <th>well</th>\n",
       "      <th>value_x</th>\n",
       "      <th>value_y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>A01</td>\n",
       "      <td>0.065</td>\n",
       "      <td>Sample 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>A02</td>\n",
       "      <td>0.063</td>\n",
       "      <td>Sample 2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>A03</td>\n",
       "      <td>0.061</td>\n",
       "      <td>Sample 3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>A04</td>\n",
       "      <td>0.07</td>\n",
       "      <td>Sample 4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>A05</td>\n",
       "      <td>0.061</td>\n",
       "      <td>Sample 5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>A06</td>\n",
       "      <td>0.06</td>\n",
       "      <td>Sample 6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>A07</td>\n",
       "      <td>0.065</td>\n",
       "      <td>Sample 7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>A08</td>\n",
       "      <td>0.064</td>\n",
       "      <td>Sample 8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>B01</td>\n",
       "      <td>0.188</td>\n",
       "      <td>Sample 9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>B02</td>\n",
       "      <td>0.164</td>\n",
       "      <td>Sample 10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>B03</td>\n",
       "      <td>0.213</td>\n",
       "      <td>Sample 11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>B04</td>\n",
       "      <td>0.219</td>\n",
       "      <td>Sample 12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>B05</td>\n",
       "      <td>0.161</td>\n",
       "      <td>Sample 13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>B06</td>\n",
       "      <td>0.176</td>\n",
       "      <td>Sample 14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>B07</td>\n",
       "      <td>0.184</td>\n",
       "      <td>Sample 15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>B08</td>\n",
       "      <td>0.172</td>\n",
       "      <td>Sample 16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>C01</td>\n",
       "      <td>0.207</td>\n",
       "      <td>Sample 17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>C02</td>\n",
       "      <td>0.19</td>\n",
       "      <td>Sample 18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>C03</td>\n",
       "      <td>0.218</td>\n",
       "      <td>Sample 19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>C04</td>\n",
       "      <td>0.19</td>\n",
       "      <td>Sample 20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>C05</td>\n",
       "      <td>0.211</td>\n",
       "      <td>Sample 21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>C06</td>\n",
       "      <td>0.182</td>\n",
       "      <td>Sample 22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>C07</td>\n",
       "      <td>0.215</td>\n",
       "      <td>Sample 23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>C08</td>\n",
       "      <td>0.211</td>\n",
       "      <td>Sample 24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>D01</td>\n",
       "      <td>0.076</td>\n",
       "      <td>Sample 25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>D02</td>\n",
       "      <td>0.081</td>\n",
       "      <td>Sample 26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>D03</td>\n",
       "      <td>0.093</td>\n",
       "      <td>Sample 27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>D04</td>\n",
       "      <td>0.071</td>\n",
       "      <td>Sample 28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>D05</td>\n",
       "      <td>0.081</td>\n",
       "      <td>Sample 29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>D06</td>\n",
       "      <td>0.075</td>\n",
       "      <td>Sample 30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>D07</td>\n",
       "      <td>0.106</td>\n",
       "      <td>Sample 31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>D08</td>\n",
       "      <td>0.071</td>\n",
       "      <td>Sample 32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>E01</td>\n",
       "      <td>0.076</td>\n",
       "      <td>Sample 33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>E02</td>\n",
       "      <td>0.069</td>\n",
       "      <td>Sample 34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>E03</td>\n",
       "      <td>0.082</td>\n",
       "      <td>Sample 35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>E04</td>\n",
       "      <td>0.099</td>\n",
       "      <td>Sample 36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>E05</td>\n",
       "      <td>0.094</td>\n",
       "      <td>Sample 37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>E06</td>\n",
       "      <td>0.072</td>\n",
       "      <td>Sample 38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>E07</td>\n",
       "      <td>0.086</td>\n",
       "      <td>Sample 39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>E08</td>\n",
       "      <td>0.064</td>\n",
       "      <td>Sample 40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>F01</td>\n",
       "      <td>0.08</td>\n",
       "      <td>Sample 41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>F02</td>\n",
       "      <td>0.067</td>\n",
       "      <td>Sample 42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>6</td>\n",
       "      <td>3</td>\n",
       "      <td>F03</td>\n",
       "      <td>0.077</td>\n",
       "      <td>Sample 43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>F04</td>\n",
       "      <td>0.067</td>\n",
       "      <td>Sample 44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>F05</td>\n",
       "      <td>0.068</td>\n",
       "      <td>Sample 45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>F06</td>\n",
       "      <td>0.066</td>\n",
       "      <td>Sample 46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>F07</td>\n",
       "      <td>0.069</td>\n",
       "      <td>Sample 47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>F08</td>\n",
       "      <td>0.074</td>\n",
       "      <td>Sample 48</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    row  column well value_x    value_y\n",
       "0     1       1  A01   0.065   Sample 1\n",
       "1     1       2  A02   0.063   Sample 2\n",
       "2     1       3  A03   0.061   Sample 3\n",
       "3     1       4  A04    0.07   Sample 4\n",
       "4     1       5  A05   0.061   Sample 5\n",
       "5     1       6  A06    0.06   Sample 6\n",
       "6     1       7  A07   0.065   Sample 7\n",
       "7     1       8  A08   0.064   Sample 8\n",
       "8     2       1  B01   0.188   Sample 9\n",
       "9     2       2  B02   0.164  Sample 10\n",
       "10    2       3  B03   0.213  Sample 11\n",
       "11    2       4  B04   0.219  Sample 12\n",
       "12    2       5  B05   0.161  Sample 13\n",
       "13    2       6  B06   0.176  Sample 14\n",
       "14    2       7  B07   0.184  Sample 15\n",
       "15    2       8  B08   0.172  Sample 16\n",
       "16    3       1  C01   0.207  Sample 17\n",
       "17    3       2  C02    0.19  Sample 18\n",
       "18    3       3  C03   0.218  Sample 19\n",
       "19    3       4  C04    0.19  Sample 20\n",
       "20    3       5  C05   0.211  Sample 21\n",
       "21    3       6  C06   0.182  Sample 22\n",
       "22    3       7  C07   0.215  Sample 23\n",
       "23    3       8  C08   0.211  Sample 24\n",
       "24    4       1  D01   0.076  Sample 25\n",
       "25    4       2  D02   0.081  Sample 26\n",
       "26    4       3  D03   0.093  Sample 27\n",
       "27    4       4  D04   0.071  Sample 28\n",
       "28    4       5  D05   0.081  Sample 29\n",
       "29    4       6  D06   0.075  Sample 30\n",
       "30    4       7  D07   0.106  Sample 31\n",
       "31    4       8  D08   0.071  Sample 32\n",
       "32    5       1  E01   0.076  Sample 33\n",
       "33    5       2  E02   0.069  Sample 34\n",
       "34    5       3  E03   0.082  Sample 35\n",
       "35    5       4  E04   0.099  Sample 36\n",
       "36    5       5  E05   0.094  Sample 37\n",
       "37    5       6  E06   0.072  Sample 38\n",
       "38    5       7  E07   0.086  Sample 39\n",
       "39    5       8  E08   0.064  Sample 40\n",
       "40    6       1  F01    0.08  Sample 41\n",
       "41    6       2  F02   0.067  Sample 42\n",
       "42    6       3  F03   0.077  Sample 43\n",
       "43    6       4  F04   0.067  Sample 44\n",
       "44    6       5  F05   0.068  Sample 45\n",
       "45    6       6  F06   0.066  Sample 46\n",
       "46    6       7  F07   0.069  Sample 47\n",
       "47    6       8  F08   0.074  Sample 48"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Once you have the plates as tidy dataframes, you can merge them to create a clean dataset\n",
    "merged = reduce(\n",
    "        lambda left, right: pd.merge(left, right, on=['row', 'column', 'well'], how=\"outer\"),\n",
    "        res,\n",
    "    )\n",
    "merged"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4a37b8ba-3836-4131-9656-44dac6116803",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.10.14"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}