LoraWAN-Loc.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 111,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    packetbroker\n",
      "1         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    packetbroker\n",
      "1         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    mtik-riosaliceto\n",
      "1        mtik-sitip01\n",
      "2             uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    mtik-sitip01\n",
      "1    packetbroker\n",
      "2         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    mtik-sitip01\n",
      "1         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    mtik-sitip01\n",
      "1    packetbroker\n",
      "2         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    mtik-sitip01\n",
      "1    packetbroker\n",
      "2         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    mtik-sitip01\n",
      "1         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    mtik-sitip01\n",
      "1         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    packetbroker\n",
      "1         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    mtik-sitip01\n",
      "1         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0        mtik-sitip01\n",
      "1    mtik-riosaliceto\n",
      "2        packetbroker\n",
      "3             uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    mtik-sitip01\n",
      "1         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0        mtik-sitip01\n",
      "1    mtik-riosaliceto\n",
      "2             uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    mtik-sitip01\n",
      "1    packetbroker\n",
      "2    packetbroker\n",
      "3         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    mtik-sitip01\n",
      "1    packetbroker\n",
      "2    packetbroker\n",
      "3         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    mtik-sitip01\n",
      "1    packetbroker\n",
      "2         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0        mtik-sitip01\n",
      "1    mtik-riosaliceto\n",
      "2             uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    mtik-sitip01\n",
      "1         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    mtik-sitip01\n",
      "1    packetbroker\n",
      "2         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    mtik-sitip01\n",
      "1    packetbroker\n",
      "2         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    mtik-sitip01\n",
      "1    packetbroker\n",
      "2         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0        mtik-sitip01\n",
      "1    mtik-riosaliceto\n",
      "2        packetbroker\n",
      "3             uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    packetbroker\n",
      "1         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    packetbroker\n",
      "1         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    packetbroker\n",
      "1         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    packetbroker\n",
      "1         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    packetbroker\n",
      "1         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    packetbroker\n",
      "1         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    packetbroker\n",
      "1         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    packetbroker\n",
      "1         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    packetbroker\n",
      "1         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    mtik-sitip01\n",
      "1    packetbroker\n",
      "2    packetbroker\n",
      "3    packetbroker\n",
      "4         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    packetbroker\n",
      "1    packetbroker\n",
      "2         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    packetbroker\n",
      "1    packetbroker\n",
      "2    packetbroker\n",
      "3         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    mtik-riosaliceto\n",
      "1        mtik-sitip01\n",
      "2        packetbroker\n",
      "3        packetbroker\n",
      "4        packetbroker\n",
      "5             uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    mtik-sitip01\n",
      "1    packetbroker\n",
      "2    packetbroker\n",
      "3    packetbroker\n",
      "4    packetbroker\n",
      "5    packetbroker\n",
      "6         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0        mtik-sitip01\n",
      "1    mtik-riosaliceto\n",
      "2             uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    mtik-sitip01\n",
      "1    packetbroker\n",
      "2    packetbroker\n",
      "3    packetbroker\n",
      "4    packetbroker\n",
      "5    packetbroker\n",
      "6         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    mtik-riosaliceto\n",
      "1        mtik-sitip01\n",
      "2        packetbroker\n",
      "3        packetbroker\n",
      "4             uniprgw\n",
      "5        packetbroker\n",
      "6        packetbroker\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0        mtik-sitip01\n",
      "1    mtik-riosaliceto\n",
      "2             uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    mtik-riosaliceto\n",
      "1        mtik-sitip01\n",
      "2        packetbroker\n",
      "3        packetbroker\n",
      "4        packetbroker\n",
      "5        packetbroker\n",
      "6             uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0        mtik-sitip01\n",
      "1    mtik-riosaliceto\n",
      "2        packetbroker\n",
      "3        packetbroker\n",
      "4             uniprgw\n",
      "5        packetbroker\n",
      "6        packetbroker\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    packetbroker\n",
      "1    packetbroker\n",
      "2    packetbroker\n",
      "3    packetbroker\n",
      "4    packetbroker\n",
      "5         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0        mtik-sitip01\n",
      "1    mtik-riosaliceto\n",
      "2        packetbroker\n",
      "3        packetbroker\n",
      "4             uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0        mtik-sitip01\n",
      "1    mtik-riosaliceto\n",
      "2        packetbroker\n",
      "3        packetbroker\n",
      "4        packetbroker\n",
      "5             uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0        mtik-sitip01\n",
      "1    mtik-riosaliceto\n",
      "2        packetbroker\n",
      "3        packetbroker\n",
      "4        packetbroker\n",
      "5        packetbroker\n",
      "6             uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    mtik-sitip01\n",
      "1    packetbroker\n",
      "2    packetbroker\n",
      "3    packetbroker\n",
      "4         uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n",
      "0    uniprgw\n",
      "Name: gateway_ids.gateway_id, dtype: object\n"
     ]
    }
   ],
   "source": [
    "from datetime import datetime, date, time, timedelta\n",
    "from itertools import islice\n",
    "from geopy.distance import great_circle\n",
    "from operator import itemgetter\n",
    "import matplotlib.pylab as plt\n",
    "from pandas import DataFrame\n",
    "from plotly.subplots import make_subplots\n",
    "import plotly.graph_objects as go\n",
    "import plotly.express as px\n",
    "import pandas as pd\n",
    "import numpy\n",
    "import json\n",
    "import math\n",
    "\n",
    "\n",
    "DELTA_GNSS = 0.05 #equivalent to about 5-6 km\n",
    "DELTA_GNSS_INIT = 1 #equivalent to about 5-6 km\n",
    "DELTA_POS = 0.0001 #equivalent to about 100 m\n",
    "\n",
    "#six decimal are enough for a decimeter precision\n",
    "#0.1 = 11.1 km\n",
    "#0.01 = 1.11 km\n",
    "#...\n",
    "#0.000001 = 0.111 m\n",
    "gw_latitude = 45.004831\n",
    "gw_longitude = 10.467967\n",
    "gw_coo = (gw_latitude, gw_longitude)\n",
    "\n",
    "#support variables\n",
    "bts_latitude = 0\n",
    "bts_longitude = 0\n",
    "\n",
    "#Import UAV Log network Ping data from JSON file\n",
    "data = []\n",
    "with open('LORAWAN_TTGO.json') as f:\n",
    "    for line in f:\n",
    "        try:\n",
    "            data.append(json.loads(line))\n",
    "        except:\n",
    "            print('Skip line')\n",
    "\n",
    "#Convert JSON data from Python dict to DF\n",
    "UAV_LOG = pd.json_normalize(data)\n",
    "\n",
    "#Drop unusfull data\n",
    "#UAV_LOG = UAV_LOG.drop(columns=['uav_param.status','uav_param.mode','interface','gps_param.groundspeed','gps_param.velocity.vx','uav_param.attitude.pitch','uav_param.attitude.yaw','uav_param.attitude.roll','gps_param.velocity.vy','gps_param.velocity.vz','gps_param.hdop','gps_param.vdop','gps_param.fix_type'])\n",
    "\n",
    "#Remove duplicate entries\n",
    "UAV_LOG = UAV_LOG.drop_duplicates('timestamp')\n",
    "UAV_LOG = UAV_LOG.apply(pd.to_numeric, errors='ignore')\n",
    "\n",
    "#Remove false flights\n",
    "#UAV_bench = UAV_LOG['uav_param.battery']>=10.0\n",
    "#UAV_LOG = UAV_LOG[UAV_bench]\n",
    "l = UAV_LOG['gateways']\n",
    "\n",
    "#l[1]['channel_rssi']\n",
    "#print(d)\n",
    "#print(l['gateway_ids']['gateway_id'])\n",
    "\n",
    "for i in range(len(l)):\n",
    "    d = pd.json_normalize(l[i])\n",
    "    print(str(d['gateway_ids.gateway_id']))\n",
    "    #if (d['gateway_ids.gateway_id'] == 'uniprgw'):\n",
    "    #    print(d['channel_rssi'])\n",
    "#Remove no GPS fix data\n",
    "#GPS_Null = UAV_LOG['gps_param.satellites']>=6\n",
    "#UAV_LOG = UAV_LOG[GPS_Null]\n",
    "\n",
    "#Sort by time for time clustering\n",
    "#UAV_LOG = UAV_LOG.sort_values(by='timestamp')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 112,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "0d3a1c210d5145cb96da431bb83fece0",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "Map(center=[45.004831, 10.467967], controls=(ZoomControl(options=['position', 'zoom_in_text', 'zoom_in_title',…"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "from ipyleaflet import Map, basemaps, Marker, Icon\n",
    "from ipywidgets import Layout\n",
    "\n",
    "zoom = 25\n",
    "\n",
    "icon_drone = Icon(icon_url='https://raw.githubusercontent.com/palia95/lora-Localization/main/icons/drone.png', icon_anchor=[16, 16], icon_size=[44, 44], rotate=True)\n",
    "icon_bts = Icon(icon_url='http://simpleicon.com/wp-content/uploads/antenna-2-64x64.png', icon_anchor=[32, 32], icon_size=[32, 32])\n",
    "\n",
    "#Remove log for same points\n",
    "UAV_LOG = UAV_LOG.round(6)\n",
    "UAV_LOG = UAV_LOG.drop_duplicates('latitude')\n",
    "UAV_LOG = UAV_LOG.drop_duplicates('longitude')\n",
    "\n",
    "m = Map(basemap=basemaps.OpenStreetMap.Mapnik, center=gw_coo, zoom=zoom, layout=Layout(width='100%', height='800px'))\n",
    "\n",
    "def MarkerDrone(uav_coo):\n",
    "    m.add_layer(Marker(location=uav_coo, icon=icon_drone, draggable=False))\n",
    "\n",
    "def MarkerGW(gw_coo):\n",
    "    m.add_layer(Marker(location=gw_coo, icon=icon_bts, draggable=False))\n",
    "\n",
    "    \n",
    "uav_flight = []\n",
    "log = 0\n",
    "\n",
    "MarkerGW(gw_coo)\n",
    "\n",
    "for log in range(len(UAV_LOG)):\n",
    "    uav_coo = (UAV_LOG.iloc[log]['latitude'], UAV_LOG.iloc[log]['longitude'])\n",
    "    distance = great_circle(uav_coo, gw_coo).m\n",
    "    l = UAV_LOG.iloc[log]['gateways']\n",
    "\n",
    "    for i in range(len(l)):\n",
    "        if (l[i]['gateway_ids']['gateway_id'] == 'uniprgw'):\n",
    "            rssi = l[i]['channel_rssi']\n",
    "            snr = l[i]['snr']\n",
    "\n",
    "            uav_flight.append((UAV_LOG.iloc[log]['timestamp'], UAV_LOG.iloc[log]['latitude'], UAV_LOG.iloc[log]['longitude'], UAV_LOG.iloc[log]['altitude'], distance, rssi, snr))\n",
    "            MarkerDrone(uav_coo)\n",
    "    #print(BTS.iloc[0])\n",
    "    #print(DF.iloc[log])\n",
    "#uav_flight\n",
    "\n",
    "m"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "metadata": {},
   "outputs": [],
   "source": [
    "DF = DataFrame (uav_flight)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 118,
   "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>time</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>altitude</th>\n",
       "      <th>distance</th>\n",
       "      <th>rssi</th>\n",
       "      <th>snr</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022-07-19T07:03:47.036096458Z</td>\n",
       "      <td>45.004825</td>\n",
       "      <td>10.467922</td>\n",
       "      <td>16</td>\n",
       "      <td>3.600265</td>\n",
       "      <td>-31</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022-07-19T07:05:07.434762820Z</td>\n",
       "      <td>45.004836</td>\n",
       "      <td>10.467836</td>\n",
       "      <td>14</td>\n",
       "      <td>10.314237</td>\n",
       "      <td>-37</td>\n",
       "      <td>13.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022-07-19T07:05:27.478161442Z</td>\n",
       "      <td>45.004868</td>\n",
       "      <td>10.467901</td>\n",
       "      <td>13</td>\n",
       "      <td>6.622068</td>\n",
       "      <td>-43</td>\n",
       "      <td>10.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022-07-19T07:10:28.716715410Z</td>\n",
       "      <td>45.005136</td>\n",
       "      <td>10.468008</td>\n",
       "      <td>22</td>\n",
       "      <td>34.067342</td>\n",
       "      <td>-57</td>\n",
       "      <td>14.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022-07-19T07:10:48.804194109Z</td>\n",
       "      <td>45.005426</td>\n",
       "      <td>10.468158</td>\n",
       "      <td>21</td>\n",
       "      <td>67.843786</td>\n",
       "      <td>-59</td>\n",
       "      <td>13.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2022-07-19T07:11:08.853045904Z</td>\n",
       "      <td>45.005887</td>\n",
       "      <td>10.468180</td>\n",
       "      <td>26</td>\n",
       "      <td>118.610095</td>\n",
       "      <td>-75</td>\n",
       "      <td>11.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2022-07-19T07:11:28.934541344Z</td>\n",
       "      <td>45.006617</td>\n",
       "      <td>10.468223</td>\n",
       "      <td>31</td>\n",
       "      <td>199.611667</td>\n",
       "      <td>-74</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2022-07-19T07:11:49.015840975Z</td>\n",
       "      <td>45.007658</td>\n",
       "      <td>10.468201</td>\n",
       "      <td>31</td>\n",
       "      <td>314.886357</td>\n",
       "      <td>-68</td>\n",
       "      <td>14.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2022-07-19T07:12:09.112394359Z</td>\n",
       "      <td>45.008666</td>\n",
       "      <td>10.468051</td>\n",
       "      <td>30</td>\n",
       "      <td>426.484278</td>\n",
       "      <td>-70</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2022-07-19T07:12:29.172815746Z</td>\n",
       "      <td>45.009632</td>\n",
       "      <td>10.467815</td>\n",
       "      <td>30</td>\n",
       "      <td>533.981323</td>\n",
       "      <td>-74</td>\n",
       "      <td>13.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2022-07-19T07:12:49.258364203Z</td>\n",
       "      <td>45.010705</td>\n",
       "      <td>10.467665</td>\n",
       "      <td>31</td>\n",
       "      <td>653.591286</td>\n",
       "      <td>-81</td>\n",
       "      <td>11.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2022-07-19T07:13:09.335863945Z</td>\n",
       "      <td>45.011874</td>\n",
       "      <td>10.467643</td>\n",
       "      <td>47</td>\n",
       "      <td>783.561085</td>\n",
       "      <td>-81</td>\n",
       "      <td>13.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2022-07-19T07:14:29.607489420Z</td>\n",
       "      <td>45.017249</td>\n",
       "      <td>10.467793</td>\n",
       "      <td>65</td>\n",
       "      <td>1380.888297</td>\n",
       "      <td>-82</td>\n",
       "      <td>13.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2022-07-19T07:16:30.083799028Z</td>\n",
       "      <td>45.017239</td>\n",
       "      <td>10.467708</td>\n",
       "      <td>64</td>\n",
       "      <td>1379.858820</td>\n",
       "      <td>-82</td>\n",
       "      <td>13.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2022-07-19T07:16:50.165446648Z</td>\n",
       "      <td>45.016423</td>\n",
       "      <td>10.467622</td>\n",
       "      <td>64</td>\n",
       "      <td>1289.258707</td>\n",
       "      <td>-83</td>\n",
       "      <td>13.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2022-07-19T07:17:10.240681671Z</td>\n",
       "      <td>45.015597</td>\n",
       "      <td>10.467536</td>\n",
       "      <td>65</td>\n",
       "      <td>1197.605656</td>\n",
       "      <td>-86</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2022-07-19T07:17:30.323398882Z</td>\n",
       "      <td>45.014749</td>\n",
       "      <td>10.467450</td>\n",
       "      <td>65</td>\n",
       "      <td>1103.581504</td>\n",
       "      <td>-85</td>\n",
       "      <td>13.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2022-07-19T07:17:50.402311346Z</td>\n",
       "      <td>45.013913</td>\n",
       "      <td>10.467364</td>\n",
       "      <td>65</td>\n",
       "      <td>1010.985732</td>\n",
       "      <td>-87</td>\n",
       "      <td>13.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2022-07-19T07:18:10.483461323Z</td>\n",
       "      <td>45.013086</td>\n",
       "      <td>10.467257</td>\n",
       "      <td>65</td>\n",
       "      <td>919.610880</td>\n",
       "      <td>-80</td>\n",
       "      <td>9.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2022-07-19T07:18:50.658837451Z</td>\n",
       "      <td>45.011434</td>\n",
       "      <td>10.467085</td>\n",
       "      <td>63</td>\n",
       "      <td>737.488017</td>\n",
       "      <td>-79</td>\n",
       "      <td>10.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2022-07-19T07:19:10.729980805Z</td>\n",
       "      <td>45.010651</td>\n",
       "      <td>10.467021</td>\n",
       "      <td>60</td>\n",
       "      <td>651.414711</td>\n",
       "      <td>-77</td>\n",
       "      <td>13.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2022-07-19T07:19:30.813732900Z</td>\n",
       "      <td>45.009879</td>\n",
       "      <td>10.466978</td>\n",
       "      <td>61</td>\n",
       "      <td>566.672217</td>\n",
       "      <td>-79</td>\n",
       "      <td>13.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2022-07-19T07:19:50.898980301Z</td>\n",
       "      <td>45.009106</td>\n",
       "      <td>10.466914</td>\n",
       "      <td>60</td>\n",
       "      <td>482.513569</td>\n",
       "      <td>-86</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2022-07-19T07:20:10.986596830Z</td>\n",
       "      <td>45.008334</td>\n",
       "      <td>10.466999</td>\n",
       "      <td>59</td>\n",
       "      <td>396.880993</td>\n",
       "      <td>-81</td>\n",
       "      <td>13.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2022-07-19T07:20:31.055768656Z</td>\n",
       "      <td>45.007583</td>\n",
       "      <td>10.467042</td>\n",
       "      <td>59</td>\n",
       "      <td>314.531246</td>\n",
       "      <td>-68</td>\n",
       "      <td>13.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2022-07-19T07:20:51.135235958Z</td>\n",
       "      <td>45.006853</td>\n",
       "      <td>10.467107</td>\n",
       "      <td>59</td>\n",
       "      <td>234.782530</td>\n",
       "      <td>-68</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2022-07-19T07:21:11.297457992Z</td>\n",
       "      <td>45.006134</td>\n",
       "      <td>10.467193</td>\n",
       "      <td>60</td>\n",
       "      <td>157.147007</td>\n",
       "      <td>-67</td>\n",
       "      <td>13.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2022-07-19T07:21:31.307151341Z</td>\n",
       "      <td>45.005458</td>\n",
       "      <td>10.467493</td>\n",
       "      <td>60</td>\n",
       "      <td>79.053904</td>\n",
       "      <td>-59</td>\n",
       "      <td>10.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2022-07-19T07:21:51.401840809Z</td>\n",
       "      <td>45.005190</td>\n",
       "      <td>10.467750</td>\n",
       "      <td>43</td>\n",
       "      <td>43.411874</td>\n",
       "      <td>-56</td>\n",
       "      <td>13.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2022-07-19T07:22:11.500047507Z</td>\n",
       "      <td>45.005029</td>\n",
       "      <td>10.467772</td>\n",
       "      <td>19</td>\n",
       "      <td>26.828502</td>\n",
       "      <td>-47</td>\n",
       "      <td>13.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2022-07-19T07:22:31.557962391Z</td>\n",
       "      <td>45.005297</td>\n",
       "      <td>10.467171</td>\n",
       "      <td>24</td>\n",
       "      <td>81.249145</td>\n",
       "      <td>-54</td>\n",
       "      <td>12.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2022-07-19T07:24:11.975401948Z</td>\n",
       "      <td>45.004975</td>\n",
       "      <td>10.470132</td>\n",
       "      <td>30</td>\n",
       "      <td>170.963929</td>\n",
       "      <td>-61</td>\n",
       "      <td>13.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2022-07-19T07:24:52.136517350Z</td>\n",
       "      <td>45.004997</td>\n",
       "      <td>10.469660</td>\n",
       "      <td>28</td>\n",
       "      <td>134.377530</td>\n",
       "      <td>-63</td>\n",
       "      <td>13.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2022-07-19T07:25:12.224186385Z</td>\n",
       "      <td>45.005008</td>\n",
       "      <td>10.468823</td>\n",
       "      <td>28</td>\n",
       "      <td>70.117656</td>\n",
       "      <td>-61</td>\n",
       "      <td>13.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2022-07-19T07:28:33.075621253Z</td>\n",
       "      <td>45.005147</td>\n",
       "      <td>10.466334</td>\n",
       "      <td>30</td>\n",
       "      <td>133.107914</td>\n",
       "      <td>-56</td>\n",
       "      <td>13.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2022-07-19T07:28:53.150175493Z</td>\n",
       "      <td>45.005287</td>\n",
       "      <td>10.465090</td>\n",
       "      <td>43</td>\n",
       "      <td>231.802939</td>\n",
       "      <td>-62</td>\n",
       "      <td>11.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2022-07-19T07:29:33.271645071Z</td>\n",
       "      <td>45.005673</td>\n",
       "      <td>10.462536</td>\n",
       "      <td>44</td>\n",
       "      <td>437.127388</td>\n",
       "      <td>-69</td>\n",
       "      <td>13.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>2022-07-19T07:30:53.640813139Z</td>\n",
       "      <td>45.006703</td>\n",
       "      <td>10.457515</td>\n",
       "      <td>67</td>\n",
       "      <td>847.679588</td>\n",
       "      <td>-72</td>\n",
       "      <td>14.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>2022-07-19T07:31:13.736741435Z</td>\n",
       "      <td>45.006939</td>\n",
       "      <td>10.456356</td>\n",
       "      <td>68</td>\n",
       "      <td>942.456083</td>\n",
       "      <td>-71</td>\n",
       "      <td>10.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>2022-07-19T07:31:53.902111745Z</td>\n",
       "      <td>45.007508</td>\n",
       "      <td>10.453610</td>\n",
       "      <td>67</td>\n",
       "      <td>1167.314625</td>\n",
       "      <td>-73</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>2022-07-19T07:32:13.950291453Z</td>\n",
       "      <td>45.007786</td>\n",
       "      <td>10.452279</td>\n",
       "      <td>70</td>\n",
       "      <td>1276.380068</td>\n",
       "      <td>-74</td>\n",
       "      <td>12.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>2022-07-19T07:33:34.267240655Z</td>\n",
       "      <td>45.008301</td>\n",
       "      <td>10.449833</td>\n",
       "      <td>73</td>\n",
       "      <td>1476.946130</td>\n",
       "      <td>-74</td>\n",
       "      <td>14.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>2022-07-19T07:35:14.688836904Z</td>\n",
       "      <td>45.007604</td>\n",
       "      <td>10.453116</td>\n",
       "      <td>74</td>\n",
       "      <td>1207.589338</td>\n",
       "      <td>-74</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>2022-07-19T07:35:54.845026418Z</td>\n",
       "      <td>45.007304</td>\n",
       "      <td>10.454554</td>\n",
       "      <td>75</td>\n",
       "      <td>1089.774005</td>\n",
       "      <td>-73</td>\n",
       "      <td>10.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>2022-07-19T07:36:14.929581654Z</td>\n",
       "      <td>45.007132</td>\n",
       "      <td>10.455284</td>\n",
       "      <td>71</td>\n",
       "      <td>1029.422995</td>\n",
       "      <td>-73</td>\n",
       "      <td>14.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>2022-07-19T07:36:35.015845310Z</td>\n",
       "      <td>45.006982</td>\n",
       "      <td>10.455992</td>\n",
       "      <td>70</td>\n",
       "      <td>971.366104</td>\n",
       "      <td>-73</td>\n",
       "      <td>13.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>2022-07-19T07:36:55.080342803Z</td>\n",
       "      <td>45.006842</td>\n",
       "      <td>10.456635</td>\n",
       "      <td>71</td>\n",
       "      <td>918.542412</td>\n",
       "      <td>-73</td>\n",
       "      <td>10.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>2022-07-19T07:37:15.165758358Z</td>\n",
       "      <td>45.006714</td>\n",
       "      <td>10.457215</td>\n",
       "      <td>72</td>\n",
       "      <td>870.855545</td>\n",
       "      <td>-73</td>\n",
       "      <td>14.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>2022-07-19T07:39:35.729465840Z</td>\n",
       "      <td>45.005641</td>\n",
       "      <td>10.462279</td>\n",
       "      <td>65</td>\n",
       "      <td>456.168468</td>\n",
       "      <td>-68</td>\n",
       "      <td>14.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>2022-07-19T07:40:35.980680651Z</td>\n",
       "      <td>45.006209</td>\n",
       "      <td>10.464682</td>\n",
       "      <td>59</td>\n",
       "      <td>300.297900</td>\n",
       "      <td>-65</td>\n",
       "      <td>15.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>2022-07-19T07:42:58.188504294Z</td>\n",
       "      <td>45.005244</td>\n",
       "      <td>10.467879</td>\n",
       "      <td>32</td>\n",
       "      <td>46.441798</td>\n",
       "      <td>-54</td>\n",
       "      <td>12.2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                              time   latitude  longitude  altitude  \\\n",
       "0   2022-07-19T07:03:47.036096458Z  45.004825  10.467922        16   \n",
       "1   2022-07-19T07:05:07.434762820Z  45.004836  10.467836        14   \n",
       "2   2022-07-19T07:05:27.478161442Z  45.004868  10.467901        13   \n",
       "3   2022-07-19T07:10:28.716715410Z  45.005136  10.468008        22   \n",
       "4   2022-07-19T07:10:48.804194109Z  45.005426  10.468158        21   \n",
       "5   2022-07-19T07:11:08.853045904Z  45.005887  10.468180        26   \n",
       "6   2022-07-19T07:11:28.934541344Z  45.006617  10.468223        31   \n",
       "7   2022-07-19T07:11:49.015840975Z  45.007658  10.468201        31   \n",
       "8   2022-07-19T07:12:09.112394359Z  45.008666  10.468051        30   \n",
       "9   2022-07-19T07:12:29.172815746Z  45.009632  10.467815        30   \n",
       "10  2022-07-19T07:12:49.258364203Z  45.010705  10.467665        31   \n",
       "11  2022-07-19T07:13:09.335863945Z  45.011874  10.467643        47   \n",
       "12  2022-07-19T07:14:29.607489420Z  45.017249  10.467793        65   \n",
       "13  2022-07-19T07:16:30.083799028Z  45.017239  10.467708        64   \n",
       "14  2022-07-19T07:16:50.165446648Z  45.016423  10.467622        64   \n",
       "15  2022-07-19T07:17:10.240681671Z  45.015597  10.467536        65   \n",
       "16  2022-07-19T07:17:30.323398882Z  45.014749  10.467450        65   \n",
       "17  2022-07-19T07:17:50.402311346Z  45.013913  10.467364        65   \n",
       "18  2022-07-19T07:18:10.483461323Z  45.013086  10.467257        65   \n",
       "19  2022-07-19T07:18:50.658837451Z  45.011434  10.467085        63   \n",
       "20  2022-07-19T07:19:10.729980805Z  45.010651  10.467021        60   \n",
       "21  2022-07-19T07:19:30.813732900Z  45.009879  10.466978        61   \n",
       "22  2022-07-19T07:19:50.898980301Z  45.009106  10.466914        60   \n",
       "23  2022-07-19T07:20:10.986596830Z  45.008334  10.466999        59   \n",
       "24  2022-07-19T07:20:31.055768656Z  45.007583  10.467042        59   \n",
       "25  2022-07-19T07:20:51.135235958Z  45.006853  10.467107        59   \n",
       "26  2022-07-19T07:21:11.297457992Z  45.006134  10.467193        60   \n",
       "27  2022-07-19T07:21:31.307151341Z  45.005458  10.467493        60   \n",
       "28  2022-07-19T07:21:51.401840809Z  45.005190  10.467750        43   \n",
       "29  2022-07-19T07:22:11.500047507Z  45.005029  10.467772        19   \n",
       "30  2022-07-19T07:22:31.557962391Z  45.005297  10.467171        24   \n",
       "31  2022-07-19T07:24:11.975401948Z  45.004975  10.470132        30   \n",
       "32  2022-07-19T07:24:52.136517350Z  45.004997  10.469660        28   \n",
       "33  2022-07-19T07:25:12.224186385Z  45.005008  10.468823        28   \n",
       "34  2022-07-19T07:28:33.075621253Z  45.005147  10.466334        30   \n",
       "35  2022-07-19T07:28:53.150175493Z  45.005287  10.465090        43   \n",
       "36  2022-07-19T07:29:33.271645071Z  45.005673  10.462536        44   \n",
       "37  2022-07-19T07:30:53.640813139Z  45.006703  10.457515        67   \n",
       "38  2022-07-19T07:31:13.736741435Z  45.006939  10.456356        68   \n",
       "39  2022-07-19T07:31:53.902111745Z  45.007508  10.453610        67   \n",
       "40  2022-07-19T07:32:13.950291453Z  45.007786  10.452279        70   \n",
       "41  2022-07-19T07:33:34.267240655Z  45.008301  10.449833        73   \n",
       "42  2022-07-19T07:35:14.688836904Z  45.007604  10.453116        74   \n",
       "43  2022-07-19T07:35:54.845026418Z  45.007304  10.454554        75   \n",
       "44  2022-07-19T07:36:14.929581654Z  45.007132  10.455284        71   \n",
       "45  2022-07-19T07:36:35.015845310Z  45.006982  10.455992        70   \n",
       "46  2022-07-19T07:36:55.080342803Z  45.006842  10.456635        71   \n",
       "47  2022-07-19T07:37:15.165758358Z  45.006714  10.457215        72   \n",
       "48  2022-07-19T07:39:35.729465840Z  45.005641  10.462279        65   \n",
       "49  2022-07-19T07:40:35.980680651Z  45.006209  10.464682        59   \n",
       "50  2022-07-19T07:42:58.188504294Z  45.005244  10.467879        32   \n",
       "\n",
       "       distance  rssi   snr  \n",
       "0      3.600265   -31  13.0  \n",
       "1     10.314237   -37  13.5  \n",
       "2      6.622068   -43  10.5  \n",
       "3     34.067342   -57  14.0  \n",
       "4     67.843786   -59  13.8  \n",
       "5    118.610095   -75  11.8  \n",
       "6    199.611667   -74  13.0  \n",
       "7    314.886357   -68  14.0  \n",
       "8    426.484278   -70  11.0  \n",
       "9    533.981323   -74  13.8  \n",
       "10   653.591286   -81  11.2  \n",
       "11   783.561085   -81  13.2  \n",
       "12  1380.888297   -82  13.2  \n",
       "13  1379.858820   -82  13.5  \n",
       "14  1289.258707   -83  13.5  \n",
       "15  1197.605656   -86  10.0  \n",
       "16  1103.581504   -85  13.8  \n",
       "17  1010.985732   -87  13.8  \n",
       "18   919.610880   -80   9.5  \n",
       "19   737.488017   -79  10.5  \n",
       "20   651.414711   -77  13.5  \n",
       "21   566.672217   -79  13.5  \n",
       "22   482.513569   -86   9.0  \n",
       "23   396.880993   -81  13.5  \n",
       "24   314.531246   -68  13.5  \n",
       "25   234.782530   -68  10.0  \n",
       "26   157.147007   -67  13.5  \n",
       "27    79.053904   -59  10.2  \n",
       "28    43.411874   -56  13.5  \n",
       "29    26.828502   -47  13.8  \n",
       "30    81.249145   -54  12.0  \n",
       "31   170.963929   -61  13.5  \n",
       "32   134.377530   -63  13.2  \n",
       "33    70.117656   -61  13.8  \n",
       "34   133.107914   -56  13.5  \n",
       "35   231.802939   -62  11.2  \n",
       "36   437.127388   -69  13.5  \n",
       "37   847.679588   -72  14.0  \n",
       "38   942.456083   -71  10.5  \n",
       "39  1167.314625   -73  11.0  \n",
       "40  1276.380068   -74  12.5  \n",
       "41  1476.946130   -74  14.5  \n",
       "42  1207.589338   -74  10.0  \n",
       "43  1089.774005   -73  10.8  \n",
       "44  1029.422995   -73  14.0  \n",
       "45   971.366104   -73  13.5  \n",
       "46   918.542412   -73  10.8  \n",
       "47   870.855545   -73  14.5  \n",
       "48   456.168468   -68  14.5  \n",
       "49   300.297900   -65  15.5  \n",
       "50    46.441798   -54  12.2  "
      ]
     },
     "execution_count": 118,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "DF.columns = [\"time\", \"latitude\", \"longitude\", \"altitude\", \"distance\", \"rssi\", \"snr\"]\n",
    "DF"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "8f3421ac5b404ecc877a0e8d551e75a0",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "Map(center=[0.0, 0.0], controls=(ZoomControl(options=['position', 'zoom_in_text', 'zoom_in_title', 'zoom_out_t…"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "from ipyleaflet import Map, basemaps, Marker, Icon\n",
    "from ipywidgets import Layout\n",
    "\n",
    "zoom = 25\n",
    "DF = UAV_LOG\n",
    "\n",
    "icon_drone = Icon(icon_url='https://raw.githubusercontent.com/palia95/LoRa-Localization/main/icons/drone_plane.png', icon_anchor=[16, 16], icon_size=[44, 44], rotate=True)\n",
    "icon_bts = Icon(icon_url='http://simpleicon.com/wp-content/uploads/antenna-2-64x64.png', icon_anchor=[32, 32], icon_size=[32, 32])\n",
    "\n",
    "#Remove log for same points\n",
    "#DF = DF.round(5)\n",
    "DF = DF.drop_duplicates('latitude')\n",
    "DF = DF.drop_duplicates('longitude')\n",
    "\n",
    "m = Map(basemap=basemaps.OpenStreetMap.Mapnik, zoom=zoom, layout=Layout(width='100%', height='800px'))\n",
    "\n",
    "def MarkerDrone(uav_coo):\n",
    "    m.add_layer(Marker(location=uav_coo, icon=icon_drone, draggable=False))\n",
    "\n",
    "def MarkerGW(gw_coo):\n",
    "    m.add_layer(Marker(location=gw_coo, icon=icon_bts, draggable=False))\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "m"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.8.12 ('base')",
   "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.12"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "7eef852e22c39fca4471d89a3d6b1f03cc55d0eaf129c816dabfc6b6d1a36433"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}