osc-accel-parse.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 147,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import sys"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Replace id with the OSC ID"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 184,
   "metadata": {},
   "outputs": [],
   "source": [
    "filesuffix = !curl -s \"http://openstreetcam.org/details\" --data \"id=1249727\" | jq .[] | grep meta | awk -F\\\" '{print $4}'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Download the sensor reading file associated with the OSC ID"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 185,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "--2018-07-29 20:49:46--  http://www.openstreetcam.org/storage8/files/photo/2018/6/15/1249727_5b2306ecd0e60.txt\n",
      "Resolving www.openstreetcam.org (www.openstreetcam.org)... 78.47.202.71\n",
      "Connecting to www.openstreetcam.org (www.openstreetcam.org)|78.47.202.71|:80... connected.\n",
      "HTTP request sent, awaiting response... 301 Moved Permanently\n",
      "Location: http://storage8.openstreetcam.org/files/photo/2018/6/15/1249727_5b2306ecd0e60.txt [following]\n",
      "--2018-07-29 20:49:47--  http://storage8.openstreetcam.org/files/photo/2018/6/15/1249727_5b2306ecd0e60.txt\n",
      "Resolving storage8.openstreetcam.org (storage8.openstreetcam.org)... 94.130.205.166\n",
      "Connecting to storage8.openstreetcam.org (storage8.openstreetcam.org)|94.130.205.166|:80... connected.\n",
      "HTTP request sent, awaiting response... 200 OK\n",
      "Length: 2616505 (2.5M) [text/plain]\n",
      "Saving to: ‘1249727_5b2306ecd0e60.txt’\n",
      "\n",
      "1249727_5b2306ecd0e 100%[===================>]   2.50M   637KB/s    in 4.0s    \n",
      "\n",
      "2018-07-29 20:49:51 (637 KB/s) - ‘1249727_5b2306ecd0e60.txt’ saved [2616505/2616505]\n",
      "\n"
     ]
    }
   ],
   "source": [
    "filesuffix = ''.join(filesuffix)\n",
    "filename='www.openstreetcam.org/'+ filesuffix\n",
    "!wget $filename"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The general shape of the OSC metadata_file file is as follows:\n",
    "```\n",
    "accel_reading1\n",
    "accel_reading2\n",
    "accel_reading3\n",
    "accel_reading4\n",
    "accel_reading5\n",
    "accel_reading6\n",
    "accel_reading7\n",
    "accel_reading8\n",
    "accel_reading9\n",
    "accel_reading10\n",
    "location_reading\n",
    "```\n",
    "The code below: \n",
    "- rolls up all the `accel_reading_*` values and calculates the `average(magnitude(accel_reading*_x,accel_reading*_y,accel_reading*_z))`\n",
    "- Assigns the \"bumpiness score\" to the location_reading.\n",
    "\n",
    "The resultant shape is:\n",
    "# `location_reading<>rolledUp_accelMagnitude`"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Replace `read_csv` with the file you just downloaded and `to_csv` to `OSC_id-result.csv`"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 186,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/vadibhatla/anaconda2/lib/python2.7/site-packages/ipykernel_launcher.py:18: RuntimeWarning: invalid value encountered in double_scalars\n",
      "/Users/vadibhatla/anaconda2/lib/python2.7/site-packages/ipykernel_launcher.py:32: RuntimeWarning: invalid value encountered in double_scalars\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "end\n"
     ]
    }
   ],
   "source": [
    "# Refer https://github.com/openstreetcam/openstreetview.org/issues/109 for file spec\n",
    "df = pd.read_csv(\"1249727_5b2306ecd0e60.txt\",header=None,skiprows=1,delimiter=\";\",names=[\"timestamp\",\"longitude\",\"latitude\",\"elevation\",\"horizontal_accuracy\",\"GPSspeed\",\"yaw\",\"pitch\",\"roll\",\"accelerationX\",\"accelerationY\",\"accelerationZ\",\"pressure\",\"compass\",\"videoIndex\",\"tripFrameIndex\",\"gravityX\",\"gravityY\",\"gravityZ\",\"OBD2speed\",\"vertical_accuracy\"])\n",
    "df['bump']=0\n",
    "locs =  df.loc[df['longitude'].notnull()].index\n",
    "bump=[]\n",
    "\n",
    "for idx,i in enumerate(locs):\n",
    "    bump_t=[]\n",
    "    try:\n",
    "        if idx == 0:\n",
    "            next_val = locs[0]\n",
    "            for idx2 in xrange(0,i):\n",
    "                a_x = df['accelerationX'][idx2]\n",
    "                a_y = df['accelerationY'][idx2]\n",
    "                a_z = df['accelerationZ'][idx2]\n",
    "                bump_val = np.sqrt(a_x**2 + a_y**2 + a_z**2)\n",
    "                bump_t.append(bump_val)\n",
    "            bump_avg = np.nansum(bump_t) / float(np.count_nonzero(~np.isnan(bump_t)))\n",
    "            #print \"Assining \",bump_avg,\" to row\",i\n",
    "            df.loc[i,'bump'] = bump_avg\n",
    "        else:\n",
    "            next_val = locs[idx + 1]\n",
    "    except IndexError:\n",
    "        print \"end\"\n",
    "        break\n",
    "    for idx2 in xrange(i,next_val):\n",
    "        a_x = df['accelerationX'][idx2]\n",
    "        a_y = df['accelerationY'][idx2]\n",
    "        a_z = df['accelerationZ'][idx2]\n",
    "        bump_val = np.sqrt(a_x**2 + a_y**2 + a_z**2)\n",
    "        bump_t.append(bump_val)\n",
    "    bump_avg = np.nansum(bump_t) / float(np.count_nonzero(~np.isnan(bump_t)))\n",
    "    #print \"Assining \",bump_avg,\" to row\",i\n",
    "    df.loc[i,'bump'] = bump_avg\n",
    "    #print \"Avg of all the accels for \",idx, bump_avg\n",
    "df.iloc[locs].to_csv('1249727-parsed.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## The last column contains the Bumpiness Score and Location Readings"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 188,
   "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>timestamp</th>\n",
       "      <th>longitude</th>\n",
       "      <th>latitude</th>\n",
       "      <th>elevation</th>\n",
       "      <th>horizontal_accuracy</th>\n",
       "      <th>GPSspeed</th>\n",
       "      <th>yaw</th>\n",
       "      <th>pitch</th>\n",
       "      <th>roll</th>\n",
       "      <th>accelerationX</th>\n",
       "      <th>...</th>\n",
       "      <th>pressure</th>\n",
       "      <th>compass</th>\n",
       "      <th>videoIndex</th>\n",
       "      <th>tripFrameIndex</th>\n",
       "      <th>gravityX</th>\n",
       "      <th>gravityY</th>\n",
       "      <th>gravityZ</th>\n",
       "      <th>OBD2speed</th>\n",
       "      <th>vertical_accuracy</th>\n",
       "      <th>bump</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156575</td>\n",
       "      <td>39.987288</td>\n",
       "      <td>1715.1</td>\n",
       "      <td>18.1</td>\n",
       "      <td>12.119488</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156575</td>\n",
       "      <td>39.987288</td>\n",
       "      <td>1715.1</td>\n",
       "      <td>18.1</td>\n",
       "      <td>12.119488</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31.0</td>\n",
       "      <td>0.088868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156582</td>\n",
       "      <td>39.987244</td>\n",
       "      <td>1713.4</td>\n",
       "      <td>18.1</td>\n",
       "      <td>17.645857</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>186.0</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>31.0</td>\n",
       "      <td>0.111884</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156586</td>\n",
       "      <td>39.987200</td>\n",
       "      <td>1712.5</td>\n",
       "      <td>18.1</td>\n",
       "      <td>18.577412</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>183.0</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>31.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156586</td>\n",
       "      <td>39.987200</td>\n",
       "      <td>1712.5</td>\n",
       "      <td>18.1</td>\n",
       "      <td>18.577412</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>183.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31.0</td>\n",
       "      <td>0.125381</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156576</td>\n",
       "      <td>39.987144</td>\n",
       "      <td>1712.4</td>\n",
       "      <td>18.1</td>\n",
       "      <td>15.277148</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>172.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156576</td>\n",
       "      <td>39.987144</td>\n",
       "      <td>1712.4</td>\n",
       "      <td>18.1</td>\n",
       "      <td>15.277148</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>172.0</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>31.0</td>\n",
       "      <td>0.170510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156567</td>\n",
       "      <td>39.987115</td>\n",
       "      <td>1713.6</td>\n",
       "      <td>18.1</td>\n",
       "      <td>9.782264</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>165.0</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>30.9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156567</td>\n",
       "      <td>39.987115</td>\n",
       "      <td>1713.6</td>\n",
       "      <td>18.1</td>\n",
       "      <td>9.782264</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>165.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.9</td>\n",
       "      <td>0.154728</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156570</td>\n",
       "      <td>39.987102</td>\n",
       "      <td>1713.8</td>\n",
       "      <td>18.0</td>\n",
       "      <td>5.320796</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>190.0</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>30.9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156570</td>\n",
       "      <td>39.987102</td>\n",
       "      <td>1713.8</td>\n",
       "      <td>18.0</td>\n",
       "      <td>5.320796</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>190.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.9</td>\n",
       "      <td>0.119362</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156571</td>\n",
       "      <td>39.987095</td>\n",
       "      <td>1713.9</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1.896448</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>185.0</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>30.9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156571</td>\n",
       "      <td>39.987095</td>\n",
       "      <td>1713.9</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1.896448</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>185.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.9</td>\n",
       "      <td>0.052704</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156567</td>\n",
       "      <td>39.987087</td>\n",
       "      <td>1714.1</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.172236</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>158.0</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>30.9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156567</td>\n",
       "      <td>39.987087</td>\n",
       "      <td>1714.1</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.172236</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>158.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.9</td>\n",
       "      <td>0.019757</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156562</td>\n",
       "      <td>39.987082</td>\n",
       "      <td>1713.9</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.312988</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>141.0</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>30.9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156562</td>\n",
       "      <td>39.987082</td>\n",
       "      <td>1713.9</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.312988</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>141.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.9</td>\n",
       "      <td>0.024927</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156559</td>\n",
       "      <td>39.987082</td>\n",
       "      <td>1714.2</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.174088</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>112.0</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>30.9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156559</td>\n",
       "      <td>39.987082</td>\n",
       "      <td>1714.2</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.174088</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>112.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.9</td>\n",
       "      <td>0.015833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156556</td>\n",
       "      <td>39.987082</td>\n",
       "      <td>1714.6</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.024076</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.9</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156556</td>\n",
       "      <td>39.987082</td>\n",
       "      <td>1714.6</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.024076</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86.0</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>30.9</td>\n",
       "      <td>0.013859</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156554</td>\n",
       "      <td>39.987081</td>\n",
       "      <td>1715.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.225944</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>101.0</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>30.8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156554</td>\n",
       "      <td>39.987081</td>\n",
       "      <td>1715.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.225944</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>101.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.8</td>\n",
       "      <td>0.027831</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156554</td>\n",
       "      <td>39.987079</td>\n",
       "      <td>1715.2</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1.459376</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>180.0</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>30.8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156554</td>\n",
       "      <td>39.987079</td>\n",
       "      <td>1715.2</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1.459376</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>180.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.8</td>\n",
       "      <td>0.019296</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156556</td>\n",
       "      <td>39.987075</td>\n",
       "      <td>1715.5</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1.337144</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>208.0</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>30.8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156556</td>\n",
       "      <td>39.987075</td>\n",
       "      <td>1715.5</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1.337144</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>208.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.8</td>\n",
       "      <td>0.030509</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156557</td>\n",
       "      <td>39.987073</td>\n",
       "      <td>1715.6</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.968596</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>190.0</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>30.8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156557</td>\n",
       "      <td>39.987073</td>\n",
       "      <td>1715.6</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.968596</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>190.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>30.8</td>\n",
       "      <td>0.016870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.156557</td>\n",
       "      <td>39.987071</td>\n",
       "      <td>1715.7</td>\n",
       "      <td>18.0</td>\n",
       "      <td>1.020452</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>188.0</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>30.8</td>\n",
       "      <td>NaN</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>398</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157189</td>\n",
       "      <td>39.986852</td>\n",
       "      <td>1715.2</td>\n",
       "      <td>13.9</td>\n",
       "      <td>12.495444</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>142.0</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>21.8</td>\n",
       "      <td>0.277413</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>400</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157186</td>\n",
       "      <td>39.986848</td>\n",
       "      <td>1714.1</td>\n",
       "      <td>13.9</td>\n",
       "      <td>13.349216</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>153.0</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>21.8</td>\n",
       "      <td>0.303021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>402</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157182</td>\n",
       "      <td>39.986845</td>\n",
       "      <td>1714.5</td>\n",
       "      <td>13.9</td>\n",
       "      <td>13.808512</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>129.0</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>21.8</td>\n",
       "      <td>0.275648</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>404</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157179</td>\n",
       "      <td>39.986843</td>\n",
       "      <td>1714.5</td>\n",
       "      <td>13.9</td>\n",
       "      <td>13.493672</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>134.0</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>21.8</td>\n",
       "      <td>0.243315</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>406</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157177</td>\n",
       "      <td>39.986840</td>\n",
       "      <td>1715.0</td>\n",
       "      <td>13.9</td>\n",
       "      <td>14.214100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>144.0</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>21.8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>407</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157177</td>\n",
       "      <td>39.986840</td>\n",
       "      <td>1715.0</td>\n",
       "      <td>13.9</td>\n",
       "      <td>14.214100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>144.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21.8</td>\n",
       "      <td>0.243099</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>409</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157174</td>\n",
       "      <td>39.986838</td>\n",
       "      <td>1715.1</td>\n",
       "      <td>13.9</td>\n",
       "      <td>13.078824</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>138.0</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>21.8</td>\n",
       "      <td>0.233532</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>411</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157173</td>\n",
       "      <td>39.986835</td>\n",
       "      <td>1715.0</td>\n",
       "      <td>13.9</td>\n",
       "      <td>13.328844</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>167.0</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>21.8</td>\n",
       "      <td>0.265611</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>413</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157169</td>\n",
       "      <td>39.986833</td>\n",
       "      <td>1714.8</td>\n",
       "      <td>13.9</td>\n",
       "      <td>13.919632</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>119.0</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>21.8</td>\n",
       "      <td>0.276449</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>415</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157165</td>\n",
       "      <td>39.986832</td>\n",
       "      <td>1715.3</td>\n",
       "      <td>13.9</td>\n",
       "      <td>14.443748</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>110.0</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>21.8</td>\n",
       "      <td>0.244463</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>417</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157161</td>\n",
       "      <td>39.986831</td>\n",
       "      <td>1715.4</td>\n",
       "      <td>13.9</td>\n",
       "      <td>14.375224</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>103.0</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>21.8</td>\n",
       "      <td>0.166283</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157157</td>\n",
       "      <td>39.986831</td>\n",
       "      <td>1715.4</td>\n",
       "      <td>13.9</td>\n",
       "      <td>13.552936</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>99.0</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>21.8</td>\n",
       "      <td>0.173934</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157152</td>\n",
       "      <td>39.986830</td>\n",
       "      <td>1715.5</td>\n",
       "      <td>13.9</td>\n",
       "      <td>13.841848</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>95.0</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>21.8</td>\n",
       "      <td>0.127585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>423</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157147</td>\n",
       "      <td>39.986830</td>\n",
       "      <td>1715.6</td>\n",
       "      <td>13.9</td>\n",
       "      <td>14.165948</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>90.0</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>21.8</td>\n",
       "      <td>0.147248</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>425</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157141</td>\n",
       "      <td>39.986830</td>\n",
       "      <td>1715.8</td>\n",
       "      <td>13.9</td>\n",
       "      <td>14.710436</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>87.0</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>21.8</td>\n",
       "      <td>0.166880</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>427</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157135</td>\n",
       "      <td>39.986831</td>\n",
       "      <td>1716.2</td>\n",
       "      <td>13.9</td>\n",
       "      <td>15.429012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>84.0</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>21.8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>428</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157135</td>\n",
       "      <td>39.986831</td>\n",
       "      <td>1716.2</td>\n",
       "      <td>13.9</td>\n",
       "      <td>15.429012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>84.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21.8</td>\n",
       "      <td>0.133195</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>430</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157128</td>\n",
       "      <td>39.986831</td>\n",
       "      <td>1716.5</td>\n",
       "      <td>13.9</td>\n",
       "      <td>15.429012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>85.0</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>21.8</td>\n",
       "      <td>0.085680</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>432</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157122</td>\n",
       "      <td>39.986832</td>\n",
       "      <td>1716.8</td>\n",
       "      <td>13.9</td>\n",
       "      <td>16.255005</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86.0</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>21.8</td>\n",
       "      <td>0.072952</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>434</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157116</td>\n",
       "      <td>39.986832</td>\n",
       "      <td>1716.9</td>\n",
       "      <td>13.9</td>\n",
       "      <td>16.912464</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>90.0</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>21.8</td>\n",
       "      <td>0.073600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>436</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157111</td>\n",
       "      <td>39.986832</td>\n",
       "      <td>1717.0</td>\n",
       "      <td>13.9</td>\n",
       "      <td>16.710596</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>90.0</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>21.8</td>\n",
       "      <td>0.058864</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>438</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157105</td>\n",
       "      <td>39.986832</td>\n",
       "      <td>1717.2</td>\n",
       "      <td>13.9</td>\n",
       "      <td>17.038401</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>84.0</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>21.8</td>\n",
       "      <td>0.092553</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>442</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157098</td>\n",
       "      <td>39.986832</td>\n",
       "      <td>1717.3</td>\n",
       "      <td>13.9</td>\n",
       "      <td>17.855131</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86.0</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>21.8</td>\n",
       "      <td>0.164864</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>445</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157091</td>\n",
       "      <td>39.986833</td>\n",
       "      <td>1717.4</td>\n",
       "      <td>13.9</td>\n",
       "      <td>19.107084</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>81.0</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>21.8</td>\n",
       "      <td>0.141993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>449</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157084</td>\n",
       "      <td>39.986833</td>\n",
       "      <td>1717.4</td>\n",
       "      <td>13.9</td>\n",
       "      <td>19.433037</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>90.0</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>21.8</td>\n",
       "      <td>0.063435</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>453</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157078</td>\n",
       "      <td>39.986833</td>\n",
       "      <td>1717.5</td>\n",
       "      <td>13.9</td>\n",
       "      <td>20.134945</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>91.0</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>21.8</td>\n",
       "      <td>0.098295</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>456</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157071</td>\n",
       "      <td>39.986833</td>\n",
       "      <td>1717.4</td>\n",
       "      <td>13.9</td>\n",
       "      <td>20.338663</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>87.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21.8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>457</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157071</td>\n",
       "      <td>39.986833</td>\n",
       "      <td>1717.4</td>\n",
       "      <td>13.9</td>\n",
       "      <td>20.338663</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>87.0</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>21.8</td>\n",
       "      <td>0.067860</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>461</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157064</td>\n",
       "      <td>39.986833</td>\n",
       "      <td>1717.4</td>\n",
       "      <td>13.9</td>\n",
       "      <td>20.962788</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>90.0</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>21.8</td>\n",
       "      <td>0.096338</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>465</th>\n",
       "      <td>1.529019e+09</td>\n",
       "      <td>-105.157057</td>\n",
       "      <td>39.986834</td>\n",
       "      <td>1717.4</td>\n",
       "      <td>13.9</td>\n",
       "      <td>21.409121</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>86.0</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>21.8</td>\n",
       "      <td>0.092531</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        timestamp   longitude   latitude  elevation  horizontal_accuracy  \\\n",
       "0    1.529019e+09 -105.156575  39.987288     1715.1                 18.1   \n",
       "1    1.529019e+09 -105.156575  39.987288     1715.1                 18.1   \n",
       "6    1.529019e+09 -105.156582  39.987244     1713.4                 18.1   \n",
       "17   1.529019e+09 -105.156586  39.987200     1712.5                 18.1   \n",
       "18   1.529019e+09 -105.156586  39.987200     1712.5                 18.1   \n",
       "29   1.529019e+09 -105.156576  39.987144     1712.4                 18.1   \n",
       "30   1.529019e+09 -105.156576  39.987144     1712.4                 18.1   \n",
       "41   1.529019e+09 -105.156567  39.987115     1713.6                 18.1   \n",
       "42   1.529019e+09 -105.156567  39.987115     1713.6                 18.1   \n",
       "53   1.529019e+09 -105.156570  39.987102     1713.8                 18.0   \n",
       "54   1.529019e+09 -105.156570  39.987102     1713.8                 18.0   \n",
       "65   1.529019e+09 -105.156571  39.987095     1713.9                 18.0   \n",
       "66   1.529019e+09 -105.156571  39.987095     1713.9                 18.0   \n",
       "77   1.529019e+09 -105.156567  39.987087     1714.1                 18.0   \n",
       "78   1.529019e+09 -105.156567  39.987087     1714.1                 18.0   \n",
       "89   1.529019e+09 -105.156562  39.987082     1713.9                 18.0   \n",
       "90   1.529019e+09 -105.156562  39.987082     1713.9                 18.0   \n",
       "101  1.529019e+09 -105.156559  39.987082     1714.2                 18.0   \n",
       "102  1.529019e+09 -105.156559  39.987082     1714.2                 18.0   \n",
       "113  1.529019e+09 -105.156556  39.987082     1714.6                 18.0   \n",
       "114  1.529019e+09 -105.156556  39.987082     1714.6                 18.0   \n",
       "125  1.529019e+09 -105.156554  39.987081     1715.0                 18.0   \n",
       "126  1.529019e+09 -105.156554  39.987081     1715.0                 18.0   \n",
       "137  1.529019e+09 -105.156554  39.987079     1715.2                 18.0   \n",
       "138  1.529019e+09 -105.156554  39.987079     1715.2                 18.0   \n",
       "149  1.529019e+09 -105.156556  39.987075     1715.5                 18.0   \n",
       "150  1.529019e+09 -105.156556  39.987075     1715.5                 18.0   \n",
       "161  1.529019e+09 -105.156557  39.987073     1715.6                 18.0   \n",
       "162  1.529019e+09 -105.156557  39.987073     1715.6                 18.0   \n",
       "173  1.529019e+09 -105.156557  39.987071     1715.7                 18.0   \n",
       "..            ...         ...        ...        ...                  ...   \n",
       "398  1.529019e+09 -105.157189  39.986852     1715.2                 13.9   \n",
       "400  1.529019e+09 -105.157186  39.986848     1714.1                 13.9   \n",
       "402  1.529019e+09 -105.157182  39.986845     1714.5                 13.9   \n",
       "404  1.529019e+09 -105.157179  39.986843     1714.5                 13.9   \n",
       "406  1.529019e+09 -105.157177  39.986840     1715.0                 13.9   \n",
       "407  1.529019e+09 -105.157177  39.986840     1715.0                 13.9   \n",
       "409  1.529019e+09 -105.157174  39.986838     1715.1                 13.9   \n",
       "411  1.529019e+09 -105.157173  39.986835     1715.0                 13.9   \n",
       "413  1.529019e+09 -105.157169  39.986833     1714.8                 13.9   \n",
       "415  1.529019e+09 -105.157165  39.986832     1715.3                 13.9   \n",
       "417  1.529019e+09 -105.157161  39.986831     1715.4                 13.9   \n",
       "419  1.529019e+09 -105.157157  39.986831     1715.4                 13.9   \n",
       "421  1.529019e+09 -105.157152  39.986830     1715.5                 13.9   \n",
       "423  1.529019e+09 -105.157147  39.986830     1715.6                 13.9   \n",
       "425  1.529019e+09 -105.157141  39.986830     1715.8                 13.9   \n",
       "427  1.529019e+09 -105.157135  39.986831     1716.2                 13.9   \n",
       "428  1.529019e+09 -105.157135  39.986831     1716.2                 13.9   \n",
       "430  1.529019e+09 -105.157128  39.986831     1716.5                 13.9   \n",
       "432  1.529019e+09 -105.157122  39.986832     1716.8                 13.9   \n",
       "434  1.529019e+09 -105.157116  39.986832     1716.9                 13.9   \n",
       "436  1.529019e+09 -105.157111  39.986832     1717.0                 13.9   \n",
       "438  1.529019e+09 -105.157105  39.986832     1717.2                 13.9   \n",
       "442  1.529019e+09 -105.157098  39.986832     1717.3                 13.9   \n",
       "445  1.529019e+09 -105.157091  39.986833     1717.4                 13.9   \n",
       "449  1.529019e+09 -105.157084  39.986833     1717.4                 13.9   \n",
       "453  1.529019e+09 -105.157078  39.986833     1717.5                 13.9   \n",
       "456  1.529019e+09 -105.157071  39.986833     1717.4                 13.9   \n",
       "457  1.529019e+09 -105.157071  39.986833     1717.4                 13.9   \n",
       "461  1.529019e+09 -105.157064  39.986833     1717.4                 13.9   \n",
       "465  1.529019e+09 -105.157057  39.986834     1717.4                 13.9   \n",
       "\n",
       "      GPSspeed  yaw  pitch  roll  accelerationX    ...     pressure  compass  \\\n",
       "0    12.119488  NaN    NaN   NaN            NaN    ...          NaN      NaN   \n",
       "1    12.119488  NaN    NaN   NaN            NaN    ...          NaN      NaN   \n",
       "6    17.645857  NaN    NaN   NaN            NaN    ...          NaN    186.0   \n",
       "17   18.577412  NaN    NaN   NaN            NaN    ...          NaN    183.0   \n",
       "18   18.577412  NaN    NaN   NaN            NaN    ...          NaN    183.0   \n",
       "29   15.277148  NaN    NaN   NaN            NaN    ...          NaN    172.0   \n",
       "30   15.277148  NaN    NaN   NaN            NaN    ...          NaN    172.0   \n",
       "41    9.782264  NaN    NaN   NaN            NaN    ...          NaN    165.0   \n",
       "42    9.782264  NaN    NaN   NaN            NaN    ...          NaN    165.0   \n",
       "53    5.320796  NaN    NaN   NaN            NaN    ...          NaN    190.0   \n",
       "54    5.320796  NaN    NaN   NaN            NaN    ...          NaN    190.0   \n",
       "65    1.896448  NaN    NaN   NaN            NaN    ...          NaN    185.0   \n",
       "66    1.896448  NaN    NaN   NaN            NaN    ...          NaN    185.0   \n",
       "77    0.172236  NaN    NaN   NaN            NaN    ...          NaN    158.0   \n",
       "78    0.172236  NaN    NaN   NaN            NaN    ...          NaN    158.0   \n",
       "89    0.312988  NaN    NaN   NaN            NaN    ...          NaN    141.0   \n",
       "90    0.312988  NaN    NaN   NaN            NaN    ...          NaN    141.0   \n",
       "101   0.174088  NaN    NaN   NaN            NaN    ...          NaN    112.0   \n",
       "102   0.174088  NaN    NaN   NaN            NaN    ...          NaN    112.0   \n",
       "113   0.024076  NaN    NaN   NaN            NaN    ...          NaN     86.0   \n",
       "114   0.024076  NaN    NaN   NaN            NaN    ...          NaN     86.0   \n",
       "125   0.225944  NaN    NaN   NaN            NaN    ...          NaN    101.0   \n",
       "126   0.225944  NaN    NaN   NaN            NaN    ...          NaN    101.0   \n",
       "137   1.459376  NaN    NaN   NaN            NaN    ...          NaN    180.0   \n",
       "138   1.459376  NaN    NaN   NaN            NaN    ...          NaN    180.0   \n",
       "149   1.337144  NaN    NaN   NaN            NaN    ...          NaN    208.0   \n",
       "150   1.337144  NaN    NaN   NaN            NaN    ...          NaN    208.0   \n",
       "161   0.968596  NaN    NaN   NaN            NaN    ...          NaN    190.0   \n",
       "162   0.968596  NaN    NaN   NaN            NaN    ...          NaN    190.0   \n",
       "173   1.020452  NaN    NaN   NaN            NaN    ...          NaN    188.0   \n",
       "..         ...  ...    ...   ...            ...    ...          ...      ...   \n",
       "398  12.495444  NaN    NaN   NaN            NaN    ...          NaN    142.0   \n",
       "400  13.349216  NaN    NaN   NaN            NaN    ...          NaN    153.0   \n",
       "402  13.808512  NaN    NaN   NaN            NaN    ...          NaN    129.0   \n",
       "404  13.493672  NaN    NaN   NaN            NaN    ...          NaN    134.0   \n",
       "406  14.214100  NaN    NaN   NaN            NaN    ...          NaN    144.0   \n",
       "407  14.214100  NaN    NaN   NaN            NaN    ...          NaN    144.0   \n",
       "409  13.078824  NaN    NaN   NaN            NaN    ...          NaN    138.0   \n",
       "411  13.328844  NaN    NaN   NaN            NaN    ...          NaN    167.0   \n",
       "413  13.919632  NaN    NaN   NaN            NaN    ...          NaN    119.0   \n",
       "415  14.443748  NaN    NaN   NaN            NaN    ...          NaN    110.0   \n",
       "417  14.375224  NaN    NaN   NaN            NaN    ...          NaN    103.0   \n",
       "419  13.552936  NaN    NaN   NaN            NaN    ...          NaN     99.0   \n",
       "421  13.841848  NaN    NaN   NaN            NaN    ...          NaN     95.0   \n",
       "423  14.165948  NaN    NaN   NaN            NaN    ...          NaN     90.0   \n",
       "425  14.710436  NaN    NaN   NaN            NaN    ...          NaN     87.0   \n",
       "427  15.429012  NaN    NaN   NaN            NaN    ...          NaN     84.0   \n",
       "428  15.429012  NaN    NaN   NaN            NaN    ...          NaN     84.0   \n",
       "430  15.429012  NaN    NaN   NaN            NaN    ...          NaN     85.0   \n",
       "432  16.255005  NaN    NaN   NaN            NaN    ...          NaN     86.0   \n",
       "434  16.912464  NaN    NaN   NaN            NaN    ...          NaN     90.0   \n",
       "436  16.710596  NaN    NaN   NaN            NaN    ...          NaN     90.0   \n",
       "438  17.038401  NaN    NaN   NaN            NaN    ...          NaN     84.0   \n",
       "442  17.855131  NaN    NaN   NaN            NaN    ...          NaN     86.0   \n",
       "445  19.107084  NaN    NaN   NaN            NaN    ...          NaN     81.0   \n",
       "449  19.433037  NaN    NaN   NaN            NaN    ...          NaN     90.0   \n",
       "453  20.134945  NaN    NaN   NaN            NaN    ...          NaN     91.0   \n",
       "456  20.338663  NaN    NaN   NaN            NaN    ...          NaN     87.0   \n",
       "457  20.338663  NaN    NaN   NaN            NaN    ...          NaN     87.0   \n",
       "461  20.962788  NaN    NaN   NaN            NaN    ...          NaN     90.0   \n",
       "465  21.409121  NaN    NaN   NaN            NaN    ...          NaN     86.0   \n",
       "\n",
       "     videoIndex  tripFrameIndex  gravityX  gravityY  gravityZ  OBD2speed  \\\n",
       "0           0.0             0.0       NaN       NaN       NaN        NaN   \n",
       "1           NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "6           NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "17          NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "18          1.0             1.0       NaN       NaN       NaN        NaN   \n",
       "29          2.0             2.0       NaN       NaN       NaN        NaN   \n",
       "30          NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "41          NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "42          3.0             3.0       NaN       NaN       NaN        NaN   \n",
       "53          NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "54          4.0             4.0       NaN       NaN       NaN        NaN   \n",
       "65          NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "66          5.0             5.0       NaN       NaN       NaN        NaN   \n",
       "77          NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "78          6.0             6.0       NaN       NaN       NaN        NaN   \n",
       "89          NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "90          7.0             7.0       NaN       NaN       NaN        NaN   \n",
       "101         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "102         8.0             8.0       NaN       NaN       NaN        NaN   \n",
       "113         9.0             9.0       NaN       NaN       NaN        NaN   \n",
       "114         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "125         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "126        10.0            10.0       NaN       NaN       NaN        NaN   \n",
       "137         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "138        11.0            11.0       NaN       NaN       NaN        NaN   \n",
       "149         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "150        12.0            12.0       NaN       NaN       NaN        NaN   \n",
       "161         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "162        13.0            13.0       NaN       NaN       NaN        NaN   \n",
       "173         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "..          ...             ...       ...       ...       ...        ...   \n",
       "398         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "400         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "402         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "404         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "406         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "407        33.0            33.0       NaN       NaN       NaN        NaN   \n",
       "409         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "411         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "413         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "415         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "417         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "419         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "421         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "423         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "425         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "427         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "428        34.0            34.0       NaN       NaN       NaN        NaN   \n",
       "430         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "432         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "434         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "436         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "438         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "442         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "445         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "449         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "453         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "456        35.0            35.0       NaN       NaN       NaN        NaN   \n",
       "457         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "461         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "465         NaN             NaN       NaN       NaN       NaN        NaN   \n",
       "\n",
       "     vertical_accuracy      bump  \n",
       "0                 31.0       NaN  \n",
       "1                 31.0  0.088868  \n",
       "6                 31.0  0.111884  \n",
       "17                31.0       NaN  \n",
       "18                31.0  0.125381  \n",
       "29                31.0       NaN  \n",
       "30                31.0  0.170510  \n",
       "41                30.9       NaN  \n",
       "42                30.9  0.154728  \n",
       "53                30.9       NaN  \n",
       "54                30.9  0.119362  \n",
       "65                30.9       NaN  \n",
       "66                30.9  0.052704  \n",
       "77                30.9       NaN  \n",
       "78                30.9  0.019757  \n",
       "89                30.9       NaN  \n",
       "90                30.9  0.024927  \n",
       "101               30.9       NaN  \n",
       "102               30.9  0.015833  \n",
       "113               30.9       NaN  \n",
       "114               30.9  0.013859  \n",
       "125               30.8       NaN  \n",
       "126               30.8  0.027831  \n",
       "137               30.8       NaN  \n",
       "138               30.8  0.019296  \n",
       "149               30.8       NaN  \n",
       "150               30.8  0.030509  \n",
       "161               30.8       NaN  \n",
       "162               30.8  0.016870  \n",
       "173               30.8       NaN  \n",
       "..                 ...       ...  \n",
       "398               21.8  0.277413  \n",
       "400               21.8  0.303021  \n",
       "402               21.8  0.275648  \n",
       "404               21.8  0.243315  \n",
       "406               21.8       NaN  \n",
       "407               21.8  0.243099  \n",
       "409               21.8  0.233532  \n",
       "411               21.8  0.265611  \n",
       "413               21.8  0.276449  \n",
       "415               21.8  0.244463  \n",
       "417               21.8  0.166283  \n",
       "419               21.8  0.173934  \n",
       "421               21.8  0.127585  \n",
       "423               21.8  0.147248  \n",
       "425               21.8  0.166880  \n",
       "427               21.8       NaN  \n",
       "428               21.8  0.133195  \n",
       "430               21.8  0.085680  \n",
       "432               21.8  0.072952  \n",
       "434               21.8  0.073600  \n",
       "436               21.8  0.058864  \n",
       "438               21.8  0.092553  \n",
       "442               21.8  0.164864  \n",
       "445               21.8  0.141993  \n",
       "449               21.8  0.063435  \n",
       "453               21.8  0.098295  \n",
       "456               21.8       NaN  \n",
       "457               21.8  0.067860  \n",
       "461               21.8  0.096338  \n",
       "465               21.8  0.092531  \n",
       "\n",
       "[100 rows x 22 columns]"
      ]
     },
     "execution_count": 188,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[locs].head(100)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.14"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}