{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import datetime as dt\n",
    "from salishsea_tools import evaltools as et\n",
    "\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "/ocean/ksuchy/MOAD/observe/Data and Code files for KS 2020dec11/2020_05_21 1995-2011 SoG VNH.csv\r\n"
     ]
    }
   ],
   "source": [
    "ls '/ocean/ksuchy/MOAD/observe/Data and Code files for KS 2020dec11/2020_05_21 1995-2011 SoG VNH.csv'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.read_csv('/ocean/ksuchy/MOAD/observe/Data and Code files for KS 2020dec11/2020_05_21 2012-2015 SoG VNH.csv',\n",
    "               encoding = \"ISO-8859-1\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>Key</th>\n",
       "      <th>region_name</th>\n",
       "      <th>Station</th>\n",
       "      <th>PROJECT</th>\n",
       "      <th>lon</th>\n",
       "      <th>lat</th>\n",
       "      <th>Date</th>\n",
       "      <th>STN_TIME</th>\n",
       "      <th>Twilight</th>\n",
       "      <th>Net_Type</th>\n",
       "      <th>...</th>\n",
       "      <th>Phylum:</th>\n",
       "      <th>Class:</th>\n",
       "      <th>Order:</th>\n",
       "      <th>Family:</th>\n",
       "      <th>Name</th>\n",
       "      <th>Abundance(#/m3)</th>\n",
       "      <th>Biomass(mg/m3)</th>\n",
       "      <th>NumberOfSpecies</th>\n",
       "      <th>Station Diversity</th>\n",
       "      <th>Station Equitability</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>IOS2012005000901</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>22</td>\n",
       "      <td>Str. Geo.</td>\n",
       "      <td>-124.272</td>\n",
       "      <td>49.670</td>\n",
       "      <td>6/14/2012</td>\n",
       "      <td>7:32</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>...</td>\n",
       "      <td>Arthropoda</td>\n",
       "      <td>Branchiopoda</td>\n",
       "      <td>Diplostraca</td>\n",
       "      <td>Podonidae</td>\n",
       "      <td>Podon *sp.  s1</td>\n",
       "      <td>12.22541</td>\n",
       "      <td>0.06113</td>\n",
       "      <td>51</td>\n",
       "      <td>2.63</td>\n",
       "      <td>0.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>IOS2012005000901</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>22</td>\n",
       "      <td>Str. Geo.</td>\n",
       "      <td>-124.272</td>\n",
       "      <td>49.670</td>\n",
       "      <td>6/14/2012</td>\n",
       "      <td>7:32</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>...</td>\n",
       "      <td>Arthropoda</td>\n",
       "      <td>Cirripedia</td>\n",
       "      <td>Thecostraca</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cirripedia *sp. nauplii s1</td>\n",
       "      <td>30.56351</td>\n",
       "      <td>1.22254</td>\n",
       "      <td>51</td>\n",
       "      <td>2.63</td>\n",
       "      <td>0.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>IOS2012005000901</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>22</td>\n",
       "      <td>Str. Geo.</td>\n",
       "      <td>-124.272</td>\n",
       "      <td>49.670</td>\n",
       "      <td>6/14/2012</td>\n",
       "      <td>7:32</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>...</td>\n",
       "      <td>Arthropoda</td>\n",
       "      <td>Malacostraca</td>\n",
       "      <td>Amphipoda</td>\n",
       "      <td>Hyperiidae</td>\n",
       "      <td>Themisto pacifica juvenile s1</td>\n",
       "      <td>6.11270</td>\n",
       "      <td>1.44871</td>\n",
       "      <td>51</td>\n",
       "      <td>2.63</td>\n",
       "      <td>0.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>IOS2012005000901</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>22</td>\n",
       "      <td>Str. Geo.</td>\n",
       "      <td>-124.272</td>\n",
       "      <td>49.670</td>\n",
       "      <td>6/14/2012</td>\n",
       "      <td>7:32</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>...</td>\n",
       "      <td>Arthropoda</td>\n",
       "      <td>Malacostraca</td>\n",
       "      <td>Decapoda</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Caridea *sp. zoea s1</td>\n",
       "      <td>3.05635</td>\n",
       "      <td>0.07030</td>\n",
       "      <td>51</td>\n",
       "      <td>2.63</td>\n",
       "      <td>0.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>IOS2012005000901</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>22</td>\n",
       "      <td>Str. Geo.</td>\n",
       "      <td>-124.272</td>\n",
       "      <td>49.670</td>\n",
       "      <td>6/14/2012</td>\n",
       "      <td>7:32</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>...</td>\n",
       "      <td>Arthropoda</td>\n",
       "      <td>Malacostraca</td>\n",
       "      <td>Decapoda</td>\n",
       "      <td>Hippolytidae</td>\n",
       "      <td>Hippolytidae *sp. mysis s2</td>\n",
       "      <td>0.09551</td>\n",
       "      <td>0.06017</td>\n",
       "      <td>51</td>\n",
       "      <td>2.63</td>\n",
       "      <td>0.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60225</th>\n",
       "      <td>SOO2015095000801</td>\n",
       "      <td>Tidal Mixed</td>\n",
       "      <td>MAC41</td>\n",
       "      <td>Citizen Science</td>\n",
       "      <td>-123.409</td>\n",
       "      <td>48.402</td>\n",
       "      <td>7/27/2015</td>\n",
       "      <td>13:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>...</td>\n",
       "      <td>Ctenophora</td>\n",
       "      <td>Tentaculata</td>\n",
       "      <td>Cydippida</td>\n",
       "      <td>Pleurobrachiidae</td>\n",
       "      <td>Pleurobrachia bachei  s2</td>\n",
       "      <td>0.25316</td>\n",
       "      <td>0.31797</td>\n",
       "      <td>44</td>\n",
       "      <td>2.56</td>\n",
       "      <td>0.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60226</th>\n",
       "      <td>SOO2015095000801</td>\n",
       "      <td>Tidal Mixed</td>\n",
       "      <td>MAC41</td>\n",
       "      <td>Citizen Science</td>\n",
       "      <td>-123.409</td>\n",
       "      <td>48.402</td>\n",
       "      <td>7/27/2015</td>\n",
       "      <td>13:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>...</td>\n",
       "      <td>Ectoprocta</td>\n",
       "      <td>Gymnolaemata</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bryozoa *sp. cyphonautes s1</td>\n",
       "      <td>48.60759</td>\n",
       "      <td>0.06319</td>\n",
       "      <td>44</td>\n",
       "      <td>2.56</td>\n",
       "      <td>0.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60227</th>\n",
       "      <td>SOO2015095000801</td>\n",
       "      <td>Tidal Mixed</td>\n",
       "      <td>MAC41</td>\n",
       "      <td>Citizen Science</td>\n",
       "      <td>-123.409</td>\n",
       "      <td>48.402</td>\n",
       "      <td>7/27/2015</td>\n",
       "      <td>13:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>...</td>\n",
       "      <td>Mollusca</td>\n",
       "      <td>Bivalvia</td>\n",
       "      <td>Pholadomyoida</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Bivalvia *sp. veligers s1</td>\n",
       "      <td>21.60338</td>\n",
       "      <td>0.01296</td>\n",
       "      <td>44</td>\n",
       "      <td>2.56</td>\n",
       "      <td>0.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60228</th>\n",
       "      <td>SOO2015095000801</td>\n",
       "      <td>Tidal Mixed</td>\n",
       "      <td>MAC41</td>\n",
       "      <td>Citizen Science</td>\n",
       "      <td>-123.409</td>\n",
       "      <td>48.402</td>\n",
       "      <td>7/27/2015</td>\n",
       "      <td>13:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>...</td>\n",
       "      <td>Mollusca</td>\n",
       "      <td>Cephalopoda</td>\n",
       "      <td>Teuthida</td>\n",
       "      <td>Gonatidae</td>\n",
       "      <td>Berryteuthis magister  s2</td>\n",
       "      <td>0.08439</td>\n",
       "      <td>0.46414</td>\n",
       "      <td>44</td>\n",
       "      <td>2.56</td>\n",
       "      <td>0.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60229</th>\n",
       "      <td>SOO2015095000801</td>\n",
       "      <td>Tidal Mixed</td>\n",
       "      <td>MAC41</td>\n",
       "      <td>Citizen Science</td>\n",
       "      <td>-123.409</td>\n",
       "      <td>48.402</td>\n",
       "      <td>7/27/2015</td>\n",
       "      <td>13:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>...</td>\n",
       "      <td>Mollusca</td>\n",
       "      <td>Gastropoda</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Gastropoda *sp. veligers s1</td>\n",
       "      <td>10.80169</td>\n",
       "      <td>0.02808</td>\n",
       "      <td>44</td>\n",
       "      <td>2.56</td>\n",
       "      <td>0.67</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>60230 rows × 29 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Key                 region_name Station          PROJECT  \\\n",
       "0      IOS2012005000901  Northern Strait of Georgia      22        Str. Geo.   \n",
       "1      IOS2012005000901  Northern Strait of Georgia      22        Str. Geo.   \n",
       "2      IOS2012005000901  Northern Strait of Georgia      22        Str. Geo.   \n",
       "3      IOS2012005000901  Northern Strait of Georgia      22        Str. Geo.   \n",
       "4      IOS2012005000901  Northern Strait of Georgia      22        Str. Geo.   \n",
       "...                 ...                         ...     ...              ...   \n",
       "60225  SOO2015095000801                 Tidal Mixed   MAC41  Citizen Science   \n",
       "60226  SOO2015095000801                 Tidal Mixed   MAC41  Citizen Science   \n",
       "60227  SOO2015095000801                 Tidal Mixed   MAC41  Citizen Science   \n",
       "60228  SOO2015095000801                 Tidal Mixed   MAC41  Citizen Science   \n",
       "60229  SOO2015095000801                 Tidal Mixed   MAC41  Citizen Science   \n",
       "\n",
       "           lon     lat       Date STN_TIME  Twilight  Net_Type  ...  \\\n",
       "0     -124.272  49.670  6/14/2012     7:32  Daylight  SCOR VNH  ...   \n",
       "1     -124.272  49.670  6/14/2012     7:32  Daylight  SCOR VNH  ...   \n",
       "2     -124.272  49.670  6/14/2012     7:32  Daylight  SCOR VNH  ...   \n",
       "3     -124.272  49.670  6/14/2012     7:32  Daylight  SCOR VNH  ...   \n",
       "4     -124.272  49.670  6/14/2012     7:32  Daylight  SCOR VNH  ...   \n",
       "...        ...     ...        ...      ...       ...       ...  ...   \n",
       "60225 -123.409  48.402  7/27/2015    13:00  Daylight  SCOR VNH  ...   \n",
       "60226 -123.409  48.402  7/27/2015    13:00  Daylight  SCOR VNH  ...   \n",
       "60227 -123.409  48.402  7/27/2015    13:00  Daylight  SCOR VNH  ...   \n",
       "60228 -123.409  48.402  7/27/2015    13:00  Daylight  SCOR VNH  ...   \n",
       "60229 -123.409  48.402  7/27/2015    13:00  Daylight  SCOR VNH  ...   \n",
       "\n",
       "          Phylum:        Class:         Order:           Family:  \\\n",
       "0      Arthropoda  Branchiopoda    Diplostraca         Podonidae   \n",
       "1      Arthropoda    Cirripedia    Thecostraca               NaN   \n",
       "2      Arthropoda  Malacostraca      Amphipoda        Hyperiidae   \n",
       "3      Arthropoda  Malacostraca       Decapoda               NaN   \n",
       "4      Arthropoda  Malacostraca       Decapoda      Hippolytidae   \n",
       "...           ...           ...            ...               ...   \n",
       "60225  Ctenophora   Tentaculata      Cydippida  Pleurobrachiidae   \n",
       "60226  Ectoprocta  Gymnolaemata            NaN               NaN   \n",
       "60227    Mollusca      Bivalvia  Pholadomyoida               NaN   \n",
       "60228    Mollusca   Cephalopoda       Teuthida         Gonatidae   \n",
       "60229    Mollusca    Gastropoda            NaN               NaN   \n",
       "\n",
       "                                Name  Abundance(#/m3)  Biomass(mg/m3)  \\\n",
       "0                     Podon *sp.  s1         12.22541         0.06113   \n",
       "1         Cirripedia *sp. nauplii s1         30.56351         1.22254   \n",
       "2      Themisto pacifica juvenile s1          6.11270         1.44871   \n",
       "3               Caridea *sp. zoea s1          3.05635         0.07030   \n",
       "4         Hippolytidae *sp. mysis s2          0.09551         0.06017   \n",
       "...                              ...              ...             ...   \n",
       "60225       Pleurobrachia bachei  s2          0.25316         0.31797   \n",
       "60226    Bryozoa *sp. cyphonautes s1         48.60759         0.06319   \n",
       "60227      Bivalvia *sp. veligers s1         21.60338         0.01296   \n",
       "60228      Berryteuthis magister  s2          0.08439         0.46414   \n",
       "60229    Gastropoda *sp. veligers s1         10.80169         0.02808   \n",
       "\n",
       "      NumberOfSpecies Station Diversity Station Equitability  \n",
       "0                  51              2.63                 0.67  \n",
       "1                  51              2.63                 0.67  \n",
       "2                  51              2.63                 0.67  \n",
       "3                  51              2.63                 0.67  \n",
       "4                  51              2.63                 0.67  \n",
       "...               ...               ...                  ...  \n",
       "60225              44              2.56                 0.67  \n",
       "60226              44              2.56                 0.67  \n",
       "60227              44              2.56                 0.67  \n",
       "60228              44              2.56                 0.67  \n",
       "60229              44              2.56                 0.67  \n",
       "\n",
       "[60230 rows x 29 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Key', 'region_name', 'Station', 'PROJECT', 'lon', 'lat', 'Date',\n",
       "       'STN_TIME', 'Twilight', 'Net_Type', 'Mesh_Size(um)', 'Net_Mouth_Dia(m)',\n",
       "       'DEPTH_STRT1', 'DEPTH_END1', 'Bottom Depth(m)', 'Volume Filtered(m3)',\n",
       "       'CTD', 'NOTES', 'PI', 'Phylum:', 'Class:', 'Order:', 'Family:', 'Name',\n",
       "       'Abundance(#/m3)', 'Biomass(mg/m3)', 'NumberOfSpecies',\n",
       "       'Station Diversity', 'Station Equitability'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        0.06113\n",
       "1        1.22254\n",
       "2        1.44871\n",
       "3        0.07030\n",
       "4        0.06017\n",
       "          ...   \n",
       "60225    0.31797\n",
       "60226    0.06319\n",
       "60227    0.01296\n",
       "60228    0.46414\n",
       "60229    0.02808\n",
       "Name: Biomass(mg/m3), Length: 60230, dtype: float64"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Biomass(mg/m3)']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "('6/14/2012', '7:32')"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Date'][0],df['STN_TIME'][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1000    6/15/2012\n",
       "1001    6/15/2012\n",
       "1002    6/15/2012\n",
       "1003    6/15/2012\n",
       "1004    6/15/2012\n",
       "1005    6/15/2012\n",
       "1006    6/15/2012\n",
       "1007    6/15/2012\n",
       "1008    6/15/2012\n",
       "1009    6/15/2012\n",
       "1010    6/15/2012\n",
       "1011    6/15/2012\n",
       "1012    6/15/2012\n",
       "1013    6/15/2012\n",
       "1014    6/15/2012\n",
       "1015    6/15/2012\n",
       "1016    6/15/2012\n",
       "1017    6/15/2012\n",
       "1018    6/15/2012\n",
       "1019    6/15/2012\n",
       "Name: Date, dtype: object"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Date'][1000:1020]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['6', '14', '2012']"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Date'][0].split('/')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "dateslist=list()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "for el in df['Date']:\n",
    "    dateslist.append(el.split('/'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "timeslist=list()\n",
    "for el in df['STN_TIME']:\n",
    "    timeslist.append(el.split(':'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "dts=list()\n",
    "for ii,jj in zip(dateslist,timeslist):\n",
    "    dts.append(dt.datetime(int(ii[2]),int(ii[0]),int(ii[1]),int(jj[0]),int(jj[1])))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['7:32', '7:52', '3:30', '7:42', '7:49', '15:09', '16:30', '22:09',\n",
       "       '22:27', '19:36', '19:53', '9:21', '9:35', '13:29', '13:45',\n",
       "       '19:25', '19:43', '5:26', '5:43', '5:45', '5:47', '5:56', '5:59',\n",
       "       '8:38', '8:39', '8:40', '8:41', '8:57', '11:10', '11:44', '11:45',\n",
       "       '11:47', '11:48', '11:49', '12:40', '12:42', '15:14', '15:15',\n",
       "       '15:16', '15:17', '15:18', '17:54', '17:55', '17:57', '17:58',\n",
       "       '17:59', '5:39', '6:05', '14:47', '15:02', '19:13', '19:30',\n",
       "       '14:32', '14:49', '20:04', '20:24', '20:27', '20:47', '9:37',\n",
       "       '9:48', '13:57', '14:17', '19:41', '19:59', '7:18', '7:53', '9:25',\n",
       "       '12:57', '13:09', '7:30', '7:45', '13:33', '13:36', '13:38',\n",
       "       '10:00', '10:30', '11:00', '11:30', '12:30', '13:00', '13:30',\n",
       "       '16:00', '17:00', '9:29', '10:26', '11:19', '13:39', '9:16',\n",
       "       '10:04', '10:42', '11:03', '9:00', '9:41', '10:17', '10:40',\n",
       "       '12:00', '9:33', '10:13', '11:11', '12:02', '12:32', '13:22',\n",
       "       '9:57', '10:35', '10:02', '12:08', '13:18', '14:50', '17:45',\n",
       "       '18:45', '8:30', '9:30', '11:41', '12:37', '13:03', '14:05',\n",
       "       '9:20', '11:56', '13:43', '9:32', '11:22', '11:52', '7:27',\n",
       "       '19:08', '9:45', '16:38', '16:57', '16:04', '16:26', '13:31',\n",
       "       '13:35', '7:12', '16:12', '16:14', '16:18', '16:20', '16:22',\n",
       "       '3:48', '4:04', '15:20', '15:35', '21:28', '21:42', '4:33', '4:45',\n",
       "       '11:38', '11:55', '18:18', '18:29', '10:12', '12:55', '10:16',\n",
       "       '11:20', '13:08', '11:07', '12:19', '12:58', '14:42', '15:37',\n",
       "       '12:10', '12:23', '13:24', '14:33', '10:32', '12:39', '9:49',\n",
       "       '10:53', '12:49', '11:36', '14:11', '9:51', '11:24', '13:04',\n",
       "       '13:19', '9:24', '10:15', '11:53', '12:51', '12:50', '16:11',\n",
       "       '6:15', '17:15', '11:16', '12:17', '13:10', '13:59', '11:21',\n",
       "       '12:01', '12:35', '9:58', '10:41', '11:29', '9:05', '9:50', '8:49',\n",
       "       '9:55', '11:14', '12:14', '9:10', '10:20', '10:50', '11:25',\n",
       "       '11:50', '19:52', '20:32', '6:20', '5:58', '20:29', '5:20',\n",
       "       '20:10', '15:52', '6:43', '20:12', '7:22', '21:03', '21:55',\n",
       "       '14:56', '10:08', '20:01', '11:33', '15:22', '16:40', '23:15',\n",
       "       '8:51', '12:12', '15:12', '10:57', '7:03', '8:03', '14:22',\n",
       "       '23:06', '4:05', '6:25', '9:26', '11:28', '13:27', '15:11',\n",
       "       '15:53', '15:54', '15:56', '15:59', '18:06', '19:45', '9:40',\n",
       "       '20:11', '7:10', '14:34', '11:42', '13:28', '17:12', '9:04',\n",
       "       '14:10', '16:17', '8:02', '10:31', '15:27', '17:01', '16:43',\n",
       "       '10:46', '13:15', '14:43', '9:44', '13:55', '15:44', '16:59',\n",
       "       '18:41', '8:18', '11:13', '8:28', '15:43', '18:08', '7:40',\n",
       "       '10:56', '10:33', '12:52', '14:55', '7:43', '12:13', '13:44',\n",
       "       '7:41', '16:56', '8:17', '9:13', '11:12', '15:40', '18:27',\n",
       "       '10:07', '12:06', '16:07', '16:41', '10:52', '16:33', '17:48',\n",
       "       '7:48', '11:09', '15:08', '8:31', '12:22', '14:39', '12:03',\n",
       "       '14:30', '17:31', '14:15', '18:16', '7:55', '17:38', '6:36',\n",
       "       '18:22', '7:15', '9:17', '12:44', '18:54', '12:43', '18:44',\n",
       "       '7:08', '13:02', '7:19', '16:36', '8:25', '8:33', '13:25', '17:20',\n",
       "       '17:26', '13:42', '18:37', '18:43', '13:21', '14:53', '17:24',\n",
       "       '9:38', '7:06', '9:31', '12:20', '15:28', '11:01', '11:57',\n",
       "       '14:12', '15:10', '7:35', '14:38', '16:06', '8:08', '16:05',\n",
       "       '16:52', '17:47', '8:21', '9:19', '16:35', '8:10', '8:59', '10:21',\n",
       "       '14:41', '16:09', '18:26', '11:23', '8:14', '10:10', '11:27',\n",
       "       '13:26', '11:15', '13:11', '9:18', '12:04', '10:45', '12:25',\n",
       "       '13:56', '10:22', '13:53', '9:28', '11:06', '11:32', '10:34',\n",
       "       '14:08', '11:18', '12:48', '14:01', '12:07', '14:07', '11:08',\n",
       "       '14:04', '10:06', '11:43', '13:40', '10:18', '13:34', '16:27',\n",
       "       '10:28', '15:26', '9:14', '12:15', '15:23', '8:23', '14:58',\n",
       "       '9:08', '10:43', '14:29', '8:44', '9:52', '8:13', '14:27', '14:46',\n",
       "       '14:16', '10:11', '14:51', '8:32', '10:37'], dtype=object)"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[df.Twilight=='Daylight']['STN_TIME'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['dtUTC']=et.pac_to_utc(dts) #convert from Pac time to UTC"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Diplostraca', 'Thecostraca', 'Amphipoda', 'Decapoda',\n",
       "       'Euphausiacea', 'Calanoida', 'Cyclopoida', 'Poecilostomatoida',\n",
       "       'Halocyprida', 'Aphragmophora', 'Copelata', 'Leptothecate',\n",
       "       'Siphonophorae', 'Trachylina', 'Cydippida', nan, 'Pholadomyoida',\n",
       "       'Neotaenioglossa', 'Thecosomata', 'Aciculata', 'Canalipalpata',\n",
       "       'Osmeriformes', 'Perciformes', 'Beroida', 'Teuthida',\n",
       "       'Gymnosomata', 'Isopoda', 'Siphonostomatoida', 'Anthoathecatae',\n",
       "       'Scorpaeniformes', 'Phragmophora', 'Clupeiformes', 'Ophiurida',\n",
       "       'Gadiformes', 'Semaeostomeae', 'Cumacea', 'Echinoida',\n",
       "       'Harpacticoida', 'Pleuronectiformes', 'Tricladida', 'Myodocopida',\n",
       "       'Phaeogromia', 'Noctilucales', 'Octopoda', 'Actiniaria',\n",
       "       'Foraminiferida', 'Monstrilloida', 'Oligotrichida', 'Mysida',\n",
       "       'Acariformes', 'Lophogastrida', 'Ophidiiformes',\n",
       "       'Thalassocalycida', 'Doliolida', 'Lepadomorpha', 'Cephalaspidea',\n",
       "       'Sygnathiformes'], dtype=object)"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Order:'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "colList=('Amphipoda', 'Decapoda','Euphausiacea', 'Calanoida', 'Cyclopoida', \n",
    "    'Poecilostomatoida','Copelata','Harpacticoida',)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Key', 'region_name', 'Station', 'PROJECT', 'lon', 'lat', 'Date',\n",
       "       'STN_TIME', 'Twilight', 'Net_Type', 'Mesh_Size(um)', 'Net_Mouth_Dia(m)',\n",
       "       'DEPTH_STRT1', 'DEPTH_END1', 'Bottom Depth(m)', 'Volume Filtered(m3)',\n",
       "       'CTD', 'NOTES', 'PI', 'Phylum:', 'Class:', 'Order:', 'Family:', 'Name',\n",
       "       'Abundance(#/m3)', 'Biomass(mg/m3)', 'NumberOfSpecies',\n",
       "       'Station Diversity', 'Station Equitability', 'dtUTC'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "dtsutc=et.pac_to_utc(dts)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Key                                                      IOS2012005000901\n",
       "region_name                                    Northern Strait of Georgia\n",
       "Station                                                                22\n",
       "PROJECT                                                         Str. Geo.\n",
       "lon                                                              -124.272\n",
       "lat                                                                 49.67\n",
       "Date                                                            6/14/2012\n",
       "STN_TIME                                                             7:32\n",
       "Twilight                                                         Daylight\n",
       "Net_Type                                                         SCOR VNH\n",
       "Mesh_Size(um)                                                         236\n",
       "Net_Mouth_Dia(m)                                                     0.56\n",
       "DEPTH_STRT1                                                            50\n",
       "DEPTH_END1                                                              0\n",
       "Bottom Depth(m)                                                       352\n",
       "Volume Filtered(m3)                                                 10.47\n",
       "CTD                                                                     8\n",
       "NOTES                   Flowmeter reading may be incorrect. Value ente...\n",
       "PI                                                            Dave Mackas\n",
       "Phylum:                                                        Arthropoda\n",
       "Class:                                                       Branchiopoda\n",
       "Order:                                                        Diplostraca\n",
       "Family:                                                         Podonidae\n",
       "Name                                                       Podon *sp.  s1\n",
       "Abundance(#/m3)                                                   12.2254\n",
       "Biomass(mg/m3)                                                    0.06113\n",
       "NumberOfSpecies                                                        51\n",
       "Station Diversity                                                    2.63\n",
       "Station Equitability                                                 0.67\n",
       "dtUTC                                                 2012-06-14 14:32:00\n",
       "Name: 0, dtype: object"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "towIDlist=['Key', 'region_name', 'Station',  'lon', 'lat', 'dtUTC', 'Twilight', 'Net_Type', 'Mesh_Size(um)', 'DEPTH_STRT1', 'DEPTH_END1', 'Bottom Depth(m)']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "towIDlist2=['Key', 'region_name', 'Station',  'lon', 'lat', 'dtUTC', 'Twilight', 'Net_Type', 'Mesh_Size(um)', 'DEPTH_STRT1', 'DEPTH_END1', 'Bottom Depth(m)','CTD']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(654, 12694, 654)"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df.groupby(towIDlist)),len(df.groupby(towIDlist2)),len(df.groupby(['Key']))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Key is a unique identifier for each tow\n",
    "# do not group by CTD due to NaN values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "biomassDF=df.groupby(towIDlist,as_index=False).first()\\\n",
    "     .loc[:,towIDlist].copy(deep=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "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>Key</th>\n",
       "      <th>region_name</th>\n",
       "      <th>Station</th>\n",
       "      <th>lon</th>\n",
       "      <th>lat</th>\n",
       "      <th>dtUTC</th>\n",
       "      <th>Twilight</th>\n",
       "      <th>Net_Type</th>\n",
       "      <th>Mesh_Size(um)</th>\n",
       "      <th>DEPTH_STRT1</th>\n",
       "      <th>DEPTH_END1</th>\n",
       "      <th>Bottom Depth(m)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>IOS2012005000901</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>22</td>\n",
       "      <td>-124.272</td>\n",
       "      <td>49.670</td>\n",
       "      <td>2012-06-14 14:32:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>352</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>IOS2012005001001</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>22</td>\n",
       "      <td>-124.272</td>\n",
       "      <td>49.670</td>\n",
       "      <td>2012-06-14 14:52:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>345</td>\n",
       "      <td>0</td>\n",
       "      <td>352</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>IOS2012005002101</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>11</td>\n",
       "      <td>-124.722</td>\n",
       "      <td>49.710</td>\n",
       "      <td>2012-06-14 07:00:00</td>\n",
       "      <td>Night</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>307</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>IOS2012005002201</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>11</td>\n",
       "      <td>-124.722</td>\n",
       "      <td>49.710</td>\n",
       "      <td>2012-06-14 07:05:00</td>\n",
       "      <td>Night</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>300</td>\n",
       "      <td>0</td>\n",
       "      <td>307</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>IOS2012005002901</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>CPF2</td>\n",
       "      <td>-124.499</td>\n",
       "      <td>49.466</td>\n",
       "      <td>2012-06-15 10:00:00</td>\n",
       "      <td>Night</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>325</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>649</th>\n",
       "      <td>SOO2015095000101</td>\n",
       "      <td>Tidal Mixed</td>\n",
       "      <td>CLO-42</td>\n",
       "      <td>-123.345</td>\n",
       "      <td>48.394</td>\n",
       "      <td>2015-04-27 17:37:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>58</td>\n",
       "      <td>0</td>\n",
       "      <td>72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>650</th>\n",
       "      <td>SOO2015095000401</td>\n",
       "      <td>Tidal Mixed</td>\n",
       "      <td>CB01</td>\n",
       "      <td>-123.318</td>\n",
       "      <td>48.344</td>\n",
       "      <td>2015-04-30 19:00:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>54</td>\n",
       "      <td>0</td>\n",
       "      <td>64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>651</th>\n",
       "      <td>SOO2015095000501</td>\n",
       "      <td>Tidal Mixed</td>\n",
       "      <td>CLO-41</td>\n",
       "      <td>-123.345</td>\n",
       "      <td>48.395</td>\n",
       "      <td>2015-07-09 19:25:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "      <td>64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>652</th>\n",
       "      <td>SOO2015095000701</td>\n",
       "      <td>Tidal Mixed</td>\n",
       "      <td>CB01</td>\n",
       "      <td>-123.318</td>\n",
       "      <td>48.344</td>\n",
       "      <td>2015-07-27 19:06:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>653</th>\n",
       "      <td>SOO2015095000801</td>\n",
       "      <td>Tidal Mixed</td>\n",
       "      <td>MAC41</td>\n",
       "      <td>-123.409</td>\n",
       "      <td>48.402</td>\n",
       "      <td>2015-07-27 20:00:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>49</td>\n",
       "      <td>0</td>\n",
       "      <td>62</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>654 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Key                 region_name Station      lon     lat  \\\n",
       "0    IOS2012005000901  Northern Strait of Georgia      22 -124.272  49.670   \n",
       "1    IOS2012005001001  Northern Strait of Georgia      22 -124.272  49.670   \n",
       "2    IOS2012005002101  Northern Strait of Georgia      11 -124.722  49.710   \n",
       "3    IOS2012005002201  Northern Strait of Georgia      11 -124.722  49.710   \n",
       "4    IOS2012005002901  Northern Strait of Georgia    CPF2 -124.499  49.466   \n",
       "..                ...                         ...     ...      ...     ...   \n",
       "649  SOO2015095000101                 Tidal Mixed  CLO-42 -123.345  48.394   \n",
       "650  SOO2015095000401                 Tidal Mixed    CB01 -123.318  48.344   \n",
       "651  SOO2015095000501                 Tidal Mixed  CLO-41 -123.345  48.395   \n",
       "652  SOO2015095000701                 Tidal Mixed    CB01 -123.318  48.344   \n",
       "653  SOO2015095000801                 Tidal Mixed   MAC41 -123.409  48.402   \n",
       "\n",
       "                  dtUTC  Twilight  Net_Type  Mesh_Size(um)  DEPTH_STRT1  \\\n",
       "0   2012-06-14 14:32:00  Daylight  SCOR VNH            236           50   \n",
       "1   2012-06-14 14:52:00  Daylight  SCOR VNH            236          345   \n",
       "2   2012-06-14 07:00:00     Night  SCOR VNH            236           50   \n",
       "3   2012-06-14 07:05:00     Night  SCOR VNH            236          300   \n",
       "4   2012-06-15 10:00:00     Night  SCOR VNH            236           50   \n",
       "..                  ...       ...       ...            ...          ...   \n",
       "649 2015-04-27 17:37:00  Daylight  SCOR VNH            236           58   \n",
       "650 2015-04-30 19:00:00  Daylight  SCOR VNH            236           54   \n",
       "651 2015-07-09 19:25:00  Daylight  SCOR VNH            236           42   \n",
       "652 2015-07-27 19:06:00  Daylight  SCOR VNH            236           28   \n",
       "653 2015-07-27 20:00:00  Daylight  SCOR VNH            236           49   \n",
       "\n",
       "     DEPTH_END1  Bottom Depth(m)  \n",
       "0             0              352  \n",
       "1             0              352  \n",
       "2             0              307  \n",
       "3             0              307  \n",
       "4             0              325  \n",
       "..          ...              ...  \n",
       "649           0               72  \n",
       "650           0               64  \n",
       "651           0               64  \n",
       "652           0               60  \n",
       "653           0               62  \n",
       "\n",
       "[654 rows x 12 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "biomassDF"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "def getbiomass(colname,key,origdf):\n",
    "    biomassArray=df.loc[(origdf.Key==key)&(origdf['Order:']==colname),\n",
    "                    ['Biomass(mg/m3)']]\n",
    "    biomass=np.nansum(biomassArray)\n",
    "    return biomass"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "for icol in colList:\n",
    "    biomassDF[icol]=[getbiomass(icol,ikey,df) for ikey in biomassDF['Key']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {
    "scrolled": true
   },
   "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>Key</th>\n",
       "      <th>region_name</th>\n",
       "      <th>Station</th>\n",
       "      <th>lon</th>\n",
       "      <th>lat</th>\n",
       "      <th>dtUTC</th>\n",
       "      <th>Twilight</th>\n",
       "      <th>Net_Type</th>\n",
       "      <th>Mesh_Size(um)</th>\n",
       "      <th>DEPTH_STRT1</th>\n",
       "      <th>DEPTH_END1</th>\n",
       "      <th>Bottom Depth(m)</th>\n",
       "      <th>Amphipoda</th>\n",
       "      <th>Decapoda</th>\n",
       "      <th>Euphausiacea</th>\n",
       "      <th>Calanoida</th>\n",
       "      <th>Cyclopoida</th>\n",
       "      <th>Poecilostomatoida</th>\n",
       "      <th>Copelata</th>\n",
       "      <th>Harpacticoida</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>IOS2012005000901</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>22</td>\n",
       "      <td>-124.272</td>\n",
       "      <td>49.670</td>\n",
       "      <td>2012-06-14 14:32:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>352</td>\n",
       "      <td>1.44871</td>\n",
       "      <td>0.13047</td>\n",
       "      <td>0.65310</td>\n",
       "      <td>14.21881</td>\n",
       "      <td>0.35546</td>\n",
       "      <td>0.59598</td>\n",
       "      <td>0.91691</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>IOS2012005001001</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>22</td>\n",
       "      <td>-124.272</td>\n",
       "      <td>49.670</td>\n",
       "      <td>2012-06-14 14:52:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>345</td>\n",
       "      <td>0</td>\n",
       "      <td>352</td>\n",
       "      <td>2.57318</td>\n",
       "      <td>0.23591</td>\n",
       "      <td>0.16876</td>\n",
       "      <td>17.75443</td>\n",
       "      <td>0.37904</td>\n",
       "      <td>0.23747</td>\n",
       "      <td>1.15807</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>IOS2012005002101</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>11</td>\n",
       "      <td>-124.722</td>\n",
       "      <td>49.710</td>\n",
       "      <td>2012-06-14 07:00:00</td>\n",
       "      <td>Night</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>307</td>\n",
       "      <td>8.45483</td>\n",
       "      <td>5.76780</td>\n",
       "      <td>0.07720</td>\n",
       "      <td>57.97920</td>\n",
       "      <td>1.18232</td>\n",
       "      <td>0.31802</td>\n",
       "      <td>0.01917</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>IOS2012005002201</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>11</td>\n",
       "      <td>-124.722</td>\n",
       "      <td>49.710</td>\n",
       "      <td>2012-06-14 07:05:00</td>\n",
       "      <td>Night</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>300</td>\n",
       "      <td>0</td>\n",
       "      <td>307</td>\n",
       "      <td>23.57762</td>\n",
       "      <td>3.69101</td>\n",
       "      <td>4.27121</td>\n",
       "      <td>68.21370</td>\n",
       "      <td>1.32736</td>\n",
       "      <td>0.58393</td>\n",
       "      <td>0.14046</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>IOS2012005002901</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>CPF2</td>\n",
       "      <td>-124.499</td>\n",
       "      <td>49.466</td>\n",
       "      <td>2012-06-15 10:00:00</td>\n",
       "      <td>Night</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>325</td>\n",
       "      <td>124.31430</td>\n",
       "      <td>24.79259</td>\n",
       "      <td>14.47768</td>\n",
       "      <td>34.16656</td>\n",
       "      <td>0.77657</td>\n",
       "      <td>0.14856</td>\n",
       "      <td>0.36571</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>649</th>\n",
       "      <td>SOO2015095000101</td>\n",
       "      <td>Tidal Mixed</td>\n",
       "      <td>CLO-42</td>\n",
       "      <td>-123.345</td>\n",
       "      <td>48.394</td>\n",
       "      <td>2015-04-27 17:37:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>58</td>\n",
       "      <td>0</td>\n",
       "      <td>72</td>\n",
       "      <td>1.81260</td>\n",
       "      <td>0.93396</td>\n",
       "      <td>0.01031</td>\n",
       "      <td>6.19344</td>\n",
       "      <td>0.00191</td>\n",
       "      <td>0.01527</td>\n",
       "      <td>0.69466</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>650</th>\n",
       "      <td>SOO2015095000401</td>\n",
       "      <td>Tidal Mixed</td>\n",
       "      <td>CB01</td>\n",
       "      <td>-123.318</td>\n",
       "      <td>48.344</td>\n",
       "      <td>2015-04-30 19:00:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>54</td>\n",
       "      <td>0</td>\n",
       "      <td>64</td>\n",
       "      <td>5.31255</td>\n",
       "      <td>2.51960</td>\n",
       "      <td>0.02307</td>\n",
       "      <td>10.53489</td>\n",
       "      <td>0.00427</td>\n",
       "      <td>0.04784</td>\n",
       "      <td>0.47838</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>651</th>\n",
       "      <td>SOO2015095000501</td>\n",
       "      <td>Tidal Mixed</td>\n",
       "      <td>CLO-41</td>\n",
       "      <td>-123.345</td>\n",
       "      <td>48.395</td>\n",
       "      <td>2015-07-09 19:25:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "      <td>64</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.56055</td>\n",
       "      <td>0.02636</td>\n",
       "      <td>5.75176</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.03222</td>\n",
       "      <td>3.30984</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>652</th>\n",
       "      <td>SOO2015095000701</td>\n",
       "      <td>Tidal Mixed</td>\n",
       "      <td>CB01</td>\n",
       "      <td>-123.318</td>\n",
       "      <td>48.344</td>\n",
       "      <td>2015-07-27 19:06:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>60</td>\n",
       "      <td>1.29901</td>\n",
       "      <td>1.55372</td>\n",
       "      <td>0.06543</td>\n",
       "      <td>2.18596</td>\n",
       "      <td>0.00539</td>\n",
       "      <td>0.02079</td>\n",
       "      <td>3.39476</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>653</th>\n",
       "      <td>SOO2015095000801</td>\n",
       "      <td>Tidal Mixed</td>\n",
       "      <td>MAC41</td>\n",
       "      <td>-123.409</td>\n",
       "      <td>48.402</td>\n",
       "      <td>2015-07-27 20:00:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>49</td>\n",
       "      <td>0</td>\n",
       "      <td>62</td>\n",
       "      <td>1.28000</td>\n",
       "      <td>2.11012</td>\n",
       "      <td>0.19443</td>\n",
       "      <td>21.37141</td>\n",
       "      <td>0.01080</td>\n",
       "      <td>0.11882</td>\n",
       "      <td>27.27426</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>654 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Key                 region_name Station      lon     lat  \\\n",
       "0    IOS2012005000901  Northern Strait of Georgia      22 -124.272  49.670   \n",
       "1    IOS2012005001001  Northern Strait of Georgia      22 -124.272  49.670   \n",
       "2    IOS2012005002101  Northern Strait of Georgia      11 -124.722  49.710   \n",
       "3    IOS2012005002201  Northern Strait of Georgia      11 -124.722  49.710   \n",
       "4    IOS2012005002901  Northern Strait of Georgia    CPF2 -124.499  49.466   \n",
       "..                ...                         ...     ...      ...     ...   \n",
       "649  SOO2015095000101                 Tidal Mixed  CLO-42 -123.345  48.394   \n",
       "650  SOO2015095000401                 Tidal Mixed    CB01 -123.318  48.344   \n",
       "651  SOO2015095000501                 Tidal Mixed  CLO-41 -123.345  48.395   \n",
       "652  SOO2015095000701                 Tidal Mixed    CB01 -123.318  48.344   \n",
       "653  SOO2015095000801                 Tidal Mixed   MAC41 -123.409  48.402   \n",
       "\n",
       "                  dtUTC  Twilight  Net_Type  Mesh_Size(um)  DEPTH_STRT1  \\\n",
       "0   2012-06-14 14:32:00  Daylight  SCOR VNH            236           50   \n",
       "1   2012-06-14 14:52:00  Daylight  SCOR VNH            236          345   \n",
       "2   2012-06-14 07:00:00     Night  SCOR VNH            236           50   \n",
       "3   2012-06-14 07:05:00     Night  SCOR VNH            236          300   \n",
       "4   2012-06-15 10:00:00     Night  SCOR VNH            236           50   \n",
       "..                  ...       ...       ...            ...          ...   \n",
       "649 2015-04-27 17:37:00  Daylight  SCOR VNH            236           58   \n",
       "650 2015-04-30 19:00:00  Daylight  SCOR VNH            236           54   \n",
       "651 2015-07-09 19:25:00  Daylight  SCOR VNH            236           42   \n",
       "652 2015-07-27 19:06:00  Daylight  SCOR VNH            236           28   \n",
       "653 2015-07-27 20:00:00  Daylight  SCOR VNH            236           49   \n",
       "\n",
       "     DEPTH_END1  Bottom Depth(m)  Amphipoda  Decapoda  Euphausiacea  \\\n",
       "0             0              352    1.44871   0.13047       0.65310   \n",
       "1             0              352    2.57318   0.23591       0.16876   \n",
       "2             0              307    8.45483   5.76780       0.07720   \n",
       "3             0              307   23.57762   3.69101       4.27121   \n",
       "4             0              325  124.31430  24.79259      14.47768   \n",
       "..          ...              ...        ...       ...           ...   \n",
       "649           0               72    1.81260   0.93396       0.01031   \n",
       "650           0               64    5.31255   2.51960       0.02307   \n",
       "651           0               64    0.00000   0.56055       0.02636   \n",
       "652           0               60    1.29901   1.55372       0.06543   \n",
       "653           0               62    1.28000   2.11012       0.19443   \n",
       "\n",
       "     Calanoida  Cyclopoida  Poecilostomatoida  Copelata  Harpacticoida  \n",
       "0     14.21881     0.35546            0.59598   0.91691            0.0  \n",
       "1     17.75443     0.37904            0.23747   1.15807            0.0  \n",
       "2     57.97920     1.18232            0.31802   0.01917            0.0  \n",
       "3     68.21370     1.32736            0.58393   0.14046            0.0  \n",
       "4     34.16656     0.77657            0.14856   0.36571            0.0  \n",
       "..         ...         ...                ...       ...            ...  \n",
       "649    6.19344     0.00191            0.01527   0.69466            0.0  \n",
       "650   10.53489     0.00427            0.04784   0.47838            0.0  \n",
       "651    5.75176     0.00000            0.03222   3.30984            0.0  \n",
       "652    2.18596     0.00539            0.02079   3.39476            0.0  \n",
       "653   21.37141     0.01080            0.11882  27.27426            0.0  \n",
       "\n",
       "[654 rows x 20 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "biomassDF"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "import netCDF4 as nc"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "ftemp=nc.Dataset('/data/eolson/results/MEOPAR/NEMO-forcing-new/grid/mesh_mask201702.nc')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict_keys(['nav_lon', 'nav_lat', 'time_counter', 'tmask', 'umask', 'vmask', 'fmask', 'tmaskutil', 'umaskutil', 'vmaskutil', 'fmaskutil', 'glamt', 'glamu', 'glamv', 'glamf', 'gphit', 'gphiu', 'gphiv', 'gphif', 'e1t', 'e1u', 'e1v', 'e1f', 'e2t', 'e2u', 'e2v', 'e2f', 'ff', 'mbathy', 'misf', 'isfdraft', 'e3t_0', 'e3u_0', 'e3v_0', 'e3w_0', 'gdept_0', 'gdepu', 'gdepv', 'gdepw_0', 'gdept_1d', 'gdepw_1d', 'e3t_1d', 'e3w_1d'])"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ftemp.variables.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<class 'netCDF4._netCDF4.Variable'>\n",
       "float64 e3t_0(t, z, y, x)\n",
       "    _FillValue: nan\n",
       "    standard_name: e3t_0\n",
       "    long_name: grid spacing on T-grid in w direction\n",
       "    units: m\n",
       "unlimited dimensions: t\n",
       "current shape = (1, 40, 898, 398)\n",
       "filling on"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ftemp.variables['e3t_0']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "masked_array(data=[[ 1.00000115,  1.00000501,  1.00001253,  1.00002718,\n",
       "                     1.0000557 ,  1.00011125,  1.00021946,  1.0004302 ,\n",
       "                     1.00084067,  1.00164012,  1.0031971 ,  1.00622914,\n",
       "                     1.01213271,  1.02362358,  1.04597551,  1.08940061,\n",
       "                     1.17356428,  1.33592899,  1.64636781,  2.22990285,\n",
       "                     3.29248567,  5.11998508,  7.97451506, 11.8252972 ,\n",
       "                    16.10792044, 19.95870258, 22.81323256, 24.64073198,\n",
       "                    25.70331479, 26.28684983, 26.59728865, 26.75965336,\n",
       "                    26.84381704, 26.88724213, 26.90959407, 26.92108493,\n",
       "                    26.9269885 , 26.93002054, 26.93157752, 26.93237697]],\n",
       "             mask=False,\n",
       "       fill_value=1e+20)"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ftemp.variables['e3t_1d'][:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "fdict={'ptrc_T':1,'grid_T':1}\n",
    "start_date = dt.datetime(2015,6,1)\n",
    "end_date = dt.datetime(2015,6,30)\n",
    "flen=1 # number of days per model output file. always 1 for 201905 and 201812 model runs\n",
    "namfmt='nowcast' # for 201905 and 201812 model runs, this should always be 'nowcast'\n",
    "# filemap is dictionary of the form variableName: fileType, where variableName is the name\n",
    "# of the variable you want to extract and fileType designates the type of \n",
    "# model output file it can be found in (usually ptrc_T for biology, grid_T for temperature and \n",
    "# salinity)\n",
    "filemap={'microzooplankton':'ptrc_T','mesozooplankton':'ptrc_T'}\n",
    "# fdict is a dictionary mappy file type to its time resolution. Here, 1 means hourly output\n",
    "# (1h file) and 24 means daily output (1d file). In certain runs, multiple time resolutions \n",
    "# are available\n",
    "fdict={'ptrc_T':1,'grid_T':1}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [],
   "source": [
    "PATH= '/results2/SalishSea/nowcast-green.201905/'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "biomassDF.rename(columns={'lon':'Lon','lat':'Lat'},inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Key', 'region_name', 'Station', 'Lon', 'Lat', 'dtUTC', 'Twilight',\n",
       "       'Net_Type', 'Mesh_Size(um)', 'DEPTH_STRT1', 'DEPTH_END1',\n",
       "       'Bottom Depth(m)', 'Amphipoda', 'Decapoda', 'Euphausiacea', 'Calanoida',\n",
       "       'Cyclopoida', 'Poecilostomatoida', 'Copelata', 'Harpacticoida'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "biomassDF.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "biomassDF.rename(columns={'DEPTH_STRT1':'Z_lower','DEPTH_END1':'Z_upper','Bottom Depth (m)': 'Z'},inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Warning: lower limit is not an ocean value:  i=159, j=646, k_upper=0, k_lower=34, k_seafloor=34 Lon=-124.72399999999999, Lat=49.707, dtUTC=2015-06-28 06:15:00\n",
      "Warning: lower limit is not an ocean value:  i=159, j=646, k_upper=0, k_lower=34, k_seafloor=34 Lon=-124.72399999999999, Lat=49.707, dtUTC=2015-06-28 06:15:00\n"
     ]
    }
   ],
   "source": [
    "data=et.matchData(biomassDF,filemap,fdict,start_date,end_date,'nowcast',PATH,1,quiet=False,method='vertNet');"
   ]
  },
  {
   "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>Key</th>\n",
       "      <th>region_name</th>\n",
       "      <th>Station</th>\n",
       "      <th>Lon</th>\n",
       "      <th>Lat</th>\n",
       "      <th>dtUTC</th>\n",
       "      <th>Twilight</th>\n",
       "      <th>Net_Type</th>\n",
       "      <th>Mesh_Size(um)</th>\n",
       "      <th>Z_lower</th>\n",
       "      <th>...</th>\n",
       "      <th>Cyclopoida</th>\n",
       "      <th>Poecilostomatoida</th>\n",
       "      <th>Copelata</th>\n",
       "      <th>Harpacticoida</th>\n",
       "      <th>j</th>\n",
       "      <th>i</th>\n",
       "      <th>mod_microzooplankton</th>\n",
       "      <th>mod_mesozooplankton</th>\n",
       "      <th>k_upper</th>\n",
       "      <th>k_lower</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>IOS2015020019801</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>14</td>\n",
       "      <td>-124.997</td>\n",
       "      <td>49.884</td>\n",
       "      <td>2015-06-06 06:06:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>Bongo VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>302</td>\n",
       "      <td>...</td>\n",
       "      <td>0.72407</td>\n",
       "      <td>0.94464</td>\n",
       "      <td>0.49944</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>700</td>\n",
       "      <td>141</td>\n",
       "      <td>0.074582</td>\n",
       "      <td>0.290741</td>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>IOS2015020020001A</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>11</td>\n",
       "      <td>-124.723</td>\n",
       "      <td>49.707</td>\n",
       "      <td>2015-06-06 08:37:00</td>\n",
       "      <td>Night</td>\n",
       "      <td>Bongo VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>289</td>\n",
       "      <td>...</td>\n",
       "      <td>0.50000</td>\n",
       "      <td>0.43750</td>\n",
       "      <td>0.05000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>645</td>\n",
       "      <td>159</td>\n",
       "      <td>0.072160</td>\n",
       "      <td>0.309218</td>\n",
       "      <td>0</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>IOS2015020020201</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>CPF2</td>\n",
       "      <td>-124.500</td>\n",
       "      <td>49.466</td>\n",
       "      <td>2015-06-06 11:05:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>Bongo VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>315</td>\n",
       "      <td>...</td>\n",
       "      <td>0.91324</td>\n",
       "      <td>0.41343</td>\n",
       "      <td>0.09291</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>583</td>\n",
       "      <td>162</td>\n",
       "      <td>0.048654</td>\n",
       "      <td>0.186083</td>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>IOS2015020020401</td>\n",
       "      <td>Central Strait of Georgia</td>\n",
       "      <td>CPF1</td>\n",
       "      <td>-124.084</td>\n",
       "      <td>49.367</td>\n",
       "      <td>2015-06-06 13:25:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>Bongo VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>233</td>\n",
       "      <td>...</td>\n",
       "      <td>0.87370</td>\n",
       "      <td>0.44702</td>\n",
       "      <td>0.23760</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>534</td>\n",
       "      <td>211</td>\n",
       "      <td>0.094083</td>\n",
       "      <td>0.301332</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>IOS2015020020601</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>22</td>\n",
       "      <td>-124.272</td>\n",
       "      <td>49.670</td>\n",
       "      <td>2015-06-06 16:26:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>Bongo VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>342</td>\n",
       "      <td>...</td>\n",
       "      <td>0.73786</td>\n",
       "      <td>0.43804</td>\n",
       "      <td>1.47271</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>606</td>\n",
       "      <td>221</td>\n",
       "      <td>0.042945</td>\n",
       "      <td>0.192460</td>\n",
       "      <td>0</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>IOS2015020020801</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>24</td>\n",
       "      <td>-124.098</td>\n",
       "      <td>49.504</td>\n",
       "      <td>2015-06-06 18:28:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>Bongo VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>411</td>\n",
       "      <td>...</td>\n",
       "      <td>0.77318</td>\n",
       "      <td>0.35132</td>\n",
       "      <td>0.90786</td>\n",
       "      <td>0.00018</td>\n",
       "      <td>562</td>\n",
       "      <td>226</td>\n",
       "      <td>0.047029</td>\n",
       "      <td>0.173742</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>IOS2015020021001</td>\n",
       "      <td>Central Strait of Georgia</td>\n",
       "      <td>28</td>\n",
       "      <td>-123.755</td>\n",
       "      <td>49.402</td>\n",
       "      <td>2015-06-06 20:27:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>Bongo VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>122</td>\n",
       "      <td>...</td>\n",
       "      <td>1.87486</td>\n",
       "      <td>0.49741</td>\n",
       "      <td>1.77711</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>517</td>\n",
       "      <td>263</td>\n",
       "      <td>0.148792</td>\n",
       "      <td>0.430705</td>\n",
       "      <td>0</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>IOS2015020021201</td>\n",
       "      <td>Central Strait of Georgia</td>\n",
       "      <td>GEO1</td>\n",
       "      <td>-123.750</td>\n",
       "      <td>49.249</td>\n",
       "      <td>2015-06-06 22:11:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>Bongo VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>390</td>\n",
       "      <td>...</td>\n",
       "      <td>0.76200</td>\n",
       "      <td>0.38549</td>\n",
       "      <td>0.32561</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>487</td>\n",
       "      <td>245</td>\n",
       "      <td>0.058598</td>\n",
       "      <td>0.176175</td>\n",
       "      <td>0</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>IOS2015020021301</td>\n",
       "      <td>Central Strait of Georgia</td>\n",
       "      <td>GEO1</td>\n",
       "      <td>-123.748</td>\n",
       "      <td>49.249</td>\n",
       "      <td>2015-06-06 22:53:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>MPS VNH</td>\n",
       "      <td>250</td>\n",
       "      <td>390</td>\n",
       "      <td>...</td>\n",
       "      <td>0.03467</td>\n",
       "      <td>0.04440</td>\n",
       "      <td>0.17067</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>487</td>\n",
       "      <td>245</td>\n",
       "      <td>0.003679</td>\n",
       "      <td>0.025794</td>\n",
       "      <td>34</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>IOS2015020021302</td>\n",
       "      <td>Central Strait of Georgia</td>\n",
       "      <td>GEO1</td>\n",
       "      <td>-123.748</td>\n",
       "      <td>49.249</td>\n",
       "      <td>2015-06-06 22:54:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>MPS VNH</td>\n",
       "      <td>250</td>\n",
       "      <td>300</td>\n",
       "      <td>...</td>\n",
       "      <td>0.02844</td>\n",
       "      <td>0.02329</td>\n",
       "      <td>0.07585</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>487</td>\n",
       "      <td>245</td>\n",
       "      <td>0.014898</td>\n",
       "      <td>0.055481</td>\n",
       "      <td>30</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>IOS2015020021303</td>\n",
       "      <td>Central Strait of Georgia</td>\n",
       "      <td>GEO1</td>\n",
       "      <td>-123.748</td>\n",
       "      <td>49.249</td>\n",
       "      <td>2015-06-06 22:56:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>MPS VNH</td>\n",
       "      <td>250</td>\n",
       "      <td>200</td>\n",
       "      <td>...</td>\n",
       "      <td>0.41095</td>\n",
       "      <td>0.08984</td>\n",
       "      <td>0.14523</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>487</td>\n",
       "      <td>245</td>\n",
       "      <td>0.049306</td>\n",
       "      <td>0.136318</td>\n",
       "      <td>26</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>IOS2015020021304</td>\n",
       "      <td>Central Strait of Georgia</td>\n",
       "      <td>GEO1</td>\n",
       "      <td>-123.748</td>\n",
       "      <td>49.249</td>\n",
       "      <td>2015-06-06 22:59:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>MPS VNH</td>\n",
       "      <td>250</td>\n",
       "      <td>100</td>\n",
       "      <td>...</td>\n",
       "      <td>0.36214</td>\n",
       "      <td>0.07894</td>\n",
       "      <td>0.32747</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>487</td>\n",
       "      <td>245</td>\n",
       "      <td>0.092179</td>\n",
       "      <td>0.276844</td>\n",
       "      <td>23</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>IOS2015020021305</td>\n",
       "      <td>Central Strait of Georgia</td>\n",
       "      <td>GEO1</td>\n",
       "      <td>-123.748</td>\n",
       "      <td>49.249</td>\n",
       "      <td>2015-06-06 23:00:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>MPS VNH</td>\n",
       "      <td>250</td>\n",
       "      <td>50</td>\n",
       "      <td>...</td>\n",
       "      <td>1.12051</td>\n",
       "      <td>0.81724</td>\n",
       "      <td>1.01784</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>487</td>\n",
       "      <td>245</td>\n",
       "      <td>0.242380</td>\n",
       "      <td>0.688722</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>IOS2015020021501</td>\n",
       "      <td>Central Strait of Georgia</td>\n",
       "      <td>38</td>\n",
       "      <td>-123.440</td>\n",
       "      <td>49.202</td>\n",
       "      <td>2015-06-07 01:06:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>Bongo VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>293</td>\n",
       "      <td>...</td>\n",
       "      <td>1.18817</td>\n",
       "      <td>0.44428</td>\n",
       "      <td>0.48725</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>456</td>\n",
       "      <td>285</td>\n",
       "      <td>0.129881</td>\n",
       "      <td>0.326925</td>\n",
       "      <td>0</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>IOS2015020021701</td>\n",
       "      <td>Central Strait of Georgia</td>\n",
       "      <td>41</td>\n",
       "      <td>-123.372</td>\n",
       "      <td>49.056</td>\n",
       "      <td>2015-06-07 02:45:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>Bongo VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>219</td>\n",
       "      <td>...</td>\n",
       "      <td>1.04013</td>\n",
       "      <td>0.54064</td>\n",
       "      <td>0.18782</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>423</td>\n",
       "      <td>276</td>\n",
       "      <td>0.148957</td>\n",
       "      <td>0.415778</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>PSF2015098003201</td>\n",
       "      <td>Baynes Sound</td>\n",
       "      <td>BS-7</td>\n",
       "      <td>-124.767</td>\n",
       "      <td>49.484</td>\n",
       "      <td>2015-06-08 16:08:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>Ring VNH</td>\n",
       "      <td>250</td>\n",
       "      <td>47</td>\n",
       "      <td>...</td>\n",
       "      <td>0.47805</td>\n",
       "      <td>2.34147</td>\n",
       "      <td>45.46341</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>605</td>\n",
       "      <td>125</td>\n",
       "      <td>0.315842</td>\n",
       "      <td>1.034672</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>PSF2015098003301</td>\n",
       "      <td>Baynes Sound</td>\n",
       "      <td>BS-1</td>\n",
       "      <td>-124.866</td>\n",
       "      <td>49.609</td>\n",
       "      <td>2015-06-08 17:43:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>Ring VNH</td>\n",
       "      <td>250</td>\n",
       "      <td>24</td>\n",
       "      <td>...</td>\n",
       "      <td>0.06772</td>\n",
       "      <td>3.79260</td>\n",
       "      <td>135.90124</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>636</td>\n",
       "      <td>126</td>\n",
       "      <td>0.465556</td>\n",
       "      <td>1.880479</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>PSF2015097002501</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>IS-4</td>\n",
       "      <td>-124.155</td>\n",
       "      <td>49.575</td>\n",
       "      <td>2015-06-09 18:32:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>Ring VNH</td>\n",
       "      <td>250</td>\n",
       "      <td>141</td>\n",
       "      <td>...</td>\n",
       "      <td>0.32217</td>\n",
       "      <td>0.40143</td>\n",
       "      <td>1.29828</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>579</td>\n",
       "      <td>226</td>\n",
       "      <td>0.105121</td>\n",
       "      <td>0.394998</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>PSF2015097002601</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>IS-3</td>\n",
       "      <td>-124.287</td>\n",
       "      <td>49.655</td>\n",
       "      <td>2015-06-09 20:44:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>Ring VNH</td>\n",
       "      <td>250</td>\n",
       "      <td>148</td>\n",
       "      <td>...</td>\n",
       "      <td>0.32345</td>\n",
       "      <td>0.35797</td>\n",
       "      <td>0.28382</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>604</td>\n",
       "      <td>217</td>\n",
       "      <td>0.101539</td>\n",
       "      <td>0.444235</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>PSF2015097002701</td>\n",
       "      <td>Nearshore-North East</td>\n",
       "      <td>IS-2</td>\n",
       "      <td>-124.083</td>\n",
       "      <td>49.637</td>\n",
       "      <td>2015-06-09 22:40:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>Ring VNH</td>\n",
       "      <td>250</td>\n",
       "      <td>25</td>\n",
       "      <td>...</td>\n",
       "      <td>0.71367</td>\n",
       "      <td>0.85947</td>\n",
       "      <td>9.95299</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>587</td>\n",
       "      <td>245</td>\n",
       "      <td>0.336851</td>\n",
       "      <td>0.906971</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>PSF2015097002801</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>IS-4</td>\n",
       "      <td>-124.157</td>\n",
       "      <td>49.575</td>\n",
       "      <td>2015-06-15 17:34:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>Ring VNH</td>\n",
       "      <td>250</td>\n",
       "      <td>150</td>\n",
       "      <td>...</td>\n",
       "      <td>1.33018</td>\n",
       "      <td>0.22629</td>\n",
       "      <td>6.52331</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>580</td>\n",
       "      <td>226</td>\n",
       "      <td>0.189448</td>\n",
       "      <td>0.438321</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>PSF2015097002901</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>IS-3</td>\n",
       "      <td>-124.287</td>\n",
       "      <td>49.655</td>\n",
       "      <td>2015-06-15 19:08:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>Ring VNH</td>\n",
       "      <td>250</td>\n",
       "      <td>148</td>\n",
       "      <td>...</td>\n",
       "      <td>0.29802</td>\n",
       "      <td>0.22109</td>\n",
       "      <td>8.11830</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>604</td>\n",
       "      <td>217</td>\n",
       "      <td>0.205938</td>\n",
       "      <td>0.534066</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>PSF2015097003001</td>\n",
       "      <td>Nearshore-North East</td>\n",
       "      <td>IS-2</td>\n",
       "      <td>-124.083</td>\n",
       "      <td>49.637</td>\n",
       "      <td>2015-06-15 21:08:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>Ring VNH</td>\n",
       "      <td>250</td>\n",
       "      <td>36</td>\n",
       "      <td>...</td>\n",
       "      <td>1.90443</td>\n",
       "      <td>0.86977</td>\n",
       "      <td>94.24747</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>587</td>\n",
       "      <td>245</td>\n",
       "      <td>0.804913</td>\n",
       "      <td>1.618268</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>PSF2015098006001</td>\n",
       "      <td>Baynes Sound</td>\n",
       "      <td>BS-7</td>\n",
       "      <td>-124.767</td>\n",
       "      <td>49.483</td>\n",
       "      <td>2015-06-18 15:32:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>Ring VNH</td>\n",
       "      <td>250</td>\n",
       "      <td>57</td>\n",
       "      <td>...</td>\n",
       "      <td>0.74627</td>\n",
       "      <td>0.89228</td>\n",
       "      <td>20.63169</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>605</td>\n",
       "      <td>125</td>\n",
       "      <td>0.563907</td>\n",
       "      <td>0.800657</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>PSF2015098003401</td>\n",
       "      <td>Baynes Sound</td>\n",
       "      <td>BS-1</td>\n",
       "      <td>-124.867</td>\n",
       "      <td>49.608</td>\n",
       "      <td>2015-06-18 16:48:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>Ring VNH</td>\n",
       "      <td>250</td>\n",
       "      <td>33</td>\n",
       "      <td>...</td>\n",
       "      <td>0.23051</td>\n",
       "      <td>1.43729</td>\n",
       "      <td>26.57627</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>636</td>\n",
       "      <td>126</td>\n",
       "      <td>0.702900</td>\n",
       "      <td>1.055745</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>PSF2015098003501</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>BS-3</td>\n",
       "      <td>-124.666</td>\n",
       "      <td>49.692</td>\n",
       "      <td>2015-06-18 18:49:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>Ring VNH</td>\n",
       "      <td>250</td>\n",
       "      <td>150</td>\n",
       "      <td>...</td>\n",
       "      <td>1.03680</td>\n",
       "      <td>0.25693</td>\n",
       "      <td>3.19715</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>639</td>\n",
       "      <td>166</td>\n",
       "      <td>0.260603</td>\n",
       "      <td>0.456427</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>PSF2015098003601</td>\n",
       "      <td>Nearshore North West</td>\n",
       "      <td>BS-6</td>\n",
       "      <td>-124.605</td>\n",
       "      <td>49.491</td>\n",
       "      <td>2015-06-18 21:29:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>Ring VNH</td>\n",
       "      <td>250</td>\n",
       "      <td>36</td>\n",
       "      <td>...</td>\n",
       "      <td>0.56746</td>\n",
       "      <td>0.72541</td>\n",
       "      <td>2.45704</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>595</td>\n",
       "      <td>149</td>\n",
       "      <td>0.780453</td>\n",
       "      <td>0.950406</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>PSF2015098003701</td>\n",
       "      <td>Baynes Sound</td>\n",
       "      <td>BS-7</td>\n",
       "      <td>-124.767</td>\n",
       "      <td>49.483</td>\n",
       "      <td>2015-06-23 15:44:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>Ring VNH</td>\n",
       "      <td>250</td>\n",
       "      <td>47</td>\n",
       "      <td>...</td>\n",
       "      <td>0.05405</td>\n",
       "      <td>0.61622</td>\n",
       "      <td>73.62163</td>\n",
       "      <td>0.10811</td>\n",
       "      <td>605</td>\n",
       "      <td>125</td>\n",
       "      <td>0.416449</td>\n",
       "      <td>0.689419</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>PSF2015098003801</td>\n",
       "      <td>Baynes Sound</td>\n",
       "      <td>BS-1</td>\n",
       "      <td>-124.867</td>\n",
       "      <td>49.609</td>\n",
       "      <td>2015-06-23 16:52:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>Ring VNH</td>\n",
       "      <td>250</td>\n",
       "      <td>31</td>\n",
       "      <td>...</td>\n",
       "      <td>0.17524</td>\n",
       "      <td>1.60000</td>\n",
       "      <td>26.66667</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>637</td>\n",
       "      <td>126</td>\n",
       "      <td>1.018696</td>\n",
       "      <td>1.327305</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>PSF2015098003901</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>BS-3</td>\n",
       "      <td>-124.667</td>\n",
       "      <td>49.692</td>\n",
       "      <td>2015-06-23 19:04:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>Ring VNH</td>\n",
       "      <td>250</td>\n",
       "      <td>130</td>\n",
       "      <td>...</td>\n",
       "      <td>0.91690</td>\n",
       "      <td>0.85479</td>\n",
       "      <td>3.88494</td>\n",
       "      <td>0.29224</td>\n",
       "      <td>639</td>\n",
       "      <td>166</td>\n",
       "      <td>0.257833</td>\n",
       "      <td>0.493006</td>\n",
       "      <td>0</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>PSF2015097003101</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>IS-4</td>\n",
       "      <td>-124.155</td>\n",
       "      <td>49.575</td>\n",
       "      <td>2015-06-24 18:18:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>Ring VNH</td>\n",
       "      <td>250</td>\n",
       "      <td>150</td>\n",
       "      <td>...</td>\n",
       "      <td>1.52572</td>\n",
       "      <td>0.12528</td>\n",
       "      <td>0.89013</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>579</td>\n",
       "      <td>226</td>\n",
       "      <td>0.161277</td>\n",
       "      <td>0.365172</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>PSF2015097003201</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>IS-3</td>\n",
       "      <td>-124.287</td>\n",
       "      <td>49.655</td>\n",
       "      <td>2015-06-24 19:48:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>Ring VNH</td>\n",
       "      <td>250</td>\n",
       "      <td>150</td>\n",
       "      <td>...</td>\n",
       "      <td>1.03530</td>\n",
       "      <td>0.22246</td>\n",
       "      <td>1.39992</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>604</td>\n",
       "      <td>217</td>\n",
       "      <td>0.146848</td>\n",
       "      <td>0.341614</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>PSF2015097003301</td>\n",
       "      <td>Nearshore-North East</td>\n",
       "      <td>IS-2</td>\n",
       "      <td>-124.083</td>\n",
       "      <td>49.637</td>\n",
       "      <td>2015-06-24 21:41:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>Ring VNH</td>\n",
       "      <td>250</td>\n",
       "      <td>32</td>\n",
       "      <td>...</td>\n",
       "      <td>0.57785</td>\n",
       "      <td>0.67135</td>\n",
       "      <td>5.76987</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>587</td>\n",
       "      <td>245</td>\n",
       "      <td>0.449345</td>\n",
       "      <td>0.688347</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>IOS2015018000301</td>\n",
       "      <td>Tidal Mixed</td>\n",
       "      <td>59</td>\n",
       "      <td>-123.244</td>\n",
       "      <td>48.630</td>\n",
       "      <td>2015-06-25 04:55:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>151</td>\n",
       "      <td>...</td>\n",
       "      <td>0.15325</td>\n",
       "      <td>1.04130</td>\n",
       "      <td>0.73676</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>331</td>\n",
       "      <td>242</td>\n",
       "      <td>0.302414</td>\n",
       "      <td>0.548781</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>IOS2015018001501</td>\n",
       "      <td>Juan de Fuca</td>\n",
       "      <td>72</td>\n",
       "      <td>-124.067</td>\n",
       "      <td>48.311</td>\n",
       "      <td>2015-06-25 21:56:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>171</td>\n",
       "      <td>...</td>\n",
       "      <td>0.17342</td>\n",
       "      <td>0.02021</td>\n",
       "      <td>0.28119</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>329</td>\n",
       "      <td>82</td>\n",
       "      <td>0.144993</td>\n",
       "      <td>0.381645</td>\n",
       "      <td>0</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>IOS2015018002801</td>\n",
       "      <td>Tidal Mixed</td>\n",
       "      <td>63</td>\n",
       "      <td>-122.976</td>\n",
       "      <td>48.244</td>\n",
       "      <td>2015-06-26 08:46:00</td>\n",
       "      <td>Night</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>144</td>\n",
       "      <td>...</td>\n",
       "      <td>0.06949</td>\n",
       "      <td>0.50700</td>\n",
       "      <td>11.33600</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>238</td>\n",
       "      <td>234</td>\n",
       "      <td>0.270909</td>\n",
       "      <td>0.616372</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>IOS2015018003501</td>\n",
       "      <td>Gulf Islands</td>\n",
       "      <td>52</td>\n",
       "      <td>-123.025</td>\n",
       "      <td>48.773</td>\n",
       "      <td>2015-06-26 17:08:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>203</td>\n",
       "      <td>...</td>\n",
       "      <td>0.27303</td>\n",
       "      <td>0.63049</td>\n",
       "      <td>2.91797</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>344</td>\n",
       "      <td>292</td>\n",
       "      <td>0.260919</td>\n",
       "      <td>0.516593</td>\n",
       "      <td>0</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>IOS2015018004801</td>\n",
       "      <td>Central Strait of Georgia</td>\n",
       "      <td>42</td>\n",
       "      <td>-123.437</td>\n",
       "      <td>49.030</td>\n",
       "      <td>2015-06-27 03:01:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>312</td>\n",
       "      <td>...</td>\n",
       "      <td>0.21688</td>\n",
       "      <td>0.14958</td>\n",
       "      <td>1.43429</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>422</td>\n",
       "      <td>263</td>\n",
       "      <td>0.156038</td>\n",
       "      <td>0.311815</td>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>IOS2015018005801</td>\n",
       "      <td>Central Strait of Georgia</td>\n",
       "      <td>GEO1</td>\n",
       "      <td>-123.748</td>\n",
       "      <td>49.250</td>\n",
       "      <td>2015-06-27 09:54:00</td>\n",
       "      <td>Night</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>395</td>\n",
       "      <td>...</td>\n",
       "      <td>1.38083</td>\n",
       "      <td>0.40716</td>\n",
       "      <td>0.41838</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>487</td>\n",
       "      <td>245</td>\n",
       "      <td>0.079141</td>\n",
       "      <td>0.164747</td>\n",
       "      <td>0</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>IOS2015018006901</td>\n",
       "      <td>Central Strait of Georgia</td>\n",
       "      <td>CPF1</td>\n",
       "      <td>-124.086</td>\n",
       "      <td>49.366</td>\n",
       "      <td>2015-06-27 18:33:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>231</td>\n",
       "      <td>...</td>\n",
       "      <td>1.15273</td>\n",
       "      <td>0.20288</td>\n",
       "      <td>0.38883</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>534</td>\n",
       "      <td>210</td>\n",
       "      <td>0.104848</td>\n",
       "      <td>0.246499</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>IOS2015018007401</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>CPF2</td>\n",
       "      <td>-124.500</td>\n",
       "      <td>49.467</td>\n",
       "      <td>2015-06-27 22:22:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>325</td>\n",
       "      <td>...</td>\n",
       "      <td>1.27439</td>\n",
       "      <td>0.30115</td>\n",
       "      <td>2.72906</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>583</td>\n",
       "      <td>162</td>\n",
       "      <td>0.088338</td>\n",
       "      <td>0.207112</td>\n",
       "      <td>0</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>IOS2015018007501</td>\n",
       "      <td>Baynes Sound</td>\n",
       "      <td>BS1</td>\n",
       "      <td>-124.763</td>\n",
       "      <td>49.480</td>\n",
       "      <td>2015-06-27 23:40:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>61</td>\n",
       "      <td>...</td>\n",
       "      <td>0.69324</td>\n",
       "      <td>0.58465</td>\n",
       "      <td>13.15498</td>\n",
       "      <td>0.10440</td>\n",
       "      <td>604</td>\n",
       "      <td>125</td>\n",
       "      <td>0.401219</td>\n",
       "      <td>0.796621</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>IOS2015018008401</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>11</td>\n",
       "      <td>-124.724</td>\n",
       "      <td>49.707</td>\n",
       "      <td>2015-06-28 06:15:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>298</td>\n",
       "      <td>...</td>\n",
       "      <td>1.06781</td>\n",
       "      <td>0.23454</td>\n",
       "      <td>0.10399</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>646</td>\n",
       "      <td>159</td>\n",
       "      <td>0.118683</td>\n",
       "      <td>0.252703</td>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>IOS2015018008701</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>14</td>\n",
       "      <td>-124.994</td>\n",
       "      <td>49.884</td>\n",
       "      <td>2015-06-28 09:57:00</td>\n",
       "      <td>Night</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>313</td>\n",
       "      <td>...</td>\n",
       "      <td>0.64792</td>\n",
       "      <td>0.41158</td>\n",
       "      <td>0.15437</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>699</td>\n",
       "      <td>141</td>\n",
       "      <td>0.100846</td>\n",
       "      <td>0.233627</td>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>IOS2015018010001</td>\n",
       "      <td>Northern Strait of Georgia</td>\n",
       "      <td>22</td>\n",
       "      <td>-124.271</td>\n",
       "      <td>49.670</td>\n",
       "      <td>2015-06-29 02:59:00</td>\n",
       "      <td>Daylight</td>\n",
       "      <td>SCOR VNH</td>\n",
       "      <td>236</td>\n",
       "      <td>347</td>\n",
       "      <td>...</td>\n",
       "      <td>1.20016</td>\n",
       "      <td>0.33240</td>\n",
       "      <td>0.40017</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>606</td>\n",
       "      <td>221</td>\n",
       "      <td>0.053246</td>\n",
       "      <td>0.155823</td>\n",
       "      <td>0</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>45 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Key                 region_name Station      Lon     Lat  \\\n",
       "0    IOS2015020019801  Northern Strait of Georgia      14 -124.997  49.884   \n",
       "1   IOS2015020020001A  Northern Strait of Georgia      11 -124.723  49.707   \n",
       "2    IOS2015020020201  Northern Strait of Georgia    CPF2 -124.500  49.466   \n",
       "3    IOS2015020020401   Central Strait of Georgia    CPF1 -124.084  49.367   \n",
       "4    IOS2015020020601  Northern Strait of Georgia      22 -124.272  49.670   \n",
       "5    IOS2015020020801  Northern Strait of Georgia      24 -124.098  49.504   \n",
       "6    IOS2015020021001   Central Strait of Georgia      28 -123.755  49.402   \n",
       "7    IOS2015020021201   Central Strait of Georgia    GEO1 -123.750  49.249   \n",
       "8    IOS2015020021301   Central Strait of Georgia    GEO1 -123.748  49.249   \n",
       "9    IOS2015020021302   Central Strait of Georgia    GEO1 -123.748  49.249   \n",
       "10   IOS2015020021303   Central Strait of Georgia    GEO1 -123.748  49.249   \n",
       "11   IOS2015020021304   Central Strait of Georgia    GEO1 -123.748  49.249   \n",
       "12   IOS2015020021305   Central Strait of Georgia    GEO1 -123.748  49.249   \n",
       "13   IOS2015020021501   Central Strait of Georgia      38 -123.440  49.202   \n",
       "14   IOS2015020021701   Central Strait of Georgia      41 -123.372  49.056   \n",
       "15   PSF2015098003201                Baynes Sound    BS-7 -124.767  49.484   \n",
       "16   PSF2015098003301                Baynes Sound    BS-1 -124.866  49.609   \n",
       "17   PSF2015097002501  Northern Strait of Georgia    IS-4 -124.155  49.575   \n",
       "18   PSF2015097002601  Northern Strait of Georgia    IS-3 -124.287  49.655   \n",
       "19   PSF2015097002701        Nearshore-North East    IS-2 -124.083  49.637   \n",
       "20   PSF2015097002801  Northern Strait of Georgia    IS-4 -124.157  49.575   \n",
       "21   PSF2015097002901  Northern Strait of Georgia    IS-3 -124.287  49.655   \n",
       "22   PSF2015097003001        Nearshore-North East    IS-2 -124.083  49.637   \n",
       "23   PSF2015098006001                Baynes Sound    BS-7 -124.767  49.483   \n",
       "24   PSF2015098003401                Baynes Sound    BS-1 -124.867  49.608   \n",
       "25   PSF2015098003501  Northern Strait of Georgia    BS-3 -124.666  49.692   \n",
       "26   PSF2015098003601        Nearshore North West    BS-6 -124.605  49.491   \n",
       "27   PSF2015098003701                Baynes Sound    BS-7 -124.767  49.483   \n",
       "28   PSF2015098003801                Baynes Sound    BS-1 -124.867  49.609   \n",
       "29   PSF2015098003901  Northern Strait of Georgia    BS-3 -124.667  49.692   \n",
       "30   PSF2015097003101  Northern Strait of Georgia    IS-4 -124.155  49.575   \n",
       "31   PSF2015097003201  Northern Strait of Georgia    IS-3 -124.287  49.655   \n",
       "32   PSF2015097003301        Nearshore-North East    IS-2 -124.083  49.637   \n",
       "33   IOS2015018000301                 Tidal Mixed      59 -123.244  48.630   \n",
       "34   IOS2015018001501                Juan de Fuca      72 -124.067  48.311   \n",
       "35   IOS2015018002801                 Tidal Mixed      63 -122.976  48.244   \n",
       "36   IOS2015018003501                Gulf Islands      52 -123.025  48.773   \n",
       "37   IOS2015018004801   Central Strait of Georgia      42 -123.437  49.030   \n",
       "38   IOS2015018005801   Central Strait of Georgia    GEO1 -123.748  49.250   \n",
       "39   IOS2015018006901   Central Strait of Georgia    CPF1 -124.086  49.366   \n",
       "40   IOS2015018007401  Northern Strait of Georgia    CPF2 -124.500  49.467   \n",
       "41   IOS2015018007501                Baynes Sound     BS1 -124.763  49.480   \n",
       "42   IOS2015018008401  Northern Strait of Georgia      11 -124.724  49.707   \n",
       "43   IOS2015018008701  Northern Strait of Georgia      14 -124.994  49.884   \n",
       "44   IOS2015018010001  Northern Strait of Georgia      22 -124.271  49.670   \n",
       "\n",
       "                 dtUTC  Twilight   Net_Type  Mesh_Size(um)  Z_lower  ...  \\\n",
       "0  2015-06-06 06:06:00  Daylight  Bongo VNH            236      302  ...   \n",
       "1  2015-06-06 08:37:00     Night  Bongo VNH            236      289  ...   \n",
       "2  2015-06-06 11:05:00  Daylight  Bongo VNH            236      315  ...   \n",
       "3  2015-06-06 13:25:00  Daylight  Bongo VNH            236      233  ...   \n",
       "4  2015-06-06 16:26:00  Daylight  Bongo VNH            236      342  ...   \n",
       "5  2015-06-06 18:28:00  Daylight  Bongo VNH            236      411  ...   \n",
       "6  2015-06-06 20:27:00  Daylight  Bongo VNH            236      122  ...   \n",
       "7  2015-06-06 22:11:00  Daylight  Bongo VNH            236      390  ...   \n",
       "8  2015-06-06 22:53:00  Daylight    MPS VNH            250      390  ...   \n",
       "9  2015-06-06 22:54:00  Daylight    MPS VNH            250      300  ...   \n",
       "10 2015-06-06 22:56:00  Daylight    MPS VNH            250      200  ...   \n",
       "11 2015-06-06 22:59:00  Daylight    MPS VNH            250      100  ...   \n",
       "12 2015-06-06 23:00:00  Daylight    MPS VNH            250       50  ...   \n",
       "13 2015-06-07 01:06:00  Daylight  Bongo VNH            236      293  ...   \n",
       "14 2015-06-07 02:45:00  Daylight  Bongo VNH            236      219  ...   \n",
       "15 2015-06-08 16:08:00  Daylight   Ring VNH            250       47  ...   \n",
       "16 2015-06-08 17:43:00  Daylight   Ring VNH            250       24  ...   \n",
       "17 2015-06-09 18:32:00  Daylight   Ring VNH            250      141  ...   \n",
       "18 2015-06-09 20:44:00  Daylight   Ring VNH            250      148  ...   \n",
       "19 2015-06-09 22:40:00  Daylight   Ring VNH            250       25  ...   \n",
       "20 2015-06-15 17:34:00  Daylight   Ring VNH            250      150  ...   \n",
       "21 2015-06-15 19:08:00  Daylight   Ring VNH            250      148  ...   \n",
       "22 2015-06-15 21:08:00  Daylight   Ring VNH            250       36  ...   \n",
       "23 2015-06-18 15:32:00  Daylight   Ring VNH            250       57  ...   \n",
       "24 2015-06-18 16:48:00  Daylight   Ring VNH            250       33  ...   \n",
       "25 2015-06-18 18:49:00  Daylight   Ring VNH            250      150  ...   \n",
       "26 2015-06-18 21:29:00  Daylight   Ring VNH            250       36  ...   \n",
       "27 2015-06-23 15:44:00  Daylight   Ring VNH            250       47  ...   \n",
       "28 2015-06-23 16:52:00  Daylight   Ring VNH            250       31  ...   \n",
       "29 2015-06-23 19:04:00  Daylight   Ring VNH            250      130  ...   \n",
       "30 2015-06-24 18:18:00  Daylight   Ring VNH            250      150  ...   \n",
       "31 2015-06-24 19:48:00  Daylight   Ring VNH            250      150  ...   \n",
       "32 2015-06-24 21:41:00  Daylight   Ring VNH            250       32  ...   \n",
       "33 2015-06-25 04:55:00  Daylight   SCOR VNH            236      151  ...   \n",
       "34 2015-06-25 21:56:00  Daylight   SCOR VNH            236      171  ...   \n",
       "35 2015-06-26 08:46:00     Night   SCOR VNH            236      144  ...   \n",
       "36 2015-06-26 17:08:00  Daylight   SCOR VNH            236      203  ...   \n",
       "37 2015-06-27 03:01:00  Daylight   SCOR VNH            236      312  ...   \n",
       "38 2015-06-27 09:54:00     Night   SCOR VNH            236      395  ...   \n",
       "39 2015-06-27 18:33:00  Daylight   SCOR VNH            236      231  ...   \n",
       "40 2015-06-27 22:22:00  Daylight   SCOR VNH            236      325  ...   \n",
       "41 2015-06-27 23:40:00  Daylight   SCOR VNH            236       61  ...   \n",
       "42 2015-06-28 06:15:00  Daylight   SCOR VNH            236      298  ...   \n",
       "43 2015-06-28 09:57:00     Night   SCOR VNH            236      313  ...   \n",
       "44 2015-06-29 02:59:00  Daylight   SCOR VNH            236      347  ...   \n",
       "\n",
       "    Cyclopoida  Poecilostomatoida   Copelata  Harpacticoida    j    i  \\\n",
       "0      0.72407            0.94464    0.49944        0.00000  700  141   \n",
       "1      0.50000            0.43750    0.05000        0.00000  645  159   \n",
       "2      0.91324            0.41343    0.09291        0.00000  583  162   \n",
       "3      0.87370            0.44702    0.23760        0.00000  534  211   \n",
       "4      0.73786            0.43804    1.47271        0.00000  606  221   \n",
       "5      0.77318            0.35132    0.90786        0.00018  562  226   \n",
       "6      1.87486            0.49741    1.77711        0.00000  517  263   \n",
       "7      0.76200            0.38549    0.32561        0.00000  487  245   \n",
       "8      0.03467            0.04440    0.17067        0.00000  487  245   \n",
       "9      0.02844            0.02329    0.07585        0.00000  487  245   \n",
       "10     0.41095            0.08984    0.14523        0.00000  487  245   \n",
       "11     0.36214            0.07894    0.32747        0.00000  487  245   \n",
       "12     1.12051            0.81724    1.01784        0.00000  487  245   \n",
       "13     1.18817            0.44428    0.48725        0.00000  456  285   \n",
       "14     1.04013            0.54064    0.18782        0.00000  423  276   \n",
       "15     0.47805            2.34147   45.46341        0.00000  605  125   \n",
       "16     0.06772            3.79260  135.90124        0.00000  636  126   \n",
       "17     0.32217            0.40143    1.29828        0.00000  579  226   \n",
       "18     0.32345            0.35797    0.28382        0.00000  604  217   \n",
       "19     0.71367            0.85947    9.95299        0.00000  587  245   \n",
       "20     1.33018            0.22629    6.52331        0.00000  580  226   \n",
       "21     0.29802            0.22109    8.11830        0.00000  604  217   \n",
       "22     1.90443            0.86977   94.24747        0.00000  587  245   \n",
       "23     0.74627            0.89228   20.63169        0.00000  605  125   \n",
       "24     0.23051            1.43729   26.57627        0.00000  636  126   \n",
       "25     1.03680            0.25693    3.19715        0.00000  639  166   \n",
       "26     0.56746            0.72541    2.45704        0.00000  595  149   \n",
       "27     0.05405            0.61622   73.62163        0.10811  605  125   \n",
       "28     0.17524            1.60000   26.66667        0.00000  637  126   \n",
       "29     0.91690            0.85479    3.88494        0.29224  639  166   \n",
       "30     1.52572            0.12528    0.89013        0.00000  579  226   \n",
       "31     1.03530            0.22246    1.39992        0.00000  604  217   \n",
       "32     0.57785            0.67135    5.76987        0.00000  587  245   \n",
       "33     0.15325            1.04130    0.73676        0.00000  331  242   \n",
       "34     0.17342            0.02021    0.28119        0.00000  329   82   \n",
       "35     0.06949            0.50700   11.33600        0.00000  238  234   \n",
       "36     0.27303            0.63049    2.91797        0.00000  344  292   \n",
       "37     0.21688            0.14958    1.43429        0.00000  422  263   \n",
       "38     1.38083            0.40716    0.41838        0.00000  487  245   \n",
       "39     1.15273            0.20288    0.38883        0.00000  534  210   \n",
       "40     1.27439            0.30115    2.72906        0.00000  583  162   \n",
       "41     0.69324            0.58465   13.15498        0.10440  604  125   \n",
       "42     1.06781            0.23454    0.10399        0.00000  646  159   \n",
       "43     0.64792            0.41158    0.15437        0.00000  699  141   \n",
       "44     1.20016            0.33240    0.40017        0.00000  606  221   \n",
       "\n",
       "    mod_microzooplankton  mod_mesozooplankton  k_upper  k_lower  \n",
       "0               0.074582             0.290741        0       34  \n",
       "1               0.072160             0.309218        0       33  \n",
       "2               0.048654             0.186083        0       34  \n",
       "3               0.094083             0.301332        0       31  \n",
       "4               0.042945             0.192460        0       35  \n",
       "5               0.047029             0.173742        0       38  \n",
       "6               0.148792             0.430705        0       27  \n",
       "7               0.058598             0.176175        0       37  \n",
       "8               0.003679             0.025794       34       37  \n",
       "9               0.014898             0.055481       30       34  \n",
       "10              0.049306             0.136318       26       30  \n",
       "11              0.092179             0.276844       23       26  \n",
       "12              0.242380             0.688722        0       23  \n",
       "13              0.129881             0.326925        0       33  \n",
       "14              0.148957             0.415778        0       31  \n",
       "15              0.315842             1.034672        0       23  \n",
       "16              0.465556             1.880479        0       20  \n",
       "17              0.105121             0.394998        0       28  \n",
       "18              0.101539             0.444235        0       28  \n",
       "19              0.336851             0.906971        0       20  \n",
       "20              0.189448             0.438321        0       28  \n",
       "21              0.205938             0.534066        0       28  \n",
       "22              0.804913             1.618268        0       22  \n",
       "23              0.563907             0.800657        0       24  \n",
       "24              0.702900             1.055745        0       22  \n",
       "25              0.260603             0.456427        0       28  \n",
       "26              0.780453             0.950406        0       22  \n",
       "27              0.416449             0.689419        0       23  \n",
       "28              1.018696             1.327305        0       21  \n",
       "29              0.257833             0.493006        0       27  \n",
       "30              0.161277             0.365172        0       28  \n",
       "31              0.146848             0.341614        0       28  \n",
       "32              0.449345             0.688347        0       22  \n",
       "33              0.302414             0.548781        0       28  \n",
       "34              0.144993             0.381645        0       29  \n",
       "35              0.270909             0.616372        0       28  \n",
       "36              0.260919             0.516593        0       30  \n",
       "37              0.156038             0.311815        0       34  \n",
       "38              0.079141             0.164747        0       37  \n",
       "39              0.104848             0.246499        0       31  \n",
       "40              0.088338             0.207112        0       35  \n",
       "41              0.401219             0.796621        0       24  \n",
       "42              0.118683             0.252703        0       34  \n",
       "43              0.100846             0.233627        0       34  \n",
       "44              0.053246             0.155823        0       35  \n",
       "\n",
       "[45 rows x 26 columns]"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python (py39)",
   "language": "python",
   "name": "py39"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}