test-new-api.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import json\n",
    "from urllib import request\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "ORIGINAL_URL = \"https://www.sistemas.dftrans.df.gov.br/service/gps/operacoes\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requesting on https://www.sistemas.dftrans.df.gov.br/service/gps/operacoes\n"
     ]
    }
   ],
   "source": [
    "req = request.Request(ORIGINAL_URL, method='GET')\n",
    "print('Requesting on %s' % ORIGINAL_URL)\n",
    "\n",
    "response = request.urlopen(req)\n",
    "body = response.read().decode('utf-8')\n",
    "body = json.loads(body)\n",
    "\n",
    "#df = pd.DataFrame.from_records(body['Dados'], columns=body['Campos'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.DataFrame()\n",
    "for operadora in body:\n",
    "    df_temp = pd.DataFrame.from_records(operadora['veiculos'])\n",
    "    df = pd.concat([df,df_temp], ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(2640, 9)\n"
     ]
    },
    {
     "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>codigoImei</th>\n",
       "      <th>direcao</th>\n",
       "      <th>horario</th>\n",
       "      <th>linha</th>\n",
       "      <th>localizacao</th>\n",
       "      <th>numero</th>\n",
       "      <th>sentido</th>\n",
       "      <th>valid</th>\n",
       "      <th>velocidade</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7316166</td>\n",
       "      <td>244.0</td>\n",
       "      <td>1597824667000</td>\n",
       "      <td></td>\n",
       "      <td>{'latitude': -15.92161, 'longitude': -48.10853}</td>\n",
       "      <td>335029</td>\n",
       "      <td>VOLTA</td>\n",
       "      <td>True</td>\n",
       "      <td>{'unidade': 'KM_POR_HORA', 'valor': 0}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>7516188</td>\n",
       "      <td>64.0</td>\n",
       "      <td>1600491046000</td>\n",
       "      <td></td>\n",
       "      <td>{'latitude': -15.89958, 'longitude': -48.12305}</td>\n",
       "      <td>333581</td>\n",
       "      <td>VOLTA</td>\n",
       "      <td>True</td>\n",
       "      <td>{'unidade': 'KM_POR_HORA', 'valor': 0}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>7119230</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1600969642000</td>\n",
       "      <td></td>\n",
       "      <td>{'latitude': -15.92148, 'longitude': -48.10834}</td>\n",
       "      <td>332780</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>{'unidade': 'KM_POR_HORA', 'valor': 0}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>7477164</td>\n",
       "      <td>253.0</td>\n",
       "      <td>1601678032000</td>\n",
       "      <td></td>\n",
       "      <td>{'latitude': -15.89945, 'longitude': -48.12276}</td>\n",
       "      <td>334146</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>{'unidade': 'KM_POR_HORA', 'valor': 0}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>7238112</td>\n",
       "      <td>158.0</td>\n",
       "      <td>1602410128000</td>\n",
       "      <td>807.1</td>\n",
       "      <td>{'latitude': -15.91111, 'longitude': -48.05508}</td>\n",
       "      <td>334561</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>{'unidade': 'KM_POR_HORA', 'valor': 0}</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  codigoImei  direcao        horario  linha  \\\n",
       "0    7316166    244.0  1597824667000          \n",
       "1    7516188     64.0  1600491046000          \n",
       "2    7119230      5.0  1600969642000          \n",
       "3    7477164    253.0  1601678032000          \n",
       "4    7238112    158.0  1602410128000  807.1   \n",
       "\n",
       "                                       localizacao  numero sentido  valid  \\\n",
       "0  {'latitude': -15.92161, 'longitude': -48.10853}  335029   VOLTA   True   \n",
       "1  {'latitude': -15.89958, 'longitude': -48.12305}  333581   VOLTA   True   \n",
       "2  {'latitude': -15.92148, 'longitude': -48.10834}  332780     IDA   True   \n",
       "3  {'latitude': -15.89945, 'longitude': -48.12276}  334146     IDA   True   \n",
       "4  {'latitude': -15.91111, 'longitude': -48.05508}  334561     IDA   True   \n",
       "\n",
       "                               velocidade  \n",
       "0  {'unidade': 'KM_POR_HORA', 'valor': 0}  \n",
       "1  {'unidade': 'KM_POR_HORA', 'valor': 0}  \n",
       "2  {'unidade': 'KM_POR_HORA', 'valor': 0}  \n",
       "3  {'unidade': 'KM_POR_HORA', 'valor': 0}  \n",
       "4  {'unidade': 'KM_POR_HORA', 'valor': 0}  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print(df.shape)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "def process_data(df):\n",
    "    #df = df.apply(convert_lat_long, axis=1)\n",
    "    df_lat_long = df.localizacao.apply(pd.Series)\n",
    "    df = df.merge(df_lat_long, on=df.index)\n",
    "    \n",
    "    # limpa campos com string vazia -> \"\"\n",
    "    df['GPS_Latitude'] = df['latitude']\n",
    "    df['GPS_Longitude'] = df['longitude']\n",
    "\n",
    "    df['GPS_Latitude'].replace('', np.nan, inplace=True)\n",
    "    df['GPS_Longitude'].replace('', np.nan, inplace=True)\n",
    "    df = df.dropna(subset=['GPS_Latitude', 'GPS_Longitude'])\n",
    "\n",
    "    df.GPS_Latitude = df.GPS_Latitude.astype(float)\n",
    "    df.GPS_Longitude = df.GPS_Longitude.astype(float)\n",
    "    df.drop(columns=['latitude','longitude','localizacao'], inplace=True)\n",
    "\n",
    "    return df\n",
    "\n",
    "def apply_filters(df):\n",
    "    \n",
    "    linhas = ['0.195', '147.5', '147.6', '180.1', '180.2', '181.2', '181.4', '8002','106.2','0.147','2207','2209']\n",
    "    \n",
    "    df = df[df.linha.isin(linhas)]\n",
    "    \n",
    "    return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = process_data(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = apply_filters(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>key_0</th>\n",
       "      <th>codigoImei</th>\n",
       "      <th>direcao</th>\n",
       "      <th>horario</th>\n",
       "      <th>linha</th>\n",
       "      <th>numero</th>\n",
       "      <th>sentido</th>\n",
       "      <th>valid</th>\n",
       "      <th>velocidade</th>\n",
       "      <th>GPS_Latitude</th>\n",
       "      <th>GPS_Longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1026</th>\n",
       "      <td>1026</td>\n",
       "      <td>None</td>\n",
       "      <td>6.01</td>\n",
       "      <td>1602940982000</td>\n",
       "      <td>2207</td>\n",
       "      <td>223972</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.879971</td>\n",
       "      <td>-47.959644</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1042</th>\n",
       "      <td>1042</td>\n",
       "      <td>None</td>\n",
       "      <td>201.27</td>\n",
       "      <td>1602940952000</td>\n",
       "      <td>180.1</td>\n",
       "      <td>229881</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.794376</td>\n",
       "      <td>-47.882142</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1048</th>\n",
       "      <td>1048</td>\n",
       "      <td>None</td>\n",
       "      <td>246.66</td>\n",
       "      <td>1602941038000</td>\n",
       "      <td>0.147</td>\n",
       "      <td>226866</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.856625</td>\n",
       "      <td>-47.861613</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1049</th>\n",
       "      <td>1049</td>\n",
       "      <td>None</td>\n",
       "      <td>219.07</td>\n",
       "      <td>1602941010000</td>\n",
       "      <td>2207</td>\n",
       "      <td>229440</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.860217</td>\n",
       "      <td>-47.935478</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1066</th>\n",
       "      <td>1066</td>\n",
       "      <td>None</td>\n",
       "      <td>106.54</td>\n",
       "      <td>1602941002000</td>\n",
       "      <td>180.1</td>\n",
       "      <td>229873</td>\n",
       "      <td>VOLTA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.886475</td>\n",
       "      <td>-47.812531</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1091</th>\n",
       "      <td>1091</td>\n",
       "      <td>None</td>\n",
       "      <td>305.79</td>\n",
       "      <td>1602941022000</td>\n",
       "      <td>180.1</td>\n",
       "      <td>229822</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.842214</td>\n",
       "      <td>-47.821616</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1099</th>\n",
       "      <td>1099</td>\n",
       "      <td>None</td>\n",
       "      <td>35.72</td>\n",
       "      <td>1602940990000</td>\n",
       "      <td>180.1</td>\n",
       "      <td>227463</td>\n",
       "      <td>VOLTA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.906501</td>\n",
       "      <td>-47.770969</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1142</th>\n",
       "      <td>1142</td>\n",
       "      <td>None</td>\n",
       "      <td>167.16</td>\n",
       "      <td>1602941018000</td>\n",
       "      <td>2207</td>\n",
       "      <td>227927</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.744724</td>\n",
       "      <td>-47.897268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1158</th>\n",
       "      <td>1158</td>\n",
       "      <td>None</td>\n",
       "      <td>288.14</td>\n",
       "      <td>1602940978000</td>\n",
       "      <td>180.1</td>\n",
       "      <td>229857</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.801101</td>\n",
       "      <td>-47.856323</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1169</th>\n",
       "      <td>1169</td>\n",
       "      <td>None</td>\n",
       "      <td>8.28</td>\n",
       "      <td>1602940944000</td>\n",
       "      <td>2207</td>\n",
       "      <td>229288</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.879979</td>\n",
       "      <td>-47.959899</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1173</th>\n",
       "      <td>1173</td>\n",
       "      <td>None</td>\n",
       "      <td>186.33</td>\n",
       "      <td>1602940976000</td>\n",
       "      <td>2209</td>\n",
       "      <td>227609</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.879796</td>\n",
       "      <td>-47.959899</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1181</th>\n",
       "      <td>1181</td>\n",
       "      <td>None</td>\n",
       "      <td>182.99</td>\n",
       "      <td>1602940974000</td>\n",
       "      <td>180.1</td>\n",
       "      <td>227277</td>\n",
       "      <td>VOLTA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.836037</td>\n",
       "      <td>-47.824960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1182</th>\n",
       "      <td>1182</td>\n",
       "      <td>None</td>\n",
       "      <td>273.39</td>\n",
       "      <td>1602941010000</td>\n",
       "      <td>147.5</td>\n",
       "      <td>227935</td>\n",
       "      <td>VOLTA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.913591</td>\n",
       "      <td>-47.757128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1185</th>\n",
       "      <td>1185</td>\n",
       "      <td>None</td>\n",
       "      <td>59.20</td>\n",
       "      <td>1602940922000</td>\n",
       "      <td>181.2</td>\n",
       "      <td>227501</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.913568</td>\n",
       "      <td>-47.757351</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1215</th>\n",
       "      <td>1215</td>\n",
       "      <td>None</td>\n",
       "      <td>154.33</td>\n",
       "      <td>1602940972000</td>\n",
       "      <td>181.2</td>\n",
       "      <td>227421</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.900466</td>\n",
       "      <td>-47.773290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1235</th>\n",
       "      <td>1235</td>\n",
       "      <td>None</td>\n",
       "      <td>190.72</td>\n",
       "      <td>1602940976000</td>\n",
       "      <td>2209</td>\n",
       "      <td>227528</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.879256</td>\n",
       "      <td>-47.959848</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1240</th>\n",
       "      <td>1240</td>\n",
       "      <td>None</td>\n",
       "      <td>196.11</td>\n",
       "      <td>1602940990000</td>\n",
       "      <td>0.147</td>\n",
       "      <td>224707</td>\n",
       "      <td>VOLTA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.736861</td>\n",
       "      <td>-47.766099</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1264</th>\n",
       "      <td>1264</td>\n",
       "      <td>None</td>\n",
       "      <td>30.07</td>\n",
       "      <td>1602940988000</td>\n",
       "      <td>2209</td>\n",
       "      <td>223816</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.786489</td>\n",
       "      <td>-47.900936</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1270</th>\n",
       "      <td>1270</td>\n",
       "      <td>None</td>\n",
       "      <td>241.24</td>\n",
       "      <td>1602941044000</td>\n",
       "      <td>181.2</td>\n",
       "      <td>227218</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.845269</td>\n",
       "      <td>-47.895665</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1285</th>\n",
       "      <td>1285</td>\n",
       "      <td>None</td>\n",
       "      <td>156.67</td>\n",
       "      <td>1602940998000</td>\n",
       "      <td>181.2</td>\n",
       "      <td>227081</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.892892</td>\n",
       "      <td>-47.777753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1318</th>\n",
       "      <td>1318</td>\n",
       "      <td>None</td>\n",
       "      <td>233.58</td>\n",
       "      <td>1602941048000</td>\n",
       "      <td>180.1</td>\n",
       "      <td>227234</td>\n",
       "      <td>VOLTA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.912342</td>\n",
       "      <td>-47.756575</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1324</th>\n",
       "      <td>1324</td>\n",
       "      <td>None</td>\n",
       "      <td>318.42</td>\n",
       "      <td>1602940990000</td>\n",
       "      <td>147.6</td>\n",
       "      <td>227391</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.846607</td>\n",
       "      <td>-47.887222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1332</th>\n",
       "      <td>1332</td>\n",
       "      <td>None</td>\n",
       "      <td>70.86</td>\n",
       "      <td>1602940982000</td>\n",
       "      <td>0.147</td>\n",
       "      <td>229903</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.912647</td>\n",
       "      <td>-47.757796</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1333</th>\n",
       "      <td>1333</td>\n",
       "      <td>None</td>\n",
       "      <td>308.01</td>\n",
       "      <td>1602941010000</td>\n",
       "      <td>180.1</td>\n",
       "      <td>227951</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.900904</td>\n",
       "      <td>-47.778713</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1348</th>\n",
       "      <td>1348</td>\n",
       "      <td>None</td>\n",
       "      <td>-319.78</td>\n",
       "      <td>1602941008000</td>\n",
       "      <td>181.2</td>\n",
       "      <td>229474</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.910935</td>\n",
       "      <td>-47.759017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1360</th>\n",
       "      <td>1360</td>\n",
       "      <td>None</td>\n",
       "      <td>59.04</td>\n",
       "      <td>1602940984000</td>\n",
       "      <td>0.147</td>\n",
       "      <td>227196</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.794220</td>\n",
       "      <td>-47.881869</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1383</th>\n",
       "      <td>1383</td>\n",
       "      <td>None</td>\n",
       "      <td>89.91</td>\n",
       "      <td>1602940984000</td>\n",
       "      <td>180.1</td>\n",
       "      <td>227153</td>\n",
       "      <td>VOLTA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.913361</td>\n",
       "      <td>-47.756804</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1395</th>\n",
       "      <td>1395</td>\n",
       "      <td>None</td>\n",
       "      <td>35.77</td>\n",
       "      <td>1602940996000</td>\n",
       "      <td>2207</td>\n",
       "      <td>228800</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.801586</td>\n",
       "      <td>-47.894477</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1434</th>\n",
       "      <td>1434</td>\n",
       "      <td>None</td>\n",
       "      <td>68.44</td>\n",
       "      <td>1602941022000</td>\n",
       "      <td>180.2</td>\n",
       "      <td>227439</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.794336</td>\n",
       "      <td>-47.881907</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1435</th>\n",
       "      <td>1435</td>\n",
       "      <td>None</td>\n",
       "      <td>107.66</td>\n",
       "      <td>1602940966000</td>\n",
       "      <td>147.5</td>\n",
       "      <td>229083</td>\n",
       "      <td>VOLTA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.795320</td>\n",
       "      <td>-47.881608</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1443</th>\n",
       "      <td>1443</td>\n",
       "      <td>None</td>\n",
       "      <td>-302.82</td>\n",
       "      <td>1602888814000</td>\n",
       "      <td>0.147</td>\n",
       "      <td>229849</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.912388</td>\n",
       "      <td>-47.752080</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1462</th>\n",
       "      <td>1462</td>\n",
       "      <td>None</td>\n",
       "      <td>138.86</td>\n",
       "      <td>1602940978000</td>\n",
       "      <td>147.5</td>\n",
       "      <td>227358</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.798073</td>\n",
       "      <td>-47.852655</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1476</th>\n",
       "      <td>1476</td>\n",
       "      <td>None</td>\n",
       "      <td>96.88</td>\n",
       "      <td>1602940984000</td>\n",
       "      <td>181.4</td>\n",
       "      <td>227811</td>\n",
       "      <td>VOLTA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.859509</td>\n",
       "      <td>-47.871360</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1487</th>\n",
       "      <td>1487</td>\n",
       "      <td>None</td>\n",
       "      <td>245.24</td>\n",
       "      <td>1602940936000</td>\n",
       "      <td>181.2</td>\n",
       "      <td>229547</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.856250</td>\n",
       "      <td>-47.860786</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1508</th>\n",
       "      <td>1508</td>\n",
       "      <td>None</td>\n",
       "      <td>56.86</td>\n",
       "      <td>1602940988000</td>\n",
       "      <td>2207</td>\n",
       "      <td>229521</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.823693</td>\n",
       "      <td>-47.921555</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1514</th>\n",
       "      <td>1514</td>\n",
       "      <td>None</td>\n",
       "      <td>43.66</td>\n",
       "      <td>1602941006000</td>\n",
       "      <td>0.147</td>\n",
       "      <td>226815</td>\n",
       "      <td>VOLTA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.840511</td>\n",
       "      <td>-47.884851</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1564</th>\n",
       "      <td>1564</td>\n",
       "      <td>None</td>\n",
       "      <td>-321.39</td>\n",
       "      <td>1602940982000</td>\n",
       "      <td>181.2</td>\n",
       "      <td>229458</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.900011</td>\n",
       "      <td>-47.773328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1588</th>\n",
       "      <td>1588</td>\n",
       "      <td>None</td>\n",
       "      <td>131.00</td>\n",
       "      <td>1602940936000</td>\n",
       "      <td>2209</td>\n",
       "      <td>227048</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.786335</td>\n",
       "      <td>-47.909888</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1623</th>\n",
       "      <td>1623</td>\n",
       "      <td>None</td>\n",
       "      <td>34.72</td>\n",
       "      <td>1602940974000</td>\n",
       "      <td>2207</td>\n",
       "      <td>223905</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.736386</td>\n",
       "      <td>-47.898126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1625</th>\n",
       "      <td>1625</td>\n",
       "      <td>None</td>\n",
       "      <td>232.47</td>\n",
       "      <td>1602940938000</td>\n",
       "      <td>180.1</td>\n",
       "      <td>229466</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.912218</td>\n",
       "      <td>-47.756467</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1634</th>\n",
       "      <td>1634</td>\n",
       "      <td>None</td>\n",
       "      <td>43.50</td>\n",
       "      <td>1602869740000</td>\n",
       "      <td>2207</td>\n",
       "      <td>228729</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.806177</td>\n",
       "      <td>-47.898628</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1648</th>\n",
       "      <td>1648</td>\n",
       "      <td>None</td>\n",
       "      <td>2.64</td>\n",
       "      <td>1602940934000</td>\n",
       "      <td>2209</td>\n",
       "      <td>227285</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.852412</td>\n",
       "      <td>-47.955016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1659</th>\n",
       "      <td>1659</td>\n",
       "      <td>None</td>\n",
       "      <td>184.50</td>\n",
       "      <td>1602940930000</td>\n",
       "      <td>2207</td>\n",
       "      <td>223611</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.879655</td>\n",
       "      <td>-47.959848</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1704</th>\n",
       "      <td>1704</td>\n",
       "      <td>None</td>\n",
       "      <td>295.77</td>\n",
       "      <td>1602940960000</td>\n",
       "      <td>180.2</td>\n",
       "      <td>227072</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.896352</td>\n",
       "      <td>-47.796782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2352</th>\n",
       "      <td>2352</td>\n",
       "      <td>None</td>\n",
       "      <td>288.00</td>\n",
       "      <td>1602940806000</td>\n",
       "      <td>106.2</td>\n",
       "      <td>116599</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.835940</td>\n",
       "      <td>-47.933340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2535</th>\n",
       "      <td>2535</td>\n",
       "      <td>None</td>\n",
       "      <td>172.00</td>\n",
       "      <td>1602940999000</td>\n",
       "      <td>106.2</td>\n",
       "      <td>116335</td>\n",
       "      <td>IDA</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.779000</td>\n",
       "      <td>-47.873740</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2565</th>\n",
       "      <td>2565</td>\n",
       "      <td>None</td>\n",
       "      <td>13.00</td>\n",
       "      <td>1602941005000</td>\n",
       "      <td>106.2</td>\n",
       "      <td>116912</td>\n",
       "      <td>None</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>-15.786680</td>\n",
       "      <td>-47.887900</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      key_0 codigoImei  direcao        horario  linha  numero sentido  valid  \\\n",
       "1026   1026       None     6.01  1602940982000   2207  223972     IDA   True   \n",
       "1042   1042       None   201.27  1602940952000  180.1  229881     IDA   True   \n",
       "1048   1048       None   246.66  1602941038000  0.147  226866     IDA   True   \n",
       "1049   1049       None   219.07  1602941010000   2207  229440     IDA   True   \n",
       "1066   1066       None   106.54  1602941002000  180.1  229873   VOLTA   True   \n",
       "1091   1091       None   305.79  1602941022000  180.1  229822     IDA   True   \n",
       "1099   1099       None    35.72  1602940990000  180.1  227463   VOLTA   True   \n",
       "1142   1142       None   167.16  1602941018000   2207  227927     IDA   True   \n",
       "1158   1158       None   288.14  1602940978000  180.1  229857     IDA   True   \n",
       "1169   1169       None     8.28  1602940944000   2207  229288     IDA   True   \n",
       "1173   1173       None   186.33  1602940976000   2209  227609     IDA   True   \n",
       "1181   1181       None   182.99  1602940974000  180.1  227277   VOLTA   True   \n",
       "1182   1182       None   273.39  1602941010000  147.5  227935   VOLTA   True   \n",
       "1185   1185       None    59.20  1602940922000  181.2  227501     IDA   True   \n",
       "1215   1215       None   154.33  1602940972000  181.2  227421     IDA   True   \n",
       "1235   1235       None   190.72  1602940976000   2209  227528     IDA   True   \n",
       "1240   1240       None   196.11  1602940990000  0.147  224707   VOLTA   True   \n",
       "1264   1264       None    30.07  1602940988000   2209  223816     IDA   True   \n",
       "1270   1270       None   241.24  1602941044000  181.2  227218     IDA   True   \n",
       "1285   1285       None   156.67  1602940998000  181.2  227081     IDA   True   \n",
       "1318   1318       None   233.58  1602941048000  180.1  227234   VOLTA   True   \n",
       "1324   1324       None   318.42  1602940990000  147.6  227391     IDA   True   \n",
       "1332   1332       None    70.86  1602940982000  0.147  229903     IDA   True   \n",
       "1333   1333       None   308.01  1602941010000  180.1  227951     IDA   True   \n",
       "1348   1348       None  -319.78  1602941008000  181.2  229474     IDA   True   \n",
       "1360   1360       None    59.04  1602940984000  0.147  227196     IDA   True   \n",
       "1383   1383       None    89.91  1602940984000  180.1  227153   VOLTA   True   \n",
       "1395   1395       None    35.77  1602940996000   2207  228800     IDA   True   \n",
       "1434   1434       None    68.44  1602941022000  180.2  227439     IDA   True   \n",
       "1435   1435       None   107.66  1602940966000  147.5  229083   VOLTA   True   \n",
       "1443   1443       None  -302.82  1602888814000  0.147  229849     IDA   True   \n",
       "1462   1462       None   138.86  1602940978000  147.5  227358     IDA   True   \n",
       "1476   1476       None    96.88  1602940984000  181.4  227811   VOLTA   True   \n",
       "1487   1487       None   245.24  1602940936000  181.2  229547     IDA   True   \n",
       "1508   1508       None    56.86  1602940988000   2207  229521     IDA   True   \n",
       "1514   1514       None    43.66  1602941006000  0.147  226815   VOLTA   True   \n",
       "1564   1564       None  -321.39  1602940982000  181.2  229458     IDA   True   \n",
       "1588   1588       None   131.00  1602940936000   2209  227048     IDA   True   \n",
       "1623   1623       None    34.72  1602940974000   2207  223905     IDA   True   \n",
       "1625   1625       None   232.47  1602940938000  180.1  229466     IDA   True   \n",
       "1634   1634       None    43.50  1602869740000   2207  228729     IDA   True   \n",
       "1648   1648       None     2.64  1602940934000   2209  227285     IDA   True   \n",
       "1659   1659       None   184.50  1602940930000   2207  223611     IDA   True   \n",
       "1704   1704       None   295.77  1602940960000  180.2  227072     IDA   True   \n",
       "2352   2352       None   288.00  1602940806000  106.2  116599     IDA   True   \n",
       "2535   2535       None   172.00  1602940999000  106.2  116335     IDA   True   \n",
       "2565   2565       None    13.00  1602941005000  106.2  116912    None   True   \n",
       "\n",
       "     velocidade  GPS_Latitude  GPS_Longitude  \n",
       "1026       None    -15.879971     -47.959644  \n",
       "1042       None    -15.794376     -47.882142  \n",
       "1048       None    -15.856625     -47.861613  \n",
       "1049       None    -15.860217     -47.935478  \n",
       "1066       None    -15.886475     -47.812531  \n",
       "1091       None    -15.842214     -47.821616  \n",
       "1099       None    -15.906501     -47.770969  \n",
       "1142       None    -15.744724     -47.897268  \n",
       "1158       None    -15.801101     -47.856323  \n",
       "1169       None    -15.879979     -47.959899  \n",
       "1173       None    -15.879796     -47.959899  \n",
       "1181       None    -15.836037     -47.824960  \n",
       "1182       None    -15.913591     -47.757128  \n",
       "1185       None    -15.913568     -47.757351  \n",
       "1215       None    -15.900466     -47.773290  \n",
       "1235       None    -15.879256     -47.959848  \n",
       "1240       None    -15.736861     -47.766099  \n",
       "1264       None    -15.786489     -47.900936  \n",
       "1270       None    -15.845269     -47.895665  \n",
       "1285       None    -15.892892     -47.777753  \n",
       "1318       None    -15.912342     -47.756575  \n",
       "1324       None    -15.846607     -47.887222  \n",
       "1332       None    -15.912647     -47.757796  \n",
       "1333       None    -15.900904     -47.778713  \n",
       "1348       None    -15.910935     -47.759017  \n",
       "1360       None    -15.794220     -47.881869  \n",
       "1383       None    -15.913361     -47.756804  \n",
       "1395       None    -15.801586     -47.894477  \n",
       "1434       None    -15.794336     -47.881907  \n",
       "1435       None    -15.795320     -47.881608  \n",
       "1443       None    -15.912388     -47.752080  \n",
       "1462       None    -15.798073     -47.852655  \n",
       "1476       None    -15.859509     -47.871360  \n",
       "1487       None    -15.856250     -47.860786  \n",
       "1508       None    -15.823693     -47.921555  \n",
       "1514       None    -15.840511     -47.884851  \n",
       "1564       None    -15.900011     -47.773328  \n",
       "1588       None    -15.786335     -47.909888  \n",
       "1623       None    -15.736386     -47.898126  \n",
       "1625       None    -15.912218     -47.756467  \n",
       "1634       None    -15.806177     -47.898628  \n",
       "1648       None    -15.852412     -47.955016  \n",
       "1659       None    -15.879655     -47.959848  \n",
       "1704       None    -15.896352     -47.796782  \n",
       "2352       None    -15.835940     -47.933340  \n",
       "2535       None    -15.779000     -47.873740  \n",
       "2565       None    -15.786680     -47.887900  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}