{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>event_timestamp</th>\n",
       "      <th>driver_id</th>\n",
       "      <th>conv_rate</th>\n",
       "      <th>acc_rate</th>\n",
       "      <th>created</th>\n",
       "      <th>day</th>\n",
       "      <th>miles_driven</th>\n",
       "      <th>daily_miles_driven</th>\n",
       "      <th>lat</th>\n",
       "      <th>lon</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022-02-27 15:00:00+00:00</td>\n",
       "      <td>1005</td>\n",
       "      <td>0.142214</td>\n",
       "      <td>0.408987</td>\n",
       "      <td>2022-03-14 15:21:25.842</td>\n",
       "      <td>2022-02-27</td>\n",
       "      <td>24.817618</td>\n",
       "      <td>150.587752</td>\n",
       "      <td>1.693756</td>\n",
       "      <td>1.550350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022-02-27 16:00:00+00:00</td>\n",
       "      <td>1005</td>\n",
       "      <td>0.349267</td>\n",
       "      <td>0.734021</td>\n",
       "      <td>2022-03-14 15:21:25.842</td>\n",
       "      <td>2022-02-27</td>\n",
       "      <td>8.293352</td>\n",
       "      <td>150.587752</td>\n",
       "      <td>1.371052</td>\n",
       "      <td>3.637346</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022-02-27 17:00:00+00:00</td>\n",
       "      <td>1005</td>\n",
       "      <td>0.358805</td>\n",
       "      <td>0.366804</td>\n",
       "      <td>2022-03-14 15:21:25.842</td>\n",
       "      <td>2022-02-27</td>\n",
       "      <td>8.316672</td>\n",
       "      <td>150.587752</td>\n",
       "      <td>2.077928</td>\n",
       "      <td>4.232362</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022-02-27 18:00:00+00:00</td>\n",
       "      <td>1005</td>\n",
       "      <td>0.611828</td>\n",
       "      <td>0.773883</td>\n",
       "      <td>2022-03-14 15:21:25.842</td>\n",
       "      <td>2022-02-27</td>\n",
       "      <td>10.566458</td>\n",
       "      <td>150.587752</td>\n",
       "      <td>1.185602</td>\n",
       "      <td>0.046604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022-02-27 19:00:00+00:00</td>\n",
       "      <td>1005</td>\n",
       "      <td>0.156503</td>\n",
       "      <td>0.966413</td>\n",
       "      <td>2022-03-14 15:21:25.842</td>\n",
       "      <td>2022-02-27</td>\n",
       "      <td>15.664332</td>\n",
       "      <td>150.587752</td>\n",
       "      <td>0.633673</td>\n",
       "      <td>1.016666</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1802</th>\n",
       "      <td>2022-03-14 11:00:00+00:00</td>\n",
       "      <td>1001</td>\n",
       "      <td>0.667961</td>\n",
       "      <td>0.211051</td>\n",
       "      <td>2022-03-14 15:21:25.842</td>\n",
       "      <td>2022-03-14</td>\n",
       "      <td>40.500185</td>\n",
       "      <td>350.650257</td>\n",
       "      <td>2.390705</td>\n",
       "      <td>3.319251</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1803</th>\n",
       "      <td>2022-03-14 12:00:00+00:00</td>\n",
       "      <td>1001</td>\n",
       "      <td>0.209861</td>\n",
       "      <td>0.672022</td>\n",
       "      <td>2022-03-14 15:21:25.842</td>\n",
       "      <td>2022-03-14</td>\n",
       "      <td>21.341177</td>\n",
       "      <td>350.650257</td>\n",
       "      <td>2.179745</td>\n",
       "      <td>1.250355</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1804</th>\n",
       "      <td>2022-03-14 13:00:00+00:00</td>\n",
       "      <td>1001</td>\n",
       "      <td>0.215754</td>\n",
       "      <td>0.791849</td>\n",
       "      <td>2022-03-14 15:21:25.842</td>\n",
       "      <td>2022-03-14</td>\n",
       "      <td>8.068214</td>\n",
       "      <td>350.650257</td>\n",
       "      <td>1.289601</td>\n",
       "      <td>6.045587</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1805</th>\n",
       "      <td>2022-03-14 14:00:00+00:00</td>\n",
       "      <td>1001</td>\n",
       "      <td>0.404588</td>\n",
       "      <td>0.407571</td>\n",
       "      <td>2022-03-14 15:21:25.842</td>\n",
       "      <td>2022-03-14</td>\n",
       "      <td>46.533292</td>\n",
       "      <td>350.650257</td>\n",
       "      <td>2.710022</td>\n",
       "      <td>5.376999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1806</th>\n",
       "      <td>2021-04-12 07:00:00+00:00</td>\n",
       "      <td>1001</td>\n",
       "      <td>0.521149</td>\n",
       "      <td>0.751659</td>\n",
       "      <td>2022-03-14 15:21:25.842</td>\n",
       "      <td>2021-04-12</td>\n",
       "      <td>18.926695</td>\n",
       "      <td>18.926695</td>\n",
       "      <td>1.265647</td>\n",
       "      <td>1.150815</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1807 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               event_timestamp  driver_id  conv_rate  acc_rate  \\\n",
       "0    2022-02-27 15:00:00+00:00       1005   0.142214  0.408987   \n",
       "1    2022-02-27 16:00:00+00:00       1005   0.349267  0.734021   \n",
       "2    2022-02-27 17:00:00+00:00       1005   0.358805  0.366804   \n",
       "3    2022-02-27 18:00:00+00:00       1005   0.611828  0.773883   \n",
       "4    2022-02-27 19:00:00+00:00       1005   0.156503  0.966413   \n",
       "...                        ...        ...        ...       ...   \n",
       "1802 2022-03-14 11:00:00+00:00       1001   0.667961  0.211051   \n",
       "1803 2022-03-14 12:00:00+00:00       1001   0.209861  0.672022   \n",
       "1804 2022-03-14 13:00:00+00:00       1001   0.215754  0.791849   \n",
       "1805 2022-03-14 14:00:00+00:00       1001   0.404588  0.407571   \n",
       "1806 2021-04-12 07:00:00+00:00       1001   0.521149  0.751659   \n",
       "\n",
       "                     created         day  miles_driven  daily_miles_driven  \\\n",
       "0    2022-03-14 15:21:25.842  2022-02-27     24.817618          150.587752   \n",
       "1    2022-03-14 15:21:25.842  2022-02-27      8.293352          150.587752   \n",
       "2    2022-03-14 15:21:25.842  2022-02-27      8.316672          150.587752   \n",
       "3    2022-03-14 15:21:25.842  2022-02-27     10.566458          150.587752   \n",
       "4    2022-03-14 15:21:25.842  2022-02-27     15.664332          150.587752   \n",
       "...                      ...         ...           ...                 ...   \n",
       "1802 2022-03-14 15:21:25.842  2022-03-14     40.500185          350.650257   \n",
       "1803 2022-03-14 15:21:25.842  2022-03-14     21.341177          350.650257   \n",
       "1804 2022-03-14 15:21:25.842  2022-03-14      8.068214          350.650257   \n",
       "1805 2022-03-14 15:21:25.842  2022-03-14     46.533292          350.650257   \n",
       "1806 2022-03-14 15:21:25.842  2021-04-12     18.926695           18.926695   \n",
       "\n",
       "           lat       lon  \n",
       "0     1.693756  1.550350  \n",
       "1     1.371052  3.637346  \n",
       "2     2.077928  4.232362  \n",
       "3     1.185602  0.046604  \n",
       "4     0.633673  1.016666  \n",
       "...        ...       ...  \n",
       "1802  2.390705  3.319251  \n",
       "1803  2.179745  1.250355  \n",
       "1804  1.289601  6.045587  \n",
       "1805  2.710022  5.376999  \n",
       "1806  1.265647  1.150815  \n",
       "\n",
       "[1807 rows x 10 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "pd.read_parquet(\"data/driver_stats_lat_lon.parquet\")"
   ]
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "7d634b9af180bcb32a446a43848522733ff8f5bbf0cc46dba1a83bede04bf237"
  },
  "kernelspec": {
   "display_name": "Python 3.8.10 64-bit ('python-3.8')",
   "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.8.10"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}