new data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "d23e50f6",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import fixation"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "501f59f2",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv(\"new data/eye_tracking_Ha.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "5a1db703",
   "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>Obsv.</th>\n",
       "      <th>Frame</th>\n",
       "      <th>Capture Time</th>\n",
       "      <th>System Time</th>\n",
       "      <th>Sensor Time</th>\n",
       "      <th>Lft X Pos</th>\n",
       "      <th>Lft Y Pos</th>\n",
       "      <th>Lft Pupil Diameter</th>\n",
       "      <th>Rt X Pos</th>\n",
       "      <th>Rt Y Pos</th>\n",
       "      <th>...</th>\n",
       "      <th>Head Rot (X)</th>\n",
       "      <th>Head Rot (Y)</th>\n",
       "      <th>Head Rot (Z)</th>\n",
       "      <th>Head Pos (X)</th>\n",
       "      <th>Head Pos (Y)</th>\n",
       "      <th>Head Pos (Z)</th>\n",
       "      <th>L Eyelid Valid</th>\n",
       "      <th>L Eyelid Opening</th>\n",
       "      <th>R Eyelid Valid</th>\n",
       "      <th>R Eyelid Opening</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>24771</td>\n",
       "      <td>8129229012</td>\n",
       "      <td>1647913378953127</td>\n",
       "      <td>8133865256</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>24772</td>\n",
       "      <td>8129247007</td>\n",
       "      <td>1647913378971128</td>\n",
       "      <td>8133882981</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>24773</td>\n",
       "      <td>8129261008</td>\n",
       "      <td>1647913378985129</td>\n",
       "      <td>8133898057</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>24774</td>\n",
       "      <td>8129275008</td>\n",
       "      <td>1647913378999130</td>\n",
       "      <td>8133914191</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>24775</td>\n",
       "      <td>8129293010</td>\n",
       "      <td>1647913379017131</td>\n",
       "      <td>8133930509</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24683</th>\n",
       "      <td>24684</td>\n",
       "      <td>49454</td>\n",
       "      <td>8529694123</td>\n",
       "      <td>1647913779424033</td>\n",
       "      <td>8536658331</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24684</th>\n",
       "      <td>24685</td>\n",
       "      <td>49455</td>\n",
       "      <td>8529712139</td>\n",
       "      <td>1647913779442034</td>\n",
       "      <td>8536674686</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24685</th>\n",
       "      <td>24686</td>\n",
       "      <td>49456</td>\n",
       "      <td>8529728134</td>\n",
       "      <td>1647913779458035</td>\n",
       "      <td>8536691158</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24686</th>\n",
       "      <td>24687</td>\n",
       "      <td>49457</td>\n",
       "      <td>8529744127</td>\n",
       "      <td>1647913779474035</td>\n",
       "      <td>8536707303</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24687</th>\n",
       "      <td>24688</td>\n",
       "      <td>49458</td>\n",
       "      <td>8529760139</td>\n",
       "      <td>1647913779490036</td>\n",
       "      <td>8536723783</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>24688 rows × 37 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Obsv.  Frame  Capture Time       System Time  Sensor Time  Lft X Pos  \\\n",
       "0          1  24771    8129229012  1647913378953127   8133865256        0.0   \n",
       "1          2  24772    8129247007  1647913378971128   8133882981        0.0   \n",
       "2          3  24773    8129261008  1647913378985129   8133898057        0.0   \n",
       "3          4  24774    8129275008  1647913378999130   8133914191        0.0   \n",
       "4          5  24775    8129293010  1647913379017131   8133930509        0.0   \n",
       "...      ...    ...           ...               ...          ...        ...   \n",
       "24683  24684  49454    8529694123  1647913779424033   8536658331        0.0   \n",
       "24684  24685  49455    8529712139  1647913779442034   8536674686        0.0   \n",
       "24685  24686  49456    8529728134  1647913779458035   8536691158        0.0   \n",
       "24686  24687  49457    8529744127  1647913779474035   8536707303        0.0   \n",
       "24687  24688  49458    8529760139  1647913779490036   8536723783        0.0   \n",
       "\n",
       "       Lft Y Pos  Lft Pupil Diameter  Rt X Pos  Rt Y Pos  ...  Head Rot (X)  \\\n",
       "0            0.0                 0.0       0.0       0.0  ...           0.0   \n",
       "1            0.0                 0.0       0.0       0.0  ...           0.0   \n",
       "2            0.0                 0.0       0.0       0.0  ...           0.0   \n",
       "3            0.0                 0.0       0.0       0.0  ...           0.0   \n",
       "4            0.0                 0.0       0.0       0.0  ...           0.0   \n",
       "...          ...                 ...       ...       ...  ...           ...   \n",
       "24683        0.0                 0.0       0.0       0.0  ...           0.0   \n",
       "24684        0.0                 0.0       0.0       0.0  ...           0.0   \n",
       "24685        0.0                 0.0       0.0       0.0  ...           0.0   \n",
       "24686        0.0                 0.0       0.0       0.0  ...           0.0   \n",
       "24687        0.0                 0.0       0.0       0.0  ...           0.0   \n",
       "\n",
       "       Head Rot (Y)  Head Rot (Z)  Head Pos (X)  Head Pos (Y)  Head Pos (Z)  \\\n",
       "0               0.0           0.0           0.0           0.0           0.0   \n",
       "1               0.0           0.0           0.0           0.0           0.0   \n",
       "2               0.0           0.0           0.0           0.0           0.0   \n",
       "3               0.0           0.0           0.0           0.0           0.0   \n",
       "4               0.0           0.0           0.0           0.0           0.0   \n",
       "...             ...           ...           ...           ...           ...   \n",
       "24683           0.0           0.0           0.0           0.0           0.0   \n",
       "24684           0.0           0.0           0.0           0.0           0.0   \n",
       "24685           0.0           0.0           0.0           0.0           0.0   \n",
       "24686           0.0           0.0           0.0           0.0           0.0   \n",
       "24687           0.0           0.0           0.0           0.0           0.0   \n",
       "\n",
       "       L Eyelid Valid  L Eyelid Opening  R Eyelid Valid  R Eyelid Opening  \n",
       "0                   0               0.0               0               0.0  \n",
       "1                   0               0.0               0               0.0  \n",
       "2                   0               0.0               0               0.0  \n",
       "3                   0               0.0               0               0.0  \n",
       "4                   0               0.0               0               0.0  \n",
       "...               ...               ...             ...               ...  \n",
       "24683               0               0.0               0               0.0  \n",
       "24684               0               0.0               0               0.0  \n",
       "24685               0               0.0               0               0.0  \n",
       "24686               0               0.0               0               0.0  \n",
       "24687               0               0.0               0               0.0  \n",
       "\n",
       "[24688 rows x 37 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "f63f60cb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Obsv.', 'Frame', 'Capture Time', 'System Time', 'Sensor Time',\n",
       "       'Lft X Pos', 'Lft Y Pos', 'Lft Pupil Diameter', 'Rt X Pos', 'Rt Y Pos',\n",
       "       'Rt Pupil Diameter', 'L Display', 'R Display', 'L Quality', 'R Quality',\n",
       "       'L Eye Rot (X)', 'L Eye Rot (Y)', 'L Eye Rot (Z)', 'R Eye Rot (X)',\n",
       "       'R Eye Rot (Y)', 'R Eye Rot (Z)', 'L Eye Pos (X)', 'L Eye Pos (Y)',\n",
       "       'L Eye Pos (Z)', 'R Eye Pos (X)', 'R Eye Pos (Y)', 'R Eye Pos (Z)',\n",
       "       'Head Rot (X)', 'Head Rot (Y)', 'Head Rot (Z)', 'Head Pos (X)',\n",
       "       'Head Pos (Y)', 'Head Pos (Z)', 'L Eyelid Valid', 'L Eyelid Opening',\n",
       "       'R Eyelid Valid', 'R Eyelid Opening'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "ccb7a663",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df[['System Time', 'Lft X Pos', 'Lft Y Pos', 'Lft Pupil Diameter', 'Rt X Pos', 'Rt Y Pos',\n",
    "       'Rt Pupil Diameter', 'L Display', 'R Display', 'L Quality', 'R Quality']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "59f1b341",
   "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>System Time</th>\n",
       "      <th>Lft X Pos</th>\n",
       "      <th>Lft Y Pos</th>\n",
       "      <th>Lft Pupil Diameter</th>\n",
       "      <th>Rt X Pos</th>\n",
       "      <th>Rt Y Pos</th>\n",
       "      <th>Rt Pupil Diameter</th>\n",
       "      <th>L Display</th>\n",
       "      <th>R Display</th>\n",
       "      <th>L Quality</th>\n",
       "      <th>R Quality</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>10869</th>\n",
       "      <td>1647913555301214</td>\n",
       "      <td>500.0691</td>\n",
       "      <td>500.4668</td>\n",
       "      <td>3.095041</td>\n",
       "      <td>500.0691</td>\n",
       "      <td>500.4668</td>\n",
       "      <td>3.303374</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10870</th>\n",
       "      <td>1647913555315214</td>\n",
       "      <td>500.0640</td>\n",
       "      <td>500.4816</td>\n",
       "      <td>3.162473</td>\n",
       "      <td>500.0640</td>\n",
       "      <td>500.4816</td>\n",
       "      <td>3.289466</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10871</th>\n",
       "      <td>1647913555331215</td>\n",
       "      <td>500.0602</td>\n",
       "      <td>500.4692</td>\n",
       "      <td>3.126891</td>\n",
       "      <td>500.0602</td>\n",
       "      <td>500.4692</td>\n",
       "      <td>3.250312</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10872</th>\n",
       "      <td>1647913555347216</td>\n",
       "      <td>500.0633</td>\n",
       "      <td>500.4488</td>\n",
       "      <td>3.202751</td>\n",
       "      <td>500.0633</td>\n",
       "      <td>500.4488</td>\n",
       "      <td>3.202108</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10883</th>\n",
       "      <td>1647913555527226</td>\n",
       "      <td>500.0610</td>\n",
       "      <td>500.4525</td>\n",
       "      <td>3.361325</td>\n",
       "      <td>500.0610</td>\n",
       "      <td>500.4525</td>\n",
       "      <td>3.308391</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10884</th>\n",
       "      <td>1647913555541227</td>\n",
       "      <td>500.0673</td>\n",
       "      <td>500.4527</td>\n",
       "      <td>3.512242</td>\n",
       "      <td>500.0673</td>\n",
       "      <td>500.4527</td>\n",
       "      <td>3.295081</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10885</th>\n",
       "      <td>1647913555559228</td>\n",
       "      <td>500.0720</td>\n",
       "      <td>500.4551</td>\n",
       "      <td>3.463623</td>\n",
       "      <td>500.0720</td>\n",
       "      <td>500.4551</td>\n",
       "      <td>3.332366</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10886</th>\n",
       "      <td>1647913555573229</td>\n",
       "      <td>500.0763</td>\n",
       "      <td>500.4570</td>\n",
       "      <td>3.339823</td>\n",
       "      <td>500.0763</td>\n",
       "      <td>500.4570</td>\n",
       "      <td>3.242193</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10887</th>\n",
       "      <td>1647913555589230</td>\n",
       "      <td>500.0798</td>\n",
       "      <td>500.4582</td>\n",
       "      <td>3.292574</td>\n",
       "      <td>500.0798</td>\n",
       "      <td>500.4582</td>\n",
       "      <td>3.140425</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10888</th>\n",
       "      <td>1647913555607231</td>\n",
       "      <td>500.0837</td>\n",
       "      <td>500.4566</td>\n",
       "      <td>3.158476</td>\n",
       "      <td>500.0837</td>\n",
       "      <td>500.4566</td>\n",
       "      <td>3.096770</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10889</th>\n",
       "      <td>1647913555623232</td>\n",
       "      <td>500.0870</td>\n",
       "      <td>500.4516</td>\n",
       "      <td>3.181434</td>\n",
       "      <td>500.0870</td>\n",
       "      <td>500.4516</td>\n",
       "      <td>3.052048</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12345</th>\n",
       "      <td>1647913579245583</td>\n",
       "      <td>499.9461</td>\n",
       "      <td>500.4567</td>\n",
       "      <td>3.114580</td>\n",
       "      <td>499.9461</td>\n",
       "      <td>500.4567</td>\n",
       "      <td>3.062346</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12346</th>\n",
       "      <td>1647913579263584</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>499.9373</td>\n",
       "      <td>500.4693</td>\n",
       "      <td>3.057730</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12347</th>\n",
       "      <td>1647913579279585</td>\n",
       "      <td>499.9358</td>\n",
       "      <td>500.4745</td>\n",
       "      <td>3.019305</td>\n",
       "      <td>499.9358</td>\n",
       "      <td>500.4745</td>\n",
       "      <td>3.009157</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12348</th>\n",
       "      <td>1647913579295586</td>\n",
       "      <td>499.9316</td>\n",
       "      <td>500.4791</td>\n",
       "      <td>2.942697</td>\n",
       "      <td>499.9316</td>\n",
       "      <td>500.4791</td>\n",
       "      <td>3.004862</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12349</th>\n",
       "      <td>1647913579311587</td>\n",
       "      <td>499.9322</td>\n",
       "      <td>500.4769</td>\n",
       "      <td>2.950537</td>\n",
       "      <td>499.9322</td>\n",
       "      <td>500.4769</td>\n",
       "      <td>2.905807</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12350</th>\n",
       "      <td>1647913579327588</td>\n",
       "      <td>499.9338</td>\n",
       "      <td>500.4713</td>\n",
       "      <td>2.853210</td>\n",
       "      <td>499.9338</td>\n",
       "      <td>500.4713</td>\n",
       "      <td>2.893071</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12351</th>\n",
       "      <td>1647913579343589</td>\n",
       "      <td>499.9358</td>\n",
       "      <td>500.4632</td>\n",
       "      <td>2.903410</td>\n",
       "      <td>499.9358</td>\n",
       "      <td>500.4632</td>\n",
       "      <td>2.885502</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15341</th>\n",
       "      <td>1647913627858364</td>\n",
       "      <td>500.0121</td>\n",
       "      <td>500.4514</td>\n",
       "      <td>3.547176</td>\n",
       "      <td>500.0121</td>\n",
       "      <td>500.4514</td>\n",
       "      <td>3.156311</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15342</th>\n",
       "      <td>1647913627870364</td>\n",
       "      <td>500.0084</td>\n",
       "      <td>500.4539</td>\n",
       "      <td>3.566239</td>\n",
       "      <td>500.0084</td>\n",
       "      <td>500.4539</td>\n",
       "      <td>3.131715</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15343</th>\n",
       "      <td>1647913627888365</td>\n",
       "      <td>500.0066</td>\n",
       "      <td>500.4532</td>\n",
       "      <td>3.451665</td>\n",
       "      <td>500.0066</td>\n",
       "      <td>500.4532</td>\n",
       "      <td>3.185162</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15344</th>\n",
       "      <td>1647913627910367</td>\n",
       "      <td>500.0046</td>\n",
       "      <td>500.4508</td>\n",
       "      <td>3.309560</td>\n",
       "      <td>500.0046</td>\n",
       "      <td>500.4508</td>\n",
       "      <td>3.217217</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22372</th>\n",
       "      <td>1647913741931888</td>\n",
       "      <td>500.2053</td>\n",
       "      <td>500.4420</td>\n",
       "      <td>3.298403</td>\n",
       "      <td>500.2053</td>\n",
       "      <td>500.4420</td>\n",
       "      <td>3.589871</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22373</th>\n",
       "      <td>1647913741945889</td>\n",
       "      <td>500.2056</td>\n",
       "      <td>500.4419</td>\n",
       "      <td>3.346011</td>\n",
       "      <td>500.2056</td>\n",
       "      <td>500.4419</td>\n",
       "      <td>3.574174</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22878</th>\n",
       "      <td>1647913750140358</td>\n",
       "      <td>500.1635</td>\n",
       "      <td>500.4492</td>\n",
       "      <td>3.582032</td>\n",
       "      <td>500.1635</td>\n",
       "      <td>500.4492</td>\n",
       "      <td>3.451210</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22879</th>\n",
       "      <td>1647913750164359</td>\n",
       "      <td>500.1664</td>\n",
       "      <td>500.4555</td>\n",
       "      <td>3.470347</td>\n",
       "      <td>500.1664</td>\n",
       "      <td>500.4555</td>\n",
       "      <td>3.353218</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22880</th>\n",
       "      <td>1647913750172359</td>\n",
       "      <td>500.1681</td>\n",
       "      <td>500.4594</td>\n",
       "      <td>3.488466</td>\n",
       "      <td>500.1681</td>\n",
       "      <td>500.4594</td>\n",
       "      <td>3.303970</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22881</th>\n",
       "      <td>1647913750188360</td>\n",
       "      <td>500.1655</td>\n",
       "      <td>500.4541</td>\n",
       "      <td>3.612791</td>\n",
       "      <td>500.1655</td>\n",
       "      <td>500.4541</td>\n",
       "      <td>3.330090</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23019</th>\n",
       "      <td>1647913752427488</td>\n",
       "      <td>500.1335</td>\n",
       "      <td>500.4570</td>\n",
       "      <td>3.298896</td>\n",
       "      <td>500.1335</td>\n",
       "      <td>500.4570</td>\n",
       "      <td>3.226465</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23020</th>\n",
       "      <td>1647913752443489</td>\n",
       "      <td>500.1344</td>\n",
       "      <td>500.4654</td>\n",
       "      <td>3.277422</td>\n",
       "      <td>500.1344</td>\n",
       "      <td>500.4654</td>\n",
       "      <td>3.213912</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23021</th>\n",
       "      <td>1647913752467491</td>\n",
       "      <td>500.1340</td>\n",
       "      <td>500.4737</td>\n",
       "      <td>3.307116</td>\n",
       "      <td>500.1340</td>\n",
       "      <td>500.4737</td>\n",
       "      <td>3.122159</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23022</th>\n",
       "      <td>1647913752477491</td>\n",
       "      <td>500.1342</td>\n",
       "      <td>500.4790</td>\n",
       "      <td>3.386877</td>\n",
       "      <td>500.1342</td>\n",
       "      <td>500.4790</td>\n",
       "      <td>3.101630</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23023</th>\n",
       "      <td>1647913752493492</td>\n",
       "      <td>500.1341</td>\n",
       "      <td>500.4797</td>\n",
       "      <td>3.442257</td>\n",
       "      <td>500.1341</td>\n",
       "      <td>500.4797</td>\n",
       "      <td>3.122218</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23024</th>\n",
       "      <td>1647913752515494</td>\n",
       "      <td>500.1335</td>\n",
       "      <td>500.4791</td>\n",
       "      <td>3.483852</td>\n",
       "      <td>500.1335</td>\n",
       "      <td>500.4791</td>\n",
       "      <td>3.160255</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23025</th>\n",
       "      <td>1647913752525494</td>\n",
       "      <td>500.1333</td>\n",
       "      <td>500.4775</td>\n",
       "      <td>3.497236</td>\n",
       "      <td>500.1333</td>\n",
       "      <td>500.4775</td>\n",
       "      <td>3.244212</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23026</th>\n",
       "      <td>1647913752541495</td>\n",
       "      <td>500.1339</td>\n",
       "      <td>500.4756</td>\n",
       "      <td>3.426142</td>\n",
       "      <td>500.1339</td>\n",
       "      <td>500.4756</td>\n",
       "      <td>3.304861</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23027</th>\n",
       "      <td>1647913752561496</td>\n",
       "      <td>500.1342</td>\n",
       "      <td>500.4723</td>\n",
       "      <td>3.354394</td>\n",
       "      <td>500.1342</td>\n",
       "      <td>500.4723</td>\n",
       "      <td>3.281670</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23028</th>\n",
       "      <td>1647913752573497</td>\n",
       "      <td>500.1350</td>\n",
       "      <td>500.4692</td>\n",
       "      <td>3.213331</td>\n",
       "      <td>500.1350</td>\n",
       "      <td>500.4692</td>\n",
       "      <td>3.319974</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23029</th>\n",
       "      <td>1647913752591498</td>\n",
       "      <td>500.1353</td>\n",
       "      <td>500.4676</td>\n",
       "      <td>3.190325</td>\n",
       "      <td>500.1353</td>\n",
       "      <td>500.4676</td>\n",
       "      <td>3.366247</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23030</th>\n",
       "      <td>1647913752613499</td>\n",
       "      <td>500.1353</td>\n",
       "      <td>500.4678</td>\n",
       "      <td>3.220968</td>\n",
       "      <td>500.1353</td>\n",
       "      <td>500.4678</td>\n",
       "      <td>3.351662</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23031</th>\n",
       "      <td>1647913752623500</td>\n",
       "      <td>500.1347</td>\n",
       "      <td>500.4690</td>\n",
       "      <td>3.303726</td>\n",
       "      <td>500.1347</td>\n",
       "      <td>500.4690</td>\n",
       "      <td>3.281282</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23032</th>\n",
       "      <td>1647913752637500</td>\n",
       "      <td>500.1338</td>\n",
       "      <td>500.4701</td>\n",
       "      <td>3.347501</td>\n",
       "      <td>500.1338</td>\n",
       "      <td>500.4701</td>\n",
       "      <td>3.288135</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23033</th>\n",
       "      <td>1647913752659502</td>\n",
       "      <td>500.1329</td>\n",
       "      <td>500.4714</td>\n",
       "      <td>3.452361</td>\n",
       "      <td>500.1329</td>\n",
       "      <td>500.4714</td>\n",
       "      <td>3.290454</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23034</th>\n",
       "      <td>1647913752673503</td>\n",
       "      <td>500.1315</td>\n",
       "      <td>500.4703</td>\n",
       "      <td>3.391895</td>\n",
       "      <td>500.1315</td>\n",
       "      <td>500.4703</td>\n",
       "      <td>3.283568</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23035</th>\n",
       "      <td>1647913752687503</td>\n",
       "      <td>500.1295</td>\n",
       "      <td>500.4706</td>\n",
       "      <td>3.325590</td>\n",
       "      <td>500.1295</td>\n",
       "      <td>500.4706</td>\n",
       "      <td>3.304301</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23036</th>\n",
       "      <td>1647913752707504</td>\n",
       "      <td>500.1276</td>\n",
       "      <td>500.4716</td>\n",
       "      <td>3.357109</td>\n",
       "      <td>500.1276</td>\n",
       "      <td>500.4716</td>\n",
       "      <td>3.359275</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23037</th>\n",
       "      <td>1647913752721505</td>\n",
       "      <td>500.1252</td>\n",
       "      <td>500.4707</td>\n",
       "      <td>3.237030</td>\n",
       "      <td>500.1252</td>\n",
       "      <td>500.4707</td>\n",
       "      <td>3.327379</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23038</th>\n",
       "      <td>1647913752735506</td>\n",
       "      <td>500.1230</td>\n",
       "      <td>500.4706</td>\n",
       "      <td>3.355501</td>\n",
       "      <td>500.1230</td>\n",
       "      <td>500.4706</td>\n",
       "      <td>3.305068</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23039</th>\n",
       "      <td>1647913752757507</td>\n",
       "      <td>500.1210</td>\n",
       "      <td>500.4672</td>\n",
       "      <td>3.328706</td>\n",
       "      <td>500.1210</td>\n",
       "      <td>500.4672</td>\n",
       "      <td>3.355820</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23040</th>\n",
       "      <td>1647913752769508</td>\n",
       "      <td>500.1185</td>\n",
       "      <td>500.4610</td>\n",
       "      <td>3.326622</td>\n",
       "      <td>500.1185</td>\n",
       "      <td>500.4610</td>\n",
       "      <td>3.314275</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23041</th>\n",
       "      <td>1647913752785509</td>\n",
       "      <td>500.1160</td>\n",
       "      <td>500.4536</td>\n",
       "      <td>3.402340</td>\n",
       "      <td>500.1160</td>\n",
       "      <td>500.4536</td>\n",
       "      <td>3.395462</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23245</th>\n",
       "      <td>1647913756101699</td>\n",
       "      <td>500.0597</td>\n",
       "      <td>500.4502</td>\n",
       "      <td>3.324737</td>\n",
       "      <td>500.0597</td>\n",
       "      <td>500.4502</td>\n",
       "      <td>3.531068</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23246</th>\n",
       "      <td>1647913756115699</td>\n",
       "      <td>500.0622</td>\n",
       "      <td>500.4530</td>\n",
       "      <td>3.225975</td>\n",
       "      <td>500.0622</td>\n",
       "      <td>500.4530</td>\n",
       "      <td>3.501263</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23247</th>\n",
       "      <td>1647913756127700</td>\n",
       "      <td>500.0629</td>\n",
       "      <td>500.4542</td>\n",
       "      <td>3.276507</td>\n",
       "      <td>500.0629</td>\n",
       "      <td>500.4542</td>\n",
       "      <td>3.550961</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23248</th>\n",
       "      <td>1647913756143701</td>\n",
       "      <td>500.0634</td>\n",
       "      <td>500.4515</td>\n",
       "      <td>3.403248</td>\n",
       "      <td>500.0634</td>\n",
       "      <td>500.4515</td>\n",
       "      <td>3.478755</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            System Time  Lft X Pos  Lft Y Pos  Lft Pupil Diameter  Rt X Pos  \\\n",
       "10869  1647913555301214   500.0691   500.4668            3.095041  500.0691   \n",
       "10870  1647913555315214   500.0640   500.4816            3.162473  500.0640   \n",
       "10871  1647913555331215   500.0602   500.4692            3.126891  500.0602   \n",
       "10872  1647913555347216   500.0633   500.4488            3.202751  500.0633   \n",
       "10883  1647913555527226   500.0610   500.4525            3.361325  500.0610   \n",
       "10884  1647913555541227   500.0673   500.4527            3.512242  500.0673   \n",
       "10885  1647913555559228   500.0720   500.4551            3.463623  500.0720   \n",
       "10886  1647913555573229   500.0763   500.4570            3.339823  500.0763   \n",
       "10887  1647913555589230   500.0798   500.4582            3.292574  500.0798   \n",
       "10888  1647913555607231   500.0837   500.4566            3.158476  500.0837   \n",
       "10889  1647913555623232   500.0870   500.4516            3.181434  500.0870   \n",
       "12345  1647913579245583   499.9461   500.4567            3.114580  499.9461   \n",
       "12346  1647913579263584     0.0000     0.0000            0.000000  499.9373   \n",
       "12347  1647913579279585   499.9358   500.4745            3.019305  499.9358   \n",
       "12348  1647913579295586   499.9316   500.4791            2.942697  499.9316   \n",
       "12349  1647913579311587   499.9322   500.4769            2.950537  499.9322   \n",
       "12350  1647913579327588   499.9338   500.4713            2.853210  499.9338   \n",
       "12351  1647913579343589   499.9358   500.4632            2.903410  499.9358   \n",
       "15341  1647913627858364   500.0121   500.4514            3.547176  500.0121   \n",
       "15342  1647913627870364   500.0084   500.4539            3.566239  500.0084   \n",
       "15343  1647913627888365   500.0066   500.4532            3.451665  500.0066   \n",
       "15344  1647913627910367   500.0046   500.4508            3.309560  500.0046   \n",
       "22372  1647913741931888   500.2053   500.4420            3.298403  500.2053   \n",
       "22373  1647913741945889   500.2056   500.4419            3.346011  500.2056   \n",
       "22878  1647913750140358   500.1635   500.4492            3.582032  500.1635   \n",
       "22879  1647913750164359   500.1664   500.4555            3.470347  500.1664   \n",
       "22880  1647913750172359   500.1681   500.4594            3.488466  500.1681   \n",
       "22881  1647913750188360   500.1655   500.4541            3.612791  500.1655   \n",
       "23019  1647913752427488   500.1335   500.4570            3.298896  500.1335   \n",
       "23020  1647913752443489   500.1344   500.4654            3.277422  500.1344   \n",
       "23021  1647913752467491   500.1340   500.4737            3.307116  500.1340   \n",
       "23022  1647913752477491   500.1342   500.4790            3.386877  500.1342   \n",
       "23023  1647913752493492   500.1341   500.4797            3.442257  500.1341   \n",
       "23024  1647913752515494   500.1335   500.4791            3.483852  500.1335   \n",
       "23025  1647913752525494   500.1333   500.4775            3.497236  500.1333   \n",
       "23026  1647913752541495   500.1339   500.4756            3.426142  500.1339   \n",
       "23027  1647913752561496   500.1342   500.4723            3.354394  500.1342   \n",
       "23028  1647913752573497   500.1350   500.4692            3.213331  500.1350   \n",
       "23029  1647913752591498   500.1353   500.4676            3.190325  500.1353   \n",
       "23030  1647913752613499   500.1353   500.4678            3.220968  500.1353   \n",
       "23031  1647913752623500   500.1347   500.4690            3.303726  500.1347   \n",
       "23032  1647913752637500   500.1338   500.4701            3.347501  500.1338   \n",
       "23033  1647913752659502   500.1329   500.4714            3.452361  500.1329   \n",
       "23034  1647913752673503   500.1315   500.4703            3.391895  500.1315   \n",
       "23035  1647913752687503   500.1295   500.4706            3.325590  500.1295   \n",
       "23036  1647913752707504   500.1276   500.4716            3.357109  500.1276   \n",
       "23037  1647913752721505   500.1252   500.4707            3.237030  500.1252   \n",
       "23038  1647913752735506   500.1230   500.4706            3.355501  500.1230   \n",
       "23039  1647913752757507   500.1210   500.4672            3.328706  500.1210   \n",
       "23040  1647913752769508   500.1185   500.4610            3.326622  500.1185   \n",
       "23041  1647913752785509   500.1160   500.4536            3.402340  500.1160   \n",
       "23245  1647913756101699   500.0597   500.4502            3.324737  500.0597   \n",
       "23246  1647913756115699   500.0622   500.4530            3.225975  500.0622   \n",
       "23247  1647913756127700   500.0629   500.4542            3.276507  500.0629   \n",
       "23248  1647913756143701   500.0634   500.4515            3.403248  500.0634   \n",
       "\n",
       "       Rt Y Pos  Rt Pupil Diameter  L Display  R Display  L Quality  R Quality  \n",
       "10869  500.4668           3.303374          0          0          3          3  \n",
       "10870  500.4816           3.289466          0          0          3          3  \n",
       "10871  500.4692           3.250312          0          0          3          3  \n",
       "10872  500.4488           3.202108          0          0          3          3  \n",
       "10883  500.4525           3.308391          0          0          3          3  \n",
       "10884  500.4527           3.295081          0          0          3          3  \n",
       "10885  500.4551           3.332366          0          0          3          3  \n",
       "10886  500.4570           3.242193          0          0          3          3  \n",
       "10887  500.4582           3.140425          0          0          3          3  \n",
       "10888  500.4566           3.096770          0          0          3          3  \n",
       "10889  500.4516           3.052048          0          0          3          3  \n",
       "12345  500.4567           3.062346          0          0          3          3  \n",
       "12346  500.4693           3.057730          0          0          0          3  \n",
       "12347  500.4745           3.009157          0          0          3          3  \n",
       "12348  500.4791           3.004862          0          0          3          3  \n",
       "12349  500.4769           2.905807          0          0          3          3  \n",
       "12350  500.4713           2.893071          0          0          3          3  \n",
       "12351  500.4632           2.885502          0          0          3          3  \n",
       "15341  500.4514           3.156311          0          0          3          3  \n",
       "15342  500.4539           3.131715          0          0          3          3  \n",
       "15343  500.4532           3.185162          0          0          3          3  \n",
       "15344  500.4508           3.217217          0          0          3          3  \n",
       "22372  500.4420           3.589871          0          0          3          3  \n",
       "22373  500.4419           3.574174          0          0          3          3  \n",
       "22878  500.4492           3.451210          0          0          3          3  \n",
       "22879  500.4555           3.353218          0          0          3          3  \n",
       "22880  500.4594           3.303970          0          0          3          3  \n",
       "22881  500.4541           3.330090          0          0          3          3  \n",
       "23019  500.4570           3.226465          0          0          3          3  \n",
       "23020  500.4654           3.213912          0          0          3          3  \n",
       "23021  500.4737           3.122159          0          0          3          3  \n",
       "23022  500.4790           3.101630          0          0          3          3  \n",
       "23023  500.4797           3.122218          0          0          3          3  \n",
       "23024  500.4791           3.160255          0          0          3          3  \n",
       "23025  500.4775           3.244212          0          0          3          3  \n",
       "23026  500.4756           3.304861          0          0          3          3  \n",
       "23027  500.4723           3.281670          0          0          3          3  \n",
       "23028  500.4692           3.319974          0          0          3          3  \n",
       "23029  500.4676           3.366247          0          0          3          3  \n",
       "23030  500.4678           3.351662          0          0          3          3  \n",
       "23031  500.4690           3.281282          0          0          3          3  \n",
       "23032  500.4701           3.288135          0          0          3          3  \n",
       "23033  500.4714           3.290454          0          0          3          3  \n",
       "23034  500.4703           3.283568          0          0          3          3  \n",
       "23035  500.4706           3.304301          0          0          3          3  \n",
       "23036  500.4716           3.359275          0          0          3          3  \n",
       "23037  500.4707           3.327379          0          0          3          3  \n",
       "23038  500.4706           3.305068          0          0          3          3  \n",
       "23039  500.4672           3.355820          0          0          3          3  \n",
       "23040  500.4610           3.314275          0          0          3          3  \n",
       "23041  500.4536           3.395462          0          0          3          3  \n",
       "23245  500.4502           3.531068          0          0          3          3  \n",
       "23246  500.4530           3.501263          0          0          3          3  \n",
       "23247  500.4542           3.550961          0          0          3          3  \n",
       "23248  500.4515           3.478755          0          0          3          3  "
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[(df[\"R Quality\"] == 3) & (df[\"R Display\"] == 0)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "247e4617",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\habom\\anaconda3\\envs\\kia\\lib\\site-packages\\ipykernel_launcher.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n",
      "C:\\Users\\habom\\anaconda3\\envs\\kia\\lib\\site-packages\\ipykernel_launcher.py:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  \n"
     ]
    }
   ],
   "source": [
    "df[\"X_pos\"] = (df['Lft X Pos'] + df['Rt X Pos'])/2\n",
    "df[\"Y_pos\"] = (df['Lft Y Pos'] + df['Rt Y Pos'])/2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "92ed8a63",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df[['System Time', \"X_pos\", \"Y_pos\", 'Lft Pupil Diameter','Rt Pupil Diameter', \n",
    "         'L Display', 'R Display', 'L Quality', 'R Quality']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "5e76983c",
   "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>System Time</th>\n",
       "      <th>X_pos</th>\n",
       "      <th>Y_pos</th>\n",
       "      <th>Lft Pupil Diameter</th>\n",
       "      <th>Rt Pupil Diameter</th>\n",
       "      <th>L Display</th>\n",
       "      <th>R Display</th>\n",
       "      <th>L Quality</th>\n",
       "      <th>R Quality</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1647913378953127</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1647913378971128</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1647913378985129</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1647913378999130</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1647913379017131</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24683</th>\n",
       "      <td>1647913779424033</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24684</th>\n",
       "      <td>1647913779442034</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24685</th>\n",
       "      <td>1647913779458035</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24686</th>\n",
       "      <td>1647913779474035</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24687</th>\n",
       "      <td>1647913779490036</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>24688 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            System Time  X_pos  Y_pos  Lft Pupil Diameter  Rt Pupil Diameter  \\\n",
       "0      1647913378953127    0.0    0.0                 0.0                0.0   \n",
       "1      1647913378971128    0.0    0.0                 0.0                0.0   \n",
       "2      1647913378985129    0.0    0.0                 0.0                0.0   \n",
       "3      1647913378999130    0.0    0.0                 0.0                0.0   \n",
       "4      1647913379017131    0.0    0.0                 0.0                0.0   \n",
       "...                 ...    ...    ...                 ...                ...   \n",
       "24683  1647913779424033    0.0    0.0                 0.0                0.0   \n",
       "24684  1647913779442034    0.0    0.0                 0.0                0.0   \n",
       "24685  1647913779458035    0.0    0.0                 0.0                0.0   \n",
       "24686  1647913779474035    0.0    0.0                 0.0                0.0   \n",
       "24687  1647913779490036    0.0    0.0                 0.0                0.0   \n",
       "\n",
       "       L Display  R Display  L Quality  R Quality  \n",
       "0              0          0          0          0  \n",
       "1              0          0          0          0  \n",
       "2              0          0          0          0  \n",
       "3              0          0          0          0  \n",
       "4              0          0          0          0  \n",
       "...          ...        ...        ...        ...  \n",
       "24683          0          0          0          0  \n",
       "24684          0          0          0          0  \n",
       "24685          0          0          0          0  \n",
       "24686          0          0          0          0  \n",
       "24687          0          0          0          0  \n",
       "\n",
       "[24688 rows x 9 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6f8541ad",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.11"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}