BOTorch_optimization_individual_volume.ipynb

{
 "cells": [
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Optimization of OT2 transfer paramters of viscous liquids guided by Baysesian Optimization"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Summary\n",
    "\n",
    "This notebook objective is to generate new suggestions of aspiration and dispense rates that will minimize the tansfer error while minimizing the time of transfer of a viscous liquid. \n",
    "The code is strucutred as follows:\n",
    "1.  Fisrt section is for importing the relevant packages to perform BO, inclduing Pytorch and BOtorch\n",
    "2.  Second section includes the definition of the BO_LiqTransfer class that includes the method optimized_suggestions() that generates BO optimized aspiration and dispense rate values for a particular data set.\n",
    "3.  Third section includes the code to run in conjuction with the OT2 BO optimization of a viscous liquid. The steps for the optimziation are:\n",
    "\n",
    "    i. Initilize a BO_LiTransfer objecet and load initilization data using data_from_csv() method\n",
    "\n",
    "    ii. Run optimized_suggestions() method\n",
    "\n",
    "    iii. Run liquid transfer using the best suggestion for aspiration and dispense rates in OT2 notebook\n",
    "\n",
    "    iv. Update latest %error obtained from the transfer using suggested aspiration and dispense rates.\n",
    "    \n",
    "    v. Iterate through steps ii-iV\n",
    " "
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 1. Imports"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# basic dependencies\n",
    "\n",
    "import numpy as np\n",
    "from numpy import loadtxt\n",
    "from numpy import savetxt\n",
    "\n",
    "import pandas as pd\n",
    "import math\n",
    "import time\n",
    "from datetime import date\n",
    "\n",
    "np.set_printoptions(formatter={'float': lambda x: \"{0:0.3f}\".format(x)})\n",
    "\n",
    "###########\n",
    "\n",
    "# torch dependencies\n",
    "import torch\n",
    "\n",
    "tkwargs = {\"dtype\": torch.double, # set as double to minimize zero error for cholesky decomposition error\n",
    "           \"device\": torch.device(\"cuda:0\" if torch.cuda.is_available() else \"cpu\")} # set tensors to GPU, if multiple GPUs please set cuda:x properly\n",
    "\n",
    "torch.set_printoptions(precision=3)\n",
    "\n",
    "###########\n",
    "\n",
    "# botorch dependencies\n",
    "import botorch\n",
    "\n",
    "# data related\n",
    "from botorch.utils.sampling import draw_sobol_samples\n",
    "from botorch.utils.transforms import unnormalize, normalize\n",
    "\n",
    "# surrogate model specific\n",
    "from botorch.models.gp_regression import SingleTaskGP\n",
    "from botorch.models.model_list_gp_regression import ModelListGP\n",
    "from botorch.models.transforms.outcome import Standardize\n",
    "from gpytorch.mlls.sum_marginal_log_likelihood import SumMarginalLogLikelihood\n",
    "from botorch import fit_gpytorch_model\n",
    "\n",
    "# qNEHVI specific\n",
    "from botorch.acquisition.multi_objective.objective import IdentityMCMultiOutputObjective\n",
    "from botorch.acquisition.multi_objective.monte_carlo import qNoisyExpectedHypervolumeImprovement\n",
    "\n",
    "# utilities\n",
    "from botorch.optim.optimize import optimize_acqf\n",
    "from botorch.sampling import SobolQMCNormalSampler\n",
    "from botorch.utils.multi_objective.pareto import is_non_dominated\n",
    "from botorch.utils.multi_objective.hypervolume import Hypervolume\n",
    "from typing import Optional\n",
    "from torch import Tensor\n",
    "from botorch.exceptions import BadInitialCandidatesWarning\n",
    "\n",
    "from gpytorch.constraints import GreaterThan\n",
    "from torch.optim import SGD\n",
    "from gpytorch.mlls import ExactMarginalLogLikelihood\n",
    "\n",
    "import warnings\n",
    "\n",
    "warnings.filterwarnings('ignore', category=BadInitialCandidatesWarning)\n",
    "warnings.filterwarnings('ignore', category=RuntimeWarning)\n",
    "\n",
    "# plotting dependencies\n",
    "import matplotlib\n",
    "from matplotlib import pyplot as plt\n",
    "%matplotlib inline\n",
    "\n",
    "SMALL_SIZE = 14\n",
    "MEDIUM_SIZE = 18\n",
    "BIGGER_SIZE = 20\n",
    "\n",
    "plt.rc('axes', titlesize=SMALL_SIZE)     # fontsize of the axes title\n",
    "plt.rc('axes', labelsize=MEDIUM_SIZE)    # fontsize of the x and y labels\n",
    "plt.rc('xtick', labelsize=SMALL_SIZE)    # fontsize of the tick labels\n",
    "plt.rc('ytick', labelsize=SMALL_SIZE)    # fontsize of the tick labels\n",
    "plt.rc('legend', fontsize=SMALL_SIZE)    # legend fontsize\n",
    "plt.rc('figure', titlesize=BIGGER_SIZE)  # fontsize of the figure title\n"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 2. BO_LiqTransfer class"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "class BO_LiqTransfer:\n",
    "\n",
    "    def __init__(self, liquid_name):\n",
    "        self.liquid_name = liquid_name\n",
    "        self._data = None\n",
    "        self.features = ['aspiration_rate','dispense_rate']\n",
    "        self.objectives = ['%error','time_asp_1000']\n",
    "        self.bmax = 1.25\n",
    "        self.bmin = 0.1\n",
    "        self._latest_suggestion = None\n",
    "        self._latest_volume = None\n",
    "        self._latest_acq_value = None\n",
    "    \n",
    "\n",
    "    def set_data(self,df):\n",
    "        df['time_asp_1000'] = 1000/df['aspiration_rate'] + 1000/df['dispense_rate'] + df['delay_aspirate'] + df['delay_dispense']\n",
    "        if 'acq_value' not in df.columns:\n",
    "            df['acq_value'] = None\n",
    "        self._data = df\n",
    "\n",
    "    def data_from_csv(self,file_name):\n",
    "        data = pd.read_csv(file_name)\n",
    "        data = data.loc[:,['liquid','pipette','volume','aspiration_rate','dispense_rate','blow_out_rate','delay_aspirate','delay_dispense','delay_blow_out','%error']]\n",
    "        self.set_data(data)\n",
    "\n",
    "\n",
    "    def update_data(self,error):\n",
    "        updated_data = pd.concat([self._data,self._data.iloc[[-1]]],ignore_index=True)\n",
    "        updated_data.loc[updated_data.last_valid_index(),'volume'] = self._latest_volume\n",
    "        updated_data.loc[updated_data.last_valid_index(),'aspiration_rate']  = self._latest_suggestion['aspiration_rate']\n",
    "        updated_data.loc[updated_data.last_valid_index(),'dispense_rate']  = self._latest_suggestion['dispense_rate']\n",
    "        updated_data.loc[updated_data.last_valid_index(),'acq_value']  = self._latest_acq_value\n",
    "        updated_data.loc[updated_data.last_valid_index(),'%error'] = error\n",
    "        self.set_data(updated_data)\n",
    "        return self._data\n",
    "                                \n",
    "\n",
    "    def xy_split(self, volume=1000):\n",
    "        x_train = self._data[self.features].copy().where(self._data['volume']==volume).dropna(how='all') \n",
    "        y_train = self._data[self.objectives].copy().where(self._data['volume']==volume).dropna(how='all') \n",
    "        return x_train,y_train\n",
    "        \n",
    "\n",
    "    def set_bounds(self, x_train):\n",
    "        return torch.vstack([x_train[0]*self.bmin, x_train[0]*self.bmax])\n",
    "\n",
    "\n",
    "\n",
    "    def fit_surrogate(self, volume= 1000):\n",
    "        x_train, y_train = self.xy_split(volume=volume)\n",
    "        x_train = torch.tensor(x_train.to_numpy(), **tkwargs)\n",
    "        y_train = torch.tensor(y_train.to_numpy(), **tkwargs)\n",
    "        y_train[:,0] = -torch.absolute(y_train[:,0])\n",
    "        y_train[:,1] = -torch.absolute(y_train[:,1])\n",
    "\n",
    "        problem_bounds = self.set_bounds(x_train)\n",
    "        time_upper = 1000/problem_bounds[0][0] +1000/problem_bounds[0][1] + 10\n",
    "        error_upper = np.absolute(y_train[:,0].numpy()).min()*1.25\n",
    "        ref_point = torch.tensor([-error_upper,-time_upper], **tkwargs)\n",
    "\n",
    "        train_x_gp = normalize(x_train, problem_bounds)\n",
    "        models = []\n",
    "        for i in range(y_train.shape[-1]):\n",
    "            models.append(SingleTaskGP(train_x_gp, y_train[..., i : i + 1], outcome_transform=Standardize(m=1)))\n",
    "        model1 = ModelListGP(*models)\n",
    "        mll1 = SumMarginalLogLikelihood(model1.likelihood, model1)\n",
    "\n",
    "        fit_gpytorch_model(mll1)\n",
    "    \n",
    "        return model1, ref_point, train_x_gp, problem_bounds\n",
    "    \n",
    "    def optimized_suggestions(self, volume= 1000, random_state= 42):\n",
    "        self._latest_volume = volume\n",
    "        if random_state != None:\n",
    "            torch.manual_seed(random_state) \n",
    "        standard_bounds = torch.zeros(2, len(self.features), **tkwargs)\n",
    "        standard_bounds[1] = 1\n",
    "        model1, ref_point, train_x_gp, problem_bounds = self.fit_surrogate(volume=volume)\n",
    "        acq_func1 = qNoisyExpectedHypervolumeImprovement(\n",
    "        model=model1,\n",
    "        ref_point=ref_point, # for computing HV, must flip for BoTorch\n",
    "        X_baseline=train_x_gp, # feed total list of train_x for this current iteration\n",
    "        sampler=SobolQMCNormalSampler(sample_shape=512),  # determines how candidates are randomly proposed before selection\n",
    "        objective=IdentityMCMultiOutputObjective(outcomes=np.arange(len(self.objectives)).tolist()), # optimize first n_obj col \n",
    "        prune_baseline=True, cache_pending=True)  # options for improving qNEHVI, keep these on\n",
    "        sobol1 = draw_sobol_samples(bounds=standard_bounds,n=512, q=1).squeeze(1)\n",
    "        sobol2 = draw_sobol_samples(bounds=standard_bounds,n=512, q=1).squeeze(1)\n",
    "        sobol_all = torch.vstack([sobol1, sobol2])\n",
    "            \n",
    "        acq_value_list = []\n",
    "        for i in range(0, sobol_all.shape[0]):\n",
    "            with torch.no_grad():\n",
    "                acq_value = acq_func1(sobol_all[i].unsqueeze(dim=0))\n",
    "                acq_value_list.append(acq_value.item())\n",
    "                \n",
    "        # filter the best 12 QMC candidates first\n",
    "        sorted_x = sobol_all.cpu().numpy()[np.argsort((acq_value_list))]\n",
    "        qnehvi_x = torch.tensor(sorted_x[-12:], **tkwargs)  \n",
    "        # unormalize our training inputs back to original problem bounds\n",
    "        new_x =  unnormalize(qnehvi_x, bounds=problem_bounds)\n",
    "        new_x = pd.DataFrame(new_x.numpy(),columns=['aspiration_rate','dispense_rate'])\n",
    "        new_x['acq_values'] = sorted(acq_value_list, reverse=True)[:12]\n",
    "        self._latest_suggestion = new_x[['aspiration_rate','dispense_rate']].iloc[0]\n",
    "        self._latest_acq_value = new_x['acq_values'].iloc[0] \n",
    "        return new_x\n",
    "        \n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "        \n",
    "    \n",
    "    \n"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 3. Guided BO optimization\n",
    "i.   Create BO_LiqTransfer object and load data set.\n",
    "\n",
    "Please set liquid name and volume to transfer according to the experiment."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>liquid</th>\n",
       "      <th>pipette</th>\n",
       "      <th>volume</th>\n",
       "      <th>aspiration_rate</th>\n",
       "      <th>dispense_rate</th>\n",
       "      <th>blow_out_rate</th>\n",
       "      <th>delay_aspirate</th>\n",
       "      <th>delay_dispense</th>\n",
       "      <th>delay_blow_out</th>\n",
       "      <th>%error</th>\n",
       "      <th>time_asp_1000</th>\n",
       "      <th>acq_value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>22.061005</td>\n",
       "      <td>22.061005</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-15.934066</td>\n",
       "      <td>100.657700</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>500</td>\n",
       "      <td>22.061005</td>\n",
       "      <td>22.061005</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-29.212454</td>\n",
       "      <td>100.657700</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>22.061005</td>\n",
       "      <td>22.061005</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-37.080281</td>\n",
       "      <td>100.657700</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-24.015568</td>\n",
       "      <td>82.526160</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>500</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-31.524725</td>\n",
       "      <td>82.526160</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-34.790904</td>\n",
       "      <td>82.526160</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-4.521520</td>\n",
       "      <td>499.551578</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>500</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-3.296703</td>\n",
       "      <td>499.551578</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5.883700</td>\n",
       "      <td>499.551578</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-9.043040</td>\n",
       "      <td>499.551578</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>500</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-10.416667</td>\n",
       "      <td>499.551578</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-8.730159</td>\n",
       "      <td>499.551578</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>2.003205</td>\n",
       "      <td>916.576807</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>500</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>3.708791</td>\n",
       "      <td>916.576807</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>16.262210</td>\n",
       "      <td>916.576807</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>17.916117</td>\n",
       "      <td>5.497443</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-8.928571</td>\n",
       "      <td>247.718432</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>500</td>\n",
       "      <td>17.085379</td>\n",
       "      <td>4.055253</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-9.546703</td>\n",
       "      <td>315.123302</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>20.068075</td>\n",
       "      <td>4.646839</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-13.347070</td>\n",
       "      <td>275.030422</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>7.796307</td>\n",
       "      <td>14.719089</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-8.390568</td>\n",
       "      <td>206.204852</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>500</td>\n",
       "      <td>3.360299</td>\n",
       "      <td>12.875949</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-7.532051</td>\n",
       "      <td>385.256744</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>3.492819</td>\n",
       "      <td>17.546750</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-15.102259</td>\n",
       "      <td>353.292305</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>8.808699</td>\n",
       "      <td>2.590972</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0.583791</td>\n",
       "      <td>509.479700</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>500</td>\n",
       "      <td>8.678091</td>\n",
       "      <td>5.029741</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-2.472527</td>\n",
       "      <td>324.050109</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>25.976865</td>\n",
       "      <td>6.855167</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-25.175519</td>\n",
       "      <td>194.371153</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>5.894619</td>\n",
       "      <td>7.881091</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-2.369505</td>\n",
       "      <td>306.532248</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>500</td>\n",
       "      <td>6.012369</td>\n",
       "      <td>6.890593</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-0.915751</td>\n",
       "      <td>321.449177</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>13.436717</td>\n",
       "      <td>4.390610</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-7.509158</td>\n",
       "      <td>312.181749</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>5.160444</td>\n",
       "      <td>3.459446</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>1.659799</td>\n",
       "      <td>492.845410</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>500</td>\n",
       "      <td>4.471689</td>\n",
       "      <td>5.297171</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0.824176</td>\n",
       "      <td>422.409165</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>11.233147</td>\n",
       "      <td>9.084766</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-14.148352</td>\n",
       "      <td>209.096628</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>19.863642</td>\n",
       "      <td>2.595325</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-9.951160</td>\n",
       "      <td>445.651461</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>12.242798</td>\n",
       "      <td>3.517569</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-3.083028</td>\n",
       "      <td>375.967918</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>8.869361</td>\n",
       "      <td>27.064008</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-31.852869</td>\n",
       "      <td>159.697139</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                liquid pipette  volume  aspiration_rate  dispense_rate  \\\n",
       "0   Viscosity_std_1275   p1000    1000        22.061005      22.061005   \n",
       "1   Viscosity_std_1275   p1000     500        22.061005      22.061005   \n",
       "2   Viscosity_std_1275   p1000     300        22.061005      22.061005   \n",
       "3   Viscosity_std_1275   p1000    1000        27.576257      27.576257   \n",
       "4   Viscosity_std_1275   p1000     500        27.576257      27.576257   \n",
       "5   Viscosity_std_1275   p1000     300        27.576257      27.576257   \n",
       "6   Viscosity_std_1275   p1000    1000        27.576257       2.206101   \n",
       "7   Viscosity_std_1275   p1000     500        27.576257       2.206101   \n",
       "8   Viscosity_std_1275   p1000     300        27.576257       2.206101   \n",
       "9   Viscosity_std_1275   p1000    1000         2.206101      27.576257   \n",
       "10  Viscosity_std_1275   p1000     500         2.206101      27.576257   \n",
       "11  Viscosity_std_1275   p1000     300         2.206101      27.576257   \n",
       "12  Viscosity_std_1275   p1000    1000         2.206101       2.206101   \n",
       "13  Viscosity_std_1275   p1000     500         2.206101       2.206101   \n",
       "14  Viscosity_std_1275   p1000     300         2.206101       2.206101   \n",
       "15  Viscosity_std_1275   p1000    1000        17.916117       5.497443   \n",
       "16  Viscosity_std_1275   p1000     500        17.085379       4.055253   \n",
       "17  Viscosity_std_1275   p1000     300        20.068075       4.646839   \n",
       "18  Viscosity_std_1275   p1000    1000         7.796307      14.719089   \n",
       "19  Viscosity_std_1275   p1000     500         3.360299      12.875949   \n",
       "20  Viscosity_std_1275   p1000     300         3.492819      17.546750   \n",
       "21  Viscosity_std_1275   p1000    1000         8.808699       2.590972   \n",
       "22  Viscosity_std_1275   p1000     500         8.678091       5.029741   \n",
       "23  Viscosity_std_1275   p1000     300        25.976865       6.855167   \n",
       "24  Viscosity_std_1275   p1000    1000         5.894619       7.881091   \n",
       "25  Viscosity_std_1275   p1000     500         6.012369       6.890593   \n",
       "26  Viscosity_std_1275   p1000     300        13.436717       4.390610   \n",
       "27  Viscosity_std_1275   p1000    1000         5.160444       3.459446   \n",
       "28  Viscosity_std_1275   p1000     500         4.471689       5.297171   \n",
       "29  Viscosity_std_1275   p1000     300        11.233147       9.084766   \n",
       "30  Viscosity_std_1275   p1000     300        19.863642       2.595325   \n",
       "31  Viscosity_std_1275   p1000     300        12.242798       3.517569   \n",
       "32  Viscosity_std_1275   p1000     300         8.869361      27.064008   \n",
       "\n",
       "    blow_out_rate  delay_aspirate  delay_dispense  delay_blow_out     %error  \\\n",
       "0               0               5               5               0 -15.934066   \n",
       "1               0               5               5               0 -29.212454   \n",
       "2               0               5               5               0 -37.080281   \n",
       "3               0               5               5               0 -24.015568   \n",
       "4               0               5               5               0 -31.524725   \n",
       "5               0               5               5               0 -34.790904   \n",
       "6               0               5               5               0  -4.521520   \n",
       "7               0               5               5               0  -3.296703   \n",
       "8               0               5               5               0   5.883700   \n",
       "9               0               5               5               0  -9.043040   \n",
       "10              0               5               5               0 -10.416667   \n",
       "11              0               5               5               0  -8.730159   \n",
       "12              0               5               5               0   2.003205   \n",
       "13              0               5               5               0   3.708791   \n",
       "14              0               5               5               0  16.262210   \n",
       "15              0               5               5               0  -8.928571   \n",
       "16              0               5               5               0  -9.546703   \n",
       "17              0               5               5               0 -13.347070   \n",
       "18              0               5               5               0  -8.390568   \n",
       "19              0               5               5               0  -7.532051   \n",
       "20              0               5               5               0 -15.102259   \n",
       "21              0               5               5               0   0.583791   \n",
       "22              0               5               5               0  -2.472527   \n",
       "23              0               5               5               0 -25.175519   \n",
       "24              0               5               5               0  -2.369505   \n",
       "25              0               5               5               0  -0.915751   \n",
       "26              0               5               5               0  -7.509158   \n",
       "27              0               5               5               0   1.659799   \n",
       "28              0               5               5               0   0.824176   \n",
       "29              0               5               5               0 -14.148352   \n",
       "30              0               5               5               0  -9.951160   \n",
       "31              0               5               5               0  -3.083028   \n",
       "32              0               5               5               0 -31.852869   \n",
       "\n",
       "    time_asp_1000 acq_value  \n",
       "0      100.657700      None  \n",
       "1      100.657700      None  \n",
       "2      100.657700      None  \n",
       "3       82.526160      None  \n",
       "4       82.526160      None  \n",
       "5       82.526160      None  \n",
       "6      499.551578      None  \n",
       "7      499.551578      None  \n",
       "8      499.551578      None  \n",
       "9      499.551578      None  \n",
       "10     499.551578      None  \n",
       "11     499.551578      None  \n",
       "12     916.576807      None  \n",
       "13     916.576807      None  \n",
       "14     916.576807      None  \n",
       "15     247.718432      None  \n",
       "16     315.123302      None  \n",
       "17     275.030422      None  \n",
       "18     206.204852      None  \n",
       "19     385.256744      None  \n",
       "20     353.292305      None  \n",
       "21     509.479700      None  \n",
       "22     324.050109      None  \n",
       "23     194.371153      None  \n",
       "24     306.532248      None  \n",
       "25     321.449177      None  \n",
       "26     312.181749      None  \n",
       "27     492.845410      None  \n",
       "28     422.409165      None  \n",
       "29     209.096628      None  \n",
       "30     445.651461      None  \n",
       "31     375.967918      None  \n",
       "32     159.697139      None  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Change according to experiment\n",
    "liquid_name = 'Viscosity_std_1275' \n",
    "experiment = '3_vol_opt_more_trials_final'  #'1_vol_opt_duplicate_unused' #or '3_vol_opt' \n",
    "\n",
    "# Do not change\n",
    "liq = BO_LiqTransfer(liquid_name)\n",
    "liq.data_from_csv('C:\\\\Users\\\\amdm_\\\\OneDrive\\\\Documents\\\\GitHub\\\\viscosity_liquid_transfer_Pablo\\\\Opentrons_experiments\\\\BOTorch_optimization\\\\VS_code_csv\\\\'+liquid_name+'_'+experiment+'_changed_bounds_correct.csv')\n",
    "    #r'C:\\Users\\amdm_\\OneDrive\\Documents\\GitHub\\viscosity_liquid_transfer_Pablo\\Opentrons_experiments\\BOTorch_optimization\\CCF_initialization\\BOTorch_optimization_CCF_Viscosity_std_1275.csv')\n",
    "liq._data"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "\n",
    "ii.   Run BO_LiqTransfer.optimized_suggestions() method to obtain optimized aspiration and dispense rates.\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "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>aspiration_rate</th>\n",
       "      <th>dispense_rate</th>\n",
       "      <th>acq_values</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>27.310229</td>\n",
       "      <td>15.693270</td>\n",
       "      <td>88.904796</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2.795871</td>\n",
       "      <td>8.644933</td>\n",
       "      <td>86.349336</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>27.536537</td>\n",
       "      <td>15.421011</td>\n",
       "      <td>76.289663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3.309620</td>\n",
       "      <td>8.140592</td>\n",
       "      <td>57.261576</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>8.808699</td>\n",
       "      <td>2.590972</td>\n",
       "      <td>28.253434</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>3.629788</td>\n",
       "      <td>7.213369</td>\n",
       "      <td>27.757961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>3.180184</td>\n",
       "      <td>5.877480</td>\n",
       "      <td>27.344363</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8.440840</td>\n",
       "      <td>2.498218</td>\n",
       "      <td>21.585961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2.547686</td>\n",
       "      <td>8.180616</td>\n",
       "      <td>13.740186</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2.912503</td>\n",
       "      <td>7.289645</td>\n",
       "      <td>13.507388</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2.324162</td>\n",
       "      <td>6.172633</td>\n",
       "      <td>13.423827</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2.700051</td>\n",
       "      <td>6.543393</td>\n",
       "      <td>12.266614</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    aspiration_rate  dispense_rate  acq_values\n",
       "0         27.310229      15.693270   88.904796\n",
       "1          2.795871       8.644933   86.349336\n",
       "2         27.536537      15.421011   76.289663\n",
       "3          3.309620       8.140592   57.261576\n",
       "4          8.808699       2.590972   28.253434\n",
       "5          3.629788       7.213369   27.757961\n",
       "6          3.180184       5.877480   27.344363\n",
       "7          8.440840       2.498218   21.585961\n",
       "8          2.547686       8.180616   13.740186\n",
       "9          2.912503       7.289645   13.507388\n",
       "10         2.324162       6.172633   13.423827\n",
       "11         2.700051       6.543393   12.266614"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "volume = 300\n",
    "liq.optimized_suggestions(volume)\n"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "iii. Run liquid transfer using the best suggestion for aspiration and dispense rates in OT2 notebook.\n",
    "\n",
    "iv. Update latest %error obtained from the transfer using suggested aspiration and dispense rates."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "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>liquid</th>\n",
       "      <th>pipette</th>\n",
       "      <th>volume</th>\n",
       "      <th>aspiration_rate</th>\n",
       "      <th>dispense_rate</th>\n",
       "      <th>blow_out_rate</th>\n",
       "      <th>delay_aspirate</th>\n",
       "      <th>delay_dispense</th>\n",
       "      <th>delay_blow_out</th>\n",
       "      <th>%error</th>\n",
       "      <th>time_asp_1000</th>\n",
       "      <th>acq_value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>22.061005</td>\n",
       "      <td>22.061005</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-15.934066</td>\n",
       "      <td>100.657700</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>500</td>\n",
       "      <td>22.061005</td>\n",
       "      <td>22.061005</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-29.212454</td>\n",
       "      <td>100.657700</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>22.061005</td>\n",
       "      <td>22.061005</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-37.080281</td>\n",
       "      <td>100.657700</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-24.015568</td>\n",
       "      <td>82.526160</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>500</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-31.524725</td>\n",
       "      <td>82.526160</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-34.790904</td>\n",
       "      <td>82.526160</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-4.521520</td>\n",
       "      <td>499.551578</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>500</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-3.296703</td>\n",
       "      <td>499.551578</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5.883700</td>\n",
       "      <td>499.551578</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-9.043040</td>\n",
       "      <td>499.551578</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>500</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-10.416667</td>\n",
       "      <td>499.551578</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-8.730159</td>\n",
       "      <td>499.551578</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>2.003205</td>\n",
       "      <td>916.576807</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>500</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>3.708791</td>\n",
       "      <td>916.576807</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>16.262210</td>\n",
       "      <td>916.576807</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>17.916117</td>\n",
       "      <td>5.497443</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-8.928571</td>\n",
       "      <td>247.718432</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>500</td>\n",
       "      <td>17.085379</td>\n",
       "      <td>4.055253</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-9.546703</td>\n",
       "      <td>315.123302</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>20.068075</td>\n",
       "      <td>4.646839</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-13.347070</td>\n",
       "      <td>275.030422</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>7.796307</td>\n",
       "      <td>14.719089</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-8.390568</td>\n",
       "      <td>206.204852</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>500</td>\n",
       "      <td>3.360299</td>\n",
       "      <td>12.875949</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-7.532051</td>\n",
       "      <td>385.256744</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>3.492819</td>\n",
       "      <td>17.546750</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-15.102259</td>\n",
       "      <td>353.292305</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>8.808699</td>\n",
       "      <td>2.590972</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0.583791</td>\n",
       "      <td>509.479700</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>500</td>\n",
       "      <td>8.678091</td>\n",
       "      <td>5.029741</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-2.472527</td>\n",
       "      <td>324.050109</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>25.976865</td>\n",
       "      <td>6.855167</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-25.175519</td>\n",
       "      <td>194.371153</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>5.894619</td>\n",
       "      <td>7.881091</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-2.369505</td>\n",
       "      <td>306.532248</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>500</td>\n",
       "      <td>6.012369</td>\n",
       "      <td>6.890593</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-0.915751</td>\n",
       "      <td>321.449177</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>13.436717</td>\n",
       "      <td>4.390610</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-7.509158</td>\n",
       "      <td>312.181749</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>5.160444</td>\n",
       "      <td>3.459446</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>1.659799</td>\n",
       "      <td>492.845410</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>500</td>\n",
       "      <td>4.471689</td>\n",
       "      <td>5.297171</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0.824176</td>\n",
       "      <td>422.409165</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>11.233147</td>\n",
       "      <td>9.084766</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-14.148352</td>\n",
       "      <td>209.096628</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>19.863642</td>\n",
       "      <td>2.595325</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-9.951160</td>\n",
       "      <td>445.651461</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>12.242798</td>\n",
       "      <td>3.517569</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-3.083028</td>\n",
       "      <td>375.967918</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>8.869361</td>\n",
       "      <td>27.064008</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-31.852869</td>\n",
       "      <td>159.697139</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>8.532868</td>\n",
       "      <td>2.868048</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0.541819</td>\n",
       "      <td>475.863041</td>\n",
       "      <td>351.950442</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>9.866478</td>\n",
       "      <td>4.270275</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-3.998779</td>\n",
       "      <td>345.530265</td>\n",
       "      <td>253.599993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>2.624286</td>\n",
       "      <td>10.110200</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-6.059219</td>\n",
       "      <td>489.966053</td>\n",
       "      <td>260.282349</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>6.495213</td>\n",
       "      <td>5.530329</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-3.922466</td>\n",
       "      <td>344.780605</td>\n",
       "      <td>214.132523</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>5.984616</td>\n",
       "      <td>9.122200</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-12.622100</td>\n",
       "      <td>286.717785</td>\n",
       "      <td>125.045663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>11.066120</td>\n",
       "      <td>3.374152</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-4.494811</td>\n",
       "      <td>396.736662</td>\n",
       "      <td>117.58014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>7.342814</td>\n",
       "      <td>3.596569</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-3.502747</td>\n",
       "      <td>424.230308</td>\n",
       "      <td>39.219192</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>11.724718</td>\n",
       "      <td>2.938062</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-5.563187</td>\n",
       "      <td>435.650271</td>\n",
       "      <td>35.460298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>15.998308</td>\n",
       "      <td>2.435148</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-9.913004</td>\n",
       "      <td>483.159189</td>\n",
       "      <td>19.298445</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>3.045194</td>\n",
       "      <td>24.032218</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-23.382173</td>\n",
       "      <td>379.997088</td>\n",
       "      <td>14.610252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>3.424946</td>\n",
       "      <td>14.589968</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-16.056166</td>\n",
       "      <td>370.515683</td>\n",
       "      <td>57.418936</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>17.103210</td>\n",
       "      <td>13.982708</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-26.472833</td>\n",
       "      <td>139.985464</td>\n",
       "      <td>20.310437</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>10.558909</td>\n",
       "      <td>2.704181</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-1.785714</td>\n",
       "      <td>474.504508</td>\n",
       "      <td>16.017953</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>8.678091</td>\n",
       "      <td>5.029741</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-8.730159</td>\n",
       "      <td>324.050109</td>\n",
       "      <td>15.470415</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>4.471689</td>\n",
       "      <td>5.297171</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-2.205433</td>\n",
       "      <td>422.409165</td>\n",
       "      <td>18.615898</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>4.155382</td>\n",
       "      <td>5.858973</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-3.197497</td>\n",
       "      <td>421.330119</td>\n",
       "      <td>104.757287</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                liquid pipette  volume  aspiration_rate  dispense_rate  \\\n",
       "0   Viscosity_std_1275   p1000    1000        22.061005      22.061005   \n",
       "1   Viscosity_std_1275   p1000     500        22.061005      22.061005   \n",
       "2   Viscosity_std_1275   p1000     300        22.061005      22.061005   \n",
       "3   Viscosity_std_1275   p1000    1000        27.576257      27.576257   \n",
       "4   Viscosity_std_1275   p1000     500        27.576257      27.576257   \n",
       "5   Viscosity_std_1275   p1000     300        27.576257      27.576257   \n",
       "6   Viscosity_std_1275   p1000    1000        27.576257       2.206101   \n",
       "7   Viscosity_std_1275   p1000     500        27.576257       2.206101   \n",
       "8   Viscosity_std_1275   p1000     300        27.576257       2.206101   \n",
       "9   Viscosity_std_1275   p1000    1000         2.206101      27.576257   \n",
       "10  Viscosity_std_1275   p1000     500         2.206101      27.576257   \n",
       "11  Viscosity_std_1275   p1000     300         2.206101      27.576257   \n",
       "12  Viscosity_std_1275   p1000    1000         2.206101       2.206101   \n",
       "13  Viscosity_std_1275   p1000     500         2.206101       2.206101   \n",
       "14  Viscosity_std_1275   p1000     300         2.206101       2.206101   \n",
       "15  Viscosity_std_1275   p1000    1000        17.916117       5.497443   \n",
       "16  Viscosity_std_1275   p1000     500        17.085379       4.055253   \n",
       "17  Viscosity_std_1275   p1000     300        20.068075       4.646839   \n",
       "18  Viscosity_std_1275   p1000    1000         7.796307      14.719089   \n",
       "19  Viscosity_std_1275   p1000     500         3.360299      12.875949   \n",
       "20  Viscosity_std_1275   p1000     300         3.492819      17.546750   \n",
       "21  Viscosity_std_1275   p1000    1000         8.808699       2.590972   \n",
       "22  Viscosity_std_1275   p1000     500         8.678091       5.029741   \n",
       "23  Viscosity_std_1275   p1000     300        25.976865       6.855167   \n",
       "24  Viscosity_std_1275   p1000    1000         5.894619       7.881091   \n",
       "25  Viscosity_std_1275   p1000     500         6.012369       6.890593   \n",
       "26  Viscosity_std_1275   p1000     300        13.436717       4.390610   \n",
       "27  Viscosity_std_1275   p1000    1000         5.160444       3.459446   \n",
       "28  Viscosity_std_1275   p1000     500         4.471689       5.297171   \n",
       "29  Viscosity_std_1275   p1000     300        11.233147       9.084766   \n",
       "30  Viscosity_std_1275   p1000     300        19.863642       2.595325   \n",
       "31  Viscosity_std_1275   p1000     300        12.242798       3.517569   \n",
       "32  Viscosity_std_1275   p1000     300         8.869361      27.064008   \n",
       "33  Viscosity_std_1275   p1000     300         8.532868       2.868048   \n",
       "34  Viscosity_std_1275   p1000     300         9.866478       4.270275   \n",
       "35  Viscosity_std_1275   p1000     300         2.624286      10.110200   \n",
       "36  Viscosity_std_1275   p1000     300         6.495213       5.530329   \n",
       "37  Viscosity_std_1275   p1000     300         5.984616       9.122200   \n",
       "38  Viscosity_std_1275   p1000     300        11.066120       3.374152   \n",
       "39  Viscosity_std_1275   p1000     300         7.342814       3.596569   \n",
       "40  Viscosity_std_1275   p1000     300        11.724718       2.938062   \n",
       "41  Viscosity_std_1275   p1000     300        15.998308       2.435148   \n",
       "42  Viscosity_std_1275   p1000     300         3.045194      24.032218   \n",
       "43  Viscosity_std_1275   p1000     300         3.424946      14.589968   \n",
       "44  Viscosity_std_1275   p1000     300        17.103210      13.982708   \n",
       "45  Viscosity_std_1275   p1000     300        10.558909       2.704181   \n",
       "46  Viscosity_std_1275   p1000     300         8.678091       5.029741   \n",
       "47  Viscosity_std_1275   p1000     300         4.471689       5.297171   \n",
       "48  Viscosity_std_1275   p1000     300         4.155382       5.858973   \n",
       "\n",
       "    blow_out_rate  delay_aspirate  delay_dispense  delay_blow_out     %error  \\\n",
       "0               0               5               5               0 -15.934066   \n",
       "1               0               5               5               0 -29.212454   \n",
       "2               0               5               5               0 -37.080281   \n",
       "3               0               5               5               0 -24.015568   \n",
       "4               0               5               5               0 -31.524725   \n",
       "5               0               5               5               0 -34.790904   \n",
       "6               0               5               5               0  -4.521520   \n",
       "7               0               5               5               0  -3.296703   \n",
       "8               0               5               5               0   5.883700   \n",
       "9               0               5               5               0  -9.043040   \n",
       "10              0               5               5               0 -10.416667   \n",
       "11              0               5               5               0  -8.730159   \n",
       "12              0               5               5               0   2.003205   \n",
       "13              0               5               5               0   3.708791   \n",
       "14              0               5               5               0  16.262210   \n",
       "15              0               5               5               0  -8.928571   \n",
       "16              0               5               5               0  -9.546703   \n",
       "17              0               5               5               0 -13.347070   \n",
       "18              0               5               5               0  -8.390568   \n",
       "19              0               5               5               0  -7.532051   \n",
       "20              0               5               5               0 -15.102259   \n",
       "21              0               5               5               0   0.583791   \n",
       "22              0               5               5               0  -2.472527   \n",
       "23              0               5               5               0 -25.175519   \n",
       "24              0               5               5               0  -2.369505   \n",
       "25              0               5               5               0  -0.915751   \n",
       "26              0               5               5               0  -7.509158   \n",
       "27              0               5               5               0   1.659799   \n",
       "28              0               5               5               0   0.824176   \n",
       "29              0               5               5               0 -14.148352   \n",
       "30              0               5               5               0  -9.951160   \n",
       "31              0               5               5               0  -3.083028   \n",
       "32              0               5               5               0 -31.852869   \n",
       "33              0               5               5               0   0.541819   \n",
       "34              0               5               5               0  -3.998779   \n",
       "35              0               5               5               0  -6.059219   \n",
       "36              0               5               5               0  -3.922466   \n",
       "37              0               5               5               0 -12.622100   \n",
       "38              0               5               5               0  -4.494811   \n",
       "39              0               5               5               0  -3.502747   \n",
       "40              0               5               5               0  -5.563187   \n",
       "41              0               5               5               0  -9.913004   \n",
       "42              0               5               5               0 -23.382173   \n",
       "43              0               5               5               0 -16.056166   \n",
       "44              0               5               5               0 -26.472833   \n",
       "45              0               5               5               0  -1.785714   \n",
       "46              0               5               5               0  -8.730159   \n",
       "47              0               5               5               0  -2.205433   \n",
       "48              0               5               5               0  -3.197497   \n",
       "\n",
       "    time_asp_1000   acq_value  \n",
       "0      100.657700        None  \n",
       "1      100.657700        None  \n",
       "2      100.657700        None  \n",
       "3       82.526160        None  \n",
       "4       82.526160        None  \n",
       "5       82.526160        None  \n",
       "6      499.551578        None  \n",
       "7      499.551578        None  \n",
       "8      499.551578        None  \n",
       "9      499.551578        None  \n",
       "10     499.551578        None  \n",
       "11     499.551578        None  \n",
       "12     916.576807        None  \n",
       "13     916.576807        None  \n",
       "14     916.576807        None  \n",
       "15     247.718432        None  \n",
       "16     315.123302        None  \n",
       "17     275.030422        None  \n",
       "18     206.204852        None  \n",
       "19     385.256744        None  \n",
       "20     353.292305        None  \n",
       "21     509.479700        None  \n",
       "22     324.050109        None  \n",
       "23     194.371153        None  \n",
       "24     306.532248        None  \n",
       "25     321.449177        None  \n",
       "26     312.181749        None  \n",
       "27     492.845410        None  \n",
       "28     422.409165        None  \n",
       "29     209.096628        None  \n",
       "30     445.651461        None  \n",
       "31     375.967918        None  \n",
       "32     159.697139        None  \n",
       "33     475.863041  351.950442  \n",
       "34     345.530265  253.599993  \n",
       "35     489.966053  260.282349  \n",
       "36     344.780605  214.132523  \n",
       "37     286.717785  125.045663  \n",
       "38     396.736662   117.58014  \n",
       "39     424.230308   39.219192  \n",
       "40     435.650271   35.460298  \n",
       "41     483.159189   19.298445  \n",
       "42     379.997088   14.610252  \n",
       "43     370.515683   57.418936  \n",
       "44     139.985464   20.310437  \n",
       "45     474.504508   16.017953  \n",
       "46     324.050109   15.470415  \n",
       "47     422.409165   18.615898  \n",
       "48     421.330119  104.757287  "
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "liq.update_data(-3.197497)\n"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "v. Iterate trhough last two code cells."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "#save after each standard-experiment iteration\n",
    "liq._data.to_csv('C:\\\\Users\\\\amdm_\\\\OneDrive\\\\Documents\\\\GitHub\\\\viscosity_liquid_transfer_Pablo\\\\Opentrons_experiments\\\\BOTorch_optimization\\\\VS_code_csv\\\\'+liquid_name+'_'+experiment+'_changed_bounds_correct.csv', index = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>liquid</th>\n",
       "      <th>pipette</th>\n",
       "      <th>volume</th>\n",
       "      <th>aspiration_rate</th>\n",
       "      <th>dispense_rate</th>\n",
       "      <th>blow_out_rate</th>\n",
       "      <th>delay_aspirate</th>\n",
       "      <th>delay_dispense</th>\n",
       "      <th>delay_blow_out</th>\n",
       "      <th>%error</th>\n",
       "      <th>time_asp_1000</th>\n",
       "      <th>acq_value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300.0</td>\n",
       "      <td>22.061005</td>\n",
       "      <td>22.061005</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-37.080281</td>\n",
       "      <td>100.657700</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300.0</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-34.790904</td>\n",
       "      <td>82.526160</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300.0</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.883700</td>\n",
       "      <td>499.551578</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300.0</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-8.730159</td>\n",
       "      <td>499.551578</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300.0</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16.262210</td>\n",
       "      <td>916.576807</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300.0</td>\n",
       "      <td>27.441505</td>\n",
       "      <td>10.158198</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-24.145299</td>\n",
       "      <td>144.883811</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300.0</td>\n",
       "      <td>18.388306</td>\n",
       "      <td>6.144974</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-12.736569</td>\n",
       "      <td>227.117009</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300.0</td>\n",
       "      <td>5.766143</td>\n",
       "      <td>18.939569</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-16.704823</td>\n",
       "      <td>236.225674</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300.0</td>\n",
       "      <td>15.258025</td>\n",
       "      <td>4.582396</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-26.091270</td>\n",
       "      <td>293.765715</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300.0</td>\n",
       "      <td>9.548498</td>\n",
       "      <td>25.792442</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-26.701770</td>\n",
       "      <td>153.499566</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300.0</td>\n",
       "      <td>23.071426</td>\n",
       "      <td>5.855900</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-10.905067</td>\n",
       "      <td>224.111607</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300.0</td>\n",
       "      <td>25.824983</td>\n",
       "      <td>5.448700</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-12.240537</td>\n",
       "      <td>232.252216</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300.0</td>\n",
       "      <td>13.126294</td>\n",
       "      <td>14.092762</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-13.652320</td>\n",
       "      <td>157.141374</td>\n",
       "      <td>74.700309</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300.0</td>\n",
       "      <td>20.354842</td>\n",
       "      <td>10.227794</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-16.514042</td>\n",
       "      <td>156.901150</td>\n",
       "      <td>92.834372</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                liquid pipette  volume  aspiration_rate  dispense_rate  \\\n",
       "2   Viscosity_std_1275   p1000   300.0        22.061005      22.061005   \n",
       "5   Viscosity_std_1275   p1000   300.0        27.576257      27.576257   \n",
       "8   Viscosity_std_1275   p1000   300.0        27.576257       2.206101   \n",
       "11  Viscosity_std_1275   p1000   300.0         2.206101      27.576257   \n",
       "14  Viscosity_std_1275   p1000   300.0         2.206101       2.206101   \n",
       "17  Viscosity_std_1275   p1000   300.0        27.441505      10.158198   \n",
       "20  Viscosity_std_1275   p1000   300.0        18.388306       6.144974   \n",
       "23  Viscosity_std_1275   p1000   300.0         5.766143      18.939569   \n",
       "26  Viscosity_std_1275   p1000   300.0        15.258025       4.582396   \n",
       "29  Viscosity_std_1275   p1000   300.0         9.548498      25.792442   \n",
       "32  Viscosity_std_1275   p1000   300.0        23.071426       5.855900   \n",
       "35  Viscosity_std_1275   p1000   300.0        25.824983       5.448700   \n",
       "38  Viscosity_std_1275   p1000   300.0        13.126294      14.092762   \n",
       "41  Viscosity_std_1275   p1000   300.0        20.354842      10.227794   \n",
       "\n",
       "    blow_out_rate  delay_aspirate  delay_dispense  delay_blow_out     %error  \\\n",
       "2             0.0             5.0             5.0             0.0 -37.080281   \n",
       "5             0.0             5.0             5.0             0.0 -34.790904   \n",
       "8             0.0             5.0             5.0             0.0   5.883700   \n",
       "11            0.0             5.0             5.0             0.0  -8.730159   \n",
       "14            0.0             5.0             5.0             0.0  16.262210   \n",
       "17            0.0             5.0             5.0             0.0 -24.145299   \n",
       "20            0.0             5.0             5.0             0.0 -12.736569   \n",
       "23            0.0             5.0             5.0             0.0 -16.704823   \n",
       "26            0.0             5.0             5.0             0.0 -26.091270   \n",
       "29            0.0             5.0             5.0             0.0 -26.701770   \n",
       "32            0.0             5.0             5.0             0.0 -10.905067   \n",
       "35            0.0             5.0             5.0             0.0 -12.240537   \n",
       "38            0.0             5.0             5.0             0.0 -13.652320   \n",
       "41            0.0             5.0             5.0             0.0 -16.514042   \n",
       "\n",
       "    time_asp_1000  acq_value  \n",
       "2      100.657700       None  \n",
       "5       82.526160       None  \n",
       "8      499.551578       None  \n",
       "11     499.551578       None  \n",
       "14     916.576807       None  \n",
       "17     144.883811       None  \n",
       "20     227.117009       None  \n",
       "23     236.225674       None  \n",
       "26     293.765715       None  \n",
       "29     153.499566       None  \n",
       "32     224.111607       None  \n",
       "35     232.252216       None  \n",
       "38     157.141374  74.700309  \n",
       "41     156.901150  92.834372  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "liq._data.where(liq._data.volume==300).dropna(how='all')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "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>liquid</th>\n",
       "      <th>pipette</th>\n",
       "      <th>volume</th>\n",
       "      <th>aspiration_rate</th>\n",
       "      <th>dispense_rate</th>\n",
       "      <th>blow_out_rate</th>\n",
       "      <th>delay_aspirate</th>\n",
       "      <th>delay_dispense</th>\n",
       "      <th>delay_blow_out</th>\n",
       "      <th>%error</th>\n",
       "      <th>time_asp_1000</th>\n",
       "      <th>acq_value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>22.061005</td>\n",
       "      <td>22.061005</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-15.934066</td>\n",
       "      <td>100.657700</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>500</td>\n",
       "      <td>22.061005</td>\n",
       "      <td>22.061005</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-29.212454</td>\n",
       "      <td>100.657700</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>22.061005</td>\n",
       "      <td>22.061005</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-37.080281</td>\n",
       "      <td>100.657700</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-24.015568</td>\n",
       "      <td>82.526160</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>500</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-31.524725</td>\n",
       "      <td>82.526160</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-34.790904</td>\n",
       "      <td>82.526160</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-4.521520</td>\n",
       "      <td>499.551578</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>500</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-3.296703</td>\n",
       "      <td>499.551578</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>5.883700</td>\n",
       "      <td>499.551578</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-9.043040</td>\n",
       "      <td>499.551578</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>500</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-10.416667</td>\n",
       "      <td>499.551578</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>27.576257</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-8.730159</td>\n",
       "      <td>499.551578</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>2.003205</td>\n",
       "      <td>916.576807</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>500</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>3.708791</td>\n",
       "      <td>916.576807</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>2.206101</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>16.262210</td>\n",
       "      <td>916.576807</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>17.916117</td>\n",
       "      <td>5.497443</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-8.928571</td>\n",
       "      <td>247.718432</td>\n",
       "      <td>563.693289</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>500</td>\n",
       "      <td>17.085379</td>\n",
       "      <td>4.055253</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-9.546703</td>\n",
       "      <td>315.123302</td>\n",
       "      <td>972.839669</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>300</td>\n",
       "      <td>20.068075</td>\n",
       "      <td>4.646839</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-13.347070</td>\n",
       "      <td>275.030422</td>\n",
       "      <td>818.538089</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Viscosity_std_1275</td>\n",
       "      <td>p1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>7.796307</td>\n",
       "      <td>14.719089</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>-8.390568</td>\n",
       "      <td>206.204852</td>\n",
       "      <td>310.489079</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                liquid pipette  volume  aspiration_rate  dispense_rate  \\\n",
       "0   Viscosity_std_1275   p1000    1000        22.061005      22.061005   \n",
       "1   Viscosity_std_1275   p1000     500        22.061005      22.061005   \n",
       "2   Viscosity_std_1275   p1000     300        22.061005      22.061005   \n",
       "3   Viscosity_std_1275   p1000    1000        27.576257      27.576257   \n",
       "4   Viscosity_std_1275   p1000     500        27.576257      27.576257   \n",
       "5   Viscosity_std_1275   p1000     300        27.576257      27.576257   \n",
       "6   Viscosity_std_1275   p1000    1000        27.576257       2.206101   \n",
       "7   Viscosity_std_1275   p1000     500        27.576257       2.206101   \n",
       "8   Viscosity_std_1275   p1000     300        27.576257       2.206101   \n",
       "9   Viscosity_std_1275   p1000    1000         2.206101      27.576257   \n",
       "10  Viscosity_std_1275   p1000     500         2.206101      27.576257   \n",
       "11  Viscosity_std_1275   p1000     300         2.206101      27.576257   \n",
       "12  Viscosity_std_1275   p1000    1000         2.206101       2.206101   \n",
       "13  Viscosity_std_1275   p1000     500         2.206101       2.206101   \n",
       "14  Viscosity_std_1275   p1000     300         2.206101       2.206101   \n",
       "15  Viscosity_std_1275   p1000    1000        17.916117       5.497443   \n",
       "16  Viscosity_std_1275   p1000     500        17.085379       4.055253   \n",
       "17  Viscosity_std_1275   p1000     300        20.068075       4.646839   \n",
       "18  Viscosity_std_1275   p1000    1000         7.796307      14.719089   \n",
       "\n",
       "    blow_out_rate  delay_aspirate  delay_dispense  delay_blow_out     %error  \\\n",
       "0               0               5               5               0 -15.934066   \n",
       "1               0               5               5               0 -29.212454   \n",
       "2               0               5               5               0 -37.080281   \n",
       "3               0               5               5               0 -24.015568   \n",
       "4               0               5               5               0 -31.524725   \n",
       "5               0               5               5               0 -34.790904   \n",
       "6               0               5               5               0  -4.521520   \n",
       "7               0               5               5               0  -3.296703   \n",
       "8               0               5               5               0   5.883700   \n",
       "9               0               5               5               0  -9.043040   \n",
       "10              0               5               5               0 -10.416667   \n",
       "11              0               5               5               0  -8.730159   \n",
       "12              0               5               5               0   2.003205   \n",
       "13              0               5               5               0   3.708791   \n",
       "14              0               5               5               0  16.262210   \n",
       "15              0               5               5               0  -8.928571   \n",
       "16              0               5               5               0  -9.546703   \n",
       "17              0               5               5               0 -13.347070   \n",
       "18              0               5               5               0  -8.390568   \n",
       "\n",
       "    time_asp_1000   acq_value  \n",
       "0      100.657700        None  \n",
       "1      100.657700        None  \n",
       "2      100.657700        None  \n",
       "3       82.526160        None  \n",
       "4       82.526160        None  \n",
       "5       82.526160        None  \n",
       "6      499.551578        None  \n",
       "7      499.551578        None  \n",
       "8      499.551578        None  \n",
       "9      499.551578        None  \n",
       "10     499.551578        None  \n",
       "11     499.551578        None  \n",
       "12     916.576807        None  \n",
       "13     916.576807        None  \n",
       "14     916.576807        None  \n",
       "15     247.718432  563.693289  \n",
       "16     315.123302  972.839669  \n",
       "17     275.030422  818.538089  \n",
       "18     206.204852  310.489079  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "liq._data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "base",
   "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.9.7"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}