notebooks/Explore_Ice_Thickness_Distributions.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "/home/disk/sipn/nicway/data/obs/G10006/native/AIR-EM_distributions_V20160513.txt\n"
     ]
    },
    {
     "ename": "ParserError",
     "evalue": "Error tokenizing data. C error: Expected 368 fields in line 7, saw 371\n",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mParserError\u001b[0m                               Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-1-547cc92e6553>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m     18\u001b[0m \u001b[0;32mfor\u001b[0m \u001b[0mcf\u001b[0m \u001b[0;32min\u001b[0m \u001b[0;34m[\u001b[0m\u001b[0mall_files\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     19\u001b[0m     \u001b[0;32mprint\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcf\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 20\u001b[0;31m     \u001b[0mdf\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mread_csv\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcf\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mheader\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mdelimiter\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m' '\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;32m/home/disk/sipn/nicway/anaconda3/envs/xesmf/lib/python2.7/site-packages/pandas/io/parsers.pyc\u001b[0m in \u001b[0;36mparser_f\u001b[0;34m(filepath_or_buffer, sep, delimiter, header, names, index_col, usecols, squeeze, prefix, mangle_dupe_cols, dtype, engine, converters, true_values, false_values, skipinitialspace, skiprows, nrows, na_values, keep_default_na, na_filter, verbose, skip_blank_lines, parse_dates, infer_datetime_format, keep_date_col, date_parser, dayfirst, iterator, chunksize, compression, thousands, decimal, lineterminator, quotechar, quoting, escapechar, comment, encoding, dialect, tupleize_cols, error_bad_lines, warn_bad_lines, skipfooter, skip_footer, doublequote, delim_whitespace, as_recarray, compact_ints, use_unsigned, low_memory, buffer_lines, memory_map, float_precision)\u001b[0m\n\u001b[1;32m    707\u001b[0m                     skip_blank_lines=skip_blank_lines)\n\u001b[1;32m    708\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 709\u001b[0;31m         \u001b[0;32mreturn\u001b[0m \u001b[0m_read\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mkwds\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    710\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    711\u001b[0m     \u001b[0mparser_f\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m__name__\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mname\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/home/disk/sipn/nicway/anaconda3/envs/xesmf/lib/python2.7/site-packages/pandas/io/parsers.pyc\u001b[0m in \u001b[0;36m_read\u001b[0;34m(filepath_or_buffer, kwds)\u001b[0m\n\u001b[1;32m    453\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    454\u001b[0m     \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 455\u001b[0;31m         \u001b[0mdata\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mparser\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mread\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mnrows\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    456\u001b[0m     \u001b[0;32mfinally\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    457\u001b[0m         \u001b[0mparser\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mclose\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/home/disk/sipn/nicway/anaconda3/envs/xesmf/lib/python2.7/site-packages/pandas/io/parsers.pyc\u001b[0m in \u001b[0;36mread\u001b[0;34m(self, nrows)\u001b[0m\n\u001b[1;32m   1067\u001b[0m                 \u001b[0;32mraise\u001b[0m \u001b[0mValueError\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'skipfooter not supported for iteration'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1068\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1069\u001b[0;31m         \u001b[0mret\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_engine\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mread\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mnrows\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1070\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1071\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0moptions\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'as_recarray'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/home/disk/sipn/nicway/anaconda3/envs/xesmf/lib/python2.7/site-packages/pandas/io/parsers.pyc\u001b[0m in \u001b[0;36mread\u001b[0;34m(self, nrows)\u001b[0m\n\u001b[1;32m   1837\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0mread\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mnrows\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mNone\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1838\u001b[0m         \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1839\u001b[0;31m             \u001b[0mdata\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_reader\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mread\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mnrows\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1840\u001b[0m         \u001b[0;32mexcept\u001b[0m \u001b[0mStopIteration\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1841\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_first_chunk\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/parsers.pyx\u001b[0m in \u001b[0;36mpandas._libs.parsers.TextReader.read\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/parsers.pyx\u001b[0m in \u001b[0;36mpandas._libs.parsers.TextReader._read_low_memory\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/parsers.pyx\u001b[0m in \u001b[0;36mpandas._libs.parsers.TextReader._read_rows\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/parsers.pyx\u001b[0m in \u001b[0;36mpandas._libs.parsers.TextReader._tokenize_rows\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/parsers.pyx\u001b[0m in \u001b[0;36mpandas._libs.parsers.raise_parser_error\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;31mParserError\u001b[0m: Error tokenizing data. C error: Expected 368 fields in line 7, saw 371\n"
     ]
    }
   ],
   "source": [
    "'''\n",
    "\n",
    "This code is part of the SIPN2 project focused on improving sub-seasonal to seasonal predictions of Arctic Sea Ice. \n",
    "If you use this code for a publication or presentation, please cite the reference in the README.md on the\n",
    "main page (https://github.com/NicWayand/ESIO). \n",
    "\n",
    "Questions or comments should be addressed to nicway@uw.edu\n",
    "\n",
    "Copyright (c) 2018 Nic Wayand\n",
    "\n",
    "GNU General Public License v3.0\n",
    "\n",
    "\n",
    "'''\n",
    "\n",
    "%matplotlib inline\n",
    "import numpy as np\n",
    "import numpy.ma as ma\n",
    "import pandas as pd\n",
    "import os\n",
    "import xarray as xr\n",
    "import glob\n",
    "import loadobservations as lo\n",
    "\n",
    "\n",
    "# Dirs\n",
    "data_dir = r'/home/disk/sipn/nicway/data/obs/G10006/native'\n",
    "\n",
    "# Get distribtion files\n",
    "all_files = glob.glob(data_dir+'/*distributions*.txt')\n",
    "\n",
    "# Loop through each product\n",
    "for cf in [all_files[0]]:\n",
    "    print(cf)\n",
    "    df = pd.read_csv(cf, header=0, delimiter=' ')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>Source    Campaign     Index   Year   Yday MinDay MaxDay  Month     Lat     Lon  MinLat  MaxLat  MinLon  MaxLon Length    Nsamps Nbins  Width  First</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AIR-EM       Ark17  10000000   2001  243...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AIR-EM       Ark17  10000001   2001  246...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AIR-EM       Ark17  10000002   2001  248...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AIR-EM       Ark17  10000003   2001  251...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AIR-EM       Ark17  10000004   2001  263...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>AIR-EM       Ark19  10010000   2003   65...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>AIR-EM       Ark19  10010001   2003   69...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>AIR-EM       Ark19  10010002   2003   71...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>AIR-EM       Ark19  10010003   2003   71...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>AIR-EM       Ark19  10010004   2003   71...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>AIR-EM       Ark19  10010005   2003   74...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>AIR-EM       Ark19  10010006   2003   74...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>AIR-EM       Ark19  10010007   2003   74...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>AIR-EM       Ark19  10010008   2003   75...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>AIR-EM       Ark19  10010009   2003   75...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>AIR-EM       Ark19  10010010   2003   76...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>AIR-EM       Ark19  10010011   2003   76...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>AIR-EM       Ark19  10010012   2003   80...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>AIR-EM       Ark19  10010013   2003   80...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>AIR-EM       Ark19  10010014   2003   81...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>AIR-EM       Ark19  10010015   2003   82...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>AIR-EM       Ark19  10010016   2003   83...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>AIR-EM       Ark19  10010017   2003   84...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>AIR-EM       Ark19  10010018   2003   91...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>AIR-EM       Ark19  10010019   2003   91...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>AIR-EM       Ark19  10010020   2003   94...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>AIR-EM       Ark19  10010021   2003   97...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>AIR-EM       Ark19  10010022   2003  100...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>AIR-EM       Ark19  10010023   2003  101...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>AIR-EM       Ark19  10010024   2003  101...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>425</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220017   2015   99...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>426</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220018   2015   99...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>427</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220019   2015   99...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>428</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220020   2015   99...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>429</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220021   2015  101...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>430</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220022   2015  101...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>431</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220023   2015  101...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>432</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220024   2015  101...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>433</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220025   2015  101...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>434</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220026   2015  101...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>435</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220027   2015  101...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>436</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220028   2015  101...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>437</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220029   2015  101...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>438</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220030   2015  101...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>439</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220031   2015  101...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>440</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220032   2015  101...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>441</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220033   2015  112...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>442</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220034   2015  112...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>443</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220035   2015  112...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>444</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220036   2015  112...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>445</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220037   2015  112...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>446</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220038   2015  112...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>447</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220039   2015  112...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>448</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220040   2015  112...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>449</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220041   2015  112...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>450</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220042   2015  112...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>451</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220043   2015  113...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>452</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220044   2015  113...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>453</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220045   2015  113...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>454</th>\n",
       "      <td>AIR-EM 2015PAM-ARC  10220046   2015  113...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>455 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          Source    Campaign     Index   Year   Yday MinDay MaxDay  Month     Lat     Lon  MinLat  MaxLat  MinLon  MaxLon Length    Nsamps Nbins  Width  First\n",
       "0          AIR-EM       Ark17  10000000   2001  243...                                                                                                        \n",
       "1          AIR-EM       Ark17  10000001   2001  246...                                                                                                        \n",
       "2          AIR-EM       Ark17  10000002   2001  248...                                                                                                        \n",
       "3          AIR-EM       Ark17  10000003   2001  251...                                                                                                        \n",
       "4          AIR-EM       Ark17  10000004   2001  263...                                                                                                        \n",
       "5          AIR-EM       Ark19  10010000   2003   65...                                                                                                        \n",
       "6          AIR-EM       Ark19  10010001   2003   69...                                                                                                        \n",
       "7          AIR-EM       Ark19  10010002   2003   71...                                                                                                        \n",
       "8          AIR-EM       Ark19  10010003   2003   71...                                                                                                        \n",
       "9          AIR-EM       Ark19  10010004   2003   71...                                                                                                        \n",
       "10         AIR-EM       Ark19  10010005   2003   74...                                                                                                        \n",
       "11         AIR-EM       Ark19  10010006   2003   74...                                                                                                        \n",
       "12         AIR-EM       Ark19  10010007   2003   74...                                                                                                        \n",
       "13         AIR-EM       Ark19  10010008   2003   75...                                                                                                        \n",
       "14         AIR-EM       Ark19  10010009   2003   75...                                                                                                        \n",
       "15         AIR-EM       Ark19  10010010   2003   76...                                                                                                        \n",
       "16         AIR-EM       Ark19  10010011   2003   76...                                                                                                        \n",
       "17         AIR-EM       Ark19  10010012   2003   80...                                                                                                        \n",
       "18         AIR-EM       Ark19  10010013   2003   80...                                                                                                        \n",
       "19         AIR-EM       Ark19  10010014   2003   81...                                                                                                        \n",
       "20         AIR-EM       Ark19  10010015   2003   82...                                                                                                        \n",
       "21         AIR-EM       Ark19  10010016   2003   83...                                                                                                        \n",
       "22         AIR-EM       Ark19  10010017   2003   84...                                                                                                        \n",
       "23         AIR-EM       Ark19  10010018   2003   91...                                                                                                        \n",
       "24         AIR-EM       Ark19  10010019   2003   91...                                                                                                        \n",
       "25         AIR-EM       Ark19  10010020   2003   94...                                                                                                        \n",
       "26         AIR-EM       Ark19  10010021   2003   97...                                                                                                        \n",
       "27         AIR-EM       Ark19  10010022   2003  100...                                                                                                        \n",
       "28         AIR-EM       Ark19  10010023   2003  101...                                                                                                        \n",
       "29         AIR-EM       Ark19  10010024   2003  101...                                                                                                        \n",
       "..                                                 ...                                                                                                        \n",
       "425        AIR-EM 2015PAM-ARC  10220017   2015   99...                                                                                                        \n",
       "426        AIR-EM 2015PAM-ARC  10220018   2015   99...                                                                                                        \n",
       "427        AIR-EM 2015PAM-ARC  10220019   2015   99...                                                                                                        \n",
       "428        AIR-EM 2015PAM-ARC  10220020   2015   99...                                                                                                        \n",
       "429        AIR-EM 2015PAM-ARC  10220021   2015  101...                                                                                                        \n",
       "430        AIR-EM 2015PAM-ARC  10220022   2015  101...                                                                                                        \n",
       "431        AIR-EM 2015PAM-ARC  10220023   2015  101...                                                                                                        \n",
       "432        AIR-EM 2015PAM-ARC  10220024   2015  101...                                                                                                        \n",
       "433        AIR-EM 2015PAM-ARC  10220025   2015  101...                                                                                                        \n",
       "434        AIR-EM 2015PAM-ARC  10220026   2015  101...                                                                                                        \n",
       "435        AIR-EM 2015PAM-ARC  10220027   2015  101...                                                                                                        \n",
       "436        AIR-EM 2015PAM-ARC  10220028   2015  101...                                                                                                        \n",
       "437        AIR-EM 2015PAM-ARC  10220029   2015  101...                                                                                                        \n",
       "438        AIR-EM 2015PAM-ARC  10220030   2015  101...                                                                                                        \n",
       "439        AIR-EM 2015PAM-ARC  10220031   2015  101...                                                                                                        \n",
       "440        AIR-EM 2015PAM-ARC  10220032   2015  101...                                                                                                        \n",
       "441        AIR-EM 2015PAM-ARC  10220033   2015  112...                                                                                                        \n",
       "442        AIR-EM 2015PAM-ARC  10220034   2015  112...                                                                                                        \n",
       "443        AIR-EM 2015PAM-ARC  10220035   2015  112...                                                                                                        \n",
       "444        AIR-EM 2015PAM-ARC  10220036   2015  112...                                                                                                        \n",
       "445        AIR-EM 2015PAM-ARC  10220037   2015  112...                                                                                                        \n",
       "446        AIR-EM 2015PAM-ARC  10220038   2015  112...                                                                                                        \n",
       "447        AIR-EM 2015PAM-ARC  10220039   2015  112...                                                                                                        \n",
       "448        AIR-EM 2015PAM-ARC  10220040   2015  112...                                                                                                        \n",
       "449        AIR-EM 2015PAM-ARC  10220041   2015  112...                                                                                                        \n",
       "450        AIR-EM 2015PAM-ARC  10220042   2015  112...                                                                                                        \n",
       "451        AIR-EM 2015PAM-ARC  10220043   2015  113...                                                                                                        \n",
       "452        AIR-EM 2015PAM-ARC  10220044   2015  113...                                                                                                        \n",
       "453        AIR-EM 2015PAM-ARC  10220045   2015  113...                                                                                                        \n",
       "454        AIR-EM 2015PAM-ARC  10220046   2015  113...                                                                                                        \n",
       "\n",
       "[455 rows x 1 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "3.6.4 esio",
   "language": "python",
   "name": "esio"
  },
  "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.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}