analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "22bbe540-0b1d-4b27-8b47-77942f995920",
   "metadata": {},
   "outputs": [],
   "source": [
    "%matplotlib widget\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "6702890b-71f0-4345-a4e7-df492e6fbdb9",
   "metadata": {},
   "outputs": [],
   "source": [
    "data = pd.read_csv(\"cleaned_data.csv\", parse_dates=[\"datetime\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "8480ad02-b736-488e-a586-0070b7756198",
   "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>id</th>\n",
       "      <th>start_time</th>\n",
       "      <th>end_time</th>\n",
       "      <th>time_diff</th>\n",
       "      <th>x_dir</th>\n",
       "      <th>y_dir</th>\n",
       "      <th>start_frame</th>\n",
       "      <th>end_frame</th>\n",
       "      <th>frame_diff</th>\n",
       "      <th>calculated_time</th>\n",
       "      <th>calculated_distance</th>\n",
       "      <th>speed_mps</th>\n",
       "      <th>speed_kmh</th>\n",
       "      <th>avg_size</th>\n",
       "      <th>datetime</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>7.0</td>\n",
       "      <td>1.621269e+09</td>\n",
       "      <td>1.621269e+09</td>\n",
       "      <td>1.518</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1387.0</td>\n",
       "      <td>1409.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>1.467</td>\n",
       "      <td>13.218</td>\n",
       "      <td>9.01</td>\n",
       "      <td>32.44</td>\n",
       "      <td>6681.0</td>\n",
       "      <td>2021-05-17 18:34:54.666</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>19.0</td>\n",
       "      <td>1.621269e+09</td>\n",
       "      <td>1.621269e+09</td>\n",
       "      <td>2.746</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2304.0</td>\n",
       "      <td>2345.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>2.733</td>\n",
       "      <td>13.762</td>\n",
       "      <td>5.03</td>\n",
       "      <td>18.11</td>\n",
       "      <td>4565.0</td>\n",
       "      <td>2021-05-17 18:35:55.877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>37.0</td>\n",
       "      <td>1.621270e+09</td>\n",
       "      <td>1.621270e+09</td>\n",
       "      <td>1.670</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>6171.0</td>\n",
       "      <td>6196.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>1.667</td>\n",
       "      <td>13.871</td>\n",
       "      <td>8.32</td>\n",
       "      <td>29.95</td>\n",
       "      <td>6843.0</td>\n",
       "      <td>2021-05-17 18:40:13.579</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>38.0</td>\n",
       "      <td>1.621270e+09</td>\n",
       "      <td>1.621270e+09</td>\n",
       "      <td>2.318</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>7028.0</td>\n",
       "      <td>7063.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>2.333</td>\n",
       "      <td>13.615</td>\n",
       "      <td>5.84</td>\n",
       "      <td>21.02</td>\n",
       "      <td>5793.0</td>\n",
       "      <td>2021-05-17 18:41:10.730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>57.0</td>\n",
       "      <td>1.621270e+09</td>\n",
       "      <td>1.621270e+09</td>\n",
       "      <td>1.864</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>8051.0</td>\n",
       "      <td>8079.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>1.867</td>\n",
       "      <td>13.138</td>\n",
       "      <td>7.04</td>\n",
       "      <td>25.34</td>\n",
       "      <td>7604.0</td>\n",
       "      <td>2021-05-17 18:42:18.928</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8322</th>\n",
       "      <td>29092.0</td>\n",
       "      <td>1.622142e+09</td>\n",
       "      <td>1.622142e+09</td>\n",
       "      <td>2.261</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1253144.0</td>\n",
       "      <td>1253178.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>2.267</td>\n",
       "      <td>13.620</td>\n",
       "      <td>6.01</td>\n",
       "      <td>21.64</td>\n",
       "      <td>9618.0</td>\n",
       "      <td>2021-05-27 20:54:40.302</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8323</th>\n",
       "      <td>29128.0</td>\n",
       "      <td>1.622142e+09</td>\n",
       "      <td>1.622142e+09</td>\n",
       "      <td>2.013</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1253802.0</td>\n",
       "      <td>1253832.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>2.000</td>\n",
       "      <td>13.739</td>\n",
       "      <td>6.87</td>\n",
       "      <td>24.73</td>\n",
       "      <td>6444.0</td>\n",
       "      <td>2021-05-27 20:55:24.160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8324</th>\n",
       "      <td>29136.0</td>\n",
       "      <td>1.622142e+09</td>\n",
       "      <td>1.622142e+09</td>\n",
       "      <td>1.592</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1254920.0</td>\n",
       "      <td>1254944.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>1.600</td>\n",
       "      <td>13.850</td>\n",
       "      <td>8.66</td>\n",
       "      <td>31.18</td>\n",
       "      <td>8609.0</td>\n",
       "      <td>2021-05-27 20:56:38.697</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8325</th>\n",
       "      <td>29140.0</td>\n",
       "      <td>1.622142e+09</td>\n",
       "      <td>1.622142e+09</td>\n",
       "      <td>2.080</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1255772.0</td>\n",
       "      <td>1255803.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>2.067</td>\n",
       "      <td>13.813</td>\n",
       "      <td>6.68</td>\n",
       "      <td>24.05</td>\n",
       "      <td>7877.0</td>\n",
       "      <td>2021-05-27 20:57:35.492</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8326</th>\n",
       "      <td>29142.0</td>\n",
       "      <td>1.622142e+09</td>\n",
       "      <td>1.622142e+09</td>\n",
       "      <td>2.800</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1257330.0</td>\n",
       "      <td>1257372.0</td>\n",
       "      <td>42.0</td>\n",
       "      <td>2.800</td>\n",
       "      <td>13.739</td>\n",
       "      <td>4.91</td>\n",
       "      <td>17.68</td>\n",
       "      <td>6848.0</td>\n",
       "      <td>2021-05-27 20:59:19.370</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8327 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           id    start_time      end_time  time_diff  x_dir  y_dir  \\\n",
       "0         7.0  1.621269e+09  1.621269e+09      1.518   -1.0   -1.0   \n",
       "1        19.0  1.621269e+09  1.621269e+09      2.746   -1.0    1.0   \n",
       "2        37.0  1.621270e+09  1.621270e+09      1.670   -1.0   -1.0   \n",
       "3        38.0  1.621270e+09  1.621270e+09      2.318   -1.0   -1.0   \n",
       "4        57.0  1.621270e+09  1.621270e+09      1.864   -1.0   -1.0   \n",
       "...       ...           ...           ...        ...    ...    ...   \n",
       "8322  29092.0  1.622142e+09  1.622142e+09      2.261   -1.0   -1.0   \n",
       "8323  29128.0  1.622142e+09  1.622142e+09      2.013   -1.0   -1.0   \n",
       "8324  29136.0  1.622142e+09  1.622142e+09      1.592   -1.0   -1.0   \n",
       "8325  29140.0  1.622142e+09  1.622142e+09      2.080   -1.0   -1.0   \n",
       "8326  29142.0  1.622142e+09  1.622142e+09      2.800   -1.0   -1.0   \n",
       "\n",
       "      start_frame  end_frame  frame_diff  calculated_time  \\\n",
       "0          1387.0     1409.0        22.0            1.467   \n",
       "1          2304.0     2345.0        41.0            2.733   \n",
       "2          6171.0     6196.0        25.0            1.667   \n",
       "3          7028.0     7063.0        35.0            2.333   \n",
       "4          8051.0     8079.0        28.0            1.867   \n",
       "...           ...        ...         ...              ...   \n",
       "8322    1253144.0  1253178.0        34.0            2.267   \n",
       "8323    1253802.0  1253832.0        30.0            2.000   \n",
       "8324    1254920.0  1254944.0        24.0            1.600   \n",
       "8325    1255772.0  1255803.0        31.0            2.067   \n",
       "8326    1257330.0  1257372.0        42.0            2.800   \n",
       "\n",
       "      calculated_distance  speed_mps  speed_kmh  avg_size  \\\n",
       "0                  13.218       9.01      32.44    6681.0   \n",
       "1                  13.762       5.03      18.11    4565.0   \n",
       "2                  13.871       8.32      29.95    6843.0   \n",
       "3                  13.615       5.84      21.02    5793.0   \n",
       "4                  13.138       7.04      25.34    7604.0   \n",
       "...                   ...        ...        ...       ...   \n",
       "8322               13.620       6.01      21.64    9618.0   \n",
       "8323               13.739       6.87      24.73    6444.0   \n",
       "8324               13.850       8.66      31.18    8609.0   \n",
       "8325               13.813       6.68      24.05    7877.0   \n",
       "8326               13.739       4.91      17.68    6848.0   \n",
       "\n",
       "                    datetime  \n",
       "0    2021-05-17 18:34:54.666  \n",
       "1    2021-05-17 18:35:55.877  \n",
       "2    2021-05-17 18:40:13.579  \n",
       "3    2021-05-17 18:41:10.730  \n",
       "4    2021-05-17 18:42:18.928  \n",
       "...                      ...  \n",
       "8322 2021-05-27 20:54:40.302  \n",
       "8323 2021-05-27 20:55:24.160  \n",
       "8324 2021-05-27 20:56:38.697  \n",
       "8325 2021-05-27 20:57:35.492  \n",
       "8326 2021-05-27 20:59:19.370  \n",
       "\n",
       "[8327 rows x 15 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "bfb0a10c-2ab3-454f-9bef-fe3b274b170f",
   "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>id</th>\n",
       "      <th>time_diff</th>\n",
       "      <th>x_dir</th>\n",
       "      <th>y_dir</th>\n",
       "      <th>frame_diff</th>\n",
       "      <th>calculated_time</th>\n",
       "      <th>calculated_distance</th>\n",
       "      <th>speed_mps</th>\n",
       "      <th>speed_kmh</th>\n",
       "      <th>avg_size</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>8327.000000</td>\n",
       "      <td>8327.000000</td>\n",
       "      <td>8327.000000</td>\n",
       "      <td>8327.000000</td>\n",
       "      <td>8327.000000</td>\n",
       "      <td>8327.000000</td>\n",
       "      <td>8327.000000</td>\n",
       "      <td>8327.000000</td>\n",
       "      <td>8327.000000</td>\n",
       "      <td>8327.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>15216.605981</td>\n",
       "      <td>2.060210</td>\n",
       "      <td>-0.993275</td>\n",
       "      <td>-0.933830</td>\n",
       "      <td>30.931668</td>\n",
       "      <td>2.062110</td>\n",
       "      <td>13.652838</td>\n",
       "      <td>7.339281</td>\n",
       "      <td>26.421440</td>\n",
       "      <td>7564.879428</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>12132.096735</td>\n",
       "      <td>0.807925</td>\n",
       "      <td>0.115787</td>\n",
       "      <td>0.356562</td>\n",
       "      <td>12.110936</td>\n",
       "      <td>0.807395</td>\n",
       "      <td>0.472729</td>\n",
       "      <td>2.126405</td>\n",
       "      <td>7.655146</td>\n",
       "      <td>2284.664951</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.589000</td>\n",
       "      <td>-1.000000</td>\n",
       "      <td>-1.000000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>0.600000</td>\n",
       "      <td>9.624000</td>\n",
       "      <td>1.050000</td>\n",
       "      <td>3.780000</td>\n",
       "      <td>2507.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>5492.000000</td>\n",
       "      <td>1.578000</td>\n",
       "      <td>-1.000000</td>\n",
       "      <td>-1.000000</td>\n",
       "      <td>24.000000</td>\n",
       "      <td>1.600000</td>\n",
       "      <td>13.541000</td>\n",
       "      <td>5.970000</td>\n",
       "      <td>21.490000</td>\n",
       "      <td>6104.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>12055.000000</td>\n",
       "      <td>1.866000</td>\n",
       "      <td>-1.000000</td>\n",
       "      <td>-1.000000</td>\n",
       "      <td>28.000000</td>\n",
       "      <td>1.867000</td>\n",
       "      <td>13.699000</td>\n",
       "      <td>7.320000</td>\n",
       "      <td>26.350000</td>\n",
       "      <td>7373.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>22113.500000</td>\n",
       "      <td>2.275500</td>\n",
       "      <td>-1.000000</td>\n",
       "      <td>-1.000000</td>\n",
       "      <td>34.000000</td>\n",
       "      <td>2.267000</td>\n",
       "      <td>13.850000</td>\n",
       "      <td>8.680000</td>\n",
       "      <td>31.250000</td>\n",
       "      <td>8750.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>50185.000000</td>\n",
       "      <td>11.401000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>171.000000</td>\n",
       "      <td>11.400000</td>\n",
       "      <td>17.167000</td>\n",
       "      <td>22.010000</td>\n",
       "      <td>79.240000</td>\n",
       "      <td>14992.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 id    time_diff        x_dir        y_dir   frame_diff  \\\n",
       "count   8327.000000  8327.000000  8327.000000  8327.000000  8327.000000   \n",
       "mean   15216.605981     2.060210    -0.993275    -0.933830    30.931668   \n",
       "std    12132.096735     0.807925     0.115787     0.356562    12.110936   \n",
       "min        1.000000     0.589000    -1.000000    -1.000000     9.000000   \n",
       "25%     5492.000000     1.578000    -1.000000    -1.000000    24.000000   \n",
       "50%    12055.000000     1.866000    -1.000000    -1.000000    28.000000   \n",
       "75%    22113.500000     2.275500    -1.000000    -1.000000    34.000000   \n",
       "max    50185.000000    11.401000     1.000000     1.000000   171.000000   \n",
       "\n",
       "       calculated_time  calculated_distance    speed_mps    speed_kmh  \\\n",
       "count      8327.000000          8327.000000  8327.000000  8327.000000   \n",
       "mean          2.062110            13.652838     7.339281    26.421440   \n",
       "std           0.807395             0.472729     2.126405     7.655146   \n",
       "min           0.600000             9.624000     1.050000     3.780000   \n",
       "25%           1.600000            13.541000     5.970000    21.490000   \n",
       "50%           1.867000            13.699000     7.320000    26.350000   \n",
       "75%           2.267000            13.850000     8.680000    31.250000   \n",
       "max          11.400000            17.167000    22.010000    79.240000   \n",
       "\n",
       "           avg_size  \n",
       "count   8327.000000  \n",
       "mean    7564.879428  \n",
       "std     2284.664951  \n",
       "min     2507.000000  \n",
       "25%     6104.500000  \n",
       "50%     7373.000000  \n",
       "75%     8750.500000  \n",
       "max    14992.000000  "
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[[\"id\", \"time_diff\", \"x_dir\", \"y_dir\", \"frame_diff\", \"calculated_time\", \"calculated_distance\", \"speed_mps\", \"speed_kmh\", \"avg_size\"]].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "0287228c-7dd8-4478-b278-870dfaecff0b",
   "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>id</th>\n",
       "      <th>time_diff</th>\n",
       "      <th>calculated_time</th>\n",
       "      <th>frame_diff</th>\n",
       "      <th>calculated_distance</th>\n",
       "      <th>speed_mps</th>\n",
       "      <th>speed_kmh</th>\n",
       "      <th>avg_size</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2555</th>\n",
       "      <td>27877.0</td>\n",
       "      <td>0.614</td>\n",
       "      <td>0.600</td>\n",
       "      <td>9.0</td>\n",
       "      <td>13.207</td>\n",
       "      <td>22.01</td>\n",
       "      <td>79.24</td>\n",
       "      <td>3144.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6107</th>\n",
       "      <td>28114.0</td>\n",
       "      <td>0.605</td>\n",
       "      <td>0.600</td>\n",
       "      <td>9.0</td>\n",
       "      <td>11.969</td>\n",
       "      <td>19.95</td>\n",
       "      <td>71.82</td>\n",
       "      <td>3825.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1143</th>\n",
       "      <td>19655.0</td>\n",
       "      <td>0.589</td>\n",
       "      <td>0.600</td>\n",
       "      <td>9.0</td>\n",
       "      <td>11.397</td>\n",
       "      <td>19.00</td>\n",
       "      <td>68.40</td>\n",
       "      <td>9138.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7239</th>\n",
       "      <td>8072.0</td>\n",
       "      <td>0.729</td>\n",
       "      <td>0.733</td>\n",
       "      <td>11.0</td>\n",
       "      <td>13.696</td>\n",
       "      <td>18.68</td>\n",
       "      <td>67.25</td>\n",
       "      <td>4004.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8104</th>\n",
       "      <td>26459.0</td>\n",
       "      <td>0.673</td>\n",
       "      <td>0.667</td>\n",
       "      <td>10.0</td>\n",
       "      <td>12.065</td>\n",
       "      <td>18.10</td>\n",
       "      <td>65.16</td>\n",
       "      <td>6709.0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>747</th>\n",
       "      <td>8517.0</td>\n",
       "      <td>9.339</td>\n",
       "      <td>9.333</td>\n",
       "      <td>140.0</td>\n",
       "      <td>13.040</td>\n",
       "      <td>1.40</td>\n",
       "      <td>5.04</td>\n",
       "      <td>4661.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7423</th>\n",
       "      <td>11261.0</td>\n",
       "      <td>10.077</td>\n",
       "      <td>10.067</td>\n",
       "      <td>151.0</td>\n",
       "      <td>13.694</td>\n",
       "      <td>1.36</td>\n",
       "      <td>4.90</td>\n",
       "      <td>5481.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>826</th>\n",
       "      <td>11602.0</td>\n",
       "      <td>9.600</td>\n",
       "      <td>9.600</td>\n",
       "      <td>144.0</td>\n",
       "      <td>13.080</td>\n",
       "      <td>1.36</td>\n",
       "      <td>4.90</td>\n",
       "      <td>3457.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>507</th>\n",
       "      <td>27152.0</td>\n",
       "      <td>11.401</td>\n",
       "      <td>11.400</td>\n",
       "      <td>171.0</td>\n",
       "      <td>12.712</td>\n",
       "      <td>1.12</td>\n",
       "      <td>4.03</td>\n",
       "      <td>4506.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>611</th>\n",
       "      <td>2247.0</td>\n",
       "      <td>9.414</td>\n",
       "      <td>9.400</td>\n",
       "      <td>141.0</td>\n",
       "      <td>9.866</td>\n",
       "      <td>1.05</td>\n",
       "      <td>3.78</td>\n",
       "      <td>2963.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8327 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           id  time_diff  calculated_time  frame_diff  calculated_distance  \\\n",
       "2555  27877.0      0.614            0.600         9.0               13.207   \n",
       "6107  28114.0      0.605            0.600         9.0               11.969   \n",
       "1143  19655.0      0.589            0.600         9.0               11.397   \n",
       "7239   8072.0      0.729            0.733        11.0               13.696   \n",
       "8104  26459.0      0.673            0.667        10.0               12.065   \n",
       "...       ...        ...              ...         ...                  ...   \n",
       "747    8517.0      9.339            9.333       140.0               13.040   \n",
       "7423  11261.0     10.077           10.067       151.0               13.694   \n",
       "826   11602.0      9.600            9.600       144.0               13.080   \n",
       "507   27152.0     11.401           11.400       171.0               12.712   \n",
       "611    2247.0      9.414            9.400       141.0                9.866   \n",
       "\n",
       "      speed_mps  speed_kmh  avg_size  \n",
       "2555      22.01      79.24    3144.0  \n",
       "6107      19.95      71.82    3825.0  \n",
       "1143      19.00      68.40    9138.0  \n",
       "7239      18.68      67.25    4004.0  \n",
       "8104      18.10      65.16    6709.0  \n",
       "...         ...        ...       ...  \n",
       "747        1.40       5.04    4661.0  \n",
       "7423       1.36       4.90    5481.0  \n",
       "826        1.36       4.90    3457.0  \n",
       "507        1.12       4.03    4506.0  \n",
       "611        1.05       3.78    2963.0  \n",
       "\n",
       "[8327 rows x 8 columns]"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[[\"id\", \"time_diff\",\"calculated_time\", \"frame_diff\", \"calculated_distance\", \"speed_mps\", \"speed_kmh\", \"avg_size\"]].sort_values(\"speed_kmh\", ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "2f1c7511-ae97-453d-91c5-798ac1a7e350",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "d6943411b8714a9d83e69b6cf16cb238",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "Canvas(toolbar=Toolbar(toolitems=[('Home', 'Reset original view', 'home', 'home'), ('Back', 'Back to previous …"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "7c6b3e62d31043cb850c2e9d210fd4d0",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "Canvas(toolbar=Toolbar(toolitems=[('Home', 'Reset original view', 'home', 'home'), ('Back', 'Back to previous …"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/plain": [
       "Text(0.5, 0, 'speed km/h')"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bins = [i for i in range(0, 70, 1)]\n",
    "plt.figure(0)\n",
    "data[data.speed_kmh > 35][[\"speed_kmh\"]].plot.hist(\"speed_kmh\", bins=bins, color=\"red\", legend=None, edgecolor=\"white\")\n",
    "data[data.speed_kmh <= 35].speed_kmh.plot.hist(\"speed_kmh\", bins=bins, color=\"green\", edgecolor=\"white\")\n",
    "plt.xlabel(\"speed km/h\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "245dff99-ff2f-44c9-be07-0a139fcdf5bf",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:xlabel='Hour of day', ylabel='Frequency'>"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "plt.figure(1)\n",
    "hours = data[\"datetime\"].dt.hour\n",
    "minutes = data.datetime.dt.minute\n",
    "bins = [i for i in range(6, 22)]\n",
    "data.datetime.dt.hour.plot.hist(edgecolor=\"white\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "d0961faf-4fc4-4bc9-beb4-eb4236460341",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "12.36940074456587"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(data[data.speed_kmh > 35])/len(data.speed_kmh) * 100"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "b49ee519-27db-4797-990a-0a3417c6a8ce",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1634"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(data[data.speed_kmh < 20])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "6999418e-a2b5-44cb-8a65-cc992ea5b9d8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "50d62e4e09b2407b90c6a63d2141e8e9",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "Canvas(toolbar=Toolbar(toolitems=[('Home', 'Reset original view', 'home', 'home'), ('Back', 'Back to previous …"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:xlabel='avg_size', ylabel='speed_kmh'>"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.plot.scatter(\"avg_size\", \"speed_kmh\", alpha=0.2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "39715c80-c351-4420-b665-637dd3f233a1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Text(37.06944598754247, 0.5, 'Speed km/h')"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Average speed per hour\n",
    "speed_sum_per_hour = data.groupby(data.datetime.dt.hour).agg('sum').speed_kmh\n",
    "ocassions_per_hour = data.groupby(data.datetime.dt.hour).count().datetime\n",
    "average_speed_per_hour = speed_sum_per_hour / ocassions_per_hour\n",
    "average_speed_per_hour.plot.bar(xlabel=\"Hour of day\", ylabel=\"Speed km/h\")\n",
    "plt.xlabel(\"Hour of day\")\n",
    "plt.ylabel(\"Speed km/h\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "10517d52-a898-4266-bf93-9c7710e91520",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}