eukaryote_df_with_info_for_analysis.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Dataframe containing the information for FISH image analysis"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Images taken during the last FISH experiment (2020), on the SP8 Leica microscope.  \n",
    "Informations that will allow to compare the different images between them."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Import the python libraries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "# To import the files\n",
    "import glob\n",
    "from pathlib import Path\n",
    "\n",
    "# To read the images from the lif files\n",
    "import read_lif\n",
    "\n",
    "# To read the dataframes\n",
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Load the dataframes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Read the image dataframe parquet file:\n",
    "image_info = pd.read_parquet('parquets/image_information.parquet')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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></th>\n",
       "      <th>channel_count</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>file</th>\n",
       "      <th>serie</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">200304_200304_Rev10a2_GFP_Lforms.lif</th>\n",
       "      <th>Series018</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Series019</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Series020</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>w7_p1_form632_sp100_z5</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>w7_p2_form3144_sp100_z1</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">200316_Sample_6.lif</th>\n",
       "      <th>Image008</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Image009</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Image010</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Image011</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Image012</th>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>297 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                              channel_count\n",
       "file                                 serie                                 \n",
       "200304_200304_Rev10a2_GFP_Lforms.lif Series018                            4\n",
       "                                     Series019                            4\n",
       "                                     Series020                            4\n",
       "                                     w7_p1_form632_sp100_z5               4\n",
       "                                     w7_p2_form3144_sp100_z1              4\n",
       "...                                                                     ...\n",
       "200316_Sample_6.lif                  Image008                             4\n",
       "                                     Image009                             4\n",
       "                                     Image010                             4\n",
       "                                     Image011                             4\n",
       "                                     Image012                             4\n",
       "\n",
       "[297 rows x 1 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "image_info.groupby(['file', 'serie'])[['channel']].count().rename(columns={'channel' : 'channel_count'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "image_info = image_info.merge(_, left_on=['file', 'serie'], right_index=True, how='left')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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>file</th>\n",
       "      <th>serie</th>\n",
       "      <th>channel</th>\n",
       "      <th>nbr_frames</th>\n",
       "      <th>shape_X</th>\n",
       "      <th>shape_Y</th>\n",
       "      <th>channel_count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>200316_Sample_10.lif</td>\n",
       "      <td>Image001</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>200316_Sample_10.lif</td>\n",
       "      <td>Image001</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>200316_Sample_10.lif</td>\n",
       "      <td>Image001</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>200316_Sample_10.lif</td>\n",
       "      <td>Image001</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>200316_Sample_10.lif</td>\n",
       "      <td>Image002</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>200316_Sample_10.lif</td>\n",
       "      <td>Image002</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>200316_Sample_10.lif</td>\n",
       "      <td>Image002</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>200316_Sample_10.lif</td>\n",
       "      <td>Image002</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>200316_Sample_10.lif</td>\n",
       "      <td>Image003</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>200316_Sample_10.lif</td>\n",
       "      <td>Image003</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   file     serie  channel  nbr_frames  shape_X  shape_Y  \\\n",
       "0  200316_Sample_10.lif  Image001        0           1      512      512   \n",
       "1  200316_Sample_10.lif  Image001        1           1      512      512   \n",
       "2  200316_Sample_10.lif  Image001        2           1      512      512   \n",
       "3  200316_Sample_10.lif  Image001        3           1      512      512   \n",
       "4  200316_Sample_10.lif  Image002        0           1      512      512   \n",
       "5  200316_Sample_10.lif  Image002        1           1      512      512   \n",
       "6  200316_Sample_10.lif  Image002        2           1      512      512   \n",
       "7  200316_Sample_10.lif  Image002        3           1      512      512   \n",
       "8  200316_Sample_10.lif  Image003        0           1      512      512   \n",
       "9  200316_Sample_10.lif  Image003        1           1      512      512   \n",
       "\n",
       "   channel_count  \n",
       "0              4  \n",
       "1              4  \n",
       "2              4  \n",
       "3              4  \n",
       "4              4  \n",
       "5              4  \n",
       "6              4  \n",
       "7              4  \n",
       "8              4  \n",
       "9              4  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "image_info.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 1188 entries, 0 to 1187\n",
      "Data columns (total 7 columns):\n",
      " #   Column         Non-Null Count  Dtype \n",
      "---  ------         --------------  ----- \n",
      " 0   file           1188 non-null   object\n",
      " 1   serie          1188 non-null   object\n",
      " 2   channel        1188 non-null   int64 \n",
      " 3   nbr_frames     1188 non-null   int64 \n",
      " 4   shape_X        1188 non-null   int64 \n",
      " 5   shape_Y        1188 non-null   int64 \n",
      " 6   channel_count  1188 non-null   int64 \n",
      "dtypes: int64(5), object(2)\n",
      "memory usage: 74.2+ KB\n"
     ]
    }
   ],
   "source": [
    "image_info.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([4])"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "image_info['channel_count'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Read the image metadata dataframe parquet file:\n",
    "image_meta = pd.read_pickle('../metadata_leica_files/parquets_and_pickles/combined_metadata.pickle')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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>FileName</th>\n",
       "      <th>Image.@Name</th>\n",
       "      <th>Image.@UniqueID</th>\n",
       "      <th>Channel.@DataType</th>\n",
       "      <th>Channel.@ChannelTag</th>\n",
       "      <th>Channel.@Resolution</th>\n",
       "      <th>Channel.@NameOfMeasuredQuantity</th>\n",
       "      <th>Channel.@Min</th>\n",
       "      <th>Channel.@Max</th>\n",
       "      <th>Channel.@Unit</th>\n",
       "      <th>...</th>\n",
       "      <th>ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting.@SequenceIndex</th>\n",
       "      <th>ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting.@LineDeactivationFlags</th>\n",
       "      <th>ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting.@IsLineChecked</th>\n",
       "      <th>ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting.@OutCheckedIntensity</th>\n",
       "      <th>ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting.@SuppressionMode</th>\n",
       "      <th>ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting.@IsVisible</th>\n",
       "      <th>ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting.@CanDoFastModulation</th>\n",
       "      <th>ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting</th>\n",
       "      <th>ATLConfocalSettingDefinition.AotfList.Aotf.BeamRoute.BeamPosition</th>\n",
       "      <th>_merge</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>200316_Sample_10.lif</td>\n",
       "      <td>Image001</td>\n",
       "      <td>c976e627-677d-11ea-a94d-002432168676</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>255.0</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>200316_Sample_10.lif</td>\n",
       "      <td>Image001</td>\n",
       "      <td>c976e627-677d-11ea-a94d-002432168676</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>255.0</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>200316_Sample_10.lif</td>\n",
       "      <td>Image001</td>\n",
       "      <td>c976e627-677d-11ea-a94d-002432168676</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>255.0</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>[{'@LaserLine': '458', '@IntensityDev': '0', '...</td>\n",
       "      <td>[{'@BeamPositionLevel': '0', '@BeamPosition': ...</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>200316_Sample_10.lif</td>\n",
       "      <td>Image001</td>\n",
       "      <td>c976e627-677d-11ea-a94d-002432168676</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>255.0</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>[{'@LaserLine': '458', '@IntensityDev': '0', '...</td>\n",
       "      <td>[{'@BeamPositionLevel': '0', '@BeamPosition': ...</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>200316_Sample_10.lif</td>\n",
       "      <td>Image001</td>\n",
       "      <td>c976e627-677d-11ea-a94d-002432168676</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>255.0</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>left_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>200316_Sample_10.lif</td>\n",
       "      <td>Image001</td>\n",
       "      <td>c976e627-677d-11ea-a94d-002432168676</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>255.0</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>left_only</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>200316_Sample_10.lif</td>\n",
       "      <td>Image001</td>\n",
       "      <td>c976e627-677d-11ea-a94d-002432168676</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>255.0</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>[{'@LaserLine': '458', '@IntensityDev': '0', '...</td>\n",
       "      <td>[{'@BeamPositionLevel': '0', '@BeamPosition': ...</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>200316_Sample_10.lif</td>\n",
       "      <td>Image001</td>\n",
       "      <td>c976e627-677d-11ea-a94d-002432168676</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>255.0</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>[{'@LaserLine': '458', '@IntensityDev': '0', '...</td>\n",
       "      <td>[{'@BeamPositionLevel': '0', '@BeamPosition': ...</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>200316_Sample_10.lif</td>\n",
       "      <td>Image002</td>\n",
       "      <td>d0505376-677d-11ea-a94d-002432168676</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>255.0</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>200316_Sample_10.lif</td>\n",
       "      <td>Image002</td>\n",
       "      <td>d0505376-677d-11ea-a94d-002432168676</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>255.0</td>\n",
       "      <td></td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>&lt;NA&gt;</td>\n",
       "      <td>both</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 255 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               FileName Image.@Name                       Image.@UniqueID  \\\n",
       "0  200316_Sample_10.lif    Image001  c976e627-677d-11ea-a94d-002432168676   \n",
       "1  200316_Sample_10.lif    Image001  c976e627-677d-11ea-a94d-002432168676   \n",
       "2  200316_Sample_10.lif    Image001  c976e627-677d-11ea-a94d-002432168676   \n",
       "3  200316_Sample_10.lif    Image001  c976e627-677d-11ea-a94d-002432168676   \n",
       "4  200316_Sample_10.lif    Image001  c976e627-677d-11ea-a94d-002432168676   \n",
       "5  200316_Sample_10.lif    Image001  c976e627-677d-11ea-a94d-002432168676   \n",
       "6  200316_Sample_10.lif    Image001  c976e627-677d-11ea-a94d-002432168676   \n",
       "7  200316_Sample_10.lif    Image001  c976e627-677d-11ea-a94d-002432168676   \n",
       "8  200316_Sample_10.lif    Image002  d0505376-677d-11ea-a94d-002432168676   \n",
       "9  200316_Sample_10.lif    Image002  d0505376-677d-11ea-a94d-002432168676   \n",
       "\n",
       "  Channel.@DataType  Channel.@ChannelTag  Channel.@Resolution  \\\n",
       "0                 0                    0                    8   \n",
       "1                 0                    0                    8   \n",
       "2                 0                    0                    8   \n",
       "3                 0                    0                    8   \n",
       "4                 0                    0                    8   \n",
       "5                 0                    0                    8   \n",
       "6                 0                    0                    8   \n",
       "7                 0                    0                    8   \n",
       "8                 0                    0                    8   \n",
       "9                 0                    0                    8   \n",
       "\n",
       "  Channel.@NameOfMeasuredQuantity  Channel.@Min  Channel.@Max Channel.@Unit  \\\n",
       "0                                           0.0         255.0                 \n",
       "1                                           0.0         255.0                 \n",
       "2                                           0.0         255.0                 \n",
       "3                                           0.0         255.0                 \n",
       "4                                           0.0         255.0                 \n",
       "5                                           0.0         255.0                 \n",
       "6                                           0.0         255.0                 \n",
       "7                                           0.0         255.0                 \n",
       "8                                           0.0         255.0                 \n",
       "9                                           0.0         255.0                 \n",
       "\n",
       "   ...  \\\n",
       "0  ...   \n",
       "1  ...   \n",
       "2  ...   \n",
       "3  ...   \n",
       "4  ...   \n",
       "5  ...   \n",
       "6  ...   \n",
       "7  ...   \n",
       "8  ...   \n",
       "9  ...   \n",
       "\n",
       "  ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting.@SequenceIndex  \\\n",
       "0                                                0.0                           \n",
       "1                                                0.0                           \n",
       "2                                                NaN                           \n",
       "3                                                NaN                           \n",
       "4                                                NaN                           \n",
       "5                                                NaN                           \n",
       "6                                                NaN                           \n",
       "7                                                NaN                           \n",
       "8                                                0.0                           \n",
       "9                                                0.0                           \n",
       "\n",
       "   ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting.@LineDeactivationFlags  \\\n",
       "0                                              False                                    \n",
       "1                                              False                                    \n",
       "2                                              False                                    \n",
       "3                                              False                                    \n",
       "4                                                NaN                                    \n",
       "5                                                NaN                                    \n",
       "6                                              False                                    \n",
       "7                                              False                                    \n",
       "8                                              False                                    \n",
       "9                                              False                                    \n",
       "\n",
       "   ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting.@IsLineChecked  \\\n",
       "0                                               True                            \n",
       "1                                               True                            \n",
       "2                                              False                            \n",
       "3                                              False                            \n",
       "4                                                NaN                            \n",
       "5                                                NaN                            \n",
       "6                                              False                            \n",
       "7                                              False                            \n",
       "8                                               True                            \n",
       "9                                               True                            \n",
       "\n",
       "   ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting.@OutCheckedIntensity  \\\n",
       "0                                              False                                  \n",
       "1                                              False                                  \n",
       "2                                              False                                  \n",
       "3                                              False                                  \n",
       "4                                                NaN                                  \n",
       "5                                                NaN                                  \n",
       "6                                              False                                  \n",
       "7                                              False                                  \n",
       "8                                              False                                  \n",
       "9                                              False                                  \n",
       "\n",
       "   ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting.@SuppressionMode  \\\n",
       "0                                               -1.0                              \n",
       "1                                               -1.0                              \n",
       "2                                                NaN                              \n",
       "3                                                NaN                              \n",
       "4                                                NaN                              \n",
       "5                                                NaN                              \n",
       "6                                                NaN                              \n",
       "7                                                NaN                              \n",
       "8                                               -1.0                              \n",
       "9                                               -1.0                              \n",
       "\n",
       "   ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting.@IsVisible  \\\n",
       "0                                               True                        \n",
       "1                                               True                        \n",
       "2                                              False                        \n",
       "3                                              False                        \n",
       "4                                                NaN                        \n",
       "5                                                NaN                        \n",
       "6                                              False                        \n",
       "7                                              False                        \n",
       "8                                               True                        \n",
       "9                                               True                        \n",
       "\n",
       "   ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting.@CanDoFastModulation  \\\n",
       "0                                               True                                  \n",
       "1                                               True                                  \n",
       "2                                              False                                  \n",
       "3                                              False                                  \n",
       "4                                                NaN                                  \n",
       "5                                                NaN                                  \n",
       "6                                              False                                  \n",
       "7                                              False                                  \n",
       "8                                               True                                  \n",
       "9                                               True                                  \n",
       "\n",
       "   ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting  \\\n",
       "0                                               <NA>             \n",
       "1                                               <NA>             \n",
       "2  [{'@LaserLine': '458', '@IntensityDev': '0', '...             \n",
       "3  [{'@LaserLine': '458', '@IntensityDev': '0', '...             \n",
       "4                                                NaN             \n",
       "5                                                NaN             \n",
       "6  [{'@LaserLine': '458', '@IntensityDev': '0', '...             \n",
       "7  [{'@LaserLine': '458', '@IntensityDev': '0', '...             \n",
       "8                                               <NA>             \n",
       "9                                               <NA>             \n",
       "\n",
       "  ATLConfocalSettingDefinition.AotfList.Aotf.BeamRoute.BeamPosition     _merge  \n",
       "0                                               <NA>                      both  \n",
       "1                                               <NA>                      both  \n",
       "2  [{'@BeamPositionLevel': '0', '@BeamPosition': ...                      both  \n",
       "3  [{'@BeamPositionLevel': '0', '@BeamPosition': ...                      both  \n",
       "4                                                NaN                 left_only  \n",
       "5                                                NaN                 left_only  \n",
       "6  [{'@BeamPositionLevel': '0', '@BeamPosition': ...                      both  \n",
       "7  [{'@BeamPositionLevel': '0', '@BeamPosition': ...                      both  \n",
       "8                                               <NA>                      both  \n",
       "9                                               <NA>                      both  \n",
       "\n",
       "[10 rows x 255 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "image_meta.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 2695 entries, 0 to 2694\n",
      "Data columns (total 255 columns):\n",
      " #   Column                                                                                                       Dtype   \n",
      "---  ------                                                                                                       -----   \n",
      " 0   FileName                                                                                                     object  \n",
      " 1   Image.@Name                                                                                                  object  \n",
      " 2   Image.@UniqueID                                                                                              object  \n",
      " 3   Channel.@DataType                                                                                            object  \n",
      " 4   Channel.@ChannelTag                                                                                          Int64   \n",
      " 5   Channel.@Resolution                                                                                          Int64   \n",
      " 6   Channel.@NameOfMeasuredQuantity                                                                              object  \n",
      " 7   Channel.@Min                                                                                                 float64 \n",
      " 8   Channel.@Max                                                                                                 float64 \n",
      " 9   Channel.@Unit                                                                                                object  \n",
      " 10  Channel.@LUTName                                                                                             category\n",
      " 11  Channel.@IsLUTInverted                                                                                       bool    \n",
      " 12  Channel.@BytesInc                                                                                            float64 \n",
      " 13  Channel.@BitInc                                                                                              Int64   \n",
      " 14  Dimension.@DimID                                                                                             Int64   \n",
      " 15  Dimension.@NumberOfElements                                                                                  Int64   \n",
      " 16  Dimension.@Origin                                                                                            float64 \n",
      " 17  Dimension.@Length                                                                                            float64 \n",
      " 18  Dimension.@Unit                                                                                              object  \n",
      " 19  Dimension.@BitInc                                                                                            Int64   \n",
      " 20  Dimension.@BytesInc                                                                                          float64 \n",
      " 21  @Visibility                                                                                                  bool    \n",
      " 22  @CopyOption                                                                                                  bool    \n",
      " 23  Data.Image.@TextDescription                                                                                  object  \n",
      " 24  Data.Image.TimeStampList.@NumberOfTimeStamps                                                                 Int64   \n",
      " 25  Data.Image.TimeStampList.#text                                                                               object  \n",
      " 26  Memory.@Size                                                                                                 Int64   \n",
      " 27  Memory.@MemoryBlockID                                                                                        object  \n",
      " 28  @Name                                                                                                        object  \n",
      " 29  @UniqueID                                                                                                    object  \n",
      " 30  Data.Experiment.@Path                                                                                        object  \n",
      " 31  Data.Experiment.@IsSavedFlag                                                                                 bool    \n",
      " 32  Data.Experiment.TimeStamp.@HighInteger                                                                       object  \n",
      " 33  Data.Experiment.TimeStamp.@LowInteger                                                                        object  \n",
      " 34  Attributes.Attribute                                                                                         object  \n",
      " 35  Collection.@Name                                                                                             object  \n",
      " 36  Collection.@UniqueID                                                                                         object  \n",
      " 37  Collection.@Visibility                                                                                       object  \n",
      " 38  Collection.@CopyOption                                                                                       bool    \n",
      " 39  Data.Collection.@ChildTypeTest                                                                               object  \n",
      " 40  Collection.Memory.@Size                                                                                      Int64   \n",
      " 41  Collection.Memory.@MemoryBlockID                                                                             object  \n",
      " 42  Image.Attachment.@Name                                                                                       object  \n",
      " 43  Image.Attachment.@Application                                                                                object  \n",
      " 44  Image.Attachment.@Software                                                                                   object  \n",
      " 45  Image.Attachment.@HardwareServerVersion                                                                      object  \n",
      " 46  Image.Attachment.@SystemType                                                                                 float64 \n",
      " 47  Image.Attachment.@SystemTypeName                                                                             object  \n",
      " 48  Image.Attachment.@DataSourceType                                                                             float64 \n",
      " 49  Image.Attachment.@DataSourceTypeName                                                                         object  \n",
      " 50  ATLConfocalSettingDefinition.@VersionNumber                                                                  float64 \n",
      " 51  ATLConfocalSettingDefinition.@UserSettingName                                                                object  \n",
      " 52  ATLConfocalSettingDefinition.@CanDoSTED                                                                      object  \n",
      " 53  ATLConfocalSettingDefinition.@IsSTEDActive                                                                   object  \n",
      " 54  ATLConfocalSettingDefinition.@IsSwitchForPulsedStedWithMpActive                                              object  \n",
      " 55  ATLConfocalSettingDefinition.@UseSystemOptimizedVoxelCalculation                                             object  \n",
      " 56  ATLConfocalSettingDefinition.@IsUserSettingNameSet                                                           object  \n",
      " 57  ATLConfocalSettingDefinition.@IsHydPulsedModeCoeffntManualActive                                             object  \n",
      " 58  ATLConfocalSettingDefinition.@XGalvoMovementMode                                                             float64 \n",
      " 59  ATLConfocalSettingDefinition.@XGalvoMovementModeName                                                         object  \n",
      " 60  ATLConfocalSettingDefinition.@BitSize                                                                        float64 \n",
      " 61  ATLConfocalSettingDefinition.@MaxIntegrationTime                                                             float64 \n",
      " 62  ATLConfocalSettingDefinition.@ScanMode                                                                       object  \n",
      " 63  ATLConfocalSettingDefinition.@ZUseMode                                                                       float64 \n",
      " 64  ATLConfocalSettingDefinition.@ZUseModeName                                                                   object  \n",
      " 65  ATLConfocalSettingDefinition.@ZPosition                                                                      float64 \n",
      " 66  ATLConfocalSettingDefinition.@IsSuperZ                                                                       object  \n",
      " 67  ATLConfocalSettingDefinition.@ValidBeginStack                                                                object  \n",
      " 68  ATLConfocalSettingDefinition.@ValidEndStack                                                                  object  \n",
      " 69  ATLConfocalSettingDefinition.@Sections                                                                       float64 \n",
      " 70  ATLConfocalSettingDefinition.@StackCalculationMode                                                           float64 \n",
      " 71  ATLConfocalSettingDefinition.@StackCalculationModeName                                                       object  \n",
      " 72  ATLConfocalSettingDefinition.@IsMPFormulaForStepSizerUsageActive                                             object  \n",
      " 73  ATLConfocalSettingDefinition.@IsFastZStack                                                                   object  \n",
      " 74  ATLConfocalSettingDefinition.@ZStackDirectionMode                                                            float64 \n",
      " 75  ATLConfocalSettingDefinition.@ZStackDirectionModeName                                                        object  \n",
      " 76  ATLConfocalSettingDefinition.@Magnification                                                                  float64 \n",
      " 77  ATLConfocalSettingDefinition.@ObjectivePos                                                                   float64 \n",
      " 78  ATLConfocalSettingDefinition.@ObjectiveName                                                                  object  \n",
      " 79  ATLConfocalSettingDefinition.@ObjectiveNumber                                                                float64 \n",
      " 80  ATLConfocalSettingDefinition.@MicroscopeModel                                                                object  \n",
      " 81  ATLConfocalSettingDefinition.@IsInverseMicroscopeModel                                                       object  \n",
      " 82  ATLConfocalSettingDefinition.@Immersion                                                                      object  \n",
      " 83  ATLConfocalSettingDefinition.@NumericalAperture                                                              float64 \n",
      " 84  ATLConfocalSettingDefinition.@RefractionIndex                                                                float64 \n",
      " 85  ATLConfocalSettingDefinition.@IsFCSFilterAutomationActive                                                    object  \n",
      " 86  ATLConfocalSettingDefinition.@IsSMDChaserUVAOTFAutomationActive                                              object  \n",
      " 87  ATLConfocalSettingDefinition.@CanDoCSMode                                                                    object  \n",
      " 88  ATLConfocalSettingDefinition.@ActiveCS_SubModeForTLD                                                         float64 \n",
      " 89  ATLConfocalSettingDefinition.@ActiveCS_SubModeForTLDName                                                     object  \n",
      " 90  ATLConfocalSettingDefinition.@RldFluoCubePos                                                                 float64 \n",
      " 91  ATLConfocalSettingDefinition.@RldCubeAutoSelectionEnabled                                                    object  \n",
      " 92  ATLConfocalSettingDefinition.@LastNonMP_MFP_FW_Name                                                          object  \n",
      " 93  ATLConfocalSettingDefinition.@LastNonMP_Pol_FW_Name                                                          object  \n",
      " 94  ATLConfocalSettingDefinition.@ScanSpeed                                                                      float64 \n",
      " 95  ATLConfocalSettingDefinition.@InDimension                                                                    float64 \n",
      " 96  ATLConfocalSettingDefinition.@OutDimension                                                                   float64 \n",
      " 97  ATLConfocalSettingDefinition.@UseScanFormatRestriction                                                       object  \n",
      " 98  ATLConfocalSettingDefinition.@Zoom                                                                           float64 \n",
      " 99  ATLConfocalSettingDefinition.@BaseZoom                                                                       float64 \n",
      " 100 ATLConfocalSettingDefinition.@PanFirstDim                                                                    float64 \n",
      " 101 ATLConfocalSettingDefinition.@PanSecondDim                                                                   float64 \n",
      " 102 ATLConfocalSettingDefinition.@ScanDirectionX                                                                 float64 \n",
      " 103 ATLConfocalSettingDefinition.@ScanDirectionXName                                                             object  \n",
      " 104 ATLConfocalSettingDefinition.@Pinhole                                                                        float64 \n",
      " 105 ATLConfocalSettingDefinition.@PinholeAiry                                                                    float64 \n",
      " 106 ATLConfocalSettingDefinition.@EmissionWavelengthForPinholeAiryCalculation                                    float64 \n",
      " 107 ATLConfocalSettingDefinition.@FrameAverage                                                                   float64 \n",
      " 108 ATLConfocalSettingDefinition.@LineAverage                                                                    float64 \n",
      " 109 ATLConfocalSettingDefinition.@FrameAccumulation                                                              float64 \n",
      " 110 ATLConfocalSettingDefinition.@Line_Accumulation                                                              float64 \n",
      " 111 ATLConfocalSettingDefinition.@AreBleachPointsEnabled                                                         object  \n",
      " 112 ATLConfocalSettingDefinition.@InTrigger                                                                      float64 \n",
      " 113 ATLConfocalSettingDefinition.@OutTrigger                                                                     float64 \n",
      " 114 ATLConfocalSettingDefinition.@IsRoiScanEnable                                                                object  \n",
      " 115 ATLConfocalSettingDefinition.@Is3DLimitedRoiScanEnable                                                       object  \n",
      " 116 ATLConfocalSettingDefinition.@ZCompensationModes                                                             float64 \n",
      " 117 ATLConfocalSettingDefinition.@WizardMode                                                                     float64 \n",
      " 118 ATLConfocalSettingDefinition.@IsConstantIntegrationTimeActive                                                object  \n",
      " 119 ATLConfocalSettingDefinition.@PixelDwellTime                                                                 float64 \n",
      " 120 ATLConfocalSettingDefinition.@SystemSerialNumber                                                             float64 \n",
      " 121 ATLConfocalSettingDefinition.EasySRSlider.@SRRelative                                                        float64 \n",
      " 122 ATLConfocalSettingDefinition.EasySRSlider.@ThreeDRelative                                                    float64 \n",
      " 123 ATLConfocalSettingDefinition.EasySRSlider.@GentleRelative                                                    float64 \n",
      " 124 ATLConfocalSettingDefinition.Quantity.@Value                                                                 float64 \n",
      " 125 ATLConfocalSettingDefinition.Quantity.@Unit                                                                  object  \n",
      " 126 ATLConfocalSettingDefinition.ClimateControl.@CanDoClimateControl                                             object  \n",
      " 127 ATLConfocalSettingDefinition.ClimateControl.@ClimateControlCurrentlyInUse                                    object  \n",
      " 128 ATLConfocalSettingDefinition.ClimateControl.@NumberOfUnits                                                   float64 \n",
      " 129 ATLConfocalSettingDefinition.BleachPoints.LMSDataContainerHeader.@Version                                    float64 \n",
      " 130 ATLConfocalSettingDefinition.BleachPoints.LMSDataContainerHeader.Element.@Name                               object  \n",
      " 131 ATLConfocalSettingDefinition.BleachPoints.LMSDataContainerHeader.Element.@Visibility                         float64 \n",
      " 132 ATLConfocalSettingDefinition.BleachPoints.LMSDataContainerHeader.Element.@CopyOption                         object  \n",
      " 133 ATLConfocalSettingDefinition.BleachPoints.LMSDataContainerHeader.Element.@UniqueID                           object  \n",
      " 134 ATLConfocalSettingDefinition.BleachPoints.LMSDataContainerHeader.Element.Data.ROISet.@ROISetType             object  \n",
      " 135 ATLConfocalSettingDefinition.BleachPoints.LMSDataContainerHeader.Element.Data.ROISet.@PossibleChildROITypes  object  \n",
      " 136 ATLConfocalSettingDefinition.BleachPoints.LMSDataContainerHeader.Element.Data.ROISet.@PossibleROITransforms  float64 \n",
      " 137 ATLConfocalSettingDefinition.BleachPoints.LMSDataContainerHeader.Element.Data.ROISet.@PossibleROIActions     float64 \n",
      " 138 ATLConfocalSettingDefinition.BleachPoints.LMSDataContainerHeader.Element.Memory.@Size                        float64 \n",
      " 139 ATLConfocalSettingDefinition.BleachPoints.LMSDataContainerHeader.Element.Memory.@MemoryBlockID               object  \n",
      " 140 ATLConfocalSettingDefinition.FilterWheel.@FluorifierAutoSelection                                            object  \n",
      " 141 ATLConfocalSettingDefinition.FilterWheel.@BeamSplitterAutoSelection                                          object  \n",
      " 142 ATLConfocalSettingDefinition.FilterWheel.@StedBeamSelectionPinholeCoupling                                   float64 \n",
      " 143 ATLConfocalSettingDefinition.FilterWheel.@MultiFunctionPortAutoSelection                                     object  \n",
      " 144 ATLConfocalSettingDefinition.FilterWheel.@BeamMergerAutoSelectionEnabled                                     object  \n",
      " 145 ATLConfocalSettingDefinition.FilterWheel.@RldBlockingFilterAutoSelectionEnabled                              object  \n",
      " 146 ATLConfocalSettingDefinition.DetectorList.@DetectorAutoSelection                                             object  \n",
      " 147 ATLConfocalSettingDefinition.DetectorList.@InExternalDetectionMode                                           float64 \n",
      " 148 ATLConfocalSettingDefinition.OnlineDyeSeparation.@Enabled                                                    object  \n",
      " 149 ATLConfocalSettingDefinition.OnlineDyeSeparation.@KeepRawImage                                               object  \n",
      " 150 ATLConfocalSettingDefinition.OnlineDyeSeparation.@Detectors                                                  float64 \n",
      " 151 ATLConfocalSettingDefinition.OnlineDyeSeparation.@Channels                                                   float64 \n",
      " 152 ATLConfocalSettingDefinition.OnlineDyeSeparation.@Normalize                                                  object  \n",
      " 153 ATLConfocalSettingDefinition.VariableBeamExpanderFactors.@CommonSettingEnabled                               object  \n",
      " 154 ATLConfocalSettingDefinition.VariableBeamExpanderFactors.@CommonFactor                                       float64 \n",
      " 155 ATLConfocalSettingDefinition.@StagePosX                                                                      float64 \n",
      " 156 ATLConfocalSettingDefinition.@StagePosY                                                                      float64 \n",
      " 157 ATLConfocalSettingDefinition.@StageRangeX                                                                    float64 \n",
      " 158 ATLConfocalSettingDefinition.@StageRangeY                                                                    float64 \n",
      " 159 ATLConfocalSettingDefinition.@FlipX                                                                          Int8    \n",
      " 160 ATLConfocalSettingDefinition.@FlipY                                                                          Int8    \n",
      " 161 ATLConfocalSettingDefinition.@SwapXY                                                                         Int8    \n",
      " 162 ATLConfocalSettingDefinition.@ActiveCS_SubModeForRLD                                                         Int8    \n",
      " 163 ATLConfocalSettingDefinition.@ActiveCS_SubModeForRLDName                                                     object  \n",
      " 164 ATLConfocalSettingDefinition.DetectorList.Detector.@Name                                                     category\n",
      " 165 ATLConfocalSettingDefinition.DetectorList.Detector.@Type                                                     category\n",
      " 166 ATLConfocalSettingDefinition.DetectorList.Detector.@ScanType                                                 category\n",
      " 167 ATLConfocalSettingDefinition.DetectorList.Detector.@Channel                                                  category\n",
      " 168 ATLConfocalSettingDefinition.DetectorList.Detector.@ChannelName                                              category\n",
      " 169 ATLConfocalSettingDefinition.DetectorList.Detector.@IsActive                                                 object  \n",
      " 170 ATLConfocalSettingDefinition.DetectorList.Detector.@Gain                                                     float64 \n",
      " 171 ATLConfocalSettingDefinition.DetectorList.Detector.@Offset                                                   float64 \n",
      " 172 ATLConfocalSettingDefinition.DetectorList.Detector.@IsSTEDDetector                                           object  \n",
      " 173 ATLConfocalSettingDefinition.DetectorList.Detector.@IsSRSDetector                                            object  \n",
      " 174 ATLConfocalSettingDefinition.DetectorList.Detector.@DetectionRangeBegin                                      float64 \n",
      " 175 ATLConfocalSettingDefinition.DetectorList.Detector.@DetectionRangeEnd                                        float64 \n",
      " 176 ATLConfocalSettingDefinition.DetectorList.Detector.@Phase                                                    float64 \n",
      " 177 ATLConfocalSettingDefinition.DetectorList.Detector.@IsFlimDetector                                           object  \n",
      " 178 ATLConfocalSettingDefinition.DetectorList.Detector.@IsHPDDetector                                            object  \n",
      " 179 ATLConfocalSettingDefinition.DetectorList.Detector.@IsEnabled                                                object  \n",
      " 180 ATLConfocalSettingDefinition.DetectorList.Detector.@IsHPDOverloaded                                          object  \n",
      " 181 ATLConfocalSettingDefinition.DetectorList.Detector.@CanDoPhotonCounting                                      object  \n",
      " 182 ATLConfocalSettingDefinition.DetectorList.Detector.@AcquisitionMode                                          float64 \n",
      " 183 ATLConfocalSettingDefinition.DetectorList.Detector.@AcquisitionModeName                                      object  \n",
      " 184 ATLConfocalSettingDefinition.DetectorList.Detector.@CanDoTimeGate                                            object  \n",
      " 185 ATLConfocalSettingDefinition.DetectorList.Detector.@IsTimeGateActivated                                      object  \n",
      " 186 ATLConfocalSettingDefinition.DetectorList.Detector.@TimeGatePulseStart                                       float64 \n",
      " 187 ATLConfocalSettingDefinition.DetectorList.Detector.@TimeGateWavelength                                       float64 \n",
      " 188 ATLConfocalSettingDefinition.DetectorList.Detector.@TimeGatePulseEnd                                         float64 \n",
      " 189 ATLConfocalSettingDefinition.Spectro.MultiBand.@Channel                                                      category\n",
      " 190 ATLConfocalSettingDefinition.Spectro.MultiBand.@ChannelName                                                  category\n",
      " 191 ATLConfocalSettingDefinition.Spectro.MultiBand.@LeftWorld                                                    float64 \n",
      " 192 ATLConfocalSettingDefinition.Spectro.MultiBand.@RightWorld                                                   float64 \n",
      " 193 ATLConfocalSettingDefinition.Spectro.MultiBand.@TargetWaveLengthBegin                                        float64 \n",
      " 194 ATLConfocalSettingDefinition.Spectro.MultiBand.@TargetWaveLengthEnd                                          float64 \n",
      " 195 ATLConfocalSettingDefinition.Spectro.MultiBand.@DyeName                                                      category\n",
      " 196 ATLConfocalSettingDefinition.LUT_List.LUT.@Channel                                                           category\n",
      " 197 ATLConfocalSettingDefinition.LUT_List.LUT.@LutName                                                           category\n",
      " 198 WaveLengths                                                                                                  Int64   \n",
      " 199 ATLConfocalSettingDefinition.LaserArray.Laser.@Version                                                       float64 \n",
      " 200 ATLConfocalSettingDefinition.LaserArray.Laser.@LightSourceType                                               category\n",
      " 201 ATLConfocalSettingDefinition.LaserArray.Laser.@LaserName                                                     category\n",
      " 202 ATLConfocalSettingDefinition.LaserArray.Laser.@PowerState                                                    object  \n",
      " 203 ATLConfocalSettingDefinition.LaserArray.Laser.@StedAlignFlag                                                 object  \n",
      " 204 ATLConfocalSettingDefinition.LaserArray.Laser.@CanDoLinearOutputPower                                        object  \n",
      " 205 ATLConfocalSettingDefinition.LaserArray.Laser.@CanDoPulsing                                                  object  \n",
      " 206 ATLConfocalSettingDefinition.LaserArray.Laser.@CanDoOutputPowerWatt                                          object  \n",
      " 207 ATLConfocalSettingDefinition.LaserArray.Laser.@HighPowerModeActive                                           object  \n",
      " 208 ATLConfocalSettingDefinition.LaserArray.Laser.@LightSourceName                                               category\n",
      " 209 ATLConfocalSettingDefinition.LaserArray.Laser.@OutputPowerWatt                                               float64 \n",
      " 210 ATLConfocalSettingDefinition.LaserArray.Laser.@Wavelength                                                    Int64   \n",
      " 211 ATLConfocalSettingDefinition.LaserArray.Laser.@CanDoChangeWavelength                                         object  \n",
      " 212 ATLConfocalSettingDefinition.LaserArray.Laser.BeamRoute.@Version                                             float64 \n",
      " 213 ATLConfocalSettingDefinition.LaserArray.Laser.BeamRoute.BeamPosition.@BeamPositionLevel                      object  \n",
      " 214 ATLConfocalSettingDefinition.LaserArray.Laser.BeamRoute.BeamPosition.@BeamPosition                           object  \n",
      " 215 ATLConfocalSettingDefinition.LaserArray.Laser.@OutputPowerPercentage                                         float64 \n",
      " 216 ATLConfocalSettingDefinition.LaserArray.Laser.BeamRoute.BeamPosition                                         object  \n",
      " 217 ATLConfocalSettingDefinition.ShutterList.Shutter.@Version                                                    float64 \n",
      " 218 ATLConfocalSettingDefinition.ShutterList.Shutter.@LightSourceType                                            category\n",
      " 219 ATLConfocalSettingDefinition.ShutterList.Shutter.@LightSourceName                                            category\n",
      " 220 ATLConfocalSettingDefinition.ShutterList.Shutter.@IsActive                                                   object  \n",
      " 221 ATLConfocalSettingDefinition.ShutterList.Shutter.BeamRoute.@Version                                          float64 \n",
      " 222 ATLConfocalSettingDefinition.ShutterList.Shutter.BeamRoute.BeamPosition.@BeamPositionLevel                   object  \n",
      " 223 ATLConfocalSettingDefinition.ShutterList.Shutter.BeamRoute.BeamPosition.@BeamPosition                        object  \n",
      " 224 ATLConfocalSettingDefinition.ShutterList.Shutter.BeamRoute.BeamPosition                                      object  \n",
      " 225 ATLConfocalSettingDefinition.AotfList.Aotf.@Version                                                          float64 \n",
      " 226 ATLConfocalSettingDefinition.AotfList.Aotf.@LightSourceName                                                  category\n",
      " 227 ATLConfocalSettingDefinition.AotfList.Aotf.@LightSourceType                                                  category\n",
      " 228 ATLConfocalSettingDefinition.AotfList.Aotf.@OpenVirtual                                                      object  \n",
      " 229 ATLConfocalSettingDefinition.AotfList.Aotf.@IsChanged                                                        object  \n",
      " 230 ATLConfocalSettingDefinition.AotfList.Aotf.@CanDoPulseFreq                                                   object  \n",
      " 231 ATLConfocalSettingDefinition.AotfList.Aotf.@PulsFreq                                                         object  \n",
      " 232 ATLConfocalSettingDefinition.AotfList.Aotf.@CanDoTwoLaserPIE                                                 object  \n",
      " 233 ATLConfocalSettingDefinition.AotfList.Aotf.@TwoLaserPIEPossibleLastState                                     object  \n",
      " 234 ATLConfocalSettingDefinition.AotfList.Aotf.@TwoLaserPIEActive                                                object  \n",
      " 235 ATLConfocalSettingDefinition.AotfList.Aotf.BeamRoute.@Version                                                float64 \n",
      " 236 ATLConfocalSettingDefinition.AotfList.Aotf.BeamRoute.BeamPosition.@BeamPositionLevel                         object  \n",
      " 237 ATLConfocalSettingDefinition.AotfList.Aotf.BeamRoute.BeamPosition.@BeamPosition                              object  \n",
      " 238 ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting.@LaserLine                                       object  \n",
      " 239 ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting.@IntensityDev                                    float64 \n",
      " 240 ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting.@IntensityLowDev                                 float64 \n",
      " 241 ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting.@AOBSIntensityDev                                float64 \n",
      " 242 ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting.@AOBSIntensityLowDev                             float64 \n",
      " 243 ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting.@EnableDoubleMode                                object  \n",
      " 244 ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting.@LineIndex                                       float64 \n",
      " 245 ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting.@SequenceIndex                                   float64 \n",
      " 246 ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting.@LineDeactivationFlags                           object  \n",
      " 247 ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting.@IsLineChecked                                   object  \n",
      " 248 ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting.@OutCheckedIntensity                             object  \n",
      " 249 ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting.@SuppressionMode                                 float64 \n",
      " 250 ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting.@IsVisible                                       object  \n",
      " 251 ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting.@CanDoFastModulation                             object  \n",
      " 252 ATLConfocalSettingDefinition.AotfList.Aotf.LaserLineSetting                                                  object  \n",
      " 253 ATLConfocalSettingDefinition.AotfList.Aotf.BeamRoute.BeamPosition                                            object  \n",
      " 254 _merge                                                                                                       category\n",
      "dtypes: Int64(11), Int8(4), bool(5), category(19), float64(92), object(124)\n",
      "memory usage: 4.8+ MB\n"
     ]
    }
   ],
   "source": [
    "image_meta.info(float)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3.6904670000000004e-05"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "image_meta['Dimension.@Length'][462]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "image_meta['Dimension.@DimID'][462]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "400.0"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "image_meta['ATLConfocalSettingDefinition.@ScanSpeed'][462]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "5.0000127156898895"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "image_meta['ATLConfocalSettingDefinition.@Zoom'][462]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2.5625e-06"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "image_meta['ATLConfocalSettingDefinition.@PixelDwellTime'][462]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "600.404364080262"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "image_meta['ATLConfocalSettingDefinition.DetectorList.Detector.@Gain'][462]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.0"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "image_meta['ATLConfocalSettingDefinition.DetectorList.Detector.@Offset'][462]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "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>ATLConfocalSettingDefinition.DetectorList.Detector.@Name</th>\n",
       "      <th>ATLConfocalSettingDefinition.DetectorList.Detector.@Type</th>\n",
       "      <th>ATLConfocalSettingDefinition.DetectorList.Detector.@ScanType</th>\n",
       "      <th>ATLConfocalSettingDefinition.DetectorList.Detector.@Channel</th>\n",
       "      <th>ATLConfocalSettingDefinition.DetectorList.Detector.@ChannelName</th>\n",
       "      <th>ATLConfocalSettingDefinition.DetectorList.Detector.@IsActive</th>\n",
       "      <th>ATLConfocalSettingDefinition.DetectorList.Detector.@Gain</th>\n",
       "      <th>ATLConfocalSettingDefinition.DetectorList.Detector.@Offset</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>PMT 3</td>\n",
       "      <td>PMT</td>\n",
       "      <td>Internal</td>\n",
       "      <td>3</td>\n",
       "      <td>Channel 3</td>\n",
       "      <td>False</td>\n",
       "      <td>600.289921</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>PMT 3</td>\n",
       "      <td>PMT</td>\n",
       "      <td>Internal</td>\n",
       "      <td>3</td>\n",
       "      <td>Channel 3</td>\n",
       "      <td>False</td>\n",
       "      <td>600.289921</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>HyD4 SMD</td>\n",
       "      <td>HyD</td>\n",
       "      <td>Internal</td>\n",
       "      <td>4</td>\n",
       "      <td>Channel 4</td>\n",
       "      <td>False</td>\n",
       "      <td>350.666885</td>\n",
       "      <td>-0.006667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>HyD4 SMD</td>\n",
       "      <td>HyD</td>\n",
       "      <td>Internal</td>\n",
       "      <td>4</td>\n",
       "      <td>Channel 4</td>\n",
       "      <td>False</td>\n",
       "      <td>350.666885</td>\n",
       "      <td>-0.006667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>PMT Trans</td>\n",
       "      <td>PMT</td>\n",
       "      <td>TLD</td>\n",
       "      <td>100</td>\n",
       "      <td>Transmission Channel</td>\n",
       "      <td>False</td>\n",
       "      <td>350.537881</td>\n",
       "      <td>0.000000</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2690</th>\n",
       "      <td>PMT 5</td>\n",
       "      <td>PMT</td>\n",
       "      <td>Internal</td>\n",
       "      <td>5</td>\n",
       "      <td>Channel 5</td>\n",
       "      <td>False</td>\n",
       "      <td>962.195773</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2691</th>\n",
       "      <td>PMT 5</td>\n",
       "      <td>PMT</td>\n",
       "      <td>Internal</td>\n",
       "      <td>5</td>\n",
       "      <td>Channel 5</td>\n",
       "      <td>False</td>\n",
       "      <td>962.195773</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2692</th>\n",
       "      <td>PMT 5</td>\n",
       "      <td>PMT</td>\n",
       "      <td>Internal</td>\n",
       "      <td>5</td>\n",
       "      <td>Channel 5</td>\n",
       "      <td>False</td>\n",
       "      <td>962.195773</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2693</th>\n",
       "      <td>PMT 5</td>\n",
       "      <td>PMT</td>\n",
       "      <td>Internal</td>\n",
       "      <td>5</td>\n",
       "      <td>Channel 5</td>\n",
       "      <td>False</td>\n",
       "      <td>962.195773</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2694</th>\n",
       "      <td>PMT 5</td>\n",
       "      <td>PMT</td>\n",
       "      <td>Internal</td>\n",
       "      <td>5</td>\n",
       "      <td>Channel 5</td>\n",
       "      <td>False</td>\n",
       "      <td>962.195773</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2695 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     ATLConfocalSettingDefinition.DetectorList.Detector.@Name  \\\n",
       "0                                                 PMT 3         \n",
       "1                                                 PMT 3         \n",
       "2                                              HyD4 SMD         \n",
       "3                                              HyD4 SMD         \n",
       "4                                             PMT Trans         \n",
       "...                                                 ...         \n",
       "2690                                              PMT 5         \n",
       "2691                                              PMT 5         \n",
       "2692                                              PMT 5         \n",
       "2693                                              PMT 5         \n",
       "2694                                              PMT 5         \n",
       "\n",
       "     ATLConfocalSettingDefinition.DetectorList.Detector.@Type  \\\n",
       "0                                                   PMT         \n",
       "1                                                   PMT         \n",
       "2                                                   HyD         \n",
       "3                                                   HyD         \n",
       "4                                                   PMT         \n",
       "...                                                 ...         \n",
       "2690                                                PMT         \n",
       "2691                                                PMT         \n",
       "2692                                                PMT         \n",
       "2693                                                PMT         \n",
       "2694                                                PMT         \n",
       "\n",
       "     ATLConfocalSettingDefinition.DetectorList.Detector.@ScanType  \\\n",
       "0                                              Internal             \n",
       "1                                              Internal             \n",
       "2                                              Internal             \n",
       "3                                              Internal             \n",
       "4                                                   TLD             \n",
       "...                                                 ...             \n",
       "2690                                           Internal             \n",
       "2691                                           Internal             \n",
       "2692                                           Internal             \n",
       "2693                                           Internal             \n",
       "2694                                           Internal             \n",
       "\n",
       "     ATLConfocalSettingDefinition.DetectorList.Detector.@Channel  \\\n",
       "0                                                     3            \n",
       "1                                                     3            \n",
       "2                                                     4            \n",
       "3                                                     4            \n",
       "4                                                   100            \n",
       "...                                                 ...            \n",
       "2690                                                  5            \n",
       "2691                                                  5            \n",
       "2692                                                  5            \n",
       "2693                                                  5            \n",
       "2694                                                  5            \n",
       "\n",
       "     ATLConfocalSettingDefinition.DetectorList.Detector.@ChannelName  \\\n",
       "0                                             Channel 3                \n",
       "1                                             Channel 3                \n",
       "2                                             Channel 4                \n",
       "3                                             Channel 4                \n",
       "4                                  Transmission Channel                \n",
       "...                                                 ...                \n",
       "2690                                          Channel 5                \n",
       "2691                                          Channel 5                \n",
       "2692                                          Channel 5                \n",
       "2693                                          Channel 5                \n",
       "2694                                          Channel 5                \n",
       "\n",
       "     ATLConfocalSettingDefinition.DetectorList.Detector.@IsActive  \\\n",
       "0                                                 False             \n",
       "1                                                 False             \n",
       "2                                                 False             \n",
       "3                                                 False             \n",
       "4                                                 False             \n",
       "...                                                 ...             \n",
       "2690                                              False             \n",
       "2691                                              False             \n",
       "2692                                              False             \n",
       "2693                                              False             \n",
       "2694                                              False             \n",
       "\n",
       "      ATLConfocalSettingDefinition.DetectorList.Detector.@Gain  \\\n",
       "0                                            600.289921          \n",
       "1                                            600.289921          \n",
       "2                                            350.666885          \n",
       "3                                            350.666885          \n",
       "4                                            350.537881          \n",
       "...                                                 ...          \n",
       "2690                                         962.195773          \n",
       "2691                                         962.195773          \n",
       "2692                                         962.195773          \n",
       "2693                                         962.195773          \n",
       "2694                                         962.195773          \n",
       "\n",
       "      ATLConfocalSettingDefinition.DetectorList.Detector.@Offset  \n",
       "0                                              0.000000           \n",
       "1                                              0.000000           \n",
       "2                                             -0.006667           \n",
       "3                                             -0.006667           \n",
       "4                                              0.000000           \n",
       "...                                                 ...           \n",
       "2690                                           0.000000           \n",
       "2691                                           0.000000           \n",
       "2692                                           0.000000           \n",
       "2693                                           0.000000           \n",
       "2694                                           0.000000           \n",
       "\n",
       "[2695 rows x 8 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "image_meta.iloc[:,164:172]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "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>Dimension.@DimID</th>\n",
       "      <th>Dimension.@NumberOfElements</th>\n",
       "      <th>Dimension.@Origin</th>\n",
       "      <th>Dimension.@Length</th>\n",
       "      <th>Dimension.@Unit</th>\n",
       "      <th>Dimension.@BitInc</th>\n",
       "      <th>Dimension.@BytesInc</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>-0.000007</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>m</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000012</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>m</td>\n",
       "      <td>0</td>\n",
       "      <td>512.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>-0.000007</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>m</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000012</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>m</td>\n",
       "      <td>0</td>\n",
       "      <td>512.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>-0.000007</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>m</td>\n",
       "      <td>0</td>\n",
       "      <td>1.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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2690</th>\n",
       "      <td>1</td>\n",
       "      <td>1872</td>\n",
       "      <td>-0.000043</td>\n",
       "      <td>0.000110</td>\n",
       "      <td>m</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2691</th>\n",
       "      <td>2</td>\n",
       "      <td>1872</td>\n",
       "      <td>-0.000010</td>\n",
       "      <td>0.000110</td>\n",
       "      <td>m</td>\n",
       "      <td>0</td>\n",
       "      <td>1872.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2692</th>\n",
       "      <td>2</td>\n",
       "      <td>1872</td>\n",
       "      <td>-0.000010</td>\n",
       "      <td>0.000110</td>\n",
       "      <td>m</td>\n",
       "      <td>0</td>\n",
       "      <td>1872.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2693</th>\n",
       "      <td>2</td>\n",
       "      <td>1872</td>\n",
       "      <td>-0.000010</td>\n",
       "      <td>0.000110</td>\n",
       "      <td>m</td>\n",
       "      <td>0</td>\n",
       "      <td>1872.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2694</th>\n",
       "      <td>2</td>\n",
       "      <td>1872</td>\n",
       "      <td>-0.000010</td>\n",
       "      <td>0.000110</td>\n",
       "      <td>m</td>\n",
       "      <td>0</td>\n",
       "      <td>1872.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2695 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Dimension.@DimID  Dimension.@NumberOfElements  Dimension.@Origin  \\\n",
       "0                    1                          512          -0.000007   \n",
       "1                    2                          512           0.000012   \n",
       "2                    1                          512          -0.000007   \n",
       "3                    2                          512           0.000012   \n",
       "4                    1                          512          -0.000007   \n",
       "...                ...                          ...                ...   \n",
       "2690                 1                         1872          -0.000043   \n",
       "2691                 2                         1872          -0.000010   \n",
       "2692                 2                         1872          -0.000010   \n",
       "2693                 2                         1872          -0.000010   \n",
       "2694                 2                         1872          -0.000010   \n",
       "\n",
       "      Dimension.@Length Dimension.@Unit  Dimension.@BitInc  \\\n",
       "0              0.000037               m                  0   \n",
       "1              0.000037               m                  0   \n",
       "2              0.000037               m                  0   \n",
       "3              0.000037               m                  0   \n",
       "4              0.000037               m                  0   \n",
       "...                 ...             ...                ...   \n",
       "2690           0.000110               m                  0   \n",
       "2691           0.000110               m                  0   \n",
       "2692           0.000110               m                  0   \n",
       "2693           0.000110               m                  0   \n",
       "2694           0.000110               m                  0   \n",
       "\n",
       "      Dimension.@BytesInc  \n",
       "0                     1.0  \n",
       "1                   512.0  \n",
       "2                     1.0  \n",
       "3                   512.0  \n",
       "4                     1.0  \n",
       "...                   ...  \n",
       "2690                  1.0  \n",
       "2691               1872.0  \n",
       "2692               1872.0  \n",
       "2693               1872.0  \n",
       "2694               1872.0  \n",
       "\n",
       "[2695 rows x 7 columns]"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "image_meta.iloc[:,14:21]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "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>Channel.@DataType</th>\n",
       "      <th>Channel.@ChannelTag</th>\n",
       "      <th>Channel.@Resolution</th>\n",
       "      <th>Channel.@NameOfMeasuredQuantity</th>\n",
       "      <th>Channel.@Min</th>\n",
       "      <th>Channel.@Max</th>\n",
       "      <th>Channel.@Unit</th>\n",
       "      <th>Channel.@LUTName</th>\n",
       "      <th>Channel.@IsLUTInverted</th>\n",
       "      <th>Channel.@BytesInc</th>\n",
       "      <th>Channel.@BitInc</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>255.0</td>\n",
       "      <td></td>\n",
       "      <td>Blue</td>\n",
       "      <td>False</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>255.0</td>\n",
       "      <td></td>\n",
       "      <td>Blue</td>\n",
       "      <td>False</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>255.0</td>\n",
       "      <td></td>\n",
       "      <td>Green</td>\n",
       "      <td>False</td>\n",
       "      <td>262144.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>255.0</td>\n",
       "      <td></td>\n",
       "      <td>Green</td>\n",
       "      <td>False</td>\n",
       "      <td>262144.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>255.0</td>\n",
       "      <td></td>\n",
       "      <td>Gray</td>\n",
       "      <td>False</td>\n",
       "      <td>524288.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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2690</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>255.0</td>\n",
       "      <td></td>\n",
       "      <td>Red</td>\n",
       "      <td>False</td>\n",
       "      <td>10513152.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2691</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>255.0</td>\n",
       "      <td></td>\n",
       "      <td>Red</td>\n",
       "      <td>False</td>\n",
       "      <td>10513152.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2692</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>255.0</td>\n",
       "      <td></td>\n",
       "      <td>Red</td>\n",
       "      <td>False</td>\n",
       "      <td>10513152.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2693</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>255.0</td>\n",
       "      <td></td>\n",
       "      <td>Red</td>\n",
       "      <td>False</td>\n",
       "      <td>10513152.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2694</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td></td>\n",
       "      <td>0.0</td>\n",
       "      <td>255.0</td>\n",
       "      <td></td>\n",
       "      <td>Red</td>\n",
       "      <td>False</td>\n",
       "      <td>10513152.0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2695 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Channel.@DataType  Channel.@ChannelTag  Channel.@Resolution  \\\n",
       "0                    0                    0                    8   \n",
       "1                    0                    0                    8   \n",
       "2                    0                    0                    8   \n",
       "3                    0                    0                    8   \n",
       "4                    0                    0                    8   \n",
       "...                ...                  ...                  ...   \n",
       "2690                 0                    0                    8   \n",
       "2691                 0                    0                    8   \n",
       "2692                 0                    0                    8   \n",
       "2693                 0                    0                    8   \n",
       "2694                 0                    0                    8   \n",
       "\n",
       "     Channel.@NameOfMeasuredQuantity  Channel.@Min  Channel.@Max  \\\n",
       "0                                              0.0         255.0   \n",
       "1                                              0.0         255.0   \n",
       "2                                              0.0         255.0   \n",
       "3                                              0.0         255.0   \n",
       "4                                              0.0         255.0   \n",
       "...                              ...           ...           ...   \n",
       "2690                                           0.0         255.0   \n",
       "2691                                           0.0         255.0   \n",
       "2692                                           0.0         255.0   \n",
       "2693                                           0.0         255.0   \n",
       "2694                                           0.0         255.0   \n",
       "\n",
       "     Channel.@Unit Channel.@LUTName  Channel.@IsLUTInverted  \\\n",
       "0                              Blue                   False   \n",
       "1                              Blue                   False   \n",
       "2                             Green                   False   \n",
       "3                             Green                   False   \n",
       "4                              Gray                   False   \n",
       "...            ...              ...                     ...   \n",
       "2690                            Red                   False   \n",
       "2691                            Red                   False   \n",
       "2692                            Red                   False   \n",
       "2693                            Red                   False   \n",
       "2694                            Red                   False   \n",
       "\n",
       "      Channel.@BytesInc  Channel.@BitInc  \n",
       "0                   0.0                0  \n",
       "1                   0.0                0  \n",
       "2              262144.0                0  \n",
       "3              262144.0                0  \n",
       "4              524288.0                0  \n",
       "...                 ...              ...  \n",
       "2690         10513152.0                0  \n",
       "2691         10513152.0                0  \n",
       "2692         10513152.0                0  \n",
       "2693         10513152.0                0  \n",
       "2694         10513152.0                0  \n",
       "\n",
       "[2695 rows x 11 columns]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "image_meta.iloc[:,3:14]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Add LUT channel to the `image_info` dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Channel related data + file name + image name and id\n",
    "channel_meta = image_meta.iloc[:,0:14]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 2695 entries, 0 to 2694\n",
      "Data columns (total 14 columns):\n",
      " #   Column                           Non-Null Count  Dtype   \n",
      "---  ------                           --------------  -----   \n",
      " 0   FileName                         2695 non-null   object  \n",
      " 1   Image.@Name                      2680 non-null   object  \n",
      " 2   Image.@UniqueID                  2680 non-null   object  \n",
      " 3   Channel.@DataType                2680 non-null   object  \n",
      " 4   Channel.@ChannelTag              2680 non-null   Int64   \n",
      " 5   Channel.@Resolution              2680 non-null   Int64   \n",
      " 6   Channel.@NameOfMeasuredQuantity  2680 non-null   object  \n",
      " 7   Channel.@Min                     2680 non-null   float64 \n",
      " 8   Channel.@Max                     2680 non-null   float64 \n",
      " 9   Channel.@Unit                    2680 non-null   object  \n",
      " 10  Channel.@LUTName                 2680 non-null   category\n",
      " 11  Channel.@IsLUTInverted           2695 non-null   bool    \n",
      " 12  Channel.@BytesInc                2680 non-null   float64 \n",
      " 13  Channel.@BitInc                  2680 non-null   Int64   \n",
      "dtypes: Int64(3), bool(1), category(1), float64(3), object(6)\n",
      "memory usage: 367.1+ KB\n"
     ]
    }
   ],
   "source": [
    "channel_meta.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Remove the duplicated rows that are due to the differente dimensions (2 dimensions for each channel)\n",
    "channel_meta.drop_duplicates(inplace=True, ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Drop the row for which there is no image and no image ID\n",
    "channel_meta.dropna(axis=0, how='all', subset=['Image.@Name', 'Image.@UniqueID', 'Channel.@LUTName'], inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Select the column containing relevant information (LUT information)\n",
    "lut_meta = channel_meta[['FileName', 'Image.@Name', 'Image.@UniqueID', 'Channel.@LUTName']].reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1188 entries, 0 to 1187\n",
      "Data columns (total 4 columns):\n",
      " #   Column            Non-Null Count  Dtype   \n",
      "---  ------            --------------  -----   \n",
      " 0   FileName          1188 non-null   object  \n",
      " 1   Image.@Name       1188 non-null   object  \n",
      " 2   Image.@UniqueID   1188 non-null   object  \n",
      " 3   Channel.@LUTName  1188 non-null   category\n",
      "dtypes: category(1), object(3)\n",
      "memory usage: 29.3+ KB\n"
     ]
    }
   ],
   "source": [
    "lut_meta.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "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>FileName</th>\n",
       "      <th>Image.@Name</th>\n",
       "      <th>Image.@UniqueID</th>\n",
       "      <th>Channel.@LUTName</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>200316_Sample_10.lif</td>\n",
       "      <td>Image001</td>\n",
       "      <td>c976e627-677d-11ea-a94d-002432168676</td>\n",
       "      <td>Blue</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>200316_Sample_10.lif</td>\n",
       "      <td>Image001</td>\n",
       "      <td>c976e627-677d-11ea-a94d-002432168676</td>\n",
       "      <td>Green</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>200316_Sample_10.lif</td>\n",
       "      <td>Image001</td>\n",
       "      <td>c976e627-677d-11ea-a94d-002432168676</td>\n",
       "      <td>Gray</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               FileName Image.@Name                       Image.@UniqueID  \\\n",
       "0  200316_Sample_10.lif    Image001  c976e627-677d-11ea-a94d-002432168676   \n",
       "1  200316_Sample_10.lif    Image001  c976e627-677d-11ea-a94d-002432168676   \n",
       "2  200316_Sample_10.lif    Image001  c976e627-677d-11ea-a94d-002432168676   \n",
       "\n",
       "  Channel.@LUTName  \n",
       "0             Blue  \n",
       "1            Green  \n",
       "2             Gray  "
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "lut_meta.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Merge the LUT information with the image dataframe (dataframe built while extracting the images)\n",
    "image_info = image_info.merge(lut_meta, how='outer', left_index=True, right_index=True, indicator=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 1188 entries, 0 to 1187\n",
      "Data columns (total 12 columns):\n",
      " #   Column            Non-Null Count  Dtype   \n",
      "---  ------            --------------  -----   \n",
      " 0   file              1188 non-null   object  \n",
      " 1   serie             1188 non-null   object  \n",
      " 2   channel           1188 non-null   int64   \n",
      " 3   nbr_frames        1188 non-null   int64   \n",
      " 4   shape_X           1188 non-null   int64   \n",
      " 5   shape_Y           1188 non-null   int64   \n",
      " 6   channel_count     1188 non-null   int64   \n",
      " 7   FileName          1188 non-null   object  \n",
      " 8   Image.@Name       1188 non-null   object  \n",
      " 9   Image.@UniqueID   1188 non-null   object  \n",
      " 10  Channel.@LUTName  1188 non-null   category\n",
      " 11  _merge            1188 non-null   category\n",
      "dtypes: category(2), int64(5), object(5)\n",
      "memory usage: 144.7+ KB\n"
     ]
    }
   ],
   "source": [
    "image_info.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[both]\n",
       "Categories (1, object): [both]"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "image_info['_merge'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "image_info['file_match'] = np.where(image_info['file'] == image_info['FileName'], 'True', 'False')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['True'], dtype=object)"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "image_info['file_match'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "image_info['serie_match'] = np.where(image_info['serie'] == image_info['Image.@Name'], 'True', 'False')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['True'], dtype=object)"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "image_info['serie_match'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "image_info = image_info.drop(['file_match', 'serie_match', 'FileName', 'Image.@Name', '_merge'], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 1188 entries, 0 to 1187\n",
      "Data columns (total 9 columns):\n",
      " #   Column            Non-Null Count  Dtype   \n",
      "---  ------            --------------  -----   \n",
      " 0   file              1188 non-null   object  \n",
      " 1   serie             1188 non-null   object  \n",
      " 2   channel           1188 non-null   int64   \n",
      " 3   nbr_frames        1188 non-null   int64   \n",
      " 4   shape_X           1188 non-null   int64   \n",
      " 5   shape_Y           1188 non-null   int64   \n",
      " 6   channel_count     1188 non-null   int64   \n",
      " 7   Image.@UniqueID   1188 non-null   object  \n",
      " 8   Channel.@LUTName  1188 non-null   category\n",
      "dtypes: category(1), int64(5), object(3)\n",
      "memory usage: 124.9+ KB\n"
     ]
    }
   ],
   "source": [
    "image_info.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "512     744\n",
       "632     220\n",
       "3144    184\n",
       "600      12\n",
       "1408      8\n",
       "2480      8\n",
       "1872      4\n",
       "2608      4\n",
       "320       4\n",
       "Name: shape_X, dtype: int64"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "image_info.shape_X.value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Add physical length information to the `image_info` dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "# '+' concatenates the values of the two lists\n",
    "dimension_meta = image_meta.iloc[:, list(range(0,3)) + list(range(10,11)) + list(range(14,21))]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 2695 entries, 0 to 2694\n",
      "Data columns (total 11 columns):\n",
      " #   Column                       Non-Null Count  Dtype   \n",
      "---  ------                       --------------  -----   \n",
      " 0   FileName                     2695 non-null   object  \n",
      " 1   Image.@Name                  2680 non-null   object  \n",
      " 2   Image.@UniqueID              2680 non-null   object  \n",
      " 3   Channel.@LUTName             2680 non-null   category\n",
      " 4   Dimension.@DimID             2680 non-null   Int64   \n",
      " 5   Dimension.@NumberOfElements  2680 non-null   Int64   \n",
      " 6   Dimension.@Origin            2680 non-null   float64 \n",
      " 7   Dimension.@Length            2680 non-null   float64 \n",
      " 8   Dimension.@Unit              2680 non-null   object  \n",
      " 9   Dimension.@BitInc            2680 non-null   Int64   \n",
      " 10  Dimension.@BytesInc          2680 non-null   float64 \n",
      "dtypes: Int64(3), category(1), float64(3), object(4)\n",
      "memory usage: 322.3+ KB\n"
     ]
    }
   ],
   "source": [
    "dimension_meta.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/virginie/bioformats/py376/lib/python3.7/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",
      "\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": [
    "# Drop duplicated rows\n",
    "dimension_meta.drop_duplicates(inplace=True, ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/virginie/bioformats/py376/lib/python3.7/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",
      "\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": [
    "# Drop the row for which there is no image and no image ID\n",
    "dimension_meta.dropna(axis=0, how='all', subset=['Image.@Name', 'Image.@UniqueID', 'Channel.@LUTName'], inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "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>FileName</th>\n",
       "      <th>Image.@Name</th>\n",
       "      <th>Image.@UniqueID</th>\n",
       "      <th>Channel.@LUTName</th>\n",
       "      <th>Dimension.@DimID</th>\n",
       "      <th>Dimension.@NumberOfElements</th>\n",
       "      <th>Dimension.@Origin</th>\n",
       "      <th>Dimension.@Length</th>\n",
       "      <th>Dimension.@Unit</th>\n",
       "      <th>Dimension.@BitInc</th>\n",
       "      <th>Dimension.@BytesInc</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>200316_Sample_10.lif</td>\n",
       "      <td>Image001</td>\n",
       "      <td>c976e627-677d-11ea-a94d-002432168676</td>\n",
       "      <td>Blue</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>-0.000007</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>m</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>200316_Sample_10.lif</td>\n",
       "      <td>Image001</td>\n",
       "      <td>c976e627-677d-11ea-a94d-002432168676</td>\n",
       "      <td>Blue</td>\n",
       "      <td>2</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000012</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>m</td>\n",
       "      <td>0</td>\n",
       "      <td>512.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>200316_Sample_10.lif</td>\n",
       "      <td>Image001</td>\n",
       "      <td>c976e627-677d-11ea-a94d-002432168676</td>\n",
       "      <td>Green</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>-0.000007</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>m</td>\n",
       "      <td>0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               FileName Image.@Name                       Image.@UniqueID  \\\n",
       "0  200316_Sample_10.lif    Image001  c976e627-677d-11ea-a94d-002432168676   \n",
       "1  200316_Sample_10.lif    Image001  c976e627-677d-11ea-a94d-002432168676   \n",
       "2  200316_Sample_10.lif    Image001  c976e627-677d-11ea-a94d-002432168676   \n",
       "\n",
       "  Channel.@LUTName  Dimension.@DimID  Dimension.@NumberOfElements  \\\n",
       "0             Blue                 1                          512   \n",
       "1             Blue                 2                          512   \n",
       "2            Green                 1                          512   \n",
       "\n",
       "   Dimension.@Origin  Dimension.@Length Dimension.@Unit  Dimension.@BitInc  \\\n",
       "0          -0.000007           0.000037               m                  0   \n",
       "1           0.000012           0.000037               m                  0   \n",
       "2          -0.000007           0.000037               m                  0   \n",
       "\n",
       "   Dimension.@BytesInc  \n",
       "0                  1.0  \n",
       "1                512.0  \n",
       "2                  1.0  "
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dimension_meta.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Select only rows concerning the dimension 1 == X\n",
    "dimension_meta_X = dimension_meta.loc[dimension_meta['Dimension.@DimID'] == 1].add_suffix('_X')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Select only rows concerning the dimension 2 == Y\n",
    "dimension_meta_Y = dimension_meta.loc[dimension_meta['Dimension.@DimID'] == 2].add_suffix('_Y')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Merge the the two dimension-meta dataframe\n",
    "dimension_meta = dimension_meta_X.merge(dimension_meta_Y, how='outer', left_on=['FileName_X', 'Image.@Name_X', 'Image.@UniqueID_X', 'Channel.@LUTName_X'], \n",
    "                       right_on=['FileName_Y', 'Image.@Name_Y', 'Image.@UniqueID_Y', 'Channel.@LUTName_Y'], indicator=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[both]\n",
       "Categories (1, object): [both]"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dimension_meta['_merge'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [],
   "source": [
    "dimension_meta['file_match'] = np.where(dimension_meta['FileName_X'] == dimension_meta['FileName_Y'], 'True', 'False')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['True'], dtype=object)"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dimension_meta['file_match'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [],
   "source": [
    "dimension_meta['serie_match'] = np.where(dimension_meta['Image.@Name_X'] == dimension_meta['Image.@Name_Y'], 'True', 'False')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['True'], dtype=object)"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dimension_meta['serie_match'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [],
   "source": [
    "dimension_meta['id_match'] = np.where(dimension_meta['Image.@UniqueID_X'] == dimension_meta['Image.@UniqueID_Y'], 'True', 'False')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['True'], dtype=object)"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dimension_meta['id_match'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [],
   "source": [
    "dimension_meta['channel_match'] = np.where(dimension_meta['Channel.@LUTName_X'] == dimension_meta['Channel.@LUTName_Y'], 'True', 'False')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['True'], dtype=object)"
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dimension_meta['channel_match'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Drop duplicated and verification columns\n",
    "dimension_meta.drop(['FileName_Y', 'Image.@Name_Y', 'Image.@UniqueID_Y', 'Channel.@LUTName_Y', 'file_match', 'serie_match', 'id_match', \n",
    "                                      'channel_match', '_merge'], axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Select the columns of interest -- > drop the other columns\n",
    "dimension_meta.drop(['Dimension.@Origin_X', 'Dimension.@BitInc_X', 'Dimension.@BytesInc_X', 'Dimension.@Origin_Y', 'Dimension.@BitInc_Y',\n",
    "                     'Dimension.@BytesInc_Y'], axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 1188 entries, 0 to 1187\n",
      "Data columns (total 12 columns):\n",
      " #   Column                         Non-Null Count  Dtype   \n",
      "---  ------                         --------------  -----   \n",
      " 0   FileName_X                     1188 non-null   object  \n",
      " 1   Image.@Name_X                  1188 non-null   object  \n",
      " 2   Image.@UniqueID_X              1188 non-null   object  \n",
      " 3   Channel.@LUTName_X             1188 non-null   category\n",
      " 4   Dimension.@DimID_X             1188 non-null   Int64   \n",
      " 5   Dimension.@NumberOfElements_X  1188 non-null   Int64   \n",
      " 6   Dimension.@Length_X            1188 non-null   float64 \n",
      " 7   Dimension.@Unit_X              1188 non-null   object  \n",
      " 8   Dimension.@DimID_Y             1188 non-null   Int64   \n",
      " 9   Dimension.@NumberOfElements_Y  1188 non-null   Int64   \n",
      " 10  Dimension.@Length_Y            1188 non-null   float64 \n",
      " 11  Dimension.@Unit_Y              1188 non-null   object  \n",
      "dtypes: Int64(4), category(1), float64(2), object(5)\n",
      "memory usage: 117.4+ KB\n"
     ]
    }
   ],
   "source": [
    "dimension_meta.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 1188 entries, 0 to 1187\n",
      "Data columns (total 9 columns):\n",
      " #   Column            Non-Null Count  Dtype   \n",
      "---  ------            --------------  -----   \n",
      " 0   file              1188 non-null   object  \n",
      " 1   serie             1188 non-null   object  \n",
      " 2   channel           1188 non-null   int64   \n",
      " 3   nbr_frames        1188 non-null   int64   \n",
      " 4   shape_X           1188 non-null   int64   \n",
      " 5   shape_Y           1188 non-null   int64   \n",
      " 6   channel_count     1188 non-null   int64   \n",
      " 7   Image.@UniqueID   1188 non-null   object  \n",
      " 8   Channel.@LUTName  1188 non-null   category\n",
      "dtypes: category(1), int64(5), object(3)\n",
      "memory usage: 124.9+ KB\n"
     ]
    }
   ],
   "source": [
    "image_info.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Merge the LUT information with the image dataframe (dataframe built while extracting the images)\n",
    "image_info = image_info.merge(dimension_meta, how='outer', left_on=['file', 'serie', 'Image.@UniqueID', 'Channel.@LUTName'], \n",
    "                       right_on=['FileName_X', 'Image.@Name_X', 'Image.@UniqueID_X', 'Channel.@LUTName_X'], indicator=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[both]\n",
       "Categories (1, object): [both]"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "image_info['_merge'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [],
   "source": [
    "image_info['file_match'] = np.where(image_info['file'] == image_info['FileName_X'], 'True', 'False')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['True'], dtype=object)"
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "image_info['file_match'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {},
   "outputs": [],
   "source": [
    "image_info['serie_match'] = np.where(image_info['serie'] == image_info['Image.@Name_X'], 'True', 'False')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['True'], dtype=object)"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "image_info['serie_match'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "metadata": {},
   "outputs": [],
   "source": [
    "image_info['id_match'] = np.where(image_info['Image.@UniqueID'] == image_info['Image.@UniqueID_X'], 'True', 'False')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['True'], dtype=object)"
      ]
     },
     "execution_count": 80,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "image_info['id_match'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "metadata": {},
   "outputs": [],
   "source": [
    "image_info['channel_match'] = np.where(image_info['Channel.@LUTName'] == image_info['Channel.@LUTName_X'], 'True', 'False')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['True'], dtype=object)"
      ]
     },
     "execution_count": 82,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "image_info['channel_match'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Drop duplicated and verification columns\n",
    "image_info.drop(['FileName_X', 'Image.@Name_X', 'Image.@UniqueID_X', 'Channel.@LUTName_X', 'file_match', 'serie_match', 'id_match', \n",
    "                                      'channel_match', '_merge'], axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 1188 entries, 0 to 1187\n",
      "Data columns (total 17 columns):\n",
      " #   Column                         Non-Null Count  Dtype   \n",
      "---  ------                         --------------  -----   \n",
      " 0   file                           1188 non-null   object  \n",
      " 1   serie                          1188 non-null   object  \n",
      " 2   channel                        1188 non-null   int64   \n",
      " 3   nbr_frames                     1188 non-null   int64   \n",
      " 4   shape_X                        1188 non-null   int64   \n",
      " 5   shape_Y                        1188 non-null   int64   \n",
      " 6   channel_count                  1188 non-null   int64   \n",
      " 7   Image.@UniqueID                1188 non-null   object  \n",
      " 8   Channel.@LUTName               1188 non-null   category\n",
      " 9   Dimension.@DimID_X             1188 non-null   Int64   \n",
      " 10  Dimension.@NumberOfElements_X  1188 non-null   Int64   \n",
      " 11  Dimension.@Length_X            1188 non-null   float64 \n",
      " 12  Dimension.@Unit_X              1188 non-null   object  \n",
      " 13  Dimension.@DimID_Y             1188 non-null   Int64   \n",
      " 14  Dimension.@NumberOfElements_Y  1188 non-null   Int64   \n",
      " 15  Dimension.@Length_Y            1188 non-null   float64 \n",
      " 16  Dimension.@Unit_Y              1188 non-null   object  \n",
      "dtypes: Int64(4), category(1), float64(2), int64(5), object(5)\n",
      "memory usage: 163.8+ KB\n"
     ]
    }
   ],
   "source": [
    "image_info.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Add additional information to the `image_info`dataframe necessary for the image analysis"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "`Zoom` = field of view  \n",
    "`Pixel Size` and `Scan Speed` --> `PixelDwellTime` = the time the laser remains on a pixel  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Get the information of interest\n",
    "setting_meta = image_meta.iloc[:, list(range(0,3)) + list(range(10,11)) + list(range(94,95)) + list(range(98,99)) + list(range(119,120)) + list(range(164,172))]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 2695 entries, 0 to 2694\n",
      "Data columns (total 15 columns):\n",
      " #   Column                                                           Non-Null Count  Dtype   \n",
      "---  ------                                                           --------------  -----   \n",
      " 0   FileName                                                         2695 non-null   object  \n",
      " 1   Image.@Name                                                      2680 non-null   object  \n",
      " 2   Image.@UniqueID                                                  2680 non-null   object  \n",
      " 3   Channel.@LUTName                                                 2680 non-null   category\n",
      " 4   ATLConfocalSettingDefinition.@ScanSpeed                          2680 non-null   float64 \n",
      " 5   ATLConfocalSettingDefinition.@Zoom                               2680 non-null   float64 \n",
      " 6   ATLConfocalSettingDefinition.@PixelDwellTime                     2680 non-null   float64 \n",
      " 7   ATLConfocalSettingDefinition.DetectorList.Detector.@Name         2660 non-null   category\n",
      " 8   ATLConfocalSettingDefinition.DetectorList.Detector.@Type         2660 non-null   category\n",
      " 9   ATLConfocalSettingDefinition.DetectorList.Detector.@ScanType     2660 non-null   category\n",
      " 10  ATLConfocalSettingDefinition.DetectorList.Detector.@Channel      2660 non-null   category\n",
      " 11  ATLConfocalSettingDefinition.DetectorList.Detector.@ChannelName  2660 non-null   category\n",
      " 12  ATLConfocalSettingDefinition.DetectorList.Detector.@IsActive     2660 non-null   object  \n",
      " 13  ATLConfocalSettingDefinition.DetectorList.Detector.@Gain         2660 non-null   float64 \n",
      " 14  ATLConfocalSettingDefinition.DetectorList.Detector.@Offset       2660 non-null   float64 \n",
      "dtypes: category(6), float64(5), object(4)\n",
      "memory usage: 307.3+ KB\n"
     ]
    }
   ],
   "source": [
    "setting_meta.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/virginie/bioformats/py376/lib/python3.7/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",
      "\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": [
    "# Remove the duplicated rows that are due to the differente dimensions (2 dimensions for each channel)\n",
    "setting_meta.drop_duplicates(inplace=True, ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/virginie/bioformats/py376/lib/python3.7/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",
      "\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": [
    "# Drop the row for which there is no image and no image ID\n",
    "setting_meta.dropna(axis=0, how='all', subset=['Image.@Name', 'Image.@UniqueID', 'Channel.@LUTName'], inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/virginie/bioformats/py376/lib/python3.7/site-packages/pandas/core/frame.py:3997: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\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",
      "  errors=errors,\n"
     ]
    }
   ],
   "source": [
    "# Select the columns containing relevant information\n",
    "setting_meta.drop(['ATLConfocalSettingDefinition.DetectorList.Detector.@ScanType', 'ATLConfocalSettingDefinition.DetectorList.Detector.@Channel', 'ATLConfocalSettingDefinition.DetectorList.Detector.@ChannelName',\n",
    "                   'ATLConfocalSettingDefinition.DetectorList.Detector.@IsActive'], axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 1188 entries, 0 to 1190\n",
      "Data columns (total 11 columns):\n",
      " #   Column                                                      Non-Null Count  Dtype   \n",
      "---  ------                                                      --------------  -----   \n",
      " 0   FileName                                                    1188 non-null   object  \n",
      " 1   Image.@Name                                                 1188 non-null   object  \n",
      " 2   Image.@UniqueID                                             1188 non-null   object  \n",
      " 3   Channel.@LUTName                                            1188 non-null   category\n",
      " 4   ATLConfocalSettingDefinition.@ScanSpeed                     1188 non-null   float64 \n",
      " 5   ATLConfocalSettingDefinition.@Zoom                          1188 non-null   float64 \n",
      " 6   ATLConfocalSettingDefinition.@PixelDwellTime                1188 non-null   float64 \n",
      " 7   ATLConfocalSettingDefinition.DetectorList.Detector.@Name    1179 non-null   category\n",
      " 8   ATLConfocalSettingDefinition.DetectorList.Detector.@Type    1179 non-null   category\n",
      " 9   ATLConfocalSettingDefinition.DetectorList.Detector.@Gain    1179 non-null   float64 \n",
      " 10  ATLConfocalSettingDefinition.DetectorList.Detector.@Offset  1179 non-null   float64 \n",
      "dtypes: category(3), float64(5), object(3)\n",
      "memory usage: 87.5+ KB\n"
     ]
    }
   ],
   "source": [
    "setting_meta.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Merge the setting dataframe with the image_info datfarame\n",
    "image_info = image_info.merge(setting_meta, how='inner', left_on=['file', 'serie', 'Image.@UniqueID', 'Channel.@LUTName'], right_on=['FileName', 'Image.@Name', 'Image.@UniqueID', 'Channel.@LUTName'], indicator=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[both]\n",
       "Categories (1, object): [both]"
      ]
     },
     "execution_count": 92,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "image_info['_merge'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "metadata": {},
   "outputs": [],
   "source": [
    "image_info['file_match'] = np.where(image_info['file'] == image_info['FileName'], 'True', 'False')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['True'], dtype=object)"
      ]
     },
     "execution_count": 94,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "image_info['file_match'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "metadata": {},
   "outputs": [],
   "source": [
    "image_info['serie_match'] = np.where(image_info['serie'] == image_info['Image.@Name'], 'True', 'False')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['True'], dtype=object)"
      ]
     },
     "execution_count": 96,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "image_info['serie_match'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "metadata": {},
   "outputs": [],
   "source": [
    "image_info.drop(['file_match', 'serie_match', '_merge', 'FileName', 'Image.@Name'], axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 98,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 1188 entries, 0 to 1187\n",
      "Data columns (total 24 columns):\n",
      " #   Column                                                      Non-Null Count  Dtype   \n",
      "---  ------                                                      --------------  -----   \n",
      " 0   file                                                        1188 non-null   object  \n",
      " 1   serie                                                       1188 non-null   object  \n",
      " 2   channel                                                     1188 non-null   int64   \n",
      " 3   nbr_frames                                                  1188 non-null   int64   \n",
      " 4   shape_X                                                     1188 non-null   int64   \n",
      " 5   shape_Y                                                     1188 non-null   int64   \n",
      " 6   channel_count                                               1188 non-null   int64   \n",
      " 7   Image.@UniqueID                                             1188 non-null   object  \n",
      " 8   Channel.@LUTName                                            1188 non-null   category\n",
      " 9   Dimension.@DimID_X                                          1188 non-null   Int64   \n",
      " 10  Dimension.@NumberOfElements_X                               1188 non-null   Int64   \n",
      " 11  Dimension.@Length_X                                         1188 non-null   float64 \n",
      " 12  Dimension.@Unit_X                                           1188 non-null   object  \n",
      " 13  Dimension.@DimID_Y                                          1188 non-null   Int64   \n",
      " 14  Dimension.@NumberOfElements_Y                               1188 non-null   Int64   \n",
      " 15  Dimension.@Length_Y                                         1188 non-null   float64 \n",
      " 16  Dimension.@Unit_Y                                           1188 non-null   object  \n",
      " 17  ATLConfocalSettingDefinition.@ScanSpeed                     1188 non-null   float64 \n",
      " 18  ATLConfocalSettingDefinition.@Zoom                          1188 non-null   float64 \n",
      " 19  ATLConfocalSettingDefinition.@PixelDwellTime                1188 non-null   float64 \n",
      " 20  ATLConfocalSettingDefinition.DetectorList.Detector.@Name    1179 non-null   category\n",
      " 21  ATLConfocalSettingDefinition.DetectorList.Detector.@Type    1179 non-null   category\n",
      " 22  ATLConfocalSettingDefinition.DetectorList.Detector.@Gain    1179 non-null   float64 \n",
      " 23  ATLConfocalSettingDefinition.DetectorList.Detector.@Offset  1179 non-null   float64 \n",
      "dtypes: Int64(4), category(3), float64(7), int64(5), object(5)\n",
      "memory usage: 212.8+ KB\n"
     ]
    }
   ],
   "source": [
    "image_info.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 99,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Save current `image_info` dataframe to parquet:\n",
    "image_info.to_parquet('image_info_dataframe.parquet')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "metadata": {},
   "outputs": [],
   "source": [
    "image_arrays = sorted(glob.glob('../notebooks/image_processing/image_arrays/*.npy'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[]"
      ]
     },
     "execution_count": 101,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "image_arrays"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "metadata": {},
   "outputs": [],
   "source": [
    "shape_dict = image_info.groupby(['shape_X', 'shape_Y']).indices"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "metadata": {},
   "outputs": [],
   "source": [
    "name_list = []\n",
    "shape_list = []\n",
    "arrays = dict()\n",
    "\n",
    "for indices, array in zip(shape_dict, image_arrays):\n",
    "    name_list.append(Path(array).stem)\n",
    "    shape_list.append(indices)\n",
    "    images = np.load(array)\n",
    "    for idx, img in zip(shape_dict[indices], images):\n",
    "        arrays.update({idx:img})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 104,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 104,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(arrays)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 105,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[]"
      ]
     },
     "execution_count": 105,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "name_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[]"
      ]
     },
     "execution_count": 106,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "shape_list"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Select for the samples with intracellular *Listeria*"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Select the rows of interest"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 107,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_probes = image_info[image_info['file'].str.contains('Probes')]\n",
    "df_sample = image_info[image_info['file'].str.contains('Sample')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Combine all the images of interest in one dataframe\n",
    "df_eukaryote = pd.concat([df_probes, df_sample], axis=0, join='outer', ignore_index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 109,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 484 entries, 168 to 455\n",
      "Data columns (total 24 columns):\n",
      " #   Column                                                      Non-Null Count  Dtype   \n",
      "---  ------                                                      --------------  -----   \n",
      " 0   file                                                        484 non-null    object  \n",
      " 1   serie                                                       484 non-null    object  \n",
      " 2   channel                                                     484 non-null    int64   \n",
      " 3   nbr_frames                                                  484 non-null    int64   \n",
      " 4   shape_X                                                     484 non-null    int64   \n",
      " 5   shape_Y                                                     484 non-null    int64   \n",
      " 6   channel_count                                               484 non-null    int64   \n",
      " 7   Image.@UniqueID                                             484 non-null    object  \n",
      " 8   Channel.@LUTName                                            484 non-null    category\n",
      " 9   Dimension.@DimID_X                                          484 non-null    Int64   \n",
      " 10  Dimension.@NumberOfElements_X                               484 non-null    Int64   \n",
      " 11  Dimension.@Length_X                                         484 non-null    float64 \n",
      " 12  Dimension.@Unit_X                                           484 non-null    object  \n",
      " 13  Dimension.@DimID_Y                                          484 non-null    Int64   \n",
      " 14  Dimension.@NumberOfElements_Y                               484 non-null    Int64   \n",
      " 15  Dimension.@Length_Y                                         484 non-null    float64 \n",
      " 16  Dimension.@Unit_Y                                           484 non-null    object  \n",
      " 17  ATLConfocalSettingDefinition.@ScanSpeed                     484 non-null    float64 \n",
      " 18  ATLConfocalSettingDefinition.@Zoom                          484 non-null    float64 \n",
      " 19  ATLConfocalSettingDefinition.@PixelDwellTime                484 non-null    float64 \n",
      " 20  ATLConfocalSettingDefinition.DetectorList.Detector.@Name    484 non-null    category\n",
      " 21  ATLConfocalSettingDefinition.DetectorList.Detector.@Type    484 non-null    category\n",
      " 22  ATLConfocalSettingDefinition.DetectorList.Detector.@Gain    484 non-null    float64 \n",
      " 23  ATLConfocalSettingDefinition.DetectorList.Detector.@Offset  484 non-null    float64 \n",
      "dtypes: Int64(4), category(3), float64(7), int64(5), object(5)\n",
      "memory usage: 87.0+ KB\n"
     ]
    }
   ],
   "source": [
    "df_eukaryote.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Save the dataframe to parquet"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 110,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_eukaryote.to_parquet('df_eukaryote.parquet')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Check the dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "metadata": {},
   "outputs": [],
   "source": [
    "euk = pd.read_parquet('df_eukaryote.parquet')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 112,
   "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>file</th>\n",
       "      <th>serie</th>\n",
       "      <th>channel</th>\n",
       "      <th>nbr_frames</th>\n",
       "      <th>shape_X</th>\n",
       "      <th>shape_Y</th>\n",
       "      <th>channel_count</th>\n",
       "      <th>Image.@UniqueID</th>\n",
       "      <th>Channel.@LUTName</th>\n",
       "      <th>Dimension.@DimID_X</th>\n",
       "      <th>...</th>\n",
       "      <th>Dimension.@NumberOfElements_Y</th>\n",
       "      <th>Dimension.@Length_Y</th>\n",
       "      <th>Dimension.@Unit_Y</th>\n",
       "      <th>ATLConfocalSettingDefinition.@ScanSpeed</th>\n",
       "      <th>ATLConfocalSettingDefinition.@Zoom</th>\n",
       "      <th>ATLConfocalSettingDefinition.@PixelDwellTime</th>\n",
       "      <th>ATLConfocalSettingDefinition.DetectorList.Detector.@Name</th>\n",
       "      <th>ATLConfocalSettingDefinition.DetectorList.Detector.@Type</th>\n",
       "      <th>ATLConfocalSettingDefinition.DetectorList.Detector.@Gain</th>\n",
       "      <th>ATLConfocalSettingDefinition.DetectorList.Detector.@Offset</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>200316_1_NoProbes.lif</td>\n",
       "      <td>Image001</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>07e1048b-6795-11ea-a94d-002432168676</td>\n",
       "      <td>Blue</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000185</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>PMT 3</td>\n",
       "      <td>PMT</td>\n",
       "      <td>600.289921</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>200316_1_NoProbes.lif</td>\n",
       "      <td>Image001</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>07e1048b-6795-11ea-a94d-002432168676</td>\n",
       "      <td>Green</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000185</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>HyD4 SMD</td>\n",
       "      <td>HyD</td>\n",
       "      <td>350.666885</td>\n",
       "      <td>-0.006667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>200316_1_NoProbes.lif</td>\n",
       "      <td>Image001</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>07e1048b-6795-11ea-a94d-002432168676</td>\n",
       "      <td>Gray</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000185</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>PMT Trans</td>\n",
       "      <td>PMT</td>\n",
       "      <td>350.537881</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>200316_1_NoProbes.lif</td>\n",
       "      <td>Image001</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>07e1048b-6795-11ea-a94d-002432168676</td>\n",
       "      <td>Red</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000185</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>PMT 5</td>\n",
       "      <td>PMT</td>\n",
       "      <td>600.404364</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>200316_1_NoProbes.lif</td>\n",
       "      <td>Image002</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>30830004-6795-11ea-a94d-002432168676</td>\n",
       "      <td>Blue</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000185</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>PMT 3</td>\n",
       "      <td>PMT</td>\n",
       "      <td>600.289921</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>200316_1_NoProbes.lif</td>\n",
       "      <td>Image002</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>30830004-6795-11ea-a94d-002432168676</td>\n",
       "      <td>Green</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000185</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>HyD4 SMD</td>\n",
       "      <td>HyD</td>\n",
       "      <td>350.666885</td>\n",
       "      <td>-0.006667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>200316_1_NoProbes.lif</td>\n",
       "      <td>Image002</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>30830004-6795-11ea-a94d-002432168676</td>\n",
       "      <td>Gray</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000185</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>PMT Trans</td>\n",
       "      <td>PMT</td>\n",
       "      <td>350.537881</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>200316_1_NoProbes.lif</td>\n",
       "      <td>Image002</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>30830004-6795-11ea-a94d-002432168676</td>\n",
       "      <td>Red</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000185</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>PMT 5</td>\n",
       "      <td>PMT</td>\n",
       "      <td>600.404364</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>200316_3_Triton_Probes.lif</td>\n",
       "      <td>Image001</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>632</td>\n",
       "      <td>632</td>\n",
       "      <td>4</td>\n",
       "      <td>fbbd1930-6793-11ea-a94d-002432168676</td>\n",
       "      <td>Blue</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>632</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>5.000013</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>PMT 3</td>\n",
       "      <td>PMT</td>\n",
       "      <td>600.289921</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>257</th>\n",
       "      <td>200316_3_Triton_Probes.lif</td>\n",
       "      <td>Image001</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>632</td>\n",
       "      <td>632</td>\n",
       "      <td>4</td>\n",
       "      <td>fbbd1930-6793-11ea-a94d-002432168676</td>\n",
       "      <td>Green</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>632</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>5.000013</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>HyD4 SMD</td>\n",
       "      <td>HyD</td>\n",
       "      <td>350.666885</td>\n",
       "      <td>-0.006667</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                           file     serie  channel  nbr_frames  shape_X  \\\n",
       "168       200316_1_NoProbes.lif  Image001        0           1      512   \n",
       "169       200316_1_NoProbes.lif  Image001        1           1      512   \n",
       "170       200316_1_NoProbes.lif  Image001        2           1      512   \n",
       "171       200316_1_NoProbes.lif  Image001        3           1      512   \n",
       "172       200316_1_NoProbes.lif  Image002        0           1      512   \n",
       "173       200316_1_NoProbes.lif  Image002        1           1      512   \n",
       "174       200316_1_NoProbes.lif  Image002        2           1      512   \n",
       "175       200316_1_NoProbes.lif  Image002        3           1      512   \n",
       "256  200316_3_Triton_Probes.lif  Image001        0           1      632   \n",
       "257  200316_3_Triton_Probes.lif  Image001        1           1      632   \n",
       "\n",
       "     shape_Y  channel_count                       Image.@UniqueID  \\\n",
       "168      512              4  07e1048b-6795-11ea-a94d-002432168676   \n",
       "169      512              4  07e1048b-6795-11ea-a94d-002432168676   \n",
       "170      512              4  07e1048b-6795-11ea-a94d-002432168676   \n",
       "171      512              4  07e1048b-6795-11ea-a94d-002432168676   \n",
       "172      512              4  30830004-6795-11ea-a94d-002432168676   \n",
       "173      512              4  30830004-6795-11ea-a94d-002432168676   \n",
       "174      512              4  30830004-6795-11ea-a94d-002432168676   \n",
       "175      512              4  30830004-6795-11ea-a94d-002432168676   \n",
       "256      632              4  fbbd1930-6793-11ea-a94d-002432168676   \n",
       "257      632              4  fbbd1930-6793-11ea-a94d-002432168676   \n",
       "\n",
       "    Channel.@LUTName  Dimension.@DimID_X  ...  Dimension.@NumberOfElements_Y  \\\n",
       "168             Blue                   1  ...                            512   \n",
       "169            Green                   1  ...                            512   \n",
       "170             Gray                   1  ...                            512   \n",
       "171              Red                   1  ...                            512   \n",
       "172             Blue                   1  ...                            512   \n",
       "173            Green                   1  ...                            512   \n",
       "174             Gray                   1  ...                            512   \n",
       "175              Red                   1  ...                            512   \n",
       "256             Blue                   1  ...                            632   \n",
       "257            Green                   1  ...                            632   \n",
       "\n",
       "     Dimension.@Length_Y Dimension.@Unit_Y  \\\n",
       "168             0.000185                 m   \n",
       "169             0.000185                 m   \n",
       "170             0.000185                 m   \n",
       "171             0.000185                 m   \n",
       "172             0.000185                 m   \n",
       "173             0.000185                 m   \n",
       "174             0.000185                 m   \n",
       "175             0.000185                 m   \n",
       "256             0.000037                 m   \n",
       "257             0.000037                 m   \n",
       "\n",
       "     ATLConfocalSettingDefinition.@ScanSpeed  \\\n",
       "168                                    400.0   \n",
       "169                                    400.0   \n",
       "170                                    400.0   \n",
       "171                                    400.0   \n",
       "172                                    400.0   \n",
       "173                                    400.0   \n",
       "174                                    400.0   \n",
       "175                                    400.0   \n",
       "256                                    400.0   \n",
       "257                                    400.0   \n",
       "\n",
       "     ATLConfocalSettingDefinition.@Zoom  \\\n",
       "168                            1.000000   \n",
       "169                            1.000000   \n",
       "170                            1.000000   \n",
       "171                            1.000000   \n",
       "172                            1.000000   \n",
       "173                            1.000000   \n",
       "174                            1.000000   \n",
       "175                            1.000000   \n",
       "256                            5.000013   \n",
       "257                            5.000013   \n",
       "\n",
       "     ATLConfocalSettingDefinition.@PixelDwellTime  \\\n",
       "168                                      0.000003   \n",
       "169                                      0.000003   \n",
       "170                                      0.000003   \n",
       "171                                      0.000003   \n",
       "172                                      0.000003   \n",
       "173                                      0.000003   \n",
       "174                                      0.000003   \n",
       "175                                      0.000003   \n",
       "256                                      0.000003   \n",
       "257                                      0.000003   \n",
       "\n",
       "    ATLConfocalSettingDefinition.DetectorList.Detector.@Name  \\\n",
       "168                                              PMT 3         \n",
       "169                                           HyD4 SMD         \n",
       "170                                          PMT Trans         \n",
       "171                                              PMT 5         \n",
       "172                                              PMT 3         \n",
       "173                                           HyD4 SMD         \n",
       "174                                          PMT Trans         \n",
       "175                                              PMT 5         \n",
       "256                                              PMT 3         \n",
       "257                                           HyD4 SMD         \n",
       "\n",
       "     ATLConfocalSettingDefinition.DetectorList.Detector.@Type  \\\n",
       "168                                                PMT          \n",
       "169                                                HyD          \n",
       "170                                                PMT          \n",
       "171                                                PMT          \n",
       "172                                                PMT          \n",
       "173                                                HyD          \n",
       "174                                                PMT          \n",
       "175                                                PMT          \n",
       "256                                                PMT          \n",
       "257                                                HyD          \n",
       "\n",
       "     ATLConfocalSettingDefinition.DetectorList.Detector.@Gain  \\\n",
       "168                                         600.289921          \n",
       "169                                         350.666885          \n",
       "170                                         350.537881          \n",
       "171                                         600.404364          \n",
       "172                                         600.289921          \n",
       "173                                         350.666885          \n",
       "174                                         350.537881          \n",
       "175                                         600.404364          \n",
       "256                                         600.289921          \n",
       "257                                         350.666885          \n",
       "\n",
       "     ATLConfocalSettingDefinition.DetectorList.Detector.@Offset  \n",
       "168                                           0.000000           \n",
       "169                                          -0.006667           \n",
       "170                                           0.000000           \n",
       "171                                           0.000000           \n",
       "172                                           0.000000           \n",
       "173                                          -0.006667           \n",
       "174                                           0.000000           \n",
       "175                                           0.000000           \n",
       "256                                           0.000000           \n",
       "257                                          -0.006667           \n",
       "\n",
       "[10 rows x 24 columns]"
      ]
     },
     "execution_count": 112,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "euk.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 484 entries, 168 to 455\n",
      "Data columns (total 24 columns):\n",
      " #   Column                                                      Non-Null Count  Dtype   \n",
      "---  ------                                                      --------------  -----   \n",
      " 0   file                                                        484 non-null    object  \n",
      " 1   serie                                                       484 non-null    object  \n",
      " 2   channel                                                     484 non-null    int64   \n",
      " 3   nbr_frames                                                  484 non-null    int64   \n",
      " 4   shape_X                                                     484 non-null    int64   \n",
      " 5   shape_Y                                                     484 non-null    int64   \n",
      " 6   channel_count                                               484 non-null    int64   \n",
      " 7   Image.@UniqueID                                             484 non-null    object  \n",
      " 8   Channel.@LUTName                                            484 non-null    category\n",
      " 9   Dimension.@DimID_X                                          484 non-null    Int64   \n",
      " 10  Dimension.@NumberOfElements_X                               484 non-null    Int64   \n",
      " 11  Dimension.@Length_X                                         484 non-null    float64 \n",
      " 12  Dimension.@Unit_X                                           484 non-null    object  \n",
      " 13  Dimension.@DimID_Y                                          484 non-null    Int64   \n",
      " 14  Dimension.@NumberOfElements_Y                               484 non-null    Int64   \n",
      " 15  Dimension.@Length_Y                                         484 non-null    float64 \n",
      " 16  Dimension.@Unit_Y                                           484 non-null    object  \n",
      " 17  ATLConfocalSettingDefinition.@ScanSpeed                     484 non-null    float64 \n",
      " 18  ATLConfocalSettingDefinition.@Zoom                          484 non-null    float64 \n",
      " 19  ATLConfocalSettingDefinition.@PixelDwellTime                484 non-null    float64 \n",
      " 20  ATLConfocalSettingDefinition.DetectorList.Detector.@Name    484 non-null    category\n",
      " 21  ATLConfocalSettingDefinition.DetectorList.Detector.@Type    484 non-null    category\n",
      " 22  ATLConfocalSettingDefinition.DetectorList.Detector.@Gain    484 non-null    float64 \n",
      " 23  ATLConfocalSettingDefinition.DetectorList.Detector.@Offset  484 non-null    float64 \n",
      "dtypes: Int64(4), category(3), float64(7), int64(5), object(5)\n",
      "memory usage: 87.0+ KB\n"
     ]
    }
   ],
   "source": [
    "euk.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 138,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "file                                                                          200316_Sample_12.lif\n",
       "serie                                                                                     Image006\n",
       "channel                                                                                          3\n",
       "nbr_frames                                                                                       1\n",
       "shape_X                                                                                        632\n",
       "shape_Y                                                                                        632\n",
       "channel_count                                                                                    4\n",
       "Image.@UniqueID                                               1b0253c9-6781-11ea-a94d-002432168676\n",
       "Channel.@LUTName                                                                               Red\n",
       "Dimension.@DimID_X                                                                               1\n",
       "Dimension.@NumberOfElements_X                                                                  632\n",
       "Dimension.@Length_X                                                                    3.69047e-05\n",
       "Dimension.@Unit_X                                                                                m\n",
       "Dimension.@DimID_Y                                                                               2\n",
       "Dimension.@NumberOfElements_Y                                                                  632\n",
       "Dimension.@Length_Y                                                                    3.69047e-05\n",
       "Dimension.@Unit_Y                                                                                m\n",
       "ATLConfocalSettingDefinition.@ScanSpeed                                                        400\n",
       "ATLConfocalSettingDefinition.@Zoom                                                         5.00001\n",
       "ATLConfocalSettingDefinition.@PixelDwellTime                                            2.5625e-06\n",
       "ATLConfocalSettingDefinition.DetectorList.Detector.@Name                                     PMT 5\n",
       "ATLConfocalSettingDefinition.DetectorList.Detector.@Type                                       PMT\n",
       "ATLConfocalSettingDefinition.DetectorList.Detector.@Gain                                   600.404\n",
       "ATLConfocalSettingDefinition.DetectorList.Detector.@Offset                                       0\n",
       "Name: 43, dtype: object"
      ]
     },
     "execution_count": 138,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "euk.loc[43]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 118,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['200316_1_NoProbes.lif', '200316_3_Triton_Probes.lif',\n",
       "       '200310_Probes.lif', '200316_Sample_10.lif',\n",
       "       '200316_Sample_12.lif', '200316_Sample_5.lif',\n",
       "       '200316_Sample_4.lif', '200316_Sample_6.lif',\n",
       "       '200311_Sample_1.lif', '200311_Sample_2.lif',\n",
       "       '200311_Sample_4.lif', '200311_Sample_9.lif',\n",
       "       '200311_Sample_11.lif'], dtype=object)"
      ]
     },
     "execution_count": 118,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "euk['file'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 140,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Int64Index([168, 169, 170, 171, 172, 173, 174, 175], dtype='int64')"
      ]
     },
     "execution_count": 140,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "euk[euk['file']=='200316_1_NoProbes.lif'].index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 137,
   "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>file</th>\n",
       "      <th>serie</th>\n",
       "      <th>channel</th>\n",
       "      <th>nbr_frames</th>\n",
       "      <th>shape_X</th>\n",
       "      <th>shape_Y</th>\n",
       "      <th>channel_count</th>\n",
       "      <th>Image.@UniqueID</th>\n",
       "      <th>Channel.@LUTName</th>\n",
       "      <th>Dimension.@DimID_X</th>\n",
       "      <th>...</th>\n",
       "      <th>Dimension.@NumberOfElements_Y</th>\n",
       "      <th>Dimension.@Length_Y</th>\n",
       "      <th>Dimension.@Unit_Y</th>\n",
       "      <th>ATLConfocalSettingDefinition.@ScanSpeed</th>\n",
       "      <th>ATLConfocalSettingDefinition.@Zoom</th>\n",
       "      <th>ATLConfocalSettingDefinition.@PixelDwellTime</th>\n",
       "      <th>ATLConfocalSettingDefinition.DetectorList.Detector.@Name</th>\n",
       "      <th>ATLConfocalSettingDefinition.DetectorList.Detector.@Type</th>\n",
       "      <th>ATLConfocalSettingDefinition.DetectorList.Detector.@Gain</th>\n",
       "      <th>ATLConfocalSettingDefinition.DetectorList.Detector.@Offset</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1052</th>\n",
       "      <td>200310_Probes.lif</td>\n",
       "      <td>Image001</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>f23725aa-62c4-11ea-a946-002432168676</td>\n",
       "      <td>Blue</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>5.000013</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>PMT 3</td>\n",
       "      <td>PMT</td>\n",
       "      <td>600.308995</td>\n",
       "      <td>-0.073333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1053</th>\n",
       "      <td>200310_Probes.lif</td>\n",
       "      <td>Image001</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>f23725aa-62c4-11ea-a946-002432168676</td>\n",
       "      <td>Green</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>5.000013</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>HyD4 SMD</td>\n",
       "      <td>HyD</td>\n",
       "      <td>349.980225</td>\n",
       "      <td>-0.006667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1054</th>\n",
       "      <td>200310_Probes.lif</td>\n",
       "      <td>Image001</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>f23725aa-62c4-11ea-a946-002432168676</td>\n",
       "      <td>Gray</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>5.000013</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>PMT Trans</td>\n",
       "      <td>PMT</td>\n",
       "      <td>400.034333</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1055</th>\n",
       "      <td>200310_Probes.lif</td>\n",
       "      <td>Image001</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>f23725aa-62c4-11ea-a946-002432168676</td>\n",
       "      <td>Red</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>5.000013</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>PMT 5</td>\n",
       "      <td>PMT</td>\n",
       "      <td>600.862135</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1056</th>\n",
       "      <td>200310_Probes.lif</td>\n",
       "      <td>Image002</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>fb3a707e-62c4-11ea-a946-002432168676</td>\n",
       "      <td>Blue</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000185</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>PMT 3</td>\n",
       "      <td>PMT</td>\n",
       "      <td>600.308995</td>\n",
       "      <td>-0.073333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1057</th>\n",
       "      <td>200310_Probes.lif</td>\n",
       "      <td>Image002</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>fb3a707e-62c4-11ea-a946-002432168676</td>\n",
       "      <td>Green</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000185</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>HyD4 SMD</td>\n",
       "      <td>HyD</td>\n",
       "      <td>349.980225</td>\n",
       "      <td>-0.006667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1058</th>\n",
       "      <td>200310_Probes.lif</td>\n",
       "      <td>Image002</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>fb3a707e-62c4-11ea-a946-002432168676</td>\n",
       "      <td>Gray</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000185</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>PMT Trans</td>\n",
       "      <td>PMT</td>\n",
       "      <td>400.034333</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1059</th>\n",
       "      <td>200310_Probes.lif</td>\n",
       "      <td>Image002</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>fb3a707e-62c4-11ea-a946-002432168676</td>\n",
       "      <td>Red</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000185</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>PMT 5</td>\n",
       "      <td>PMT</td>\n",
       "      <td>600.862135</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1060</th>\n",
       "      <td>200310_Probes.lif</td>\n",
       "      <td>Image003</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>19cd9973-62c5-11ea-a946-002432168676</td>\n",
       "      <td>Blue</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000185</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>PMT 3</td>\n",
       "      <td>PMT</td>\n",
       "      <td>600.308995</td>\n",
       "      <td>-0.073333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1061</th>\n",
       "      <td>200310_Probes.lif</td>\n",
       "      <td>Image003</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>19cd9973-62c5-11ea-a946-002432168676</td>\n",
       "      <td>Green</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000185</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>HyD4 SMD</td>\n",
       "      <td>HyD</td>\n",
       "      <td>349.980225</td>\n",
       "      <td>-0.006667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1062</th>\n",
       "      <td>200310_Probes.lif</td>\n",
       "      <td>Image003</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>19cd9973-62c5-11ea-a946-002432168676</td>\n",
       "      <td>Gray</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000185</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>PMT Trans</td>\n",
       "      <td>PMT</td>\n",
       "      <td>400.034333</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1063</th>\n",
       "      <td>200310_Probes.lif</td>\n",
       "      <td>Image003</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>19cd9973-62c5-11ea-a946-002432168676</td>\n",
       "      <td>Red</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000185</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>PMT 5</td>\n",
       "      <td>PMT</td>\n",
       "      <td>600.862135</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1064</th>\n",
       "      <td>200310_Probes.lif</td>\n",
       "      <td>Image004</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>206f078a-62c5-11ea-a946-002432168676</td>\n",
       "      <td>Blue</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000185</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>PMT 3</td>\n",
       "      <td>PMT</td>\n",
       "      <td>600.308995</td>\n",
       "      <td>-0.073333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1065</th>\n",
       "      <td>200310_Probes.lif</td>\n",
       "      <td>Image004</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>206f078a-62c5-11ea-a946-002432168676</td>\n",
       "      <td>Green</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000185</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>HyD4 SMD</td>\n",
       "      <td>HyD</td>\n",
       "      <td>349.980225</td>\n",
       "      <td>-0.006667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1066</th>\n",
       "      <td>200310_Probes.lif</td>\n",
       "      <td>Image004</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>206f078a-62c5-11ea-a946-002432168676</td>\n",
       "      <td>Gray</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000185</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>PMT Trans</td>\n",
       "      <td>PMT</td>\n",
       "      <td>400.034333</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1067</th>\n",
       "      <td>200310_Probes.lif</td>\n",
       "      <td>Image004</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>206f078a-62c5-11ea-a946-002432168676</td>\n",
       "      <td>Red</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000185</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>PMT 5</td>\n",
       "      <td>PMT</td>\n",
       "      <td>600.862135</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1068</th>\n",
       "      <td>200310_Probes.lif</td>\n",
       "      <td>Image005</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>44a00fac-62c5-11ea-a946-002432168676</td>\n",
       "      <td>Blue</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>5.000013</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>PMT 3</td>\n",
       "      <td>PMT</td>\n",
       "      <td>600.308995</td>\n",
       "      <td>-0.073333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1069</th>\n",
       "      <td>200310_Probes.lif</td>\n",
       "      <td>Image005</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>44a00fac-62c5-11ea-a946-002432168676</td>\n",
       "      <td>Green</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>5.000013</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>HyD4 SMD</td>\n",
       "      <td>HyD</td>\n",
       "      <td>349.980225</td>\n",
       "      <td>-0.006667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1070</th>\n",
       "      <td>200310_Probes.lif</td>\n",
       "      <td>Image005</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>44a00fac-62c5-11ea-a946-002432168676</td>\n",
       "      <td>Gray</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>5.000013</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>PMT Trans</td>\n",
       "      <td>PMT</td>\n",
       "      <td>400.034333</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1071</th>\n",
       "      <td>200310_Probes.lif</td>\n",
       "      <td>Image005</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>44a00fac-62c5-11ea-a946-002432168676</td>\n",
       "      <td>Red</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>5.000013</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>PMT 5</td>\n",
       "      <td>PMT</td>\n",
       "      <td>600.862135</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1072</th>\n",
       "      <td>200310_Probes.lif</td>\n",
       "      <td>Image006</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>668c66ed-62c5-11ea-a946-002432168676</td>\n",
       "      <td>Blue</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>5.000013</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>PMT 3</td>\n",
       "      <td>PMT</td>\n",
       "      <td>600.308995</td>\n",
       "      <td>-0.073333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1073</th>\n",
       "      <td>200310_Probes.lif</td>\n",
       "      <td>Image006</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>668c66ed-62c5-11ea-a946-002432168676</td>\n",
       "      <td>Green</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>5.000013</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>HyD4 SMD</td>\n",
       "      <td>HyD</td>\n",
       "      <td>349.980225</td>\n",
       "      <td>-0.006667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1074</th>\n",
       "      <td>200310_Probes.lif</td>\n",
       "      <td>Image006</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>668c66ed-62c5-11ea-a946-002432168676</td>\n",
       "      <td>Gray</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>5.000013</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>PMT Trans</td>\n",
       "      <td>PMT</td>\n",
       "      <td>400.034333</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1075</th>\n",
       "      <td>200310_Probes.lif</td>\n",
       "      <td>Image006</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>668c66ed-62c5-11ea-a946-002432168676</td>\n",
       "      <td>Red</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>5.000013</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>PMT 5</td>\n",
       "      <td>PMT</td>\n",
       "      <td>600.862135</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1076</th>\n",
       "      <td>200310_Probes.lif</td>\n",
       "      <td>Image007</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>7c11fc02-62c5-11ea-a946-002432168676</td>\n",
       "      <td>Blue</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>5.000013</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>PMT 3</td>\n",
       "      <td>PMT</td>\n",
       "      <td>600.308995</td>\n",
       "      <td>-0.073333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1077</th>\n",
       "      <td>200310_Probes.lif</td>\n",
       "      <td>Image007</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>7c11fc02-62c5-11ea-a946-002432168676</td>\n",
       "      <td>Green</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>5.000013</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>HyD4 SMD</td>\n",
       "      <td>HyD</td>\n",
       "      <td>349.980225</td>\n",
       "      <td>-0.006667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1078</th>\n",
       "      <td>200310_Probes.lif</td>\n",
       "      <td>Image007</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>7c11fc02-62c5-11ea-a946-002432168676</td>\n",
       "      <td>Gray</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>5.000013</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>PMT Trans</td>\n",
       "      <td>PMT</td>\n",
       "      <td>400.034333</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1079</th>\n",
       "      <td>200310_Probes.lif</td>\n",
       "      <td>Image007</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>512</td>\n",
       "      <td>512</td>\n",
       "      <td>4</td>\n",
       "      <td>7c11fc02-62c5-11ea-a946-002432168676</td>\n",
       "      <td>Red</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>512</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>m</td>\n",
       "      <td>400.0</td>\n",
       "      <td>5.000013</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>PMT 5</td>\n",
       "      <td>PMT</td>\n",
       "      <td>600.862135</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>28 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   file     serie  channel  nbr_frames  shape_X  shape_Y  \\\n",
       "1052  200310_Probes.lif  Image001        0           1      512      512   \n",
       "1053  200310_Probes.lif  Image001        1           1      512      512   \n",
       "1054  200310_Probes.lif  Image001        2           1      512      512   \n",
       "1055  200310_Probes.lif  Image001        3           1      512      512   \n",
       "1056  200310_Probes.lif  Image002        0           1      512      512   \n",
       "1057  200310_Probes.lif  Image002        1           1      512      512   \n",
       "1058  200310_Probes.lif  Image002        2           1      512      512   \n",
       "1059  200310_Probes.lif  Image002        3           1      512      512   \n",
       "1060  200310_Probes.lif  Image003        0           1      512      512   \n",
       "1061  200310_Probes.lif  Image003        1           1      512      512   \n",
       "1062  200310_Probes.lif  Image003        2           1      512      512   \n",
       "1063  200310_Probes.lif  Image003        3           1      512      512   \n",
       "1064  200310_Probes.lif  Image004        0           1      512      512   \n",
       "1065  200310_Probes.lif  Image004        1           1      512      512   \n",
       "1066  200310_Probes.lif  Image004        2           1      512      512   \n",
       "1067  200310_Probes.lif  Image004        3           1      512      512   \n",
       "1068  200310_Probes.lif  Image005        0           1      512      512   \n",
       "1069  200310_Probes.lif  Image005        1           1      512      512   \n",
       "1070  200310_Probes.lif  Image005        2           1      512      512   \n",
       "1071  200310_Probes.lif  Image005        3           1      512      512   \n",
       "1072  200310_Probes.lif  Image006        0           1      512      512   \n",
       "1073  200310_Probes.lif  Image006        1           1      512      512   \n",
       "1074  200310_Probes.lif  Image006        2           1      512      512   \n",
       "1075  200310_Probes.lif  Image006        3           1      512      512   \n",
       "1076  200310_Probes.lif  Image007        0           1      512      512   \n",
       "1077  200310_Probes.lif  Image007        1           1      512      512   \n",
       "1078  200310_Probes.lif  Image007        2           1      512      512   \n",
       "1079  200310_Probes.lif  Image007        3           1      512      512   \n",
       "\n",
       "      channel_count                       Image.@UniqueID Channel.@LUTName  \\\n",
       "1052              4  f23725aa-62c4-11ea-a946-002432168676             Blue   \n",
       "1053              4  f23725aa-62c4-11ea-a946-002432168676            Green   \n",
       "1054              4  f23725aa-62c4-11ea-a946-002432168676             Gray   \n",
       "1055              4  f23725aa-62c4-11ea-a946-002432168676              Red   \n",
       "1056              4  fb3a707e-62c4-11ea-a946-002432168676             Blue   \n",
       "1057              4  fb3a707e-62c4-11ea-a946-002432168676            Green   \n",
       "1058              4  fb3a707e-62c4-11ea-a946-002432168676             Gray   \n",
       "1059              4  fb3a707e-62c4-11ea-a946-002432168676              Red   \n",
       "1060              4  19cd9973-62c5-11ea-a946-002432168676             Blue   \n",
       "1061              4  19cd9973-62c5-11ea-a946-002432168676            Green   \n",
       "1062              4  19cd9973-62c5-11ea-a946-002432168676             Gray   \n",
       "1063              4  19cd9973-62c5-11ea-a946-002432168676              Red   \n",
       "1064              4  206f078a-62c5-11ea-a946-002432168676             Blue   \n",
       "1065              4  206f078a-62c5-11ea-a946-002432168676            Green   \n",
       "1066              4  206f078a-62c5-11ea-a946-002432168676             Gray   \n",
       "1067              4  206f078a-62c5-11ea-a946-002432168676              Red   \n",
       "1068              4  44a00fac-62c5-11ea-a946-002432168676             Blue   \n",
       "1069              4  44a00fac-62c5-11ea-a946-002432168676            Green   \n",
       "1070              4  44a00fac-62c5-11ea-a946-002432168676             Gray   \n",
       "1071              4  44a00fac-62c5-11ea-a946-002432168676              Red   \n",
       "1072              4  668c66ed-62c5-11ea-a946-002432168676             Blue   \n",
       "1073              4  668c66ed-62c5-11ea-a946-002432168676            Green   \n",
       "1074              4  668c66ed-62c5-11ea-a946-002432168676             Gray   \n",
       "1075              4  668c66ed-62c5-11ea-a946-002432168676              Red   \n",
       "1076              4  7c11fc02-62c5-11ea-a946-002432168676             Blue   \n",
       "1077              4  7c11fc02-62c5-11ea-a946-002432168676            Green   \n",
       "1078              4  7c11fc02-62c5-11ea-a946-002432168676             Gray   \n",
       "1079              4  7c11fc02-62c5-11ea-a946-002432168676              Red   \n",
       "\n",
       "      Dimension.@DimID_X  ...  Dimension.@NumberOfElements_Y  \\\n",
       "1052                   1  ...                            512   \n",
       "1053                   1  ...                            512   \n",
       "1054                   1  ...                            512   \n",
       "1055                   1  ...                            512   \n",
       "1056                   1  ...                            512   \n",
       "1057                   1  ...                            512   \n",
       "1058                   1  ...                            512   \n",
       "1059                   1  ...                            512   \n",
       "1060                   1  ...                            512   \n",
       "1061                   1  ...                            512   \n",
       "1062                   1  ...                            512   \n",
       "1063                   1  ...                            512   \n",
       "1064                   1  ...                            512   \n",
       "1065                   1  ...                            512   \n",
       "1066                   1  ...                            512   \n",
       "1067                   1  ...                            512   \n",
       "1068                   1  ...                            512   \n",
       "1069                   1  ...                            512   \n",
       "1070                   1  ...                            512   \n",
       "1071                   1  ...                            512   \n",
       "1072                   1  ...                            512   \n",
       "1073                   1  ...                            512   \n",
       "1074                   1  ...                            512   \n",
       "1075                   1  ...                            512   \n",
       "1076                   1  ...                            512   \n",
       "1077                   1  ...                            512   \n",
       "1078                   1  ...                            512   \n",
       "1079                   1  ...                            512   \n",
       "\n",
       "      Dimension.@Length_Y Dimension.@Unit_Y  \\\n",
       "1052             0.000037                 m   \n",
       "1053             0.000037                 m   \n",
       "1054             0.000037                 m   \n",
       "1055             0.000037                 m   \n",
       "1056             0.000185                 m   \n",
       "1057             0.000185                 m   \n",
       "1058             0.000185                 m   \n",
       "1059             0.000185                 m   \n",
       "1060             0.000185                 m   \n",
       "1061             0.000185                 m   \n",
       "1062             0.000185                 m   \n",
       "1063             0.000185                 m   \n",
       "1064             0.000185                 m   \n",
       "1065             0.000185                 m   \n",
       "1066             0.000185                 m   \n",
       "1067             0.000185                 m   \n",
       "1068             0.000037                 m   \n",
       "1069             0.000037                 m   \n",
       "1070             0.000037                 m   \n",
       "1071             0.000037                 m   \n",
       "1072             0.000037                 m   \n",
       "1073             0.000037                 m   \n",
       "1074             0.000037                 m   \n",
       "1075             0.000037                 m   \n",
       "1076             0.000037                 m   \n",
       "1077             0.000037                 m   \n",
       "1078             0.000037                 m   \n",
       "1079             0.000037                 m   \n",
       "\n",
       "      ATLConfocalSettingDefinition.@ScanSpeed  \\\n",
       "1052                                    400.0   \n",
       "1053                                    400.0   \n",
       "1054                                    400.0   \n",
       "1055                                    400.0   \n",
       "1056                                    400.0   \n",
       "1057                                    400.0   \n",
       "1058                                    400.0   \n",
       "1059                                    400.0   \n",
       "1060                                    400.0   \n",
       "1061                                    400.0   \n",
       "1062                                    400.0   \n",
       "1063                                    400.0   \n",
       "1064                                    400.0   \n",
       "1065                                    400.0   \n",
       "1066                                    400.0   \n",
       "1067                                    400.0   \n",
       "1068                                    400.0   \n",
       "1069                                    400.0   \n",
       "1070                                    400.0   \n",
       "1071                                    400.0   \n",
       "1072                                    400.0   \n",
       "1073                                    400.0   \n",
       "1074                                    400.0   \n",
       "1075                                    400.0   \n",
       "1076                                    400.0   \n",
       "1077                                    400.0   \n",
       "1078                                    400.0   \n",
       "1079                                    400.0   \n",
       "\n",
       "      ATLConfocalSettingDefinition.@Zoom  \\\n",
       "1052                            5.000013   \n",
       "1053                            5.000013   \n",
       "1054                            5.000013   \n",
       "1055                            5.000013   \n",
       "1056                            1.000000   \n",
       "1057                            1.000000   \n",
       "1058                            1.000000   \n",
       "1059                            1.000000   \n",
       "1060                            1.000000   \n",
       "1061                            1.000000   \n",
       "1062                            1.000000   \n",
       "1063                            1.000000   \n",
       "1064                            1.000000   \n",
       "1065                            1.000000   \n",
       "1066                            1.000000   \n",
       "1067                            1.000000   \n",
       "1068                            5.000013   \n",
       "1069                            5.000013   \n",
       "1070                            5.000013   \n",
       "1071                            5.000013   \n",
       "1072                            5.000013   \n",
       "1073                            5.000013   \n",
       "1074                            5.000013   \n",
       "1075                            5.000013   \n",
       "1076                            5.000013   \n",
       "1077                            5.000013   \n",
       "1078                            5.000013   \n",
       "1079                            5.000013   \n",
       "\n",
       "      ATLConfocalSettingDefinition.@PixelDwellTime  \\\n",
       "1052                                      0.000003   \n",
       "1053                                      0.000003   \n",
       "1054                                      0.000003   \n",
       "1055                                      0.000003   \n",
       "1056                                      0.000003   \n",
       "1057                                      0.000003   \n",
       "1058                                      0.000003   \n",
       "1059                                      0.000003   \n",
       "1060                                      0.000003   \n",
       "1061                                      0.000003   \n",
       "1062                                      0.000003   \n",
       "1063                                      0.000003   \n",
       "1064                                      0.000003   \n",
       "1065                                      0.000003   \n",
       "1066                                      0.000003   \n",
       "1067                                      0.000003   \n",
       "1068                                      0.000003   \n",
       "1069                                      0.000003   \n",
       "1070                                      0.000003   \n",
       "1071                                      0.000003   \n",
       "1072                                      0.000003   \n",
       "1073                                      0.000003   \n",
       "1074                                      0.000003   \n",
       "1075                                      0.000003   \n",
       "1076                                      0.000003   \n",
       "1077                                      0.000003   \n",
       "1078                                      0.000003   \n",
       "1079                                      0.000003   \n",
       "\n",
       "     ATLConfocalSettingDefinition.DetectorList.Detector.@Name  \\\n",
       "1052                                              PMT 3         \n",
       "1053                                           HyD4 SMD         \n",
       "1054                                          PMT Trans         \n",
       "1055                                              PMT 5         \n",
       "1056                                              PMT 3         \n",
       "1057                                           HyD4 SMD         \n",
       "1058                                          PMT Trans         \n",
       "1059                                              PMT 5         \n",
       "1060                                              PMT 3         \n",
       "1061                                           HyD4 SMD         \n",
       "1062                                          PMT Trans         \n",
       "1063                                              PMT 5         \n",
       "1064                                              PMT 3         \n",
       "1065                                           HyD4 SMD         \n",
       "1066                                          PMT Trans         \n",
       "1067                                              PMT 5         \n",
       "1068                                              PMT 3         \n",
       "1069                                           HyD4 SMD         \n",
       "1070                                          PMT Trans         \n",
       "1071                                              PMT 5         \n",
       "1072                                              PMT 3         \n",
       "1073                                           HyD4 SMD         \n",
       "1074                                          PMT Trans         \n",
       "1075                                              PMT 5         \n",
       "1076                                              PMT 3         \n",
       "1077                                           HyD4 SMD         \n",
       "1078                                          PMT Trans         \n",
       "1079                                              PMT 5         \n",
       "\n",
       "      ATLConfocalSettingDefinition.DetectorList.Detector.@Type  \\\n",
       "1052                                                PMT          \n",
       "1053                                                HyD          \n",
       "1054                                                PMT          \n",
       "1055                                                PMT          \n",
       "1056                                                PMT          \n",
       "1057                                                HyD          \n",
       "1058                                                PMT          \n",
       "1059                                                PMT          \n",
       "1060                                                PMT          \n",
       "1061                                                HyD          \n",
       "1062                                                PMT          \n",
       "1063                                                PMT          \n",
       "1064                                                PMT          \n",
       "1065                                                HyD          \n",
       "1066                                                PMT          \n",
       "1067                                                PMT          \n",
       "1068                                                PMT          \n",
       "1069                                                HyD          \n",
       "1070                                                PMT          \n",
       "1071                                                PMT          \n",
       "1072                                                PMT          \n",
       "1073                                                HyD          \n",
       "1074                                                PMT          \n",
       "1075                                                PMT          \n",
       "1076                                                PMT          \n",
       "1077                                                HyD          \n",
       "1078                                                PMT          \n",
       "1079                                                PMT          \n",
       "\n",
       "      ATLConfocalSettingDefinition.DetectorList.Detector.@Gain  \\\n",
       "1052                                         600.308995          \n",
       "1053                                         349.980225          \n",
       "1054                                         400.034333          \n",
       "1055                                         600.862135          \n",
       "1056                                         600.308995          \n",
       "1057                                         349.980225          \n",
       "1058                                         400.034333          \n",
       "1059                                         600.862135          \n",
       "1060                                         600.308995          \n",
       "1061                                         349.980225          \n",
       "1062                                         400.034333          \n",
       "1063                                         600.862135          \n",
       "1064                                         600.308995          \n",
       "1065                                         349.980225          \n",
       "1066                                         400.034333          \n",
       "1067                                         600.862135          \n",
       "1068                                         600.308995          \n",
       "1069                                         349.980225          \n",
       "1070                                         400.034333          \n",
       "1071                                         600.862135          \n",
       "1072                                         600.308995          \n",
       "1073                                         349.980225          \n",
       "1074                                         400.034333          \n",
       "1075                                         600.862135          \n",
       "1076                                         600.308995          \n",
       "1077                                         349.980225          \n",
       "1078                                         400.034333          \n",
       "1079                                         600.862135          \n",
       "\n",
       "      ATLConfocalSettingDefinition.DetectorList.Detector.@Offset  \n",
       "1052                                          -0.073333           \n",
       "1053                                          -0.006667           \n",
       "1054                                           0.000000           \n",
       "1055                                           0.000000           \n",
       "1056                                          -0.073333           \n",
       "1057                                          -0.006667           \n",
       "1058                                           0.000000           \n",
       "1059                                           0.000000           \n",
       "1060                                          -0.073333           \n",
       "1061                                          -0.006667           \n",
       "1062                                           0.000000           \n",
       "1063                                           0.000000           \n",
       "1064                                          -0.073333           \n",
       "1065                                          -0.006667           \n",
       "1066                                           0.000000           \n",
       "1067                                           0.000000           \n",
       "1068                                          -0.073333           \n",
       "1069                                          -0.006667           \n",
       "1070                                           0.000000           \n",
       "1071                                           0.000000           \n",
       "1072                                          -0.073333           \n",
       "1073                                          -0.006667           \n",
       "1074                                           0.000000           \n",
       "1075                                           0.000000           \n",
       "1076                                          -0.073333           \n",
       "1077                                          -0.006667           \n",
       "1078                                           0.000000           \n",
       "1079                                           0.000000           \n",
       "\n",
       "[28 rows x 24 columns]"
      ]
     },
     "execution_count": 137,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "euk[euk['file']=='200310_Probes.lif']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.6"
  },
  "toc-autonumbering": true,
  "toc-showcode": false,
  "toc-showmarkdowntxt": false,
  "toc-showtags": false
 },
 "nbformat": 4,
 "nbformat_minor": 4
}