notebooks/simple_with_platemap.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "dfb4ea80-bf96-4548-8dcc-b24ff5b8b636",
   "metadata": {},
   "outputs": [],
   "source": [
    "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",
       "      <th>9</th>\n",
       "      <th>10</th>\n",
       "      <th>11</th>\n",
       "      <th>12</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.070</td>\n",
       "      <td>0.061</td>\n",
       "      <td>0.060</td>\n",
       "      <td>0.065</td>\n",
       "      <td>0.064</td>\n",
       "      <td>0.063</td>\n",
       "      <td>0.063</td>\n",
       "      <td>0.059</td>\n",
       "      <td>0.073</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",
       "      <td>0.176</td>\n",
       "      <td>0.164</td>\n",
       "      <td>0.181</td>\n",
       "      <td>0.173</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>C</td>\n",
       "      <td>0.207</td>\n",
       "      <td>0.190</td>\n",
       "      <td>0.218</td>\n",
       "      <td>0.190</td>\n",
       "      <td>0.211</td>\n",
       "      <td>0.182</td>\n",
       "      <td>0.215</td>\n",
       "      <td>0.211</td>\n",
       "      <td>0.187</td>\n",
       "      <td>0.184</td>\n",
       "      <td>0.208</td>\n",
       "      <td>0.171</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",
       "      <td>0.073</td>\n",
       "      <td>0.084</td>\n",
       "      <td>0.076</td>\n",
       "      <td>0.081</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",
       "      <td>0.070</td>\n",
       "      <td>0.067</td>\n",
       "      <td>0.068</td>\n",
       "      <td>0.074</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>F</td>\n",
       "      <td>0.080</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",
       "      <td>0.068</td>\n",
       "      <td>0.078</td>\n",
       "      <td>0.065</td>\n",
       "      <td>0.066</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>G</td>\n",
       "      <td>0.061</td>\n",
       "      <td>0.076</td>\n",
       "      <td>0.063</td>\n",
       "      <td>0.069</td>\n",
       "      <td>0.083</td>\n",
       "      <td>0.074</td>\n",
       "      <td>0.071</td>\n",
       "      <td>0.067</td>\n",
       "      <td>0.066</td>\n",
       "      <td>0.067</td>\n",
       "      <td>0.067</td>\n",
       "      <td>0.068</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>H</td>\n",
       "      <td>0.080</td>\n",
       "      <td>0.090</td>\n",
       "      <td>0.074</td>\n",
       "      <td>0.066</td>\n",
       "      <td>0.074</td>\n",
       "      <td>0.075</td>\n",
       "      <td>0.076</td>\n",
       "      <td>0.079</td>\n",
       "      <td>0.071</td>\n",
       "      <td>0.066</td>\n",
       "      <td>0.063</td>\n",
       "      <td>0.069</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</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",
       "      <td>9</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</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",
       "      <td>Sample 9</td>\n",
       "      <td>Sample 10</td>\n",
       "      <td>Sample 11</td>\n",
       "      <td>Sample 12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>B</td>\n",
       "      <td>Sample 13</td>\n",
       "      <td>Sample 14</td>\n",
       "      <td>Sample 15</td>\n",
       "      <td>Sample 16</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>11</th>\n",
       "      <td>C</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",
       "      <td>Sample 33</td>\n",
       "      <td>Sample 34</td>\n",
       "      <td>Sample 35</td>\n",
       "      <td>Sample 36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>D</td>\n",
       "      <td>Sample 37</td>\n",
       "      <td>Sample 38</td>\n",
       "      <td>Sample 39</td>\n",
       "      <td>Sample 40</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>13</th>\n",
       "      <td>E</td>\n",
       "      <td>Sample 49</td>\n",
       "      <td>Sample 50</td>\n",
       "      <td>Sample 51</td>\n",
       "      <td>Sample 52</td>\n",
       "      <td>Sample 53</td>\n",
       "      <td>Sample 54</td>\n",
       "      <td>Sample 55</td>\n",
       "      <td>Sample 56</td>\n",
       "      <td>Sample 57</td>\n",
       "      <td>Sample 58</td>\n",
       "      <td>Sample 59</td>\n",
       "      <td>Sample 60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>F</td>\n",
       "      <td>Sample 61</td>\n",
       "      <td>Sample 62</td>\n",
       "      <td>Sample 63</td>\n",
       "      <td>Sample 64</td>\n",
       "      <td>Sample 65</td>\n",
       "      <td>Sample 66</td>\n",
       "      <td>Sample 67</td>\n",
       "      <td>Sample 68</td>\n",
       "      <td>Sample 69</td>\n",
       "      <td>Sample 70</td>\n",
       "      <td>Sample 71</td>\n",
       "      <td>Sample 72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>G</td>\n",
       "      <td>Sample 73</td>\n",
       "      <td>Sample 74</td>\n",
       "      <td>Sample 75</td>\n",
       "      <td>Sample 76</td>\n",
       "      <td>Sample 77</td>\n",
       "      <td>Sample 78</td>\n",
       "      <td>Sample 79</td>\n",
       "      <td>Sample 80</td>\n",
       "      <td>Sample 81</td>\n",
       "      <td>Sample 82</td>\n",
       "      <td>Sample 83</td>\n",
       "      <td>Sample 84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>H</td>\n",
       "      <td>Sample 85</td>\n",
       "      <td>Sample 86</td>\n",
       "      <td>Sample 87</td>\n",
       "      <td>Sample 88</td>\n",
       "      <td>Sample 89</td>\n",
       "      <td>Sample 90</td>\n",
       "      <td>Sample 91</td>\n",
       "      <td>Sample 92</td>\n",
       "      <td>Sample 93</td>\n",
       "      <td>Sample 94</td>\n",
       "      <td>Sample 95</td>\n",
       "      <td>Sample 96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</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",
       "      <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>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",
       "      <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>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",
       "      <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>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",
       "      <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>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",
       "      <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>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",
       "      <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.080   \n",
       "6                           G      0.061   \n",
       "7                           H      0.080   \n",
       "8                         NaN          1   \n",
       "9                           A   Sample 1   \n",
       "10                          B  Sample 13   \n",
       "11                          C  Sample 25   \n",
       "12                          D  Sample 37   \n",
       "13                          E  Sample 49   \n",
       "14                          F  Sample 61   \n",
       "15                          G  Sample 73   \n",
       "16                          H  Sample 85   \n",
       "17     Sample Wavelength (nm)        540   \n",
       "18  Reference Wavelength (nm)         -1   \n",
       "19           Smart Validation       Pass   \n",
       "20      Plate Well Assignment       Pass   \n",
       "21          Plate Orientation        NaN   \n",
       "22                 Replicates        NaN   \n",
       "23                  Standards        NaN   \n",
       "\n",
       "                                                    2          3          4  \\\n",
       "0                                               0.063      0.061      0.070   \n",
       "1                                               0.164      0.213      0.219   \n",
       "2                                               0.190      0.218      0.190   \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                                               0.076      0.063      0.069   \n",
       "7                                               0.090      0.074      0.066   \n",
       "8                                                   2          3          4   \n",
       "9                                            Sample 2   Sample 3   Sample 4   \n",
       "10                                          Sample 14  Sample 15  Sample 16   \n",
       "11                                          Sample 26  Sample 27  Sample 28   \n",
       "12                                          Sample 38  Sample 39  Sample 40   \n",
       "13                                          Sample 50  Sample 51  Sample 52   \n",
       "14                                          Sample 62  Sample 63  Sample 64   \n",
       "15                                          Sample 74  Sample 75  Sample 76   \n",
       "16                                          Sample 86  Sample 87  Sample 88   \n",
       "17                                                NaN        NaN        NaN   \n",
       "18                                                NaN        NaN        NaN   \n",
       "19                                                NaN        NaN        NaN   \n",
       "20  Measured values of assigned wells indicate cor...        NaN        NaN   \n",
       "21                                                NaN        NaN        NaN   \n",
       "22                                                NaN        NaN        NaN   \n",
       "23                                                NaN        NaN        NaN   \n",
       "\n",
       "            5          6          7          8          9         10  \\\n",
       "0       0.061      0.060      0.065      0.064      0.063      0.063   \n",
       "1       0.161      0.176      0.184      0.172      0.176      0.164   \n",
       "2       0.211      0.182      0.215      0.211      0.187      0.184   \n",
       "3       0.081      0.075      0.106      0.071      0.073      0.084   \n",
       "4       0.094      0.072      0.086      0.064      0.070      0.067   \n",
       "5       0.068      0.066      0.069      0.074      0.068      0.078   \n",
       "6       0.083      0.074      0.071      0.067      0.066      0.067   \n",
       "7       0.074      0.075      0.076      0.079      0.071      0.066   \n",
       "8           5          6          7          8          9         10   \n",
       "9    Sample 5   Sample 6   Sample 7   Sample 8   Sample 9  Sample 10   \n",
       "10  Sample 17  Sample 18  Sample 19  Sample 20  Sample 21  Sample 22   \n",
       "11  Sample 29  Sample 30  Sample 31  Sample 32  Sample 33  Sample 34   \n",
       "12  Sample 41  Sample 42  Sample 43  Sample 44  Sample 45  Sample 46   \n",
       "13  Sample 53  Sample 54  Sample 55  Sample 56  Sample 57  Sample 58   \n",
       "14  Sample 65  Sample 66  Sample 67  Sample 68  Sample 69  Sample 70   \n",
       "15  Sample 77  Sample 78  Sample 79  Sample 80  Sample 81  Sample 82   \n",
       "16  Sample 89  Sample 90  Sample 91  Sample 92  Sample 93  Sample 94   \n",
       "17        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "18        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "19        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "20        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "21        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "22        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "23        NaN        NaN        NaN        NaN        NaN        NaN   \n",
       "\n",
       "           11         12  \n",
       "0       0.059      0.073  \n",
       "1       0.181      0.173  \n",
       "2       0.208      0.171  \n",
       "3       0.076      0.081  \n",
       "4       0.068      0.074  \n",
       "5       0.065      0.066  \n",
       "6       0.067      0.068  \n",
       "7       0.063      0.069  \n",
       "8          11         12  \n",
       "9   Sample 11  Sample 12  \n",
       "10  Sample 23  Sample 24  \n",
       "11  Sample 35  Sample 36  \n",
       "12  Sample 47  Sample 48  \n",
       "13  Sample 59  Sample 60  \n",
       "14  Sample 71  Sample 72  \n",
       "15  Sample 83  Sample 84  \n",
       "16  Sample 95  Sample 96  \n",
       "17        NaN        NaN  \n",
       "18        NaN        NaN  \n",
       "19        NaN        NaN  \n",
       "20        NaN        NaN  \n",
       "21        NaN        NaN  \n",
       "22        NaN        NaN  \n",
       "23        NaN        NaN  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "byonoy_df = pd.read_csv(Path.cwd().parent / 'examples/byonoy_absolute_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": {},
   "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.070\n",
       " 4     1       5  A05  0.061\n",
       " ..  ...     ...  ...    ...\n",
       " 91    8       8  H08  0.079\n",
       " 92    8       9  H09  0.071\n",
       " 93    8      10  H10  0.066\n",
       " 94    8      11  H11  0.063\n",
       " 95    8      12  H12  0.069\n",
       " \n",
       " [96 rows x 4 columns],\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",
       " ..  ...     ...  ...        ...\n",
       " 91    8       8  H08  Sample 92\n",
       " 92    8       9  H09  Sample 93\n",
       " 93    8      10  H10  Sample 94\n",
       " 94    8      11  H11  Sample 95\n",
       " 95    8      12  H12  Sample 96\n",
       " \n",
       " [96 rows x 4 columns]]"
      ]
     },
     "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.070</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>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>H08</td>\n",
       "      <td>0.079</td>\n",
       "      <td>Sample 92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>H09</td>\n",
       "      <td>0.071</td>\n",
       "      <td>Sample 93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>H10</td>\n",
       "      <td>0.066</td>\n",
       "      <td>Sample 94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>8</td>\n",
       "      <td>11</td>\n",
       "      <td>H11</td>\n",
       "      <td>0.063</td>\n",
       "      <td>Sample 95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>H12</td>\n",
       "      <td>0.069</td>\n",
       "      <td>Sample 96</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>96 rows × 5 columns</p>\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.070   Sample 4\n",
       "4     1       5  A05   0.061   Sample 5\n",
       "..  ...     ...  ...     ...        ...\n",
       "91    8       8  H08   0.079  Sample 92\n",
       "92    8       9  H09   0.071  Sample 93\n",
       "93    8      10  H10   0.066  Sample 94\n",
       "94    8      11  H11   0.063  Sample 95\n",
       "95    8      12  H12   0.069  Sample 96\n",
       "\n",
       "[96 rows x 5 columns]"
      ]
     },
     "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"
   ]
  }
 ],
 "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.11"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}