pandas_datetime.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "import datetime as d"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = pandas.read_csv(\"/Users/clunch/Desktop/cfc_fieldData_herb.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>uid</th>\n",
       "      <th>namedLocation</th>\n",
       "      <th>domainID</th>\n",
       "      <th>siteID</th>\n",
       "      <th>plotID</th>\n",
       "      <th>plotType</th>\n",
       "      <th>nlcdClass</th>\n",
       "      <th>geodeticDatum</th>\n",
       "      <th>decimalLatitude</th>\n",
       "      <th>decimalLongitude</th>\n",
       "      <th>...</th>\n",
       "      <th>subsample1Height</th>\n",
       "      <th>subsample2Height</th>\n",
       "      <th>subsample3Height</th>\n",
       "      <th>chlorophyllSampleID</th>\n",
       "      <th>collectedBy</th>\n",
       "      <th>recordedBy</th>\n",
       "      <th>remarks</th>\n",
       "      <th>dataQF</th>\n",
       "      <th>subplots</th>\n",
       "      <th>row.index</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>96de6074-bf30-4052-afc0-89596f16c1b2</td>\n",
       "      <td>SCBI_006.basePlot.cfc</td>\n",
       "      <td>D02</td>\n",
       "      <td>SCBI</td>\n",
       "      <td>SCBI_006</td>\n",
       "      <td>distributed</td>\n",
       "      <td>pastureHay</td>\n",
       "      <td>WGS84</td>\n",
       "      <td>38.897609</td>\n",
       "      <td>-78.152007</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HvxvVDlCk19vCgQHzUqELa1Qnpo1wg/Qa/E+vku/Tm0=</td>\n",
       "      <td>dMVZgSbiazVu0oXyzneal5IPnECwOfLe</td>\n",
       "      <td>2CALKs4JNjmK3iYT4PUVEer6DObkBehF</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SCBI_006.basePlot.cfc.40</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>e7c9e828-9fdc-4d27-b021-fc3dcc79b821</td>\n",
       "      <td>SCBI_005.basePlot.cfc</td>\n",
       "      <td>D02</td>\n",
       "      <td>SCBI</td>\n",
       "      <td>SCBI_005</td>\n",
       "      <td>distributed</td>\n",
       "      <td>deciduousForest</td>\n",
       "      <td>WGS84</td>\n",
       "      <td>38.900539</td>\n",
       "      <td>-78.161859</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>HvxvVDlCk1+aEj7OkevsmY/xu/u/XSP4UKR4FFVhlUw=</td>\n",
       "      <td>2CALKs4JNjmK3iYT4PUVEer6DObkBehF</td>\n",
       "      <td>dMVZgSbiazVu0oXyzneal5IPnECwOfLe</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SCBI_005.basePlot.cfc.41</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ea958b71-aa8c-48c9-8977-6bc9526eadde</td>\n",
       "      <td>SERC_008.basePlot.cfc</td>\n",
       "      <td>D02</td>\n",
       "      <td>SERC</td>\n",
       "      <td>SERC_008</td>\n",
       "      <td>distributed</td>\n",
       "      <td>cultivatedCrops</td>\n",
       "      <td>WGS84</td>\n",
       "      <td>38.871839</td>\n",
       "      <td>-76.524078</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FOQ0AtY6KEyr5Og0zMdhf6z+E6veTxAM7qvhEQhIM9c=</td>\n",
       "      <td>2CALKs4JNjmK3iYT4PUVEer6DObkBehF</td>\n",
       "      <td>os5Rd6V2h58xLLGOni43wF5trHQqGKuw</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SERC_008.basePlot.cfc.31</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>8321ef8d-0d5d-4676-80f7-d4991d8d3525</td>\n",
       "      <td>SERC_007.basePlot.cfc</td>\n",
       "      <td>D02</td>\n",
       "      <td>SERC</td>\n",
       "      <td>SERC_007</td>\n",
       "      <td>distributed</td>\n",
       "      <td>cultivatedCrops</td>\n",
       "      <td>WGS84</td>\n",
       "      <td>38.873795</td>\n",
       "      <td>-76.539829</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FOQ0AtY6KEz/dqob1l7/P8l6vMnxDl6DMG5gumTG2jg=</td>\n",
       "      <td>2CALKs4JNjmK3iYT4PUVEer6DObkBehF</td>\n",
       "      <td>os5Rd6V2h58xLLGOni43wF5trHQqGKuw</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SERC_007.basePlot.cfc.31</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>529c3c5a-5779-438e-bf5f-fe6d4938179d</td>\n",
       "      <td>SERC_003.basePlot.cfc</td>\n",
       "      <td>D02</td>\n",
       "      <td>SERC</td>\n",
       "      <td>SERC_003</td>\n",
       "      <td>distributed</td>\n",
       "      <td>deciduousForest</td>\n",
       "      <td>WGS84</td>\n",
       "      <td>38.899874</td>\n",
       "      <td>-76.543769</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FOQ0AtY6KEy3Hw/71mF0saL50FmFsgOw615/bzOl+Dk=</td>\n",
       "      <td>2CALKs4JNjmK3iYT4PUVEer6DObkBehF</td>\n",
       "      <td>os5Rd6V2h58xLLGOni43wF5trHQqGKuw</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SERC_003.basePlot.cfc.31</td>\n",
       "      <td>58</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 40 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    uid          namedLocation domainID  \\\n",
       "0  96de6074-bf30-4052-afc0-89596f16c1b2  SCBI_006.basePlot.cfc      D02   \n",
       "1  e7c9e828-9fdc-4d27-b021-fc3dcc79b821  SCBI_005.basePlot.cfc      D02   \n",
       "2  ea958b71-aa8c-48c9-8977-6bc9526eadde  SERC_008.basePlot.cfc      D02   \n",
       "3  8321ef8d-0d5d-4676-80f7-d4991d8d3525  SERC_007.basePlot.cfc      D02   \n",
       "4  529c3c5a-5779-438e-bf5f-fe6d4938179d  SERC_003.basePlot.cfc      D02   \n",
       "\n",
       "  siteID    plotID     plotType        nlcdClass geodeticDatum  \\\n",
       "0   SCBI  SCBI_006  distributed       pastureHay         WGS84   \n",
       "1   SCBI  SCBI_005  distributed  deciduousForest         WGS84   \n",
       "2   SERC  SERC_008  distributed  cultivatedCrops         WGS84   \n",
       "3   SERC  SERC_007  distributed  cultivatedCrops         WGS84   \n",
       "4   SERC  SERC_003  distributed  deciduousForest         WGS84   \n",
       "\n",
       "   decimalLatitude  decimalLongitude    ...      subsample1Height  \\\n",
       "0        38.897609        -78.152007    ...                   NaN   \n",
       "1        38.900539        -78.161859    ...                   NaN   \n",
       "2        38.871839        -76.524078    ...                   NaN   \n",
       "3        38.873795        -76.539829    ...                   NaN   \n",
       "4        38.899874        -76.543769    ...                   NaN   \n",
       "\n",
       "   subsample2Height  subsample3Height  \\\n",
       "0               NaN               NaN   \n",
       "1               NaN               NaN   \n",
       "2               NaN               NaN   \n",
       "3               NaN               NaN   \n",
       "4               NaN               NaN   \n",
       "\n",
       "                            chlorophyllSampleID  \\\n",
       "0  HvxvVDlCk19vCgQHzUqELa1Qnpo1wg/Qa/E+vku/Tm0=   \n",
       "1  HvxvVDlCk1+aEj7OkevsmY/xu/u/XSP4UKR4FFVhlUw=   \n",
       "2  FOQ0AtY6KEyr5Og0zMdhf6z+E6veTxAM7qvhEQhIM9c=   \n",
       "3  FOQ0AtY6KEz/dqob1l7/P8l6vMnxDl6DMG5gumTG2jg=   \n",
       "4  FOQ0AtY6KEy3Hw/71mF0saL50FmFsgOw615/bzOl+Dk=   \n",
       "\n",
       "                        collectedBy                        recordedBy remarks  \\\n",
       "0  dMVZgSbiazVu0oXyzneal5IPnECwOfLe  2CALKs4JNjmK3iYT4PUVEer6DObkBehF     NaN   \n",
       "1  2CALKs4JNjmK3iYT4PUVEer6DObkBehF  dMVZgSbiazVu0oXyzneal5IPnECwOfLe     NaN   \n",
       "2  2CALKs4JNjmK3iYT4PUVEer6DObkBehF  os5Rd6V2h58xLLGOni43wF5trHQqGKuw     NaN   \n",
       "3  2CALKs4JNjmK3iYT4PUVEer6DObkBehF  os5Rd6V2h58xLLGOni43wF5trHQqGKuw     NaN   \n",
       "4  2CALKs4JNjmK3iYT4PUVEer6DObkBehF  os5Rd6V2h58xLLGOni43wF5trHQqGKuw     NaN   \n",
       "\n",
       "  dataQF                  subplots  row.index  \n",
       "0    NaN  SCBI_006.basePlot.cfc.40         34  \n",
       "1    NaN  SCBI_005.basePlot.cfc.41         37  \n",
       "2    NaN  SERC_008.basePlot.cfc.31         55  \n",
       "3    NaN  SERC_007.basePlot.cfc.31         56  \n",
       "4    NaN  SERC_003.basePlot.cfc.31         58  \n",
       "\n",
       "[5 rows x 40 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "uid                         object\n",
       "namedLocation               object\n",
       "domainID                    object\n",
       "siteID                      object\n",
       "plotID                      object\n",
       "plotType                    object\n",
       "nlcdClass                   object\n",
       "geodeticDatum               object\n",
       "decimalLatitude            float64\n",
       "decimalLongitude           float64\n",
       "coordinateUncertainty      float64\n",
       "elevation                  float64\n",
       "elevationUncertainty       float64\n",
       "samplingProtocolVersion     object\n",
       "collectDate                 object\n",
       "subplotID                    int64\n",
       "sampleType                  object\n",
       "samplingMethod              object\n",
       "vstTag                     float64\n",
       "tagID                      float64\n",
       "individualID               float64\n",
       "taxonID                    float64\n",
       "scientificName             float64\n",
       "plantStatus                 object\n",
       "clipCellNumber               int64\n",
       "clipID                      object\n",
       "clipLength                 float64\n",
       "clipWidth                  float64\n",
       "percentCoverClip           float64\n",
       "sampleID                    object\n",
       "subsample1Height           float64\n",
       "subsample2Height           float64\n",
       "subsample3Height           float64\n",
       "chlorophyllSampleID         object\n",
       "collectedBy                 object\n",
       "recordedBy                  object\n",
       "remarks                     object\n",
       "dataQF                     float64\n",
       "subplots                    object\n",
       "row.index                    int64\n",
       "dtype: object"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "collectDate_dt = pandas.to_datetime(data.collectDate, format='%Y-%m-%dT%H:%MZ')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0   2017-08-03 13:00:00\n",
       "1   2017-08-03 19:00:00\n",
       "2   2016-07-27 11:14:00\n",
       "3   2016-07-27 12:00:00\n",
       "4   2016-07-27 13:40:00\n",
       "Name: collectDate, dtype: datetime64[ns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "collectDate_dt.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "ql = pandas.read_csv(\"/Users/clunch/Desktop/NEON_par-quantum-line/stackedFiles/PARQL_30min.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "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>domainID</th>\n",
       "      <th>siteID</th>\n",
       "      <th>horizontalPosition</th>\n",
       "      <th>verticalPosition</th>\n",
       "      <th>startDateTime</th>\n",
       "      <th>endDateTime</th>\n",
       "      <th>linePARMean</th>\n",
       "      <th>linePARMinimum</th>\n",
       "      <th>linePARMaximum</th>\n",
       "      <th>linePARVariance</th>\n",
       "      <th>linePARNumPts</th>\n",
       "      <th>linePARSkewness</th>\n",
       "      <th>linePARKurtosis</th>\n",
       "      <th>linePARExpUncert</th>\n",
       "      <th>linePARStdErMean</th>\n",
       "      <th>finalQF</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>D04</td>\n",
       "      <td>GUAN</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-01-21T00:00:00Z</td>\n",
       "      <td>2017-01-21T00:30:00Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>D04</td>\n",
       "      <td>GUAN</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-01-21T00:30:00Z</td>\n",
       "      <td>2017-01-21T01:00:00Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>D04</td>\n",
       "      <td>GUAN</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-01-21T01:00:00Z</td>\n",
       "      <td>2017-01-21T01:30:00Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>D04</td>\n",
       "      <td>GUAN</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-01-21T01:30:00Z</td>\n",
       "      <td>2017-01-21T02:00:00Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>D04</td>\n",
       "      <td>GUAN</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-01-21T02:00:00Z</td>\n",
       "      <td>2017-01-21T02:30:00Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  domainID siteID  horizontalPosition  verticalPosition         startDateTime  \\\n",
       "0      D04   GUAN                   1                 0  2017-01-21T00:00:00Z   \n",
       "1      D04   GUAN                   1                 0  2017-01-21T00:30:00Z   \n",
       "2      D04   GUAN                   1                 0  2017-01-21T01:00:00Z   \n",
       "3      D04   GUAN                   1                 0  2017-01-21T01:30:00Z   \n",
       "4      D04   GUAN                   1                 0  2017-01-21T02:00:00Z   \n",
       "\n",
       "            endDateTime  linePARMean  linePARMinimum  linePARMaximum  \\\n",
       "0  2017-01-21T00:30:00Z          NaN             NaN             NaN   \n",
       "1  2017-01-21T01:00:00Z          NaN             NaN             NaN   \n",
       "2  2017-01-21T01:30:00Z          NaN             NaN             NaN   \n",
       "3  2017-01-21T02:00:00Z          NaN             NaN             NaN   \n",
       "4  2017-01-21T02:30:00Z          NaN             NaN             NaN   \n",
       "\n",
       "   linePARVariance  linePARNumPts  linePARSkewness  linePARKurtosis  \\\n",
       "0              NaN            NaN              NaN              NaN   \n",
       "1              NaN            NaN              NaN              NaN   \n",
       "2              NaN            NaN              NaN              NaN   \n",
       "3              NaN            NaN              NaN              NaN   \n",
       "4              NaN            NaN              NaN              NaN   \n",
       "\n",
       "   linePARExpUncert  linePARStdErMean  finalQF  \n",
       "0               NaN               NaN        1  \n",
       "1               NaN               NaN        1  \n",
       "2               NaN               NaN        1  \n",
       "3               NaN               NaN        1  \n",
       "4               NaN               NaN        1  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ql.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "ql.endDateTime = pandas.to_datetime(ql.endDateTime, format='%Y-%m-%dT%H:%M:%SZ')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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>domainID</th>\n",
       "      <th>siteID</th>\n",
       "      <th>horizontalPosition</th>\n",
       "      <th>verticalPosition</th>\n",
       "      <th>startDateTime</th>\n",
       "      <th>endDateTime</th>\n",
       "      <th>linePARMean</th>\n",
       "      <th>linePARMinimum</th>\n",
       "      <th>linePARMaximum</th>\n",
       "      <th>linePARVariance</th>\n",
       "      <th>linePARNumPts</th>\n",
       "      <th>linePARSkewness</th>\n",
       "      <th>linePARKurtosis</th>\n",
       "      <th>linePARExpUncert</th>\n",
       "      <th>linePARStdErMean</th>\n",
       "      <th>finalQF</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>D04</td>\n",
       "      <td>GUAN</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-01-21T00:00:00Z</td>\n",
       "      <td>2017-01-21 00:30:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>D04</td>\n",
       "      <td>GUAN</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-01-21T00:30:00Z</td>\n",
       "      <td>2017-01-21 01:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>D04</td>\n",
       "      <td>GUAN</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-01-21T01:00:00Z</td>\n",
       "      <td>2017-01-21 01:30:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>D04</td>\n",
       "      <td>GUAN</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-01-21T01:30:00Z</td>\n",
       "      <td>2017-01-21 02:00:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>D04</td>\n",
       "      <td>GUAN</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2017-01-21T02:00:00Z</td>\n",
       "      <td>2017-01-21 02:30:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  domainID siteID  horizontalPosition  verticalPosition         startDateTime  \\\n",
       "0      D04   GUAN                   1                 0  2017-01-21T00:00:00Z   \n",
       "1      D04   GUAN                   1                 0  2017-01-21T00:30:00Z   \n",
       "2      D04   GUAN                   1                 0  2017-01-21T01:00:00Z   \n",
       "3      D04   GUAN                   1                 0  2017-01-21T01:30:00Z   \n",
       "4      D04   GUAN                   1                 0  2017-01-21T02:00:00Z   \n",
       "\n",
       "          endDateTime  linePARMean  linePARMinimum  linePARMaximum  \\\n",
       "0 2017-01-21 00:30:00          NaN             NaN             NaN   \n",
       "1 2017-01-21 01:00:00          NaN             NaN             NaN   \n",
       "2 2017-01-21 01:30:00          NaN             NaN             NaN   \n",
       "3 2017-01-21 02:00:00          NaN             NaN             NaN   \n",
       "4 2017-01-21 02:30:00          NaN             NaN             NaN   \n",
       "\n",
       "   linePARVariance  linePARNumPts  linePARSkewness  linePARKurtosis  \\\n",
       "0              NaN            NaN              NaN              NaN   \n",
       "1              NaN            NaN              NaN              NaN   \n",
       "2              NaN            NaN              NaN              NaN   \n",
       "3              NaN            NaN              NaN              NaN   \n",
       "4              NaN            NaN              NaN              NaN   \n",
       "\n",
       "   linePARExpUncert  linePARStdErMean  finalQF  \n",
       "0               NaN               NaN        1  \n",
       "1               NaN               NaN        1  \n",
       "2               NaN               NaN        1  \n",
       "3               NaN               NaN        1  \n",
       "4               NaN               NaN        1  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ql.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python [conda env:py35]",
   "language": "python",
   "name": "conda-env-py35-py"
  },
  "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.5.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}