get_IOT_data.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The first section only have exploratory trials..."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "## This function will use CKAN api to get packages list plus the url for the resources under each entity \n",
    "## The results are stored in a pandas DF\n",
    "\n",
    "import pprint\n",
    "import requests\n",
    "import pandas as pd\n",
    "\n",
    "def getPackageList(url_api):\n",
    "    r = requests.get(url_api)\n",
    "    j = r.json()\n",
    "    return(pd.DataFrame({\"package_id\": j['result']}))\n",
    "\n",
    "def getResourceUrl(package_id):\n",
    "    url = \"https://opendata.porto.hackacity.eu\" + \"/api/3/action/package_show?id=\" + package_id;  \n",
    "    r = requests.get(url)\n",
    "    j = r.json()\n",
    "    return(j['result']['resources'][0]['url'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "## Usage\n",
    "\n",
    "url_api = \"https://opendata.porto.hackacity.eu/api/3/action/package_list\"\n",
    "df = getPackageList(url_api)\n",
    "\n",
    "df[\"resource_url\"] = list(map(getResourceUrl, df[\"package_id\"]))\n",
    "\n",
    "#print(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "## Get packageIds as a list\n",
    "\n",
    "def getPackageIds(url):\n",
    "    r = requests.get(url)\n",
    "    j = r.json()\n",
    "    return(j['result'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "## Usage\n",
    "\n",
    "url = \"https://opendata.porto.hackacity.eu/api/3/action/package_list\";\n",
    "packageIdsList = getPackageIds(url)\n",
    "#print(packageIdsList)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 279,
   "metadata": {},
   "outputs": [],
   "source": [
    "## For a list of packagesIds extract the available metadata and store the results in a pandas DF\n",
    "\n",
    "from pandas.io.json import json_normalize\n",
    "\n",
    "def normalizeJSON(url, package_id):\n",
    "    url = url + package_id;  \n",
    "    r = requests.get(url)\n",
    "    j = r.json()\n",
    "    return(json_normalize(j['result']))\n",
    "\n",
    "def appendRowToDF(df1, df2):\n",
    "    df = pd.DataFrame()\n",
    "    if df1.empty: \n",
    "        df = df1.copy()\n",
    "    else:\n",
    "        df = pd.concat([df1,df2])\n",
    "    return(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "## Usage\n",
    "\n",
    "packagesMetadata = pd.DataFrame()\n",
    "url = \"https://opendata.porto.hackacity.eu/api/3/action/package_show?id=\"\n",
    "for packageId in packageIdsList:\n",
    "    row = normalizeJSON(url, packageId)\n",
    "    packagesMetadata = appendRowToDF(packagesMetadata, row)  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "## Request live data and store the result in a panda DF\n",
    "\n",
    "import requests\n",
    "import pprint\n",
    "import pandas\n",
    "from pandas.io.json import json_normalize\n",
    "\n",
    "def getLiveData(api_url, package_id = None, device_id = None):\n",
    "    if (package_id is None) and (device_id is not None):\n",
    "        url = api_url + \"/v2/entities?id=\" + device_id\n",
    "    elif (package_id is not None) and (device_id is None):\n",
    "        url = api_url + \"/v2/entities?type=\" + package_id\n",
    "    else:\n",
    "        raise Exception(\"package_id or device_id required or are simultaneous defined!\")\n",
    "\n",
    "    print(url)\n",
    "    \n",
    "    r = requests.get(url)\n",
    "    j = r.json()\n",
    "    #pprint.pprint(j)\n",
    "    return(json_normalize(j))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 256,
   "metadata": {},
   "outputs": [],
   "source": [
    "## Example with error\n",
    "#api_url = \"https://broker.fiware.urbanplatform.portodigital.pt\"\n",
    "#df = getLiveData(api_url)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://broker.fiware.urbanplatform.portodigital.pt/v2/entities?type=AirQualityObserved\n"
     ]
    }
   ],
   "source": [
    "## Example without device id\n",
    "api_url = \"https://broker.fiware.urbanplatform.portodigital.pt\"\n",
    "package_id = \"AirQualityObserved\"\n",
    "df = getLiveData(api_url, package_id)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://broker.fiware.urbanplatform.portodigital.pt/v2/entities?id=urn:ngsi-ld:AirQualityObserved:porto:environment:ubiwhere:5adf39366f555a4514e7ea54\n"
     ]
    }
   ],
   "source": [
    "## Example with device id\n",
    "api_url = \"https://broker.fiware.urbanplatform.portodigital.pt\"\n",
    "device_id = \"urn:ngsi-ld:AirQualityObserved:porto:environment:ubiwhere:5adf39366f555a4514e7ea54\"\n",
    "df = getLiveData(api_url, device_id = device_id)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "## Example \n",
    "## require getHistoricalData function declared below!!!\n",
    "\n",
    "#resource_list = ['urn:ngsi-ld:AirQualityObserved:porto:environment:ubiwhere:5adf39366f555a4514e7ea54', \n",
    "#                 'urn:ngsi-ld:AirQualityObserved:porto:environment:ubiwhere:5b97a1bde521e3053085c08c', \n",
    "#                 'urn:ngsi-ld:AirQualityObserved:porto:environment:ubiwhere:5b632f2706599b05e998bed8',\n",
    "#                 'urn:ngsi-ld:AirQualityObserved:porto:environment:ubiwhere:5b72dbfa06599b05e9a74f27',\n",
    "#                 'urn:ngsi-ld:AirQualityObserved:porto:environment:ubiwhere:5b97a1a6e521e3053085c067']\n",
    "\n",
    "#api_url = \"http://history-data.urbanplatform.portodigital.pt\"\n",
    "\n",
    "#df = pd.DataFrame()\n",
    "#for resource in resource_list:\n",
    "#    print(resource)\n",
    "#    df1 = getHistoricalData(api_url, device_id = resource, no=500)\n",
    "#    #print(df1.columns)\n",
    "#    if df.empty:\n",
    "#        df = df1.copy()\n",
    "#    else:\n",
    "#        df = pd.concat([df,df1])\n",
    "#    #print(df.columns)   "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "\n",
    "From this point forward are the sequential steps to get the IOT data...\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "## List IOT entities\n",
    "import requests\n",
    "import json\n",
    "\n",
    "def getListIOTEntities(api_url):\n",
    "    url = api_url + \"/v2/types\"\n",
    "    r = requests.get(url)\n",
    "    j = r.json()\n",
    "    entity_list = []\n",
    "    for item in j:\n",
    "        #print(item['type'])\n",
    "        entity_list.append(item['type'])\n",
    "    return(entity_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['AirQualityObserved', 'ArrivalEstimation', 'Device', 'Event', 'GtfsTransitFeedFile', 'NoiseLevelObserved', 'OffStreetParking', 'PointOfInterest', 'TrafficFlowObserved', 'Vehicle', 'WeatherForecast', 'WeatherObserved', 'gtfsAgency', 'gtfsCalendarDateRule', 'gtfsCalendarRule', 'gtfsRoute', 'gtfsService', 'gtfsStop']\n"
     ]
    }
   ],
   "source": [
    "api_url = \"https://broker.fiware.urbanplatform.portodigital.pt\"\n",
    "entity_list = getListIOTEntities(api_url)\n",
    "print(entity_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "## Reduce entity_list to the ones of interest (MANUAL STEP)\n",
    "\n",
    "#1 entity_list = ['AirQualityObserved']\n",
    "#2 entity_list = ['NoiseLevelObserved']\n",
    "#3 entity_list = ['TrafficFlowObserved']\n",
    "entity_list = ['WeatherObserved']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "## Get list of all available resources/devices for an entity\n",
    "\n",
    "import requests\n",
    "import pprint\n",
    "\n",
    "def getResourceList(api_url, entity_name):\n",
    "    # First let's the ID's from the FiWare\n",
    "    url = api_url + \"/v2/entities?type=\" + entity_name\n",
    "    #print(url)\n",
    "    r = requests.get(url, verify=False)\n",
    "    j = r.json()\n",
    "    #print(j)\n",
    "    resources_list = []\n",
    "    for resource in j: \n",
    "      resources_list.append(resource['id'])\n",
    "    return(resources_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "WeatherObserved\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/cha1av/dev/hackacity/env/lib/python3.5/site-packages/urllib3/connectionpool.py:847: InsecureRequestWarning: Unverified HTTPS request is being made. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings\n",
      "  InsecureRequestWarning)\n"
     ]
    }
   ],
   "source": [
    "api_url = \"https://broker.fiware.urbanplatform.portodigital.pt\"\n",
    "\n",
    "resource_list = []\n",
    "for entity in entity_list:\n",
    "    print(entity)\n",
    "    resource_list.append(getResourceList(api_url, entity))    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#print(resource_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Flat resource_list\n",
    "resource_list_flat = [item for sublist in resource_list for item in sublist]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Remove stuff that is giving errors\n",
    "#resource_list_flat.remove('Trindade_1_Rotacao')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['urn:ngsi-ld:WeatherObserved:porto:weather:communityStations:IPORTUGA71', 'urn:ngsi-ld:WeatherObserved:porto:weather:communityStations:IPORTOPO9', 'urn:ngsi-ld:WeatherObserved:porto:weather:communityStations:IPORTOPO4', 'urn:ngsi-ld:WeatherObserved:porto:weather:ubiwhere:5ad613dd3da2520542bc871a', 'urn:ngsi-ld:WeatherObserved:porto:weather:ubiwhere:5ad615bb3da2520542bc87fb', 'urn:ngsi-ld:WeatherObserved:porto:weather:ubiwhere:5ad616a53da2520542bc8859', 'urn:ngsi-ld:WeatherObserved:porto:weather:communityStations:IPORTO36', 'urn:ngsi-ld:WeatherObserved:porto:weather:ubiwhere:5b87a6eb0dde591949bb8b5e', 'urn:ngsi-ld:WeatherObserved:porto:weather:ubiwhere:5b87a6b60dde591949bb8b5b', 'urn:ngsi-ld:WeatherObserved:porto:weather:ubiwhere:5b87a6cc0dde591949bb8b5c', 'urn:ngsi-ld:WeatherObserved:porto:weather:ubiwhere:5b87a6dc0dde591949bb8b5d', 'urn:ngsi-ld:WeatherObserved:porto:weather:ubiwhere:5b97a1bde521e3053085c08c', 'urn:ngsi-ld:WeatherObserved:porto:weather:ubiwhere:5b72dbfa06599b05e9a74f27', 'urn:ngsi-ld:WeatherObserved:porto:weather:ubiwhere:5adf39366f555a4514e7ea54', 'urn:ngsi-ld:WeatherObserved:porto:weather:communityStations:IPORTO39', 'urn:ngsi-ld:WeatherObserved:porto:weather:ubiwhere:5b97a1a6e521e3053085c067', 'urn:ngsi-ld:WeatherObserved:porto:weather:ubiwhere:5b632f2706599b05e998bed8']\n"
     ]
    }
   ],
   "source": [
    "print(resource_list_flat)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "## Request historical data with resource_id and store the results as a panda DF for a single device\n",
    "\n",
    "import requests\n",
    "import pprint\n",
    "import pandas\n",
    "from pandas.io.json import json_normalize\n",
    "\n",
    "def convertJSONHistoricalToDF(j, entity = None):\n",
    "    print(entity)\n",
    "    if (entity is (None or \"NoiseLevelObserved\" or \"AirQualityObserved\")):\n",
    "        df = pd.DataFrame()\n",
    "        for i in range(0,len(j['data']['attributes'])):\n",
    "            df[j['data']['attributes'][i]['attrName']] = j['data']['attributes'][i]['values']\n",
    "        ## expand location attributes\n",
    "        #for key in df['location'][0].keys():\n",
    "        #    df[key] = str(df['location'][0][key])\n",
    "        df['long'] = df['location'][0]['coordinates'][0]\n",
    "        df['lat'] = df['location'][0]['coordinates'][1]\n",
    "        df['device_id'] = j['data']['entityId']\n",
    "        #print(df)\n",
    "    elif (entity is \"TrafficFlowObserved\"):\n",
    "        df = pd.DataFrame()\n",
    "        #TODO\n",
    "    elif (entity is \"WeatherObserved\"):\n",
    "        df = pd.DataFrame()\n",
    "        for i in range(0, len(j['data']['attributes'])):\n",
    "            df[j['data']['attributes'][i]['attrName']] = j['data']['attributes'][i]['values']\n",
    "        df['long'] = df['location'][0]['coordinates'][0]\n",
    "        df['lat'] = df['location'][0]['coordinates'][1]\n",
    "        df['device_id'] = j['data']['entityId']\n",
    "    else:\n",
    "        raise Exception(\"Wrong json template specified\")\n",
    "    return(df)\n",
    "\n",
    "def getHistoricalData(api_url, device_id=None, no=20, output=\"json\"):\n",
    "    if (device_id is not None):\n",
    "        url = api_url + \"/v2/entities/\" + device_id + \"?limit=\" + str(no)\n",
    "    else:\n",
    "        raise Exception(\"device_id is required\")\n",
    "    r = requests.get(url)\n",
    "    j = r.json()\n",
    "\n",
    "    if \"error\" not in j:        \n",
    "        if (output is \"json\"):\n",
    "            return (j)\n",
    "        elif (output is \"df\"):\n",
    "            return (convertJSONHistoricalToDF(j, entity))\n",
    "        else:\n",
    "            raise Exception(\"invalid output\")\n",
    "            \n",
    "#def getHistoricalData(api_url, device_id = None, no = 20):\n",
    "#    if (device_id is not None):\n",
    "#        url = api_url + \"/v2/entities/\" + device_id + \"?limit=\" + str(no)\n",
    "#    else:\n",
    "#        raise Exception(\"device_id is required\")\n",
    "#\n",
    "#    #print(url)\n",
    "#    r = requests.get(url)\n",
    "#    j = r.json()\n",
    "#    #json_normalize(j['data'], record_path=['attributes']).transpose()\n",
    "#    return(convertJSONHistoricalToDF(j, entity))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "WeatherObserved\n",
      "urn:ngsi-ld:WeatherObserved:porto:weather:communityStations:IPORTUGA71\n",
      "None\n",
      "WeatherObserved\n",
      "urn:ngsi-ld:WeatherObserved:porto:weather:communityStations:IPORTOPO9\n",
      "None\n",
      "WeatherObserved\n",
      "urn:ngsi-ld:WeatherObserved:porto:weather:communityStations:IPORTOPO4\n",
      "None\n",
      "WeatherObserved\n",
      "urn:ngsi-ld:WeatherObserved:porto:weather:ubiwhere:5ad613dd3da2520542bc871a\n",
      "WeatherObserved\n",
      "      PM1  PM10  PM25  barometricPressure dataProvider  \\\n",
      "0    None  None  None              1004.4         None   \n",
      "1    None  None  None              1017.4         None   \n",
      "2    None  None  None              1017.3         None   \n",
      "3    None  None  None              1017.4         None   \n",
      "4    None  None  None              1017.5         None   \n",
      "5    None  None  None              1017.5         None   \n",
      "6    None  None  None              1017.5         None   \n",
      "7    None  None  None              1017.5         None   \n",
      "8    None  None  None              1017.5         None   \n",
      "9    None  None  None              1017.4         None   \n",
      "10   None  None  None              1017.4         None   \n",
      "11   None  None  None              1017.4         None   \n",
      "12   None  None  None              1017.4         None   \n",
      "13   None  None  None              1017.4         None   \n",
      "14   None  None  None              1017.4         None   \n",
      "15   None  None  None              1017.4         None   \n",
      "16   None  None  None              1017.4         None   \n",
      "17   None  None  None              1017.4         None   \n",
      "18   None  None  None              1017.5         None   \n",
      "19   None  None  None              1017.5         None   \n",
      "20   None  None  None              1017.6         None   \n",
      "21   None  None  None              1017.6         None   \n",
      "22   None  None  None              1017.8         None   \n",
      "23   None  None  None              1017.8         None   \n",
      "24   None  None  None              1017.9         None   \n",
      "25   None  None  None              1017.9         None   \n",
      "26   None  None  None              1017.9         None   \n",
      "27   None  None  None              1018.0         None   \n",
      "28   None  None  None              1018.0         None   \n",
      "29   None  None  None              1018.0         None   \n",
      "..    ...   ...   ...                 ...          ...   \n",
      "470  None  None  None              1027.1         None   \n",
      "471  None  None  None              1027.1         None   \n",
      "472  None  None  None              1027.0         None   \n",
      "473  None  None  None              1027.0         None   \n",
      "474  None  None  None              1027.0         None   \n",
      "475  None  None  None              1026.9         None   \n",
      "476  None  None  None              1026.9         None   \n",
      "477  None  None  None              1026.9         None   \n",
      "478  None  None  None              1026.9         None   \n",
      "479  None  None  None              1026.8         None   \n",
      "480  None  None  None              1026.8         None   \n",
      "481  None  None  None              1026.7         None   \n",
      "482  None  None  None              1026.6         None   \n",
      "483  None  None  None              1026.6         None   \n",
      "484  None  None  None               706.3         None   \n",
      "485  None  None  None              1019.5         None   \n",
      "486  None  None  None              1019.6         None   \n",
      "487  None  None  None              1019.6         None   \n",
      "488  None  None  None              1019.6         None   \n",
      "489  None  None  None              1019.7         None   \n",
      "490  None  None  None              1019.9         None   \n",
      "491  None  None  None              1020.0         None   \n",
      "492  None  None  None              1020.0         None   \n",
      "493  None  None  None              1020.0         None   \n",
      "494  None  None  None              1020.0         None   \n",
      "495  None  None  None              1019.9         None   \n",
      "496  None  None  None              1019.9         None   \n",
      "497  None  None  None              1019.9         None   \n",
      "498  None  None  None              1019.8         None   \n",
      "499  None  None  None              1019.9         None   \n",
      "\n",
      "                dateObserved  \\\n",
      "0    2019-02-18T03:50:37.000   \n",
      "1    2019-02-18T03:56:16.000   \n",
      "2    2019-02-18T04:02:31.000   \n",
      "3    2019-02-18T04:08:49.000   \n",
      "4    2019-02-18T04:11:49.000   \n",
      "5    2019-02-18T04:17:52.000   \n",
      "6    2019-02-18T04:20:55.000   \n",
      "7    2019-02-18T04:27:06.000   \n",
      "8    2019-02-18T04:31:00.000   \n",
      "9    2019-02-18T04:36:03.000   \n",
      "10   2019-02-18T04:42:45.000   \n",
      "11   2019-02-18T04:45:34.000   \n",
      "12   2019-02-18T04:51:53.000   \n",
      "13   2019-02-18T04:58:10.000   \n",
      "14   2019-02-18T05:01:04.000   \n",
      "15   2019-02-18T05:07:31.000   \n",
      "16   2019-02-18T05:10:33.000   \n",
      "17   2019-02-18T05:16:28.000   \n",
      "18   2019-02-18T05:22:31.000   \n",
      "19   2019-02-18T05:25:34.000   \n",
      "20   2019-02-18T05:31:39.000   \n",
      "21   2019-02-18T05:37:57.000   \n",
      "22   2019-02-18T05:40:58.000   \n",
      "23   2019-02-18T05:47:07.000   \n",
      "24   2019-02-18T05:53:10.000   \n",
      "25   2019-02-18T05:56:04.000   \n",
      "26   2019-02-18T06:02:23.000   \n",
      "27   2019-02-18T06:08:30.000   \n",
      "28   2019-02-18T06:11:28.000   \n",
      "29   2019-02-18T06:18:00.000   \n",
      "..                       ...   \n",
      "470  2019-03-22T12:14:19.000   \n",
      "471  2019-03-22T12:17:16.000   \n",
      "472  2019-03-22T12:23:27.000   \n",
      "473  2019-03-22T12:26:27.000   \n",
      "474  2019-03-22T12:33:16.000   \n",
      "475  2019-03-22T12:36:19.000   \n",
      "476  2019-03-22T12:43:22.000   \n",
      "477  2019-03-22T12:46:25.000   \n",
      "478  2019-03-22T12:53:15.000   \n",
      "479  2019-03-22T12:59:51.000   \n",
      "480  2019-03-22T13:05:04.000   \n",
      "481  2019-03-22T13:10:02.000   \n",
      "482  2019-03-22T13:12:12.000   \n",
      "483  2019-03-22T13:18:57.000   \n",
      "484  2019-03-27T01:42:27.000   \n",
      "485  2019-03-27T01:48:42.000   \n",
      "486  2019-03-27T01:51:16.000   \n",
      "487  2019-03-27T01:58:23.000   \n",
      "488  2019-03-27T02:04:19.000   \n",
      "489  2019-03-27T02:05:53.000   \n",
      "490  2019-03-27T02:13:53.000   \n",
      "491  2019-03-27T02:17:15.000   \n",
      "492  2019-03-27T02:23:15.000   \n",
      "493  2019-03-27T02:26:40.000   \n",
      "494  2019-03-27T02:32:40.000   \n",
      "495  2019-03-27T02:39:08.000   \n",
      "496  2019-03-27T02:42:36.000   \n",
      "497  2019-03-27T02:48:24.000   \n",
      "498  2019-03-27T02:51:29.000   \n",
      "499  2019-03-27T02:57:59.000   \n",
      "\n",
      "                                              location precipitation  \\\n",
      "0    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "1    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "2    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "3    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "4    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "5    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "6    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "7    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "8    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "9    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "10   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "11   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "12   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "13   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "14   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "15   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "16   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "17   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "18   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "19   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "20   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "21   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "22   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "23   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "24   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "25   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "26   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "27   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "28   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "29   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "..                                                 ...           ...   \n",
      "470  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "471  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "472  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "473  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "474  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "475  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "476  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "477  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "478  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "479  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "480  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "481  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "482  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "483  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "484  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "485  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "486  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "487  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "488  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "489  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "490  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "491  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "492  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "493  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "494  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "495  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "496  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "497  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "498  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "499  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "\n",
      "     relativeHumidity  solarRadiation source  temperature  windDirection  \\\n",
      "0                0.93             0.2   None         10.1           24.0   \n",
      "1                0.93             0.2   None         10.1           22.0   \n",
      "2                0.93             0.2   None         10.1            5.0   \n",
      "3                0.93             0.1   None         10.1            5.0   \n",
      "4                0.93             0.1   None         10.1            5.0   \n",
      "5                0.93             0.2   None         10.1            5.0   \n",
      "6                0.93             0.2   None         10.1            5.0   \n",
      "7                0.93             0.2   None         10.1            5.0   \n",
      "8                0.93             0.1   None         10.1            5.0   \n",
      "9                0.93             0.1   None         10.1            5.0   \n",
      "10               0.93             0.2   None         10.1           21.0   \n",
      "11               0.93             0.1   None         10.1           21.0   \n",
      "12               0.93             0.2   None         10.1           21.0   \n",
      "13               0.93             0.2   None         10.1           21.0   \n",
      "14               0.93             0.2   None         10.1           21.0   \n",
      "15               0.93             0.1   None         10.1           21.0   \n",
      "16               0.93             0.2   None         10.1           24.0   \n",
      "17               0.93             0.2   None         10.1           27.0   \n",
      "18               0.93             0.2   None         10.1           27.0   \n",
      "19               0.93             0.2   None         10.1           27.0   \n",
      "20               0.94             0.1   None         10.1           27.0   \n",
      "21               0.94             0.2   None         10.1         -130.0   \n",
      "22               0.94             0.2   None         10.1         -124.0   \n",
      "23               0.94             0.2   None         10.1         -130.0   \n",
      "24               0.94             0.2   None         10.1         -125.0   \n",
      "25               0.94             0.2   None         10.1         -130.0   \n",
      "26               0.94             0.2   None         10.1         -133.0   \n",
      "27               0.95             0.2   None         10.1         -132.0   \n",
      "28               0.95             0.2   None         10.1         -132.0   \n",
      "29               0.95             0.2   None         10.1         -130.0   \n",
      "..                ...             ...    ...          ...            ...   \n",
      "470              0.40           738.1   None         19.7          155.0   \n",
      "471              0.40           736.9   None         20.0          -75.0   \n",
      "472              0.40           737.8   None         20.4         -126.0   \n",
      "473              0.39           738.4   None         19.8         -136.0   \n",
      "474              0.40           739.6   None         20.3         -140.0   \n",
      "475              0.40           742.9   None         19.7         -143.0   \n",
      "476              0.40           743.7   None         20.1         -132.0   \n",
      "477              0.40           746.2   None         20.4          -89.0   \n",
      "478              0.39           746.0   None         20.4          -21.0   \n",
      "479              0.38           745.7   None         20.4         -126.0   \n",
      "480              0.38           743.1   None         20.4         -119.0   \n",
      "481              0.36           741.1   None         20.4         -131.0   \n",
      "482              0.36           739.8   None         20.3         -137.0   \n",
      "483              0.36           733.9   None         20.4         -134.0   \n",
      "484              0.18             0.0   None         17.0         -180.0   \n",
      "485              0.18             0.1   None         16.9          132.0   \n",
      "486              0.18             0.2   None         16.3          153.0   \n",
      "487              0.18             0.2   None         16.3           32.0   \n",
      "488              0.18             0.1   None         16.3          127.0   \n",
      "489              0.18             0.1   None         16.3          144.0   \n",
      "490              0.19             0.2   None         16.3          144.0   \n",
      "491              0.19             0.2   None         16.3          106.0   \n",
      "492              0.19             0.1   None         16.3          123.0   \n",
      "493              0.19             0.1   None         16.3          143.0   \n",
      "494              0.19             0.1   None         16.3          119.0   \n",
      "495              0.19             0.1   None         16.3          124.0   \n",
      "496              0.19             0.1   None         16.3          125.0   \n",
      "497              0.20             0.1   None         15.7          120.0   \n",
      "498              0.20             0.2   None         15.6          118.0   \n",
      "499              0.20             0.1   None         15.6          127.0   \n",
      "\n",
      "     windSpeed      long        lat  \\\n",
      "0          1.9 -8.598082  41.148427   \n",
      "1          2.1 -8.598082  41.148427   \n",
      "2          1.8 -8.598082  41.148427   \n",
      "3          1.8 -8.598082  41.148427   \n",
      "4          1.8 -8.598082  41.148427   \n",
      "5          1.8 -8.598082  41.148427   \n",
      "6          1.8 -8.598082  41.148427   \n",
      "7          1.8 -8.598082  41.148427   \n",
      "8          1.8 -8.598082  41.148427   \n",
      "9          1.8 -8.598082  41.148427   \n",
      "10         0.4 -8.598082  41.148427   \n",
      "11         1.8 -8.598082  41.148427   \n",
      "12         0.9 -8.598082  41.148427   \n",
      "13         0.9 -8.598082  41.148427   \n",
      "14         0.9 -8.598082  41.148427   \n",
      "15         0.9 -8.598082  41.148427   \n",
      "16         1.9 -8.598082  41.148427   \n",
      "17         0.5 -8.598082  41.148427   \n",
      "18         0.5 -8.598082  41.148427   \n",
      "19         0.5 -8.598082  41.148427   \n",
      "20         0.5 -8.598082  41.148427   \n",
      "21         0.7 -8.598082  41.148427   \n",
      "22         3.0 -8.598082  41.148427   \n",
      "23         3.7 -8.598082  41.148427   \n",
      "24         5.5 -8.598082  41.148427   \n",
      "25         5.3 -8.598082  41.148427   \n",
      "26         6.7 -8.598082  41.148427   \n",
      "27         6.7 -8.598082  41.148427   \n",
      "28         6.9 -8.598082  41.148427   \n",
      "29         6.8 -8.598082  41.148427   \n",
      "..         ...       ...        ...   \n",
      "470        3.3 -8.598082  41.148427   \n",
      "471        3.6 -8.598082  41.148427   \n",
      "472        6.6 -8.598082  41.148427   \n",
      "473        6.3 -8.598082  41.148427   \n",
      "474        6.6 -8.598082  41.148427   \n",
      "475        8.9 -8.598082  41.148427   \n",
      "476        6.0 -8.598082  41.148427   \n",
      "477        4.4 -8.598082  41.148427   \n",
      "478        5.2 -8.598082  41.148427   \n",
      "479        5.6 -8.598082  41.148427   \n",
      "480        5.5 -8.598082  41.148427   \n",
      "481        6.2 -8.598082  41.148427   \n",
      "482        8.7 -8.598082  41.148427   \n",
      "483        7.6 -8.598082  41.148427   \n",
      "484       17.7 -8.598082  41.148427   \n",
      "485        7.2 -8.598082  41.148427   \n",
      "486        6.1 -8.598082  41.148427   \n",
      "487        6.5 -8.598082  41.148427   \n",
      "488        7.5 -8.598082  41.148427   \n",
      "489        7.5 -8.598082  41.148427   \n",
      "490        9.3 -8.598082  41.148427   \n",
      "491        5.0 -8.598082  41.148427   \n",
      "492        4.0 -8.598082  41.148427   \n",
      "493        7.0 -8.598082  41.148427   \n",
      "494        4.5 -8.598082  41.148427   \n",
      "495        5.8 -8.598082  41.148427   \n",
      "496        4.0 -8.598082  41.148427   \n",
      "497        5.3 -8.598082  41.148427   \n",
      "498        4.1 -8.598082  41.148427   \n",
      "499        4.2 -8.598082  41.148427   \n",
      "\n",
      "                                             device_id  \n",
      "0    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "1    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "2    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "3    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "4    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "5    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "6    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "7    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "8    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "9    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "10   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "11   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "12   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "13   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "14   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "15   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "16   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "17   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "18   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "19   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "20   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "21   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "22   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "23   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "24   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "25   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "26   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "27   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "28   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "29   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "..                                                 ...  \n",
      "470  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "471  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "472  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "473  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "474  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "475  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "476  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "477  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "478  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "479  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "480  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "481  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "482  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "483  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "484  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "485  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "486  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "487  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "488  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "489  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "490  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "491  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "492  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "493  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "494  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "495  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "496  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "497  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "498  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "499  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "\n",
      "[500 rows x 17 columns]\n",
      "WeatherObserved\n",
      "urn:ngsi-ld:WeatherObserved:porto:weather:ubiwhere:5ad615bb3da2520542bc87fb\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "WeatherObserved\n",
      "      PM1  PM10  PM25  barometricPressure dataProvider  \\\n",
      "0    None  None  None               733.4         None   \n",
      "1    None  None  None               732.4         None   \n",
      "2    None  None  None               730.5         None   \n",
      "3    None  None  None               732.5         None   \n",
      "4    None  None  None               734.6         None   \n",
      "5    None  None  None               734.8         None   \n",
      "6    None  None  None               735.1         None   \n",
      "7    None  None  None               734.8         None   \n",
      "8    None  None  None               735.4         None   \n",
      "9    None  None  None               735.3         None   \n",
      "10   None  None  None               733.0         None   \n",
      "11   None  None  None               734.3         None   \n",
      "12   None  None  None               734.4         None   \n",
      "13   None  None  None               734.4         None   \n",
      "14   None  None  None               731.0         None   \n",
      "15   None  None  None               731.0         None   \n",
      "16   None  None  None               732.6         None   \n",
      "17   None  None  None               733.2         None   \n",
      "18   None  None  None               729.4         None   \n",
      "19   None  None  None               727.3         None   \n",
      "20   None  None  None               729.7         None   \n",
      "21   None  None  None               729.1         None   \n",
      "22   None  None  None               728.0         None   \n",
      "23   None  None  None               730.6         None   \n",
      "24   None  None  None               722.1         None   \n",
      "25   None  None  None               724.2         None   \n",
      "26   None  None  None               725.3         None   \n",
      "27   None  None  None               725.0         None   \n",
      "28   None  None  None               726.0         None   \n",
      "29   None  None  None               726.8         None   \n",
      "..    ...   ...   ...                 ...          ...   \n",
      "470  None  None  None               701.1         None   \n",
      "471  None  None  None               701.1         None   \n",
      "472  None  None  None               701.1         None   \n",
      "473  None  None  None               701.1         None   \n",
      "474  None  None  None               701.1         None   \n",
      "475  None  None  None               701.1         None   \n",
      "476  None  None  None               701.1         None   \n",
      "477  None  None  None               701.1         None   \n",
      "478  None  None  None               701.1         None   \n",
      "479  None  None  None               701.1         None   \n",
      "480  None  None  None               701.1         None   \n",
      "481  None  None  None               701.1         None   \n",
      "482  None  None  None               701.1         None   \n",
      "483  None  None  None               701.1         None   \n",
      "484  None  None  None               701.1         None   \n",
      "485  None  None  None               701.1         None   \n",
      "486  None  None  None               701.1         None   \n",
      "487  None  None  None               701.1         None   \n",
      "488  None  None  None               701.1         None   \n",
      "489  None  None  None               701.1         None   \n",
      "490  None  None  None               701.1         None   \n",
      "491  None  None  None               701.1         None   \n",
      "492  None  None  None               701.1         None   \n",
      "493  None  None  None               701.1         None   \n",
      "494  None  None  None               701.1         None   \n",
      "495  None  None  None               701.1         None   \n",
      "496  None  None  None               701.1         None   \n",
      "497  None  None  None               701.1         None   \n",
      "498  None  None  None               708.0         None   \n",
      "499  None  None  None               708.0         None   \n",
      "\n",
      "                dateObserved  \\\n",
      "0    2019-02-14T17:01:59.000   \n",
      "1    2019-02-14T17:08:04.000   \n",
      "2    2019-02-14T17:11:07.000   \n",
      "3    2019-02-14T17:17:13.000   \n",
      "4    2019-02-14T17:23:22.000   \n",
      "5    2019-02-14T17:26:30.000   \n",
      "6    2019-02-14T17:32:37.000   \n",
      "7    2019-02-14T17:35:41.000   \n",
      "8    2019-02-14T17:41:56.000   \n",
      "9    2019-02-14T17:48:15.000   \n",
      "10   2019-02-14T17:51:13.000   \n",
      "11   2019-02-14T17:57:53.000   \n",
      "12   2019-02-14T18:00:24.000   \n",
      "13   2019-02-14T18:06:55.000   \n",
      "14   2019-02-14T18:12:59.000   \n",
      "15   2019-02-14T18:15:57.000   \n",
      "16   2019-02-14T18:22:05.000   \n",
      "17   2019-02-14T18:28:31.000   \n",
      "18   2019-02-14T18:31:28.000   \n",
      "19   2019-02-14T18:37:35.000   \n",
      "20   2019-02-14T18:43:34.000   \n",
      "21   2019-02-14T18:46:46.000   \n",
      "22   2019-02-14T18:52:47.000   \n",
      "23   2019-02-14T18:55:59.000   \n",
      "24   2019-02-14T19:02:07.000   \n",
      "25   2019-02-14T19:08:22.000   \n",
      "26   2019-02-14T19:11:24.000   \n",
      "27   2019-02-14T19:17:29.000   \n",
      "28   2019-02-14T19:23:34.000   \n",
      "29   2019-02-14T19:26:35.000   \n",
      "..                       ...   \n",
      "470  2019-02-16T07:37:05.000   \n",
      "471  2019-02-16T07:43:20.000   \n",
      "472  2019-02-16T07:46:10.000   \n",
      "473  2019-02-16T07:52:47.000   \n",
      "474  2019-02-16T07:55:35.000   \n",
      "475  2019-02-16T08:01:47.000   \n",
      "476  2019-02-16T08:08:03.000   \n",
      "477  2019-02-16T08:11:08.000   \n",
      "478  2019-02-16T08:17:07.000   \n",
      "479  2019-02-16T08:20:33.000   \n",
      "480  2019-02-16T08:26:37.000   \n",
      "481  2019-02-16T08:32:50.000   \n",
      "482  2019-02-16T08:36:07.000   \n",
      "483  2019-02-16T08:41:51.000   \n",
      "484  2019-02-16T08:48:24.000   \n",
      "485  2019-02-16T08:51:19.000   \n",
      "486  2019-02-16T08:57:20.000   \n",
      "487  2019-02-16T09:03:32.000   \n",
      "488  2019-02-16T09:06:25.000   \n",
      "489  2019-02-16T09:12:32.000   \n",
      "490  2019-02-16T09:15:47.000   \n",
      "491  2019-02-16T09:22:08.000   \n",
      "492  2019-02-16T09:28:11.000   \n",
      "493  2019-02-16T09:31:11.000   \n",
      "494  2019-02-16T09:37:21.000   \n",
      "495  2019-02-16T09:40:19.000   \n",
      "496  2019-02-16T09:46:36.000   \n",
      "497  2019-02-16T09:52:48.000   \n",
      "498  2019-02-16T09:55:47.000   \n",
      "499  2019-02-16T09:58:51.000   \n",
      "\n",
      "                                              location precipitation  \\\n",
      "0    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "1    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "2    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "3    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "4    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "5    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "6    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "7    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "8    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "9    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "10   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "11   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "12   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "13   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "14   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "15   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "16   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "17   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "18   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "19   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "20   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "21   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "22   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "23   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "24   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "25   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "26   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "27   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "28   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "29   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "..                                                 ...           ...   \n",
      "470  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "471  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "472  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "473  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "474  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "475  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "476  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "477  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "478  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "479  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "480  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "481  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "482  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "483  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "484  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "485  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "486  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "487  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "488  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "489  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "490  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "491  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "492  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "493  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "494  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "495  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "496  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "497  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "498  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "499  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "\n",
      "     relativeHumidity  solarRadiation source  temperature  windDirection  \\\n",
      "0                0.37            91.2   None         26.3          -34.0   \n",
      "1                0.37            96.6   None         26.4          -33.0   \n",
      "2                0.38            87.9   None         25.9          -33.0   \n",
      "3                0.37            39.0   None         26.4          -34.0   \n",
      "4                0.36            11.4   None         26.5          -20.0   \n",
      "5                0.36            10.8   None         26.5          -20.0   \n",
      "6                0.36            10.0   None         26.4          -19.0   \n",
      "7                0.37             8.5   None         25.8          -18.0   \n",
      "8                0.36             8.0   None         25.9          -16.0   \n",
      "9                0.36             6.9   None         25.9          -16.0   \n",
      "10               0.38             5.6   None         25.0          -15.0   \n",
      "11               0.37             4.4   None         25.2          -15.0   \n",
      "12               0.37             3.3   None         25.7          -15.0   \n",
      "13               0.37             2.1   None         25.6          -13.0   \n",
      "14               0.38             1.2   None         24.5           -8.0   \n",
      "15               0.38             0.7   None         24.7          152.0   \n",
      "16               0.38             0.4   None         25.0          114.0   \n",
      "17               0.38             0.3   None         25.1          120.0   \n",
      "18               0.39             0.3   None         24.1          123.0   \n",
      "19               0.39             0.2   None         24.1          123.0   \n",
      "20               0.39             0.2   None         24.8          123.0   \n",
      "21               0.39             0.2   None         24.5          123.0   \n",
      "22               0.39             0.3   None         24.2          123.0   \n",
      "23               0.39             0.3   None         24.4          110.0   \n",
      "24               0.40             0.2   None         23.3          107.0   \n",
      "25               0.40             0.3   None         23.8          105.0   \n",
      "26               0.40             0.2   None         23.8          105.0   \n",
      "27               0.40             0.2   None         23.8          105.0   \n",
      "28               0.40             0.2   None         23.8          104.0   \n",
      "29               0.40             0.2   None         23.8          104.0   \n",
      "..                ...             ...    ...          ...            ...   \n",
      "470              0.53             3.2   None         16.6           88.0   \n",
      "471              0.51             4.8   None         17.5           92.0   \n",
      "472              0.50             6.4   None         17.6           87.0   \n",
      "473              0.49             7.1   None         17.5           85.0   \n",
      "474              0.50             8.6   None         16.8           86.0   \n",
      "475              0.51            10.1   None         16.4           86.0   \n",
      "476              0.51            11.3   None         16.4           81.0   \n",
      "477              0.51            12.6   None         16.6           85.0   \n",
      "478              0.52            14.6   None         16.1           86.0   \n",
      "479              0.52            16.3   None         16.1           81.0   \n",
      "480              0.51            16.0   None         16.8           82.0   \n",
      "481              0.50            19.5   None         17.0           84.0   \n",
      "482              0.49            21.2   None         17.7           81.0   \n",
      "483              0.49            22.2   None         17.7           83.0   \n",
      "484              0.49            23.8   None         17.0           82.0   \n",
      "485              0.50            24.5   None         17.2           85.0   \n",
      "486              0.49            26.9   None         17.7           82.0   \n",
      "487              0.48            28.3   None         18.0           82.0   \n",
      "488              0.48            29.1   None         18.0           83.0   \n",
      "489              0.47            32.1   None         18.7           86.0   \n",
      "490              0.47            33.5   None         19.0           84.0   \n",
      "491              0.47            34.5   None         19.0           82.0   \n",
      "492              0.46            35.5   None         19.0           79.0   \n",
      "493              0.46            36.4   None         19.0           80.0   \n",
      "494              0.46            37.0   None         18.6           79.0   \n",
      "495              0.47            37.0   None         18.2           78.0   \n",
      "496              0.46            36.8   None         18.7           79.0   \n",
      "497              0.45            37.0   None         19.2           82.0   \n",
      "498              0.42            37.3   None         20.1           80.0   \n",
      "499              0.42            37.3   None         20.1           80.0   \n",
      "\n",
      "     windSpeed      long        lat  \\\n",
      "0          2.4 -8.603915  41.161724   \n",
      "1          2.5 -8.603915  41.161724   \n",
      "2          2.2 -8.603915  41.161724   \n",
      "3          2.6 -8.603915  41.161724   \n",
      "4          1.8 -8.603915  41.161724   \n",
      "5          1.2 -8.603915  41.161724   \n",
      "6          1.6 -8.603915  41.161724   \n",
      "7          0.8 -8.603915  41.161724   \n",
      "8          1.7 -8.603915  41.161724   \n",
      "9          1.5 -8.603915  41.161724   \n",
      "10         1.4 -8.603915  41.161724   \n",
      "11         1.4 -8.603915  41.161724   \n",
      "12         0.9 -8.603915  41.161724   \n",
      "13         1.9 -8.603915  41.161724   \n",
      "14         1.6 -8.603915  41.161724   \n",
      "15         1.5 -8.603915  41.161724   \n",
      "16         1.5 -8.603915  41.161724   \n",
      "17         2.2 -8.603915  41.161724   \n",
      "18         0.8 -8.603915  41.161724   \n",
      "19         1.0 -8.603915  41.161724   \n",
      "20         0.7 -8.603915  41.161724   \n",
      "21         1.6 -8.603915  41.161724   \n",
      "22         1.3 -8.603915  41.161724   \n",
      "23         3.9 -8.603915  41.161724   \n",
      "24         3.1 -8.603915  41.161724   \n",
      "25         0.7 -8.603915  41.161724   \n",
      "26         1.7 -8.603915  41.161724   \n",
      "27         1.5 -8.603915  41.161724   \n",
      "28         1.3 -8.603915  41.161724   \n",
      "29         0.4 -8.603915  41.161724   \n",
      "..         ...       ...        ...   \n",
      "470        4.7 -8.603915  41.161724   \n",
      "471        5.5 -8.603915  41.161724   \n",
      "472        6.0 -8.603915  41.161724   \n",
      "473        5.4 -8.603915  41.161724   \n",
      "474        5.5 -8.603915  41.161724   \n",
      "475        7.0 -8.603915  41.161724   \n",
      "476        7.1 -8.603915  41.161724   \n",
      "477        7.3 -8.603915  41.161724   \n",
      "478        7.7 -8.603915  41.161724   \n",
      "479        7.7 -8.603915  41.161724   \n",
      "480        6.0 -8.603915  41.161724   \n",
      "481        7.0 -8.603915  41.161724   \n",
      "482        6.9 -8.603915  41.161724   \n",
      "483        7.9 -8.603915  41.161724   \n",
      "484        8.3 -8.603915  41.161724   \n",
      "485        7.0 -8.603915  41.161724   \n",
      "486        8.6 -8.603915  41.161724   \n",
      "487        8.2 -8.603915  41.161724   \n",
      "488        6.6 -8.603915  41.161724   \n",
      "489        5.6 -8.603915  41.161724   \n",
      "490        5.1 -8.603915  41.161724   \n",
      "491        5.0 -8.603915  41.161724   \n",
      "492        4.4 -8.603915  41.161724   \n",
      "493        5.8 -8.603915  41.161724   \n",
      "494        6.8 -8.603915  41.161724   \n",
      "495        7.3 -8.603915  41.161724   \n",
      "496        6.9 -8.603915  41.161724   \n",
      "497        8.0 -8.603915  41.161724   \n",
      "498        8.5 -8.603915  41.161724   \n",
      "499        8.5 -8.603915  41.161724   \n",
      "\n",
      "                                             device_id  \n",
      "0    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "1    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "2    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "3    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "4    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "5    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "6    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "7    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "8    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "9    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "10   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "11   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "12   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "13   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "14   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "15   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "16   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "17   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "18   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "19   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "20   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "21   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "22   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "23   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "24   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "25   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "26   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "27   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "28   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "29   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "..                                                 ...  \n",
      "470  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "471  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "472  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "473  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "474  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "475  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "476  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "477  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "478  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "479  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "480  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "481  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "482  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "483  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "484  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "485  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "486  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "487  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "488  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "489  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "490  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "491  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "492  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "493  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "494  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "495  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "496  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "497  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "498  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "499  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "\n",
      "[500 rows x 17 columns]\n",
      "WeatherObserved\n",
      "urn:ngsi-ld:WeatherObserved:porto:weather:ubiwhere:5ad616a53da2520542bc8859\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "WeatherObserved\n",
      "      PM1  PM10  PM25  barometricPressure dataProvider  \\\n",
      "0    None  None  None              1022.6         None   \n",
      "1    None  None  None              1022.7         None   \n",
      "2    None  None  None              1022.7         None   \n",
      "3    None  None  None              1022.7         None   \n",
      "4    None  None  None              1022.7         None   \n",
      "5    None  None  None              1022.7         None   \n",
      "6    None  None  None              1022.7         None   \n",
      "7    None  None  None              1022.7         None   \n",
      "8    None  None  None              1022.7         None   \n",
      "9    None  None  None              1022.6         None   \n",
      "10   None  None  None              1022.6         None   \n",
      "11   None  None  None              1022.6         None   \n",
      "12   None  None  None              1022.6         None   \n",
      "13   None  None  None              1022.6         None   \n",
      "14   None  None  None              1022.6         None   \n",
      "15   None  None  None              1022.6         None   \n",
      "16   None  None  None              1022.6         None   \n",
      "17   None  None  None              1022.7         None   \n",
      "18   None  None  None              1022.7         None   \n",
      "19   None  None  None              1022.8         None   \n",
      "20   None  None  None              1022.9         None   \n",
      "21   None  None  None              1023.0         None   \n",
      "22   None  None  None              1023.0         None   \n",
      "23   None  None  None              1022.9         None   \n",
      "24   None  None  None              1022.9         None   \n",
      "25   None  None  None              1022.9         None   \n",
      "26   None  None  None              1023.0         None   \n",
      "27   None  None  None              1023.0         None   \n",
      "28   None  None  None              1023.1         None   \n",
      "29   None  None  None              1023.2         None   \n",
      "..    ...   ...   ...                 ...          ...   \n",
      "470  None  None  None              1023.6         None   \n",
      "471  None  None  None              1023.6         None   \n",
      "472  None  None  None              1023.7         None   \n",
      "473  None  None  None              1023.7         None   \n",
      "474  None  None  None              1023.7         None   \n",
      "475  None  None  None              1023.8         None   \n",
      "476  None  None  None              1023.8         None   \n",
      "477  None  None  None              1023.7         None   \n",
      "478  None  None  None              1023.7         None   \n",
      "479  None  None  None              1023.7         None   \n",
      "480  None  None  None              1023.8         None   \n",
      "481  None  None  None              1023.9         None   \n",
      "482  None  None  None              1023.9         None   \n",
      "483  None  None  None              1024.0         None   \n",
      "484  None  None  None              1024.0         None   \n",
      "485  None  None  None              1024.0         None   \n",
      "486  None  None  None              1024.0         None   \n",
      "487  None  None  None              1024.1         None   \n",
      "488  None  None  None              1024.1         None   \n",
      "489  None  None  None              1024.1         None   \n",
      "490  None  None  None              1024.1         None   \n",
      "491  None  None  None              1024.2         None   \n",
      "492  None  None  None              1024.2         None   \n",
      "493  None  None  None              1024.1         None   \n",
      "494  None  None  None              1024.1         None   \n",
      "495  None  None  None              1024.1         None   \n",
      "496  None  None  None              1024.1         None   \n",
      "497  None  None  None              1024.1         None   \n",
      "498  None  None  None              1024.1         None   \n",
      "499  None  None  None              1024.0         None   \n",
      "\n",
      "                dateObserved  \\\n",
      "0    2019-02-14T17:02:10.000   \n",
      "1    2019-02-14T17:08:05.000   \n",
      "2    2019-02-14T17:11:10.000   \n",
      "3    2019-02-14T17:17:15.000   \n",
      "4    2019-02-14T17:23:23.000   \n",
      "5    2019-02-14T17:26:34.000   \n",
      "6    2019-02-14T17:32:37.000   \n",
      "7    2019-02-14T17:35:40.000   \n",
      "8    2019-02-14T17:41:58.000   \n",
      "9    2019-02-14T17:48:14.000   \n",
      "10   2019-02-14T17:51:13.000   \n",
      "11   2019-02-14T17:57:48.000   \n",
      "12   2019-02-14T18:03:52.000   \n",
      "13   2019-02-14T18:06:55.000   \n",
      "14   2019-02-14T18:12:58.000   \n",
      "15   2019-02-14T18:15:59.000   \n",
      "16   2019-02-14T18:22:04.000   \n",
      "17   2019-02-14T18:28:29.000   \n",
      "18   2019-02-14T18:31:26.000   \n",
      "19   2019-02-14T18:37:35.000   \n",
      "20   2019-02-14T18:43:33.000   \n",
      "21   2019-02-14T18:46:45.000   \n",
      "22   2019-02-14T18:52:59.000   \n",
      "23   2019-02-14T18:55:58.000   \n",
      "24   2019-02-14T19:02:06.000   \n",
      "25   2019-02-14T19:08:20.000   \n",
      "26   2019-02-14T19:11:20.000   \n",
      "27   2019-02-14T19:17:25.000   \n",
      "28   2019-02-14T19:20:41.000   \n",
      "29   2019-02-14T19:26:45.000   \n",
      "..                       ...   \n",
      "470  2019-02-16T07:06:18.000   \n",
      "471  2019-02-16T07:12:32.000   \n",
      "472  2019-02-16T07:16:14.000   \n",
      "473  2019-02-16T07:21:29.000   \n",
      "474  2019-02-16T07:27:47.000   \n",
      "475  2019-02-16T07:31:05.000   \n",
      "476  2019-02-16T07:37:15.000   \n",
      "477  2019-02-16T07:40:41.000   \n",
      "478  2019-02-16T07:46:24.000   \n",
      "479  2019-02-16T07:52:42.000   \n",
      "480  2019-02-16T07:58:48.000   \n",
      "481  2019-02-16T08:02:03.000   \n",
      "482  2019-02-16T08:08:13.000   \n",
      "483  2019-02-16T08:11:14.000   \n",
      "484  2019-02-16T08:17:11.000   \n",
      "485  2019-02-16T08:23:21.000   \n",
      "486  2019-02-16T08:26:38.000   \n",
      "487  2019-02-16T08:32:55.000   \n",
      "488  2019-02-16T08:35:40.000   \n",
      "489  2019-02-16T08:38:41.000   \n",
      "490  2019-02-16T08:41:57.000   \n",
      "491  2019-02-16T08:48:12.000   \n",
      "492  2019-02-16T08:51:10.000   \n",
      "493  2019-02-16T08:57:13.000   \n",
      "494  2019-02-16T09:00:16.000   \n",
      "495  2019-02-16T09:06:32.000   \n",
      "496  2019-02-16T09:12:46.000   \n",
      "497  2019-02-16T09:15:51.000   \n",
      "498  2019-02-16T09:21:59.000   \n",
      "499  2019-02-16T09:28:15.000   \n",
      "\n",
      "                                              location precipitation  \\\n",
      "0    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "1    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "2    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "3    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "4    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "5    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "6    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "7    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "8    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "9    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "10   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "11   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "12   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "13   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "14   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "15   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "16   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "17   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "18   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "19   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "20   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "21   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "22   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "23   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "24   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "25   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "26   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "27   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "28   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "29   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "..                                                 ...           ...   \n",
      "470  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "471  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "472  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "473  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "474  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "475  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "476  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "477  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "478  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "479  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "480  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "481  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "482  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "483  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "484  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "485  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "486  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "487  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "488  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "489  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "490  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "491  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "492  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "493  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "494  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "495  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "496  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "497  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "498  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "499  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "\n",
      "     relativeHumidity  solarRadiation source  temperature  windDirection  \\\n",
      "0                0.50            22.1   None         20.4         -102.0   \n",
      "1                0.50            23.1   None         20.4         -112.0   \n",
      "2                0.50            51.9   None         20.4         -115.0   \n",
      "3                0.51            43.8   None         20.4         -103.0   \n",
      "4                0.50            43.9   None         20.4          -90.0   \n",
      "5                0.50            36.6   None         20.4         -172.0   \n",
      "6                0.50            28.7   None         20.4          -93.0   \n",
      "7                0.49            21.0   None         20.4          -88.0   \n",
      "8                0.50            13.4   None         20.4          161.0   \n",
      "9                0.50            10.3   None         19.8          -23.0   \n",
      "10               0.50             7.8   None         19.7          138.0   \n",
      "11               0.50             5.6   None         19.7          138.0   \n",
      "12               0.51             4.0   None         19.7          163.0   \n",
      "13               0.51             2.1   None         19.6          -14.0   \n",
      "14               0.52             1.1   None         19.0          -15.0   \n",
      "15               0.52             0.5   None         19.0          -15.0   \n",
      "16               0.52             0.2   None         19.0          115.0   \n",
      "17               0.52             0.2   None         19.0          115.0   \n",
      "18               0.52             0.4   None         19.0          120.0   \n",
      "19               0.54             0.4   None         18.4         -107.0   \n",
      "20               0.55             0.3   None         18.4         -105.0   \n",
      "21               0.55             0.3   None         18.4         -104.0   \n",
      "22               0.55             0.3   None         18.4         -104.0   \n",
      "23               0.56             0.4   None         18.0          125.0   \n",
      "24               0.56             0.3   None         17.9          125.0   \n",
      "25               0.56             0.3   None         17.7           -6.0   \n",
      "26               0.56             0.4   None         17.7           -9.0   \n",
      "27               0.55             0.4   None         17.7          133.0   \n",
      "28               0.56             0.3   None         17.4          178.0   \n",
      "29               0.56             0.4   None         17.0          173.0   \n",
      "..                ...             ...    ...          ...            ...   \n",
      "470              0.66             0.4   None         12.1          137.0   \n",
      "471              0.67             0.4   None         11.5          140.0   \n",
      "472              0.67             0.3   None         11.5          124.0   \n",
      "473              0.68             0.7   None         11.5          127.0   \n",
      "474              0.67             1.2   None         11.5          138.0   \n",
      "475              0.67             2.5   None         11.5          131.0   \n",
      "476              0.67             4.0   None         11.5          132.0   \n",
      "477              0.65             5.8   None         12.1          124.0   \n",
      "478              0.62             7.6   None         12.8          126.0   \n",
      "479              0.61             8.9   None         12.9          125.0   \n",
      "480              0.61            11.8   None         12.9          120.0   \n",
      "481              0.61            15.2   None         12.9          133.0   \n",
      "482              0.61            21.0   None         12.9          140.0   \n",
      "483              0.61            37.0   None         12.9          133.0   \n",
      "484              0.61            53.5   None         12.9          134.0   \n",
      "485              0.60            50.9   None         13.2          137.0   \n",
      "486              0.59            66.3   None         13.6          135.0   \n",
      "487              0.58            79.2   None         13.6          135.0   \n",
      "488              0.57            95.4   None         14.2          133.0   \n",
      "489              0.57            95.4   None         14.2          133.0   \n",
      "490              0.57           128.5   None         14.2          133.0   \n",
      "491              0.57           135.0   None         14.2          119.0   \n",
      "492              0.57           134.9   None         14.2          128.0   \n",
      "493              0.57           172.8   None         14.2          109.0   \n",
      "494              0.56           208.3   None         14.2          108.0   \n",
      "495              0.56           214.9   None         14.7          122.0   \n",
      "496              0.55           239.6   None         14.9          129.0   \n",
      "497              0.54           252.6   None         14.9          137.0   \n",
      "498              0.54           266.0   None         14.9          136.0   \n",
      "499              0.54           279.4   None         14.9          128.0   \n",
      "\n",
      "     windSpeed      long        lat  \\\n",
      "0          4.4 -8.603107  41.183769   \n",
      "1          4.5 -8.603107  41.183769   \n",
      "2          3.2 -8.603107  41.183769   \n",
      "3          3.4 -8.603107  41.183769   \n",
      "4          2.3 -8.603107  41.183769   \n",
      "5          1.5 -8.603107  41.183769   \n",
      "6          2.2 -8.603107  41.183769   \n",
      "7          2.5 -8.603107  41.183769   \n",
      "8          1.3 -8.603107  41.183769   \n",
      "9          1.2 -8.603107  41.183769   \n",
      "10         0.8 -8.603107  41.183769   \n",
      "11         0.8 -8.603107  41.183769   \n",
      "12         1.0 -8.603107  41.183769   \n",
      "13         1.3 -8.603107  41.183769   \n",
      "14         1.0 -8.603107  41.183769   \n",
      "15         0.9 -8.603107  41.183769   \n",
      "16         2.3 -8.603107  41.183769   \n",
      "17         1.7 -8.603107  41.183769   \n",
      "18         0.6 -8.603107  41.183769   \n",
      "19         0.8 -8.603107  41.183769   \n",
      "20         1.4 -8.603107  41.183769   \n",
      "21         0.7 -8.603107  41.183769   \n",
      "22         0.7 -8.603107  41.183769   \n",
      "23         1.1 -8.603107  41.183769   \n",
      "24         1.1 -8.603107  41.183769   \n",
      "25         0.7 -8.603107  41.183769   \n",
      "26         1.4 -8.603107  41.183769   \n",
      "27         1.1 -8.603107  41.183769   \n",
      "28         1.2 -8.603107  41.183769   \n",
      "29         1.6 -8.603107  41.183769   \n",
      "..         ...       ...        ...   \n",
      "470        3.0 -8.603107  41.183769   \n",
      "471        3.1 -8.603107  41.183769   \n",
      "472        2.6 -8.603107  41.183769   \n",
      "473        3.3 -8.603107  41.183769   \n",
      "474        4.1 -8.603107  41.183769   \n",
      "475        3.0 -8.603107  41.183769   \n",
      "476        2.1 -8.603107  41.183769   \n",
      "477        4.8 -8.603107  41.183769   \n",
      "478        6.0 -8.603107  41.183769   \n",
      "479        4.2 -8.603107  41.183769   \n",
      "480        4.7 -8.603107  41.183769   \n",
      "481        3.4 -8.603107  41.183769   \n",
      "482        4.7 -8.603107  41.183769   \n",
      "483        5.0 -8.603107  41.183769   \n",
      "484        6.9 -8.603107  41.183769   \n",
      "485        8.7 -8.603107  41.183769   \n",
      "486        6.5 -8.603107  41.183769   \n",
      "487        6.2 -8.603107  41.183769   \n",
      "488        5.5 -8.603107  41.183769   \n",
      "489        5.5 -8.603107  41.183769   \n",
      "490        5.7 -8.603107  41.183769   \n",
      "491        6.0 -8.603107  41.183769   \n",
      "492        5.1 -8.603107  41.183769   \n",
      "493        7.3 -8.603107  41.183769   \n",
      "494        7.6 -8.603107  41.183769   \n",
      "495        7.0 -8.603107  41.183769   \n",
      "496        9.2 -8.603107  41.183769   \n",
      "497       10.5 -8.603107  41.183769   \n",
      "498       10.4 -8.603107  41.183769   \n",
      "499        9.3 -8.603107  41.183769   \n",
      "\n",
      "                                             device_id  \n",
      "0    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "1    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "2    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "3    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "4    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "5    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "6    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "7    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "8    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "9    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "10   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "11   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "12   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "13   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "14   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "15   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "16   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "17   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "18   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "19   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "20   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "21   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "22   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "23   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "24   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "25   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "26   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "27   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "28   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "29   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "..                                                 ...  \n",
      "470  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "471  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "472  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "473  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "474  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "475  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "476  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "477  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "478  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "479  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "480  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "481  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "482  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "483  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "484  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "485  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "486  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "487  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "488  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "489  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "490  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "491  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "492  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "493  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "494  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "495  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "496  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "497  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "498  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "499  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "\n",
      "[500 rows x 17 columns]\n",
      "WeatherObserved\n",
      "urn:ngsi-ld:WeatherObserved:porto:weather:communityStations:IPORTO36\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "None\n",
      "WeatherObserved\n",
      "urn:ngsi-ld:WeatherObserved:porto:weather:ubiwhere:5b87a6eb0dde591949bb8b5e\n",
      "WeatherObserved\n",
      "      PM1  PM10  PM25  barometricPressure dataProvider  \\\n",
      "0    None  None  None              1023.3         None   \n",
      "1    None  None  None              1023.4         None   \n",
      "2    None  None  None              1023.4         None   \n",
      "3    None  None  None              1023.4         None   \n",
      "4    None  None  None              1023.4         None   \n",
      "5    None  None  None              1023.4         None   \n",
      "6    None  None  None              1023.4         None   \n",
      "7    None  None  None              1023.4         None   \n",
      "8    None  None  None              1023.4         None   \n",
      "9    None  None  None              1023.4         None   \n",
      "10   None  None  None              1023.3         None   \n",
      "11   None  None  None              1023.3         None   \n",
      "12   None  None  None              1023.3         None   \n",
      "13   None  None  None              1023.3         None   \n",
      "14   None  None  None              1023.3         None   \n",
      "15   None  None  None              1023.3         None   \n",
      "16   None  None  None              1023.3         None   \n",
      "17   None  None  None              1023.4         None   \n",
      "18   None  None  None              1023.5         None   \n",
      "19   None  None  None              1023.6         None   \n",
      "20   None  None  None              1023.7         None   \n",
      "21   None  None  None              1023.8         None   \n",
      "22   None  None  None              1023.8         None   \n",
      "23   None  None  None              1023.7         None   \n",
      "24   None  None  None              1023.7         None   \n",
      "25   None  None  None              1023.7         None   \n",
      "26   None  None  None              1023.8         None   \n",
      "27   None  None  None              1023.8         None   \n",
      "28   None  None  None              1023.9         None   \n",
      "29   None  None  None              1024.0         None   \n",
      "..    ...   ...   ...                 ...          ...   \n",
      "470  None  None  None              1024.5         None   \n",
      "471  None  None  None              1024.6         None   \n",
      "472  None  None  None              1024.6         None   \n",
      "473  None  None  None              1024.7         None   \n",
      "474  None  None  None              1024.7         None   \n",
      "475  None  None  None              1024.7         None   \n",
      "476  None  None  None              1024.8         None   \n",
      "477  None  None  None              1024.8         None   \n",
      "478  None  None  None              1024.9         None   \n",
      "479  None  None  None              1024.9         None   \n",
      "480  None  None  None              1024.9         None   \n",
      "481  None  None  None              1025.0         None   \n",
      "482  None  None  None              1025.0         None   \n",
      "483  None  None  None              1025.0         None   \n",
      "484  None  None  None              1025.0         None   \n",
      "485  None  None  None              1024.9         None   \n",
      "486  None  None  None              1024.9         None   \n",
      "487  None  None  None              1024.9         None   \n",
      "488  None  None  None              1024.9         None   \n",
      "489  None  None  None              1024.9         None   \n",
      "490  None  None  None              1024.9         None   \n",
      "491  None  None  None              1024.9         None   \n",
      "492  None  None  None              1024.8         None   \n",
      "493  None  None  None              1024.8         None   \n",
      "494  None  None  None              1024.8         None   \n",
      "495  None  None  None              1024.8         None   \n",
      "496  None  None  None              1024.8         None   \n",
      "497  None  None  None              1024.7         None   \n",
      "498  None  None  None              1024.6         None   \n",
      "499  None  None  None              1024.6         None   \n",
      "\n",
      "                dateObserved  \\\n",
      "0    2019-02-14T17:01:58.000   \n",
      "1    2019-02-14T17:08:05.000   \n",
      "2    2019-02-14T17:11:13.000   \n",
      "3    2019-02-14T17:17:21.000   \n",
      "4    2019-02-14T17:20:47.000   \n",
      "5    2019-02-14T17:26:18.000   \n",
      "6    2019-02-14T17:32:31.000   \n",
      "7    2019-02-14T17:35:56.000   \n",
      "8    2019-02-14T17:41:54.000   \n",
      "9    2019-02-14T17:48:11.000   \n",
      "10   2019-02-14T17:51:29.000   \n",
      "11   2019-02-14T17:57:50.000   \n",
      "12   2019-02-14T18:00:23.000   \n",
      "13   2019-02-14T18:06:56.000   \n",
      "14   2019-02-14T18:13:01.000   \n",
      "15   2019-02-14T18:15:55.000   \n",
      "16   2019-02-14T18:22:10.000   \n",
      "17   2019-02-14T18:28:25.000   \n",
      "18   2019-02-14T18:31:24.000   \n",
      "19   2019-02-14T18:37:34.000   \n",
      "20   2019-02-14T18:43:32.000   \n",
      "21   2019-02-14T18:46:47.000   \n",
      "22   2019-02-14T18:52:49.000   \n",
      "23   2019-02-14T18:56:03.000   \n",
      "24   2019-02-14T19:02:11.000   \n",
      "25   2019-02-14T19:08:23.000   \n",
      "26   2019-02-14T19:11:25.000   \n",
      "27   2019-02-14T19:17:31.000   \n",
      "28   2019-02-14T19:20:32.000   \n",
      "29   2019-02-14T19:26:41.000   \n",
      "..                       ...   \n",
      "470  2019-02-16T07:46:15.000   \n",
      "471  2019-02-16T07:52:34.000   \n",
      "472  2019-02-16T07:55:45.000   \n",
      "473  2019-02-16T08:02:04.000   \n",
      "474  2019-02-16T08:08:17.000   \n",
      "475  2019-02-16T08:11:23.000   \n",
      "476  2019-02-16T08:17:27.000   \n",
      "477  2019-02-16T08:20:31.000   \n",
      "478  2019-02-16T08:26:36.000   \n",
      "479  2019-02-16T08:32:53.000   \n",
      "480  2019-02-16T08:35:43.000   \n",
      "481  2019-02-16T08:41:55.000   \n",
      "482  2019-02-16T08:48:12.000   \n",
      "483  2019-02-16T08:51:15.000   \n",
      "484  2019-02-16T08:57:16.000   \n",
      "485  2019-02-16T09:03:31.000   \n",
      "486  2019-02-16T09:06:34.000   \n",
      "487  2019-02-16T09:12:44.000   \n",
      "488  2019-02-16T09:12:50.000   \n",
      "489  2019-02-16T09:15:45.000   \n",
      "490  2019-02-16T09:22:03.000   \n",
      "491  2019-02-16T09:28:08.000   \n",
      "492  2019-02-16T09:31:09.000   \n",
      "493  2019-02-16T09:37:24.000   \n",
      "494  2019-02-16T09:43:30.000   \n",
      "495  2019-02-16T09:46:51.000   \n",
      "496  2019-02-16T09:52:58.000   \n",
      "497  2019-02-16T09:55:56.000   \n",
      "498  2019-02-16T10:02:12.000   \n",
      "499  2019-02-16T10:08:16.000   \n",
      "\n",
      "                                              location precipitation  \\\n",
      "0    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "1    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "2    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "3    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "4    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "5    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "6    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "7    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "8    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "9    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "10   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "11   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "12   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "13   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "14   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "15   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "16   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "17   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "18   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "19   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "20   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "21   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "22   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "23   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "24   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "25   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "26   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "27   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "28   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "29   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "..                                                 ...           ...   \n",
      "470  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "471  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "472  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "473  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "474  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "475  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "476  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "477  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "478  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "479  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "480  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "481  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "482  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "483  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "484  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "485  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "486  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "487  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "488  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "489  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "490  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "491  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "492  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "493  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "494  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "495  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "496  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "497  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "498  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "499  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "\n",
      "     relativeHumidity solarRadiation source  temperature  windDirection  \\\n",
      "0                0.49           None   None         21.1          -74.0   \n",
      "1                0.49           None   None         21.3          -48.0   \n",
      "2                0.49           None   None         21.6          170.0   \n",
      "3                0.49           None   None         21.1          -39.0   \n",
      "4                0.49           None   None         20.7          160.0   \n",
      "5                0.50           None   None         19.8          161.0   \n",
      "6                0.51           None   None         19.7          149.0   \n",
      "7                0.51           None   None         19.6          151.0   \n",
      "8                0.51           None   None         19.0          148.0   \n",
      "9                0.52           None   None         19.0          140.0   \n",
      "10               0.52           None   None         19.0          140.0   \n",
      "11               0.53           None   None         19.0          140.0   \n",
      "12               0.53           None   None         18.7           81.0   \n",
      "13               0.53           None   None         18.4           67.0   \n",
      "14               0.53           None   None         18.4           85.0   \n",
      "15               0.54           None   None         18.4           89.0   \n",
      "16               0.54           None   None         18.4           89.0   \n",
      "17               0.55           None   None         18.3           51.0   \n",
      "18               0.55           None   None         17.8           44.0   \n",
      "19               0.56           None   None         17.7           41.0   \n",
      "20               0.56           None   None         17.7           36.0   \n",
      "21               0.57           None   None         17.7           36.0   \n",
      "22               0.57           None   None         17.1           37.0   \n",
      "23               0.58           None   None         17.0           54.0   \n",
      "24               0.58           None   None         17.0           72.0   \n",
      "25               0.58           None   None         17.0           71.0   \n",
      "26               0.59           None   None         16.3           57.0   \n",
      "27               0.59           None   None         16.3           54.0   \n",
      "28               0.59           None   None         16.2           54.0   \n",
      "29               0.60           None   None         15.6           50.0   \n",
      "..                ...            ...    ...          ...            ...   \n",
      "470              0.66           None   None         12.2          105.0   \n",
      "471              0.66           None   None         12.2           99.0   \n",
      "472              0.66           None   None         12.2           97.0   \n",
      "473              0.65           None   None         12.2           94.0   \n",
      "474              0.64           None   None         12.2           99.0   \n",
      "475              0.64           None   None         12.3          101.0   \n",
      "476              0.63           None   None         12.8           97.0   \n",
      "477              0.62           None   None         12.9           96.0   \n",
      "478              0.62           None   None         12.9           95.0   \n",
      "479              0.62           None   None         12.9          106.0   \n",
      "480              0.63           None   None         13.0          110.0   \n",
      "481              0.62           None   None         13.6           97.0   \n",
      "482              0.61           None   None         13.6           96.0   \n",
      "483              0.60           None   None         13.6           89.0   \n",
      "484              0.60           None   None         13.6           94.0   \n",
      "485              0.59           None   None         14.2           93.0   \n",
      "486              0.59           None   None         14.2           95.0   \n",
      "487              0.58           None   None         14.2          100.0   \n",
      "488              0.58           None   None         14.2          100.0   \n",
      "489              0.58           None   None         14.2          102.0   \n",
      "490              0.58           None   None         14.7          114.0   \n",
      "491              0.58           None   None         14.5          110.0   \n",
      "492              0.58           None   None         14.3          102.0   \n",
      "493              0.59           None   None         14.9          117.0   \n",
      "494              0.58           None   None         14.9          114.0   \n",
      "495              0.58           None   None         14.9           98.0   \n",
      "496              0.56           None   None         15.0           99.0   \n",
      "497              0.56           None   None         15.6          104.0   \n",
      "498              0.55           None   None         15.6          100.0   \n",
      "499              0.54           None   None         15.8           97.0   \n",
      "\n",
      "     windSpeed      long        lat  \\\n",
      "0          1.9 -8.605194  41.180222   \n",
      "1          1.1 -8.605194  41.180222   \n",
      "2          0.7 -8.605194  41.180222   \n",
      "3          1.1 -8.605194  41.180222   \n",
      "4          1.8 -8.605194  41.180222   \n",
      "5          2.4 -8.605194  41.180222   \n",
      "6          2.4 -8.605194  41.180222   \n",
      "7          2.7 -8.605194  41.180222   \n",
      "8          1.9 -8.605194  41.180222   \n",
      "9          0.8 -8.605194  41.180222   \n",
      "10         0.8 -8.605194  41.180222   \n",
      "11         0.8 -8.605194  41.180222   \n",
      "12         0.9 -8.605194  41.180222   \n",
      "13         0.5 -8.605194  41.180222   \n",
      "14         1.0 -8.605194  41.180222   \n",
      "15         1.3 -8.605194  41.180222   \n",
      "16         1.3 -8.605194  41.180222   \n",
      "17         1.1 -8.605194  41.180222   \n",
      "18         0.4 -8.605194  41.180222   \n",
      "19         0.9 -8.605194  41.180222   \n",
      "20         1.2 -8.605194  41.180222   \n",
      "21         1.2 -8.605194  41.180222   \n",
      "22         1.9 -8.605194  41.180222   \n",
      "23         0.5 -8.605194  41.180222   \n",
      "24         3.3 -8.605194  41.180222   \n",
      "25         0.8 -8.605194  41.180222   \n",
      "26         1.3 -8.605194  41.180222   \n",
      "27         0.8 -8.605194  41.180222   \n",
      "28         0.8 -8.605194  41.180222   \n",
      "29         0.5 -8.605194  41.180222   \n",
      "..         ...       ...        ...   \n",
      "470        1.8 -8.605194  41.180222   \n",
      "471        2.5 -8.605194  41.180222   \n",
      "472        2.7 -8.605194  41.180222   \n",
      "473        2.9 -8.605194  41.180222   \n",
      "474        3.6 -8.605194  41.180222   \n",
      "475        3.2 -8.605194  41.180222   \n",
      "476        5.4 -8.605194  41.180222   \n",
      "477        5.7 -8.605194  41.180222   \n",
      "478        6.2 -8.605194  41.180222   \n",
      "479        2.3 -8.605194  41.180222   \n",
      "480        1.9 -8.605194  41.180222   \n",
      "481        3.3 -8.605194  41.180222   \n",
      "482        5.1 -8.605194  41.180222   \n",
      "483        7.2 -8.605194  41.180222   \n",
      "484        5.6 -8.605194  41.180222   \n",
      "485        6.1 -8.605194  41.180222   \n",
      "486        6.9 -8.605194  41.180222   \n",
      "487        7.1 -8.605194  41.180222   \n",
      "488        7.1 -8.605194  41.180222   \n",
      "489        5.4 -8.605194  41.180222   \n",
      "490        3.6 -8.605194  41.180222   \n",
      "491        3.5 -8.605194  41.180222   \n",
      "492        4.4 -8.605194  41.180222   \n",
      "493        3.4 -8.605194  41.180222   \n",
      "494        3.9 -8.605194  41.180222   \n",
      "495        5.9 -8.605194  41.180222   \n",
      "496        5.3 -8.605194  41.180222   \n",
      "497        3.7 -8.605194  41.180222   \n",
      "498        6.5 -8.605194  41.180222   \n",
      "499        7.2 -8.605194  41.180222   \n",
      "\n",
      "                                             device_id  \n",
      "0    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "1    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "2    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "3    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "4    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "5    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "6    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "7    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "8    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "9    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "10   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "11   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "12   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "13   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "14   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "15   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "16   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "17   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "18   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "19   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "20   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "21   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "22   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "23   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "24   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "25   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "26   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "27   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "28   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "29   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "..                                                 ...  \n",
      "470  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "471  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "472  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "473  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "474  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "475  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "476  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "477  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "478  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "479  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "480  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "481  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "482  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "483  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "484  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "485  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "486  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "487  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "488  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "489  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "490  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "491  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "492  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "493  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "494  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "495  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "496  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "497  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "498  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "499  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "\n",
      "[500 rows x 17 columns]\n",
      "WeatherObserved\n",
      "urn:ngsi-ld:WeatherObserved:porto:weather:ubiwhere:5b87a6b60dde591949bb8b5b\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "WeatherObserved\n",
      "      PM1  PM10  PM25  barometricPressure dataProvider  \\\n",
      "0    None  None  None              1022.9         None   \n",
      "1    None  None  None              1022.9         None   \n",
      "2    None  None  None              1022.9         None   \n",
      "3    None  None  None              1022.9         None   \n",
      "4    None  None  None              1022.9         None   \n",
      "5    None  None  None              1022.9         None   \n",
      "6    None  None  None              1022.9         None   \n",
      "7    None  None  None              1022.8         None   \n",
      "8    None  None  None              1022.8         None   \n",
      "9    None  None  None              1022.8         None   \n",
      "10   None  None  None              1022.7         None   \n",
      "11   None  None  None              1022.7         None   \n",
      "12   None  None  None              1022.7         None   \n",
      "13   None  None  None              1022.6         None   \n",
      "14   None  None  None              1022.6         None   \n",
      "15   None  None  None              1022.6         None   \n",
      "16   None  None  None              1022.7         None   \n",
      "17   None  None  None              1022.8         None   \n",
      "18   None  None  None              1022.9         None   \n",
      "19   None  None  None              1023.0         None   \n",
      "20   None  None  None              1023.0         None   \n",
      "21   None  None  None              1023.0         None   \n",
      "22   None  None  None              1022.9         None   \n",
      "23   None  None  None              1022.9         None   \n",
      "24   None  None  None              1022.9         None   \n",
      "25   None  None  None              1023.0         None   \n",
      "26   None  None  None              1023.1         None   \n",
      "27   None  None  None              1023.1         None   \n",
      "28   None  None  None              1023.2         None   \n",
      "29   None  None  None              1023.3         None   \n",
      "..    ...   ...   ...                 ...          ...   \n",
      "470  None  None  None              1023.8         None   \n",
      "471  None  None  None              1023.9         None   \n",
      "472  None  None  None              1023.9         None   \n",
      "473  None  None  None              1024.0         None   \n",
      "474  None  None  None              1024.0         None   \n",
      "475  None  None  None              1024.1         None   \n",
      "476  None  None  None              1024.1         None   \n",
      "477  None  None  None              1024.1         None   \n",
      "478  None  None  None              1024.2         None   \n",
      "479  None  None  None              1024.2         None   \n",
      "480  None  None  None              1024.3         None   \n",
      "481  None  None  None              1024.2         None   \n",
      "482  None  None  None              1024.3         None   \n",
      "483  None  None  None              1024.3         None   \n",
      "484  None  None  None              1024.3         None   \n",
      "485  None  None  None              1024.3         None   \n",
      "486  None  None  None              1024.4         None   \n",
      "487  None  None  None              1024.4         None   \n",
      "488  None  None  None              1024.3         None   \n",
      "489  None  None  None              1024.2         None   \n",
      "490  None  None  None              1024.1         None   \n",
      "491  None  None  None              1024.0         None   \n",
      "492  None  None  None              1024.0         None   \n",
      "493  None  None  None              1023.9         None   \n",
      "494  None  None  None              1024.0         None   \n",
      "495  None  None  None              1024.0         None   \n",
      "496  None  None  None              1023.9         None   \n",
      "497  None  None  None              1023.9         None   \n",
      "498  None  None  None              1023.8         None   \n",
      "499  None  None  None              1023.8         None   \n",
      "\n",
      "                dateObserved  \\\n",
      "0    2019-02-14T17:01:48.000   \n",
      "1    2019-02-14T17:07:57.000   \n",
      "2    2019-02-14T17:11:05.000   \n",
      "3    2019-02-14T17:17:31.000   \n",
      "4    2019-02-14T17:23:24.000   \n",
      "5    2019-02-14T17:26:31.000   \n",
      "6    2019-02-14T17:32:39.000   \n",
      "7    2019-02-14T17:35:45.000   \n",
      "8    2019-02-14T17:42:02.000   \n",
      "9    2019-02-14T17:48:27.000   \n",
      "10   2019-02-14T17:51:22.000   \n",
      "11   2019-02-14T17:57:41.000   \n",
      "12   2019-02-14T18:03:48.000   \n",
      "13   2019-02-14T18:06:51.000   \n",
      "14   2019-02-14T18:12:58.000   \n",
      "15   2019-02-14T18:15:53.000   \n",
      "16   2019-02-14T18:22:08.000   \n",
      "17   2019-02-14T18:28:21.000   \n",
      "18   2019-02-14T18:31:19.000   \n",
      "19   2019-02-14T18:37:41.000   \n",
      "20   2019-02-14T18:40:29.000   \n",
      "21   2019-02-14T18:47:08.000   \n",
      "22   2019-02-14T18:52:58.000   \n",
      "23   2019-02-14T18:56:00.000   \n",
      "24   2019-02-14T19:02:09.000   \n",
      "25   2019-02-14T19:08:22.000   \n",
      "26   2019-02-14T19:11:25.000   \n",
      "27   2019-02-14T19:17:31.000   \n",
      "28   2019-02-14T19:20:35.000   \n",
      "29   2019-02-14T19:26:43.000   \n",
      "..                       ...   \n",
      "470  2019-02-16T07:43:21.000   \n",
      "471  2019-02-16T07:46:34.000   \n",
      "472  2019-02-16T07:52:49.000   \n",
      "473  2019-02-16T07:55:42.000   \n",
      "474  2019-02-16T08:02:02.000   \n",
      "475  2019-02-16T08:08:15.000   \n",
      "476  2019-02-16T08:11:22.000   \n",
      "477  2019-02-16T08:17:25.000   \n",
      "478  2019-02-16T08:20:29.000   \n",
      "479  2019-02-16T08:26:35.000   \n",
      "480  2019-02-16T08:32:52.000   \n",
      "481  2019-02-16T08:35:41.000   \n",
      "482  2019-02-16T08:41:55.000   \n",
      "483  2019-02-16T08:48:11.000   \n",
      "484  2019-02-16T08:51:15.000   \n",
      "485  2019-02-16T08:57:20.000   \n",
      "486  2019-02-16T09:03:34.000   \n",
      "487  2019-02-16T09:06:28.000   \n",
      "488  2019-02-16T09:12:37.000   \n",
      "489  2019-02-16T09:15:52.000   \n",
      "490  2019-02-16T09:22:00.000   \n",
      "491  2019-02-16T09:28:05.000   \n",
      "492  2019-02-16T09:31:05.000   \n",
      "493  2019-02-16T09:37:33.000   \n",
      "494  2019-02-16T09:40:27.000   \n",
      "495  2019-02-16T09:46:44.000   \n",
      "496  2019-02-16T09:52:56.000   \n",
      "497  2019-02-16T09:55:53.000   \n",
      "498  2019-02-16T10:02:09.000   \n",
      "499  2019-02-16T10:08:09.000   \n",
      "\n",
      "                                              location precipitation  \\\n",
      "0    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "1    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "2    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "3    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "4    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "5    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "6    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "7    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "8    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "9    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "10   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "11   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "12   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "13   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "14   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "15   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "16   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "17   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "18   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "19   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "20   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "21   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "22   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "23   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "24   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "25   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "26   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "27   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "28   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "29   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "..                                                 ...           ...   \n",
      "470  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "471  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "472  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "473  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "474  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "475  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "476  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "477  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "478  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "479  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "480  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "481  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "482  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "483  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "484  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "485  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "486  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "487  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "488  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "489  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "490  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "491  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "492  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "493  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "494  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "495  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "496  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "497  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "498  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "499  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "\n",
      "     relativeHumidity solarRadiation source  temperature  windDirection  \\\n",
      "0                0.59           None   None         19.0          146.0   \n",
      "1                0.59           None   None         19.0          144.0   \n",
      "2                0.58           None   None         19.0          144.0   \n",
      "3                0.57           None   None         19.0          142.0   \n",
      "4                0.58           None   None         18.9          146.0   \n",
      "5                0.60           None   None         18.4          135.0   \n",
      "6                0.61           None   None         18.4          116.0   \n",
      "7                0.60           None   None         18.4          135.0   \n",
      "8                0.60           None   None         18.4          126.0   \n",
      "9                0.60           None   None         18.4          132.0   \n",
      "10               0.59           None   None         18.4          131.0   \n",
      "11               0.59           None   None         18.4          131.0   \n",
      "12               0.59           None   None         18.4          106.0   \n",
      "13               0.59           None   None         18.4          120.0   \n",
      "14               0.59           None   None         18.4          104.0   \n",
      "15               0.58           None   None         18.4           86.0   \n",
      "16               0.58           None   None         18.4           91.0   \n",
      "17               0.58           None   None         18.4           90.0   \n",
      "18               0.58           None   None         18.4           75.0   \n",
      "19               0.59           None   None         18.3           79.0   \n",
      "20               0.59           None   None         18.4           77.0   \n",
      "21               0.58           None   None         18.4           86.0   \n",
      "22               0.58           None   None         18.4           92.0   \n",
      "23               0.57           None   None         18.4           85.0   \n",
      "24               0.57           None   None         18.6           82.0   \n",
      "25               0.57           None   None         18.4          115.0   \n",
      "26               0.57           None   None         18.4           85.0   \n",
      "27               0.57           None   None         18.4           80.0   \n",
      "28               0.56           None   None         18.9           89.0   \n",
      "29               0.56           None   None         19.0           95.0   \n",
      "..                ...            ...    ...          ...            ...   \n",
      "470              0.62           None   None         13.6           79.0   \n",
      "471              0.62           None   None         13.6           78.0   \n",
      "472              0.62           None   None         13.6           85.0   \n",
      "473              0.61           None   None         13.6           88.0   \n",
      "474              0.61           None   None         13.6           85.0   \n",
      "475              0.61           None   None         13.6           83.0   \n",
      "476              0.61           None   None         14.0           79.0   \n",
      "477              0.60           None   None         14.2           80.0   \n",
      "478              0.60           None   None         14.2           81.0   \n",
      "479              0.59           None   None         14.3           81.0   \n",
      "480              0.59           None   None         14.9           83.0   \n",
      "481              0.58           None   None         14.9           83.0   \n",
      "482              0.57           None   None         14.9           81.0   \n",
      "483              0.56           None   None         15.5           82.0   \n",
      "484              0.55           None   None         15.6           85.0   \n",
      "485              0.54           None   None         15.6           75.0   \n",
      "486              0.54           None   None         15.6           92.0   \n",
      "487              0.54           None   None         15.6           91.0   \n",
      "488              0.54           None   None         15.7           83.0   \n",
      "489              0.54           None   None         16.3           82.0   \n",
      "490              0.53           None   None         16.3           81.0   \n",
      "491              0.53           None   None         16.3           85.0   \n",
      "492              0.53           None   None         16.3           84.0   \n",
      "493              0.52           None   None         16.3           81.0   \n",
      "494              0.52           None   None         16.3           81.0   \n",
      "495              0.51           None   None         16.7           82.0   \n",
      "496              0.50           None   None         17.0           84.0   \n",
      "497              0.50           None   None         17.0           86.0   \n",
      "498              0.50           None   None         17.0           79.0   \n",
      "499              0.49           None   None         17.0           85.0   \n",
      "\n",
      "     windSpeed      long        lat  \\\n",
      "0          5.9 -8.688219  41.173434   \n",
      "1          8.4 -8.688219  41.173434   \n",
      "2         11.8 -8.688219  41.173434   \n",
      "3         10.2 -8.688219  41.173434   \n",
      "4          9.2 -8.688219  41.173434   \n",
      "5          8.7 -8.688219  41.173434   \n",
      "6          7.2 -8.688219  41.173434   \n",
      "7          9.4 -8.688219  41.173434   \n",
      "8          8.1 -8.688219  41.173434   \n",
      "9          7.1 -8.688219  41.173434   \n",
      "10         9.4 -8.688219  41.173434   \n",
      "11         8.4 -8.688219  41.173434   \n",
      "12         6.4 -8.688219  41.173434   \n",
      "13         5.9 -8.688219  41.173434   \n",
      "14         5.3 -8.688219  41.173434   \n",
      "15         4.0 -8.688219  41.173434   \n",
      "16         2.3 -8.688219  41.173434   \n",
      "17         1.4 -8.688219  41.173434   \n",
      "18         1.5 -8.688219  41.173434   \n",
      "19         2.5 -8.688219  41.173434   \n",
      "20         3.3 -8.688219  41.173434   \n",
      "21         3.0 -8.688219  41.173434   \n",
      "22         3.8 -8.688219  41.173434   \n",
      "23         4.4 -8.688219  41.173434   \n",
      "24         3.5 -8.688219  41.173434   \n",
      "25         2.8 -8.688219  41.173434   \n",
      "26         3.0 -8.688219  41.173434   \n",
      "27         3.5 -8.688219  41.173434   \n",
      "28         3.0 -8.688219  41.173434   \n",
      "29         2.7 -8.688219  41.173434   \n",
      "..         ...       ...        ...   \n",
      "470        8.9 -8.688219  41.173434   \n",
      "471        6.9 -8.688219  41.173434   \n",
      "472        7.3 -8.688219  41.173434   \n",
      "473        7.2 -8.688219  41.173434   \n",
      "474        8.4 -8.688219  41.173434   \n",
      "475        7.7 -8.688219  41.173434   \n",
      "476        8.7 -8.688219  41.173434   \n",
      "477        8.0 -8.688219  41.173434   \n",
      "478        7.4 -8.688219  41.173434   \n",
      "479        7.1 -8.688219  41.173434   \n",
      "480        6.6 -8.688219  41.173434   \n",
      "481        8.6 -8.688219  41.173434   \n",
      "482        7.9 -8.688219  41.173434   \n",
      "483        9.2 -8.688219  41.173434   \n",
      "484        9.4 -8.688219  41.173434   \n",
      "485        8.0 -8.688219  41.173434   \n",
      "486        9.5 -8.688219  41.173434   \n",
      "487        8.6 -8.688219  41.173434   \n",
      "488        9.5 -8.688219  41.173434   \n",
      "489       10.8 -8.688219  41.173434   \n",
      "490       12.6 -8.688219  41.173434   \n",
      "491       16.3 -8.688219  41.173434   \n",
      "492       12.5 -8.688219  41.173434   \n",
      "493       15.9 -8.688219  41.173434   \n",
      "494       14.4 -8.688219  41.173434   \n",
      "495       13.7 -8.688219  41.173434   \n",
      "496       16.7 -8.688219  41.173434   \n",
      "497       13.9 -8.688219  41.173434   \n",
      "498       15.7 -8.688219  41.173434   \n",
      "499       18.2 -8.688219  41.173434   \n",
      "\n",
      "                                             device_id  \n",
      "0    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "1    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "2    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "3    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "4    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "5    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "6    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "7    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "8    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "9    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "10   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "11   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "12   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "13   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "14   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "15   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "16   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "17   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "18   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "19   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "20   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "21   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "22   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "23   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "24   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "25   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "26   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "27   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "28   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "29   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "..                                                 ...  \n",
      "470  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "471  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "472  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "473  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "474  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "475  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "476  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "477  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "478  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "479  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "480  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "481  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "482  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "483  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "484  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "485  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "486  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "487  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "488  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "489  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "490  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "491  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "492  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "493  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "494  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "495  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "496  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "497  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "498  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "499  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "\n",
      "[500 rows x 17 columns]\n",
      "WeatherObserved\n",
      "urn:ngsi-ld:WeatherObserved:porto:weather:ubiwhere:5b87a6cc0dde591949bb8b5c\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "WeatherObserved\n",
      "      PM1  PM10  PM25  barometricPressure dataProvider  \\\n",
      "0    None  None  None              1023.2         None   \n",
      "1    None  None  None              1023.3         None   \n",
      "2    None  None  None              1023.3         None   \n",
      "3    None  None  None              1023.3         None   \n",
      "4    None  None  None              1023.3         None   \n",
      "5    None  None  None              1023.3         None   \n",
      "6    None  None  None              1023.3         None   \n",
      "7    None  None  None              1023.3         None   \n",
      "8    None  None  None              1023.3         None   \n",
      "9    None  None  None              1023.2         None   \n",
      "10   None  None  None              1023.2         None   \n",
      "11   None  None  None              1023.2         None   \n",
      "12   None  None  None              1023.3         None   \n",
      "13   None  None  None              1023.2         None   \n",
      "14   None  None  None              1023.2         None   \n",
      "15   None  None  None              1023.2         None   \n",
      "16   None  None  None              1023.2         None   \n",
      "17   None  None  None              1023.3         None   \n",
      "18   None  None  None              1023.4         None   \n",
      "19   None  None  None              1023.5         None   \n",
      "20   None  None  None              1023.6         None   \n",
      "21   None  None  None              1023.6         None   \n",
      "22   None  None  None              1023.6         None   \n",
      "23   None  None  None              1023.6         None   \n",
      "24   None  None  None              1023.5         None   \n",
      "25   None  None  None              1023.6         None   \n",
      "26   None  None  None              1023.6         None   \n",
      "27   None  None  None              1023.7         None   \n",
      "28   None  None  None              1023.7         None   \n",
      "29   None  None  None              1023.8         None   \n",
      "..    ...   ...   ...                 ...          ...   \n",
      "470  None  None  None              1024.8         None   \n",
      "471  None  None  None              1024.8         None   \n",
      "472  None  None  None              1024.8         None   \n",
      "473  None  None  None              1024.8         None   \n",
      "474  None  None  None              1024.8         None   \n",
      "475  None  None  None              1024.8         None   \n",
      "476  None  None  None              1024.8         None   \n",
      "477  None  None  None              1024.7         None   \n",
      "478  None  None  None              1024.7         None   \n",
      "479  None  None  None              1024.7         None   \n",
      "480  None  None  None              1024.7         None   \n",
      "481  None  None  None              1024.6         None   \n",
      "482  None  None  None              1024.5         None   \n",
      "483  None  None  None              1024.5         None   \n",
      "484  None  None  None              1024.4         None   \n",
      "485  None  None  None              1024.4         None   \n",
      "486  None  None  None              1024.3         None   \n",
      "487  None  None  None              1024.2         None   \n",
      "488  None  None  None              1024.2         None   \n",
      "489  None  None  None              1024.1         None   \n",
      "490  None  None  None              1024.1         None   \n",
      "491  None  None  None              1024.1         None   \n",
      "492  None  None  None              1024.1         None   \n",
      "493  None  None  None              1024.1         None   \n",
      "494  None  None  None              1024.1         None   \n",
      "495  None  None  None              1024.0         None   \n",
      "496  None  None  None              1024.0         None   \n",
      "497  None  None  None              1024.0         None   \n",
      "498  None  None  None              1024.1         None   \n",
      "499  None  None  None              1024.1         None   \n",
      "\n",
      "                dateObserved  \\\n",
      "0    2019-02-14T17:02:05.000   \n",
      "1    2019-02-14T17:08:03.000   \n",
      "2    2019-02-14T17:10:59.000   \n",
      "3    2019-02-14T17:17:11.000   \n",
      "4    2019-02-14T17:20:52.000   \n",
      "5    2019-02-14T17:26:21.000   \n",
      "6    2019-02-14T17:32:32.000   \n",
      "7    2019-02-14T17:38:49.000   \n",
      "8    2019-02-14T17:42:06.000   \n",
      "9    2019-02-14T17:48:30.000   \n",
      "10   2019-02-14T17:51:21.000   \n",
      "11   2019-02-14T17:57:40.000   \n",
      "12   2019-02-14T18:03:48.000   \n",
      "13   2019-02-14T18:06:48.000   \n",
      "14   2019-02-14T18:12:52.000   \n",
      "15   2019-02-14T18:16:03.000   \n",
      "16   2019-02-14T18:22:13.000   \n",
      "17   2019-02-14T18:28:26.000   \n",
      "18   2019-02-14T18:31:21.000   \n",
      "19   2019-02-14T18:37:29.000   \n",
      "20   2019-02-14T18:40:25.000   \n",
      "21   2019-02-14T18:46:57.000   \n",
      "22   2019-02-14T18:52:52.000   \n",
      "23   2019-02-14T18:55:46.000   \n",
      "24   2019-02-14T19:02:01.000   \n",
      "25   2019-02-14T19:08:14.000   \n",
      "26   2019-02-14T19:11:14.000   \n",
      "27   2019-02-14T19:17:34.000   \n",
      "28   2019-02-14T19:20:31.000   \n",
      "29   2019-02-14T19:26:39.000   \n",
      "..                       ...   \n",
      "470  2019-02-16T09:03:31.000   \n",
      "471  2019-02-16T09:06:22.000   \n",
      "472  2019-02-16T09:12:52.000   \n",
      "473  2019-02-16T09:15:44.000   \n",
      "474  2019-02-16T09:22:07.000   \n",
      "475  2019-02-16T09:28:10.000   \n",
      "476  2019-02-16T09:31:06.000   \n",
      "477  2019-02-16T09:37:20.000   \n",
      "478  2019-02-16T09:40:21.000   \n",
      "479  2019-02-16T09:46:34.000   \n",
      "480  2019-02-16T09:52:48.000   \n",
      "481  2019-02-16T09:55:46.000   \n",
      "482  2019-02-16T10:02:02.000   \n",
      "483  2019-02-16T10:08:02.000   \n",
      "484  2019-02-16T10:11:12.000   \n",
      "485  2019-02-16T10:17:31.000   \n",
      "486  2019-02-16T10:23:24.000   \n",
      "487  2019-02-16T10:26:20.000   \n",
      "488  2019-02-16T10:32:26.000   \n",
      "489  2019-02-16T10:35:56.000   \n",
      "490  2019-02-16T10:42:06.000   \n",
      "491  2019-02-16T10:48:08.000   \n",
      "492  2019-02-16T10:51:05.000   \n",
      "493  2019-02-16T10:57:20.000   \n",
      "494  2019-02-16T11:00:26.000   \n",
      "495  2019-02-16T11:06:25.000   \n",
      "496  2019-02-16T11:12:43.000   \n",
      "497  2019-02-16T11:18:44.000   \n",
      "498  2019-02-16T11:22:05.000   \n",
      "499  2019-02-16T11:28:11.000   \n",
      "\n",
      "                                              location precipitation  \\\n",
      "0    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "1    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "2    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "3    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "4    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "5    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "6    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "7    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "8    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "9    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "10   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "11   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "12   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "13   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "14   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "15   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "16   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "17   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "18   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "19   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "20   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "21   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "22   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "23   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "24   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "25   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "26   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "27   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "28   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "29   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "..                                                 ...           ...   \n",
      "470  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "471  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "472  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "473  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "474  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "475  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "476  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "477  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "478  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "479  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "480  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "481  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "482  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "483  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "484  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "485  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "486  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "487  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "488  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "489  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "490  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "491  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "492  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "493  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "494  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "495  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "496  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "497  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "498  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "499  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "\n",
      "     relativeHumidity solarRadiation source  temperature  windDirection  \\\n",
      "0                0.53           None   None         19.7         -114.0   \n",
      "1                0.53           None   None         19.7          -13.0   \n",
      "2                0.52           None   None         19.7           -6.0   \n",
      "3                0.51           None   None         19.7          -11.0   \n",
      "4                0.51           None   None         19.7          -15.0   \n",
      "5                0.51           None   None         19.7           -1.0   \n",
      "6                0.51           None   None         19.7           -1.0   \n",
      "7                0.51           None   None         19.7           -5.0   \n",
      "8                0.51           None   None         19.1           -4.0   \n",
      "9                0.52           None   None         19.0           -4.0   \n",
      "10               0.52           None   None         18.8           -8.0   \n",
      "11               0.53           None   None         18.4           -8.0   \n",
      "12               0.54           None   None         18.4           -8.0   \n",
      "13               0.55           None   None         17.7         -172.0   \n",
      "14               0.56           None   None         17.7         -171.0   \n",
      "15               0.56           None   None         17.7         -172.0   \n",
      "16               0.56           None   None         17.7         -172.0   \n",
      "17               0.56           None   None         17.7         -167.0   \n",
      "18               0.56           None   None         17.7         -167.0   \n",
      "19               0.57           None   None         17.5         -167.0   \n",
      "20               0.57           None   None         17.0         -167.0   \n",
      "21               0.58           None   None         16.9         -167.0   \n",
      "22               0.59           None   None         16.3         -173.0   \n",
      "23               0.60           None   None         16.3         -171.0   \n",
      "24               0.60           None   None         16.3         -171.0   \n",
      "25               0.60           None   None         16.4         -172.0   \n",
      "26               0.59           None   None         17.0         -172.0   \n",
      "27               0.59           None   None         16.6         -172.0   \n",
      "28               0.60           None   None         16.3         -172.0   \n",
      "29               0.60           None   None         16.3         -172.0   \n",
      "..                ...            ...    ...          ...            ...   \n",
      "470              0.60           None   None         13.6          145.0   \n",
      "471              0.59           None   None         13.6          156.0   \n",
      "472              0.59           None   None         13.6          163.0   \n",
      "473              0.58           None   None         14.1          175.0   \n",
      "474              0.58           None   None         14.2          171.0   \n",
      "475              0.58           None   None         14.2          178.0   \n",
      "476              0.57           None   None         14.4          178.0   \n",
      "477              0.57           None   None         14.9          177.0   \n",
      "478              0.57           None   None         14.9          165.0   \n",
      "479              0.56           None   None         14.9          156.0   \n",
      "480              0.56           None   None         14.9          154.0   \n",
      "481              0.56           None   None         15.0          152.0   \n",
      "482              0.55           None   None         15.6          161.0   \n",
      "483              0.55           None   None         15.6          165.0   \n",
      "484              0.54           None   None         15.6          151.0   \n",
      "485              0.54           None   None         15.6          156.0   \n",
      "486              0.53           None   None         16.0          166.0   \n",
      "487              0.53           None   None         16.3          153.0   \n",
      "488              0.52           None   None         16.3          148.0   \n",
      "489              0.51           None   None         16.3          166.0   \n",
      "490              0.51           None   None         16.8          166.0   \n",
      "491              0.51           None   None         17.0          171.0   \n",
      "492              0.50           None   None         17.0          180.0   \n",
      "493              0.49           None   None         17.0          176.0   \n",
      "494              0.49           None   None         17.0          147.0   \n",
      "495              0.50           None   None         17.3          159.0   \n",
      "496              0.49           None   None         17.7          166.0   \n",
      "497              0.49           None   None         17.7           -4.0   \n",
      "498              0.47           None   None         18.3           -4.0   \n",
      "499              0.47           None   None         18.4          174.0   \n",
      "\n",
      "     windSpeed      long        lat  \\\n",
      "0          0.9 -8.613186  41.171862   \n",
      "1          2.6 -8.613186  41.171862   \n",
      "2          3.5 -8.613186  41.171862   \n",
      "3          3.1 -8.613186  41.171862   \n",
      "4          5.1 -8.613186  41.171862   \n",
      "5          3.8 -8.613186  41.171862   \n",
      "6          2.3 -8.613186  41.171862   \n",
      "7          1.5 -8.613186  41.171862   \n",
      "8          0.9 -8.613186  41.171862   \n",
      "9          0.9 -8.613186  41.171862   \n",
      "10         0.5 -8.613186  41.171862   \n",
      "11         0.5 -8.613186  41.171862   \n",
      "12         0.5 -8.613186  41.171862   \n",
      "13         0.8 -8.613186  41.171862   \n",
      "14         1.5 -8.613186  41.171862   \n",
      "15         0.8 -8.613186  41.171862   \n",
      "16         0.5 -8.613186  41.171862   \n",
      "17         1.6 -8.613186  41.171862   \n",
      "18         1.6 -8.613186  41.171862   \n",
      "19         1.6 -8.613186  41.171862   \n",
      "20         1.6 -8.613186  41.171862   \n",
      "21         1.6 -8.613186  41.171862   \n",
      "22         0.8 -8.613186  41.171862   \n",
      "23         0.7 -8.613186  41.171862   \n",
      "24         1.6 -8.613186  41.171862   \n",
      "25         1.3 -8.613186  41.171862   \n",
      "26         1.5 -8.613186  41.171862   \n",
      "27         0.8 -8.613186  41.171862   \n",
      "28         0.8 -8.613186  41.171862   \n",
      "29         0.8 -8.613186  41.171862   \n",
      "..         ...       ...        ...   \n",
      "470        3.7 -8.613186  41.171862   \n",
      "471        4.1 -8.613186  41.171862   \n",
      "472        4.3 -8.613186  41.171862   \n",
      "473        5.1 -8.613186  41.171862   \n",
      "474        3.6 -8.613186  41.171862   \n",
      "475        4.2 -8.613186  41.171862   \n",
      "476        4.9 -8.613186  41.171862   \n",
      "477        5.3 -8.613186  41.171862   \n",
      "478        4.1 -8.613186  41.171862   \n",
      "479        4.5 -8.613186  41.171862   \n",
      "480        3.8 -8.613186  41.171862   \n",
      "481        3.7 -8.613186  41.171862   \n",
      "482        4.1 -8.613186  41.171862   \n",
      "483        4.0 -8.613186  41.171862   \n",
      "484        3.8 -8.613186  41.171862   \n",
      "485        3.8 -8.613186  41.171862   \n",
      "486        4.7 -8.613186  41.171862   \n",
      "487        4.5 -8.613186  41.171862   \n",
      "488        4.6 -8.613186  41.171862   \n",
      "489        4.9 -8.613186  41.171862   \n",
      "490        5.4 -8.613186  41.171862   \n",
      "491        5.2 -8.613186  41.171862   \n",
      "492        5.9 -8.613186  41.171862   \n",
      "493        6.0 -8.613186  41.171862   \n",
      "494        3.5 -8.613186  41.171862   \n",
      "495        2.6 -8.613186  41.171862   \n",
      "496        3.0 -8.613186  41.171862   \n",
      "497        5.3 -8.613186  41.171862   \n",
      "498        4.1 -8.613186  41.171862   \n",
      "499        3.0 -8.613186  41.171862   \n",
      "\n",
      "                                             device_id  \n",
      "0    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "1    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "2    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "3    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "4    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "5    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "6    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "7    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "8    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "9    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "10   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "11   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "12   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "13   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "14   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "15   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "16   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "17   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "18   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "19   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "20   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "21   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "22   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "23   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "24   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "25   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "26   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "27   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "28   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "29   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "..                                                 ...  \n",
      "470  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "471  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "472  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "473  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "474  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "475  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "476  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "477  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "478  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "479  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "480  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "481  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "482  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "483  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "484  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "485  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "486  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "487  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "488  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "489  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "490  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "491  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "492  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "493  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "494  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "495  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "496  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "497  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "498  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "499  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "\n",
      "[500 rows x 17 columns]\n",
      "WeatherObserved\n",
      "urn:ngsi-ld:WeatherObserved:porto:weather:ubiwhere:5b87a6dc0dde591949bb8b5d\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "WeatherObserved\n",
      "      PM1  PM10  PM25  barometricPressure dataProvider  \\\n",
      "0    None  None  None              1023.4         None   \n",
      "1    None  None  None              1023.5         None   \n",
      "2    None  None  None              1023.5         None   \n",
      "3    None  None  None              1023.5         None   \n",
      "4    None  None  None              1023.5         None   \n",
      "5    None  None  None              1023.5         None   \n",
      "6    None  None  None              1023.5         None   \n",
      "7    None  None  None              1023.5         None   \n",
      "8    None  None  None              1023.5         None   \n",
      "9    None  None  None              1023.5         None   \n",
      "10   None  None  None              1023.5         None   \n",
      "11   None  None  None              1023.5         None   \n",
      "12   None  None  None              1023.4         None   \n",
      "13   None  None  None              1023.5         None   \n",
      "14   None  None  None              1023.4         None   \n",
      "15   None  None  None              1023.4         None   \n",
      "16   None  None  None              1023.4         None   \n",
      "17   None  None  None              1023.5         None   \n",
      "18   None  None  None              1023.5         None   \n",
      "19   None  None  None              1023.7         None   \n",
      "20   None  None  None              1023.8         None   \n",
      "21   None  None  None              1023.9         None   \n",
      "22   None  None  None              1023.9         None   \n",
      "23   None  None  None              1023.9         None   \n",
      "24   None  None  None              1023.9         None   \n",
      "25   None  None  None              1023.9         None   \n",
      "26   None  None  None              1023.9         None   \n",
      "27   None  None  None              1023.9         None   \n",
      "28   None  None  None              1024.0         None   \n",
      "29   None  None  None              1024.1         None   \n",
      "..    ...   ...   ...                 ...          ...   \n",
      "470  None  None  None              1025.2         None   \n",
      "471  None  None  None              1025.2         None   \n",
      "472  None  None  None              1025.1         None   \n",
      "473  None  None  None              1025.1         None   \n",
      "474  None  None  None              1025.0         None   \n",
      "475  None  None  None              1025.0         None   \n",
      "476  None  None  None              1025.0         None   \n",
      "477  None  None  None              1024.9         None   \n",
      "478  None  None  None              1024.9         None   \n",
      "479  None  None  None              1024.8         None   \n",
      "480  None  None  None              1024.7         None   \n",
      "481  None  None  None              1024.7         None   \n",
      "482  None  None  None              1024.6         None   \n",
      "483  None  None  None              1024.6         None   \n",
      "484  None  None  None              1024.6         None   \n",
      "485  None  None  None              1024.5         None   \n",
      "486  None  None  None              1024.5         None   \n",
      "487  None  None  None              1024.5         None   \n",
      "488  None  None  None              1024.4         None   \n",
      "489  None  None  None              1024.4         None   \n",
      "490  None  None  None              1024.4         None   \n",
      "491  None  None  None              1024.4         None   \n",
      "492  None  None  None              1024.4         None   \n",
      "493  None  None  None              1024.4         None   \n",
      "494  None  None  None              1024.3         None   \n",
      "495  None  None  None              1024.3         None   \n",
      "496  None  None  None              1024.2         None   \n",
      "497  None  None  None              1024.2         None   \n",
      "498  None  None  None              1024.1         None   \n",
      "499  None  None  None              1024.1         None   \n",
      "\n",
      "                dateObserved  \\\n",
      "0    2019-02-14T17:02:02.000   \n",
      "1    2019-02-14T17:08:07.000   \n",
      "2    2019-02-14T17:11:14.000   \n",
      "3    2019-02-14T17:17:26.000   \n",
      "4    2019-02-14T17:20:41.000   \n",
      "5    2019-02-14T17:26:19.000   \n",
      "6    2019-02-14T17:32:33.000   \n",
      "7    2019-02-14T17:35:47.000   \n",
      "8    2019-02-14T17:41:57.000   \n",
      "9    2019-02-14T17:48:16.000   \n",
      "10   2019-02-14T17:51:14.000   \n",
      "11   2019-02-14T17:57:33.000   \n",
      "12   2019-02-14T18:03:40.000   \n",
      "13   2019-02-14T18:07:03.000   \n",
      "14   2019-02-14T18:13:06.000   \n",
      "15   2019-02-14T18:16:03.000   \n",
      "16   2019-02-14T18:22:16.000   \n",
      "17   2019-02-14T18:28:30.000   \n",
      "18   2019-02-14T18:31:29.000   \n",
      "19   2019-02-14T18:37:38.000   \n",
      "20   2019-02-14T18:40:27.000   \n",
      "21   2019-02-14T18:46:53.000   \n",
      "22   2019-02-14T18:52:55.000   \n",
      "23   2019-02-14T18:55:53.000   \n",
      "24   2019-02-14T19:02:05.000   \n",
      "25   2019-02-14T19:08:18.000   \n",
      "26   2019-02-14T19:11:21.000   \n",
      "27   2019-02-14T19:17:27.000   \n",
      "28   2019-02-14T19:23:35.000   \n",
      "29   2019-02-14T19:26:37.000   \n",
      "..                       ...   \n",
      "470  2019-02-16T09:37:33.000   \n",
      "471  2019-02-16T09:40:28.000   \n",
      "472  2019-02-16T09:46:50.000   \n",
      "473  2019-02-16T09:52:57.000   \n",
      "474  2019-02-16T09:55:54.000   \n",
      "475  2019-02-16T10:02:10.000   \n",
      "476  2019-02-16T10:08:13.000   \n",
      "477  2019-02-16T10:11:11.000   \n",
      "478  2019-02-16T10:17:29.000   \n",
      "479  2019-02-16T10:20:35.000   \n",
      "480  2019-02-16T10:26:27.000   \n",
      "481  2019-02-16T10:32:40.000   \n",
      "482  2019-02-16T10:35:45.000   \n",
      "483  2019-02-16T10:42:03.000   \n",
      "484  2019-02-16T10:48:05.000   \n",
      "485  2019-02-16T10:51:06.000   \n",
      "486  2019-02-16T10:57:21.000   \n",
      "487  2019-02-16T11:03:24.000   \n",
      "488  2019-02-16T11:06:44.000   \n",
      "489  2019-02-16T11:12:55.000   \n",
      "490  2019-02-16T11:15:46.000   \n",
      "491  2019-02-16T11:22:11.000   \n",
      "492  2019-02-16T11:28:08.000   \n",
      "493  2019-02-16T11:30:56.000   \n",
      "494  2019-02-16T11:37:22.000   \n",
      "495  2019-02-16T11:43:26.000   \n",
      "496  2019-02-16T11:46:11.000   \n",
      "497  2019-02-16T11:52:16.000   \n",
      "498  2019-02-16T11:55:59.000   \n",
      "499  2019-02-16T12:01:20.000   \n",
      "\n",
      "                                              location precipitation  \\\n",
      "0    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "1    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "2    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "3    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "4    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "5    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "6    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "7    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "8    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "9    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "10   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "11   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "12   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "13   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "14   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "15   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "16   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "17   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "18   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "19   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "20   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "21   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "22   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "23   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "24   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "25   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "26   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "27   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "28   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "29   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "..                                                 ...           ...   \n",
      "470  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "471  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "472  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "473  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "474  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "475  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "476  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "477  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "478  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "479  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "480  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "481  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "482  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "483  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "484  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "485  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "486  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "487  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "488  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "489  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "490  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "491  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "492  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "493  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "494  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "495  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "496  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "497  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "498  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "499  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "\n",
      "     relativeHumidity solarRadiation source  temperature  windDirection  \\\n",
      "0                0.49           None   None         22.4         -106.0   \n",
      "1                0.49           None   None         21.8         -106.0   \n",
      "2                0.50           None   None         21.4         -100.0   \n",
      "3                0.51           None   None         21.1         -103.0   \n",
      "4                0.51           None   None         21.1         -121.0   \n",
      "5                0.51           None   None         21.1          -67.0   \n",
      "6                0.51           None   None         21.1          -67.0   \n",
      "7                0.51           None   None         20.6          -90.0   \n",
      "8                0.52           None   None         20.3         -124.0   \n",
      "9                0.52           None   None         19.7         -177.0   \n",
      "10               0.53           None   None         19.7          134.0   \n",
      "11               0.53           None   None         19.5          150.0   \n",
      "12               0.53           None   None         19.0          135.0   \n",
      "13               0.53           None   None         19.0          133.0   \n",
      "14               0.54           None   None         19.0          130.0   \n",
      "15               0.54           None   None         18.6          130.0   \n",
      "16               0.55           None   None         18.4          142.0   \n",
      "17               0.55           None   None         18.4          174.0   \n",
      "18               0.55           None   None         18.4          174.0   \n",
      "19               0.56           None   None         18.3          174.0   \n",
      "20               0.56           None   None         17.7          174.0   \n",
      "21               0.57           None   None         17.7          174.0   \n",
      "22               0.58           None   None         17.3          174.0   \n",
      "23               0.58           None   None         17.0          162.0   \n",
      "24               0.59           None   None         17.0          154.0   \n",
      "25               0.59           None   None         17.0          153.0   \n",
      "26               0.59           None   None         17.0          153.0   \n",
      "27               0.59           None   None         17.0          153.0   \n",
      "28               0.59           None   None         17.0          103.0   \n",
      "29               0.59           None   None         17.0           24.0   \n",
      "..                ...            ...    ...          ...            ...   \n",
      "470              0.64           None   None         14.2          125.0   \n",
      "471              0.63           None   None         14.3          123.0   \n",
      "472              0.62           None   None         14.9          125.0   \n",
      "473              0.61           None   None         14.9          116.0   \n",
      "474              0.60           None   None         15.5          118.0   \n",
      "475              0.59           None   None         15.6          117.0   \n",
      "476              0.58           None   None         15.6          121.0   \n",
      "477              0.58           None   None         15.7          110.0   \n",
      "478              0.57           None   None         16.3           97.0   \n",
      "479              0.56           None   None         16.3          114.0   \n",
      "480              0.55           None   None         16.8          114.0   \n",
      "481              0.54           None   None         17.0          114.0   \n",
      "482              0.54           None   None         17.0          110.0   \n",
      "483              0.53           None   None         17.0          109.0   \n",
      "484              0.52           None   None         17.0          114.0   \n",
      "485              0.52           None   None         17.7          120.0   \n",
      "486              0.51           None   None         17.7           67.0   \n",
      "487              0.51           None   None         17.7          121.0   \n",
      "488              0.50           None   None         17.7          122.0   \n",
      "489              0.50           None   None         18.1          123.0   \n",
      "490              0.49           None   None         18.3          122.0   \n",
      "491              0.50           None   None         18.4          116.0   \n",
      "492              0.51           None   None         18.4          129.0   \n",
      "493              0.51           None   None         18.4          137.0   \n",
      "494              0.52           None   None         18.4          124.0   \n",
      "495              0.53           None   None         18.4          132.0   \n",
      "496              0.53           None   None         18.6          134.0   \n",
      "497              0.52           None   None         18.9          123.0   \n",
      "498              0.51           None   None         19.0          146.0   \n",
      "499              0.51           None   None         19.0          148.0   \n",
      "\n",
      "     windSpeed      long        lat  \\\n",
      "0          1.9 -8.590796  41.162596   \n",
      "1          1.9 -8.590796  41.162596   \n",
      "2          1.2 -8.590796  41.162596   \n",
      "3          1.3 -8.590796  41.162596   \n",
      "4          0.5 -8.590796  41.162596   \n",
      "5          0.9 -8.590796  41.162596   \n",
      "6          0.9 -8.590796  41.162596   \n",
      "7          0.5 -8.590796  41.162596   \n",
      "8          0.7 -8.590796  41.162596   \n",
      "9          1.0 -8.590796  41.162596   \n",
      "10         2.5 -8.590796  41.162596   \n",
      "11         1.1 -8.590796  41.162596   \n",
      "12         2.2 -8.590796  41.162596   \n",
      "13         0.8 -8.590796  41.162596   \n",
      "14         0.6 -8.590796  41.162596   \n",
      "15         0.6 -8.590796  41.162596   \n",
      "16         1.6 -8.590796  41.162596   \n",
      "17         0.8 -8.590796  41.162596   \n",
      "18         0.8 -8.590796  41.162596   \n",
      "19         0.6 -8.590796  41.162596   \n",
      "20         0.5 -8.590796  41.162596   \n",
      "21         0.7 -8.590796  41.162596   \n",
      "22         0.7 -8.590796  41.162596   \n",
      "23         1.3 -8.590796  41.162596   \n",
      "24         1.1 -8.590796  41.162596   \n",
      "25         0.4 -8.590796  41.162596   \n",
      "26         0.6 -8.590796  41.162596   \n",
      "27         0.9 -8.590796  41.162596   \n",
      "28         0.8 -8.590796  41.162596   \n",
      "29         0.6 -8.590796  41.162596   \n",
      "..         ...       ...        ...   \n",
      "470        4.8 -8.590796  41.162596   \n",
      "471        6.1 -8.590796  41.162596   \n",
      "472        4.3 -8.590796  41.162596   \n",
      "473        4.4 -8.590796  41.162596   \n",
      "474        5.4 -8.590796  41.162596   \n",
      "475        4.1 -8.590796  41.162596   \n",
      "476        4.9 -8.590796  41.162596   \n",
      "477        5.4 -8.590796  41.162596   \n",
      "478        4.3 -8.590796  41.162596   \n",
      "479        4.3 -8.590796  41.162596   \n",
      "480        6.2 -8.590796  41.162596   \n",
      "481        6.7 -8.590796  41.162596   \n",
      "482        6.0 -8.590796  41.162596   \n",
      "483        6.3 -8.590796  41.162596   \n",
      "484        5.6 -8.590796  41.162596   \n",
      "485        6.7 -8.590796  41.162596   \n",
      "486        5.4 -8.590796  41.162596   \n",
      "487        5.7 -8.590796  41.162596   \n",
      "488        6.8 -8.590796  41.162596   \n",
      "489        6.7 -8.590796  41.162596   \n",
      "490        7.4 -8.590796  41.162596   \n",
      "491        5.0 -8.590796  41.162596   \n",
      "492        4.7 -8.590796  41.162596   \n",
      "493        4.5 -8.590796  41.162596   \n",
      "494        4.4 -8.590796  41.162596   \n",
      "495        4.0 -8.590796  41.162596   \n",
      "496        4.1 -8.590796  41.162596   \n",
      "497        3.8 -8.590796  41.162596   \n",
      "498        4.7 -8.590796  41.162596   \n",
      "499        3.1 -8.590796  41.162596   \n",
      "\n",
      "                                             device_id  \n",
      "0    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "1    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "2    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "3    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "4    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "5    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "6    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "7    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "8    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "9    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "10   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "11   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "12   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "13   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "14   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "15   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "16   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "17   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "18   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "19   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "20   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "21   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "22   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "23   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "24   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "25   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "26   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "27   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "28   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "29   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "..                                                 ...  \n",
      "470  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "471  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "472  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "473  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "474  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "475  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "476  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "477  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "478  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "479  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "480  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "481  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "482  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "483  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "484  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "485  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "486  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "487  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "488  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "489  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "490  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "491  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "492  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "493  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "494  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "495  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "496  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "497  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "498  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "499  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "\n",
      "[500 rows x 17 columns]\n",
      "WeatherObserved\n",
      "urn:ngsi-ld:WeatherObserved:porto:weather:ubiwhere:5b97a1bde521e3053085c08c\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "WeatherObserved\n",
      "    PM1  PM10  PM25 barometricPressure dataProvider             dateObserved  \\\n",
      "0   NaN   NaN   NaN               None         None  2019-02-18T01:52:52.000   \n",
      "1   0.0   0.0   0.0               None         None  2019-03-20T04:23:01.000   \n",
      "2   0.0   0.0   0.0               None         None  2019-03-20T04:38:26.000   \n",
      "3   0.0   0.0   0.0               None         None  2019-03-20T04:44:27.000   \n",
      "4   0.0   0.0   0.0               None         None  2019-03-20T04:54:30.000   \n",
      "5   0.0   0.0   0.0               None         None  2019-03-20T04:57:35.000   \n",
      "6   0.0   0.0   0.0               None         None  2019-03-20T05:07:07.000   \n",
      "7   0.0   0.0   0.0               None         None  2019-03-20T05:13:17.000   \n",
      "8   0.0   0.0   0.0               None         None  2019-03-20T05:23:24.000   \n",
      "9   0.0   0.0   0.0               None         None  2019-03-20T05:26:44.000   \n",
      "10  0.0   0.0   0.0               None         None  2019-03-20T05:36:47.000   \n",
      "11  0.0   0.0   0.0               None         None  2019-03-20T05:43:10.000   \n",
      "12  0.0   0.0   0.0               None         None  2019-03-20T05:53:01.000   \n",
      "13  0.0   0.0   0.0               None         None  2019-03-20T06:08:56.000   \n",
      "14  0.0   0.0   0.0               None         None  2019-03-20T06:11:59.000   \n",
      "15  0.0   0.0   0.0               None         None  2019-03-20T06:24:42.000   \n",
      "16  0.0   0.0   0.0               None         None  2019-03-20T06:26:05.000   \n",
      "17  0.0   0.0   0.0               None         None  2019-03-20T06:37:29.000   \n",
      "18  0.0   0.0   0.0               None         None  2019-03-20T06:43:42.000   \n",
      "19  0.0   0.0   0.0               None         None  2019-03-20T06:53:23.000   \n",
      "20  0.0   0.0   0.0               None         None  2019-03-20T06:56:16.000   \n",
      "21  0.0   0.0   0.0               None         None  2019-03-20T07:09:07.000   \n",
      "22  0.0   0.0   0.0               None         None  2019-03-20T07:12:51.000   \n",
      "23  0.0   0.0   0.0               None         None  2019-03-20T07:22:34.000   \n",
      "24  0.0   0.0   0.0               None         None  2019-03-20T07:28:42.000   \n",
      "25  0.0   0.0   0.0               None         None  2019-03-20T07:38:36.000   \n",
      "26  0.0   0.0   0.0               None         None  2019-03-20T07:41:32.000   \n",
      "27  0.0   0.0   0.0               None         None  2019-03-20T08:07:18.000   \n",
      "28  0.0   0.0   0.0               None         None  2019-03-20T08:13:24.000   \n",
      "29  0.0   0.0   0.0               None         None  2019-03-20T08:38:45.000   \n",
      "30  0.0   0.0   0.0               None         None  2019-03-20T08:51:57.000   \n",
      "31  0.0   0.0   0.0               None         None  2019-03-20T09:13:40.000   \n",
      "32  0.0   0.0   0.0               None         None  2019-03-20T09:26:08.000   \n",
      "\n",
      "                                             location precipitation  \\\n",
      "0   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "1   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "2   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "3   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "4   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "5   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "6   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "7   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "8   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "9   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "10  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "11  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "12  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "13  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "14  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "15  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "16  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "17  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "18  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "19  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "20  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "21  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "22  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "23  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "24  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "25  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "26  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "27  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "28  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "29  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "30  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "31  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "32  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "\n",
      "   relativeHumidity solarRadiation source temperature windDirection windSpeed  \\\n",
      "0              None           None   None        None          None      None   \n",
      "1              None           None   None        None          None      None   \n",
      "2              None           None   None        None          None      None   \n",
      "3              None           None   None        None          None      None   \n",
      "4              None           None   None        None          None      None   \n",
      "5              None           None   None        None          None      None   \n",
      "6              None           None   None        None          None      None   \n",
      "7              None           None   None        None          None      None   \n",
      "8              None           None   None        None          None      None   \n",
      "9              None           None   None        None          None      None   \n",
      "10             None           None   None        None          None      None   \n",
      "11             None           None   None        None          None      None   \n",
      "12             None           None   None        None          None      None   \n",
      "13             None           None   None        None          None      None   \n",
      "14             None           None   None        None          None      None   \n",
      "15             None           None   None        None          None      None   \n",
      "16             None           None   None        None          None      None   \n",
      "17             None           None   None        None          None      None   \n",
      "18             None           None   None        None          None      None   \n",
      "19             None           None   None        None          None      None   \n",
      "20             None           None   None        None          None      None   \n",
      "21             None           None   None        None          None      None   \n",
      "22             None           None   None        None          None      None   \n",
      "23             None           None   None        None          None      None   \n",
      "24             None           None   None        None          None      None   \n",
      "25             None           None   None        None          None      None   \n",
      "26             None           None   None        None          None      None   \n",
      "27             None           None   None        None          None      None   \n",
      "28             None           None   None        None          None      None   \n",
      "29             None           None   None        None          None      None   \n",
      "30             None           None   None        None          None      None   \n",
      "31             None           None   None        None          None      None   \n",
      "32             None           None   None        None          None      None   \n",
      "\n",
      "        long        lat                                          device_id  \n",
      "0  -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "1  -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "2  -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "3  -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "4  -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "5  -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "6  -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "7  -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "8  -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "9  -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "10 -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "11 -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "12 -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "13 -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "14 -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "15 -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "16 -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "17 -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "18 -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "19 -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "20 -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "21 -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "22 -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "23 -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "24 -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "25 -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "26 -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "27 -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "28 -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "29 -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "30 -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "31 -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "32 -8.605194  41.180222  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "WeatherObserved\n",
      "urn:ngsi-ld:WeatherObserved:porto:weather:ubiwhere:5b72dbfa06599b05e9a74f27\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "WeatherObserved\n",
      "    PM1  PM10  PM25 barometricPressure dataProvider             dateObserved  \\\n",
      "0   NaN   NaN   NaN               None         None  2019-03-05T23:08:44.000   \n",
      "1   NaN   NaN   NaN               None         None  2019-03-06T05:27:03.000   \n",
      "2   0.0   0.0   0.0               None         None  2019-03-20T04:29:10.000   \n",
      "3   0.0   0.0   0.0               None         None  2019-03-20T04:38:19.000   \n",
      "4   0.0   0.0   0.0               None         None  2019-03-20T04:54:25.000   \n",
      "5   0.0   0.0   0.0               None         None  2019-03-20T04:57:31.000   \n",
      "6   0.0   0.0   0.0               None         None  2019-03-20T05:07:02.000   \n",
      "7   0.0   0.0   0.0               None         None  2019-03-20T05:13:12.000   \n",
      "8   0.0   0.0   0.0               None         None  2019-03-20T05:26:58.000   \n",
      "9   0.0   0.0   0.0               None         None  2019-03-20T05:37:02.000   \n",
      "10  0.0   0.0   0.0               None         None  2019-03-20T05:43:18.000   \n",
      "11  0.0   0.0   0.0               None         None  2019-03-20T05:53:14.000   \n",
      "12  0.0   0.0   0.0               None         None  2019-03-20T05:59:25.000   \n",
      "13  0.0   0.0   0.0               None         None  2019-03-20T06:09:05.000   \n",
      "14  0.0   0.0   0.0               None         None  2019-03-20T06:12:11.000   \n",
      "15  0.0   0.0   0.0               None         None  2019-03-20T06:24:30.000   \n",
      "16  0.0   0.0   0.0               None         None  2019-03-20T06:28:03.000   \n",
      "17  0.0   0.0   0.0               None         None  2019-03-20T06:37:24.000   \n",
      "18  0.0   0.0   0.0               None         None  2019-03-20T06:53:16.000   \n",
      "19  0.0   0.0   0.0               None         None  2019-03-20T06:59:16.000   \n",
      "20  0.0   0.0   0.0               None         None  2019-03-20T08:13:19.000   \n",
      "21  0.0   0.0   0.0               None         None  2019-03-20T08:26:05.000   \n",
      "22  0.0   0.0   0.0               None         None  2019-03-20T10:41:51.000   \n",
      "\n",
      "                                             location precipitation  \\\n",
      "0   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "1   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "2   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "3   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "4   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "5   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "6   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "7   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "8   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "9   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "10  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "11  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "12  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "13  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "14  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "15  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "16  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "17  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "18  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "19  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "20  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "21  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "22  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "\n",
      "   relativeHumidity solarRadiation source temperature windDirection windSpeed  \\\n",
      "0              None           None   None        None          None      None   \n",
      "1              None           None   None        None          None      None   \n",
      "2              None           None   None        None          None      None   \n",
      "3              None           None   None        None          None      None   \n",
      "4              None           None   None        None          None      None   \n",
      "5              None           None   None        None          None      None   \n",
      "6              None           None   None        None          None      None   \n",
      "7              None           None   None        None          None      None   \n",
      "8              None           None   None        None          None      None   \n",
      "9              None           None   None        None          None      None   \n",
      "10             None           None   None        None          None      None   \n",
      "11             None           None   None        None          None      None   \n",
      "12             None           None   None        None          None      None   \n",
      "13             None           None   None        None          None      None   \n",
      "14             None           None   None        None          None      None   \n",
      "15             None           None   None        None          None      None   \n",
      "16             None           None   None        None          None      None   \n",
      "17             None           None   None        None          None      None   \n",
      "18             None           None   None        None          None      None   \n",
      "19             None           None   None        None          None      None   \n",
      "20             None           None   None        None          None      None   \n",
      "21             None           None   None        None          None      None   \n",
      "22             None           None   None        None          None      None   \n",
      "\n",
      "        long        lat                                          device_id  \n",
      "0  -8.590796  41.162596  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "1  -8.590796  41.162596  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "2  -8.590796  41.162596  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "3  -8.590796  41.162596  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "4  -8.590796  41.162596  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "5  -8.590796  41.162596  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "6  -8.590796  41.162596  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "7  -8.590796  41.162596  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "8  -8.590796  41.162596  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "9  -8.590796  41.162596  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "10 -8.590796  41.162596  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "11 -8.590796  41.162596  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "12 -8.590796  41.162596  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "13 -8.590796  41.162596  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "14 -8.590796  41.162596  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "15 -8.590796  41.162596  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "16 -8.590796  41.162596  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "17 -8.590796  41.162596  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "18 -8.590796  41.162596  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "19 -8.590796  41.162596  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "20 -8.590796  41.162596  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "21 -8.590796  41.162596  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "22 -8.590796  41.162596  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "WeatherObserved\n",
      "urn:ngsi-ld:WeatherObserved:porto:weather:ubiwhere:5adf39366f555a4514e7ea54\n",
      "WeatherObserved\n",
      "      PM1  PM10  PM25 barometricPressure dataProvider  \\\n",
      "0    None  None  None               None         None   \n",
      "1    None  None  None               None         None   \n",
      "2    None  None  None               None         None   \n",
      "3    None  None  None               None         None   \n",
      "4    None  None  None               None         None   \n",
      "5    None  None  None               None         None   \n",
      "6    None  None  None               None         None   \n",
      "7    None  None  None               None         None   \n",
      "8    None  None  None               None         None   \n",
      "9    None  None  None               None         None   \n",
      "10   None  None  None               None         None   \n",
      "11   None  None  None               None         None   \n",
      "12   None  None  None               None         None   \n",
      "13   None  None  None               None         None   \n",
      "14   None  None  None               None         None   \n",
      "15   None  None  None               None         None   \n",
      "16   None  None  None               None         None   \n",
      "17   None  None  None               None         None   \n",
      "18   None  None  None               None         None   \n",
      "19   None  None  None               None         None   \n",
      "20   None  None  None               None         None   \n",
      "21   None  None  None               None         None   \n",
      "22   None  None  None               None         None   \n",
      "23   None  None  None               None         None   \n",
      "24   None  None  None               None         None   \n",
      "25   None  None  None               None         None   \n",
      "26   None  None  None               None         None   \n",
      "27   None  None  None               None         None   \n",
      "28   None  None  None               None         None   \n",
      "29   None  None  None               None         None   \n",
      "..    ...   ...   ...                ...          ...   \n",
      "470  None  None  None               None         None   \n",
      "471  None  None  None               None         None   \n",
      "472  None  None  None               None         None   \n",
      "473  None  None  None               None         None   \n",
      "474  None  None  None               None         None   \n",
      "475  None  None  None               None         None   \n",
      "476  None  None  None               None         None   \n",
      "477  None  None  None               None         None   \n",
      "478  None  None  None               None         None   \n",
      "479  None  None  None               None         None   \n",
      "480  None  None  None               None         None   \n",
      "481  None  None  None               None         None   \n",
      "482  None  None  None               None         None   \n",
      "483  None  None  None               None         None   \n",
      "484  None  None  None               None         None   \n",
      "485  None  None  None               None         None   \n",
      "486  None  None  None               None         None   \n",
      "487  None  None  None               None         None   \n",
      "488  None  None  None               None         None   \n",
      "489  None  None  None               None         None   \n",
      "490  None  None  None               None         None   \n",
      "491  None  None  None               None         None   \n",
      "492  None  None  None               None         None   \n",
      "493  None  None  None               None         None   \n",
      "494  None  None  None               None         None   \n",
      "495  None  None  None               None         None   \n",
      "496  None  None  None               None         None   \n",
      "497  None  None  None               None         None   \n",
      "498  None  None  None               None         None   \n",
      "499  None  None  None               None         None   \n",
      "\n",
      "                dateObserved  \\\n",
      "0    2019-03-06T05:08:43.000   \n",
      "1    2019-03-06T05:12:00.000   \n",
      "2    2019-03-06T06:59:16.000   \n",
      "3    2019-03-06T07:08:32.000   \n",
      "4    2019-03-06T07:24:18.000   \n",
      "5    2019-03-06T07:27:22.000   \n",
      "6    2019-03-06T07:39:28.000   \n",
      "7    2019-03-06T07:42:43.000   \n",
      "8    2019-03-06T07:52:00.000   \n",
      "9    2019-03-06T07:58:03.000   \n",
      "10   2019-03-06T08:07:27.000   \n",
      "11   2019-03-06T08:13:39.000   \n",
      "12   2019-03-06T08:22:54.000   \n",
      "13   2019-03-06T08:28:55.000   \n",
      "14   2019-03-06T08:38:13.000   \n",
      "15   2019-03-06T08:53:21.000   \n",
      "16   2019-03-06T08:59:27.000   \n",
      "17   2019-03-06T09:08:38.000   \n",
      "18   2019-03-06T09:11:48.000   \n",
      "19   2019-03-06T09:24:00.000   \n",
      "20   2019-03-06T09:27:20.000   \n",
      "21   2019-03-06T09:39:32.000   \n",
      "22   2019-03-06T09:42:47.000   \n",
      "23   2019-03-06T09:52:03.000   \n",
      "24   2019-03-06T09:58:09.000   \n",
      "25   2019-03-06T10:07:24.000   \n",
      "26   2019-03-06T10:13:47.000   \n",
      "27   2019-03-06T10:22:51.000   \n",
      "28   2019-03-06T10:28:57.000   \n",
      "29   2019-03-06T10:38:20.000   \n",
      "..                       ...   \n",
      "470  2019-03-08T17:58:45.000   \n",
      "471  2019-03-08T18:07:57.000   \n",
      "472  2019-03-08T18:14:09.000   \n",
      "473  2019-03-08T18:23:29.000   \n",
      "474  2019-03-08T18:29:36.000   \n",
      "475  2019-03-11T09:23:02.000   \n",
      "476  2019-03-11T09:27:01.000   \n",
      "477  2019-03-11T09:42:30.000   \n",
      "478  2019-03-11T09:43:55.000   \n",
      "479  2019-03-11T09:52:38.000   \n",
      "480  2019-03-11T09:56:05.000   \n",
      "481  2019-03-11T10:08:22.000   \n",
      "482  2019-03-11T10:11:12.000   \n",
      "483  2019-03-11T10:23:32.000   \n",
      "484  2019-03-11T10:27:06.000   \n",
      "485  2019-03-11T10:38:17.000   \n",
      "486  2019-03-11T10:41:23.000   \n",
      "487  2019-03-11T10:53:50.000   \n",
      "488  2019-03-11T10:57:11.000   \n",
      "489  2019-03-11T11:06:32.000   \n",
      "490  2019-03-11T11:13:33.000   \n",
      "491  2019-03-11T11:24:12.000   \n",
      "492  2019-03-11T11:28:20.000   \n",
      "493  2019-03-11T11:37:44.000   \n",
      "494  2019-03-11T11:44:01.000   \n",
      "495  2019-03-11T11:54:03.000   \n",
      "496  2019-03-11T11:57:05.000   \n",
      "497  2019-03-11T12:09:26.000   \n",
      "498  2019-03-11T12:12:30.000   \n",
      "499  2019-03-11T12:21:55.000   \n",
      "\n",
      "                                              location precipitation  \\\n",
      "0    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "1    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "2    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "3    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "4    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "5    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "6    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "7    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "8    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "9    {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "10   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "11   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "12   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "13   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "14   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "15   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "16   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "17   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "18   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "19   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "20   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "21   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "22   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "23   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "24   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "25   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "26   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "27   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "28   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "29   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "..                                                 ...           ...   \n",
      "470  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "471  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "472  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "473  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "474  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "475  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "476  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "477  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "478  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "479  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "480  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "481  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "482  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "483  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "484  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "485  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "486  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "487  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "488  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "489  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "490  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "491  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "492  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "493  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "494  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "495  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "496  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "497  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "498  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "499  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "\n",
      "    relativeHumidity solarRadiation source temperature windDirection  \\\n",
      "0               None           None   None        None          None   \n",
      "1               None           None   None        None          None   \n",
      "2               None           None   None        None          None   \n",
      "3               None           None   None        None          None   \n",
      "4               None           None   None        None          None   \n",
      "5               None           None   None        None          None   \n",
      "6               None           None   None        None          None   \n",
      "7               None           None   None        None          None   \n",
      "8               None           None   None        None          None   \n",
      "9               None           None   None        None          None   \n",
      "10              None           None   None        None          None   \n",
      "11              None           None   None        None          None   \n",
      "12              None           None   None        None          None   \n",
      "13              None           None   None        None          None   \n",
      "14              None           None   None        None          None   \n",
      "15              None           None   None        None          None   \n",
      "16              None           None   None        None          None   \n",
      "17              None           None   None        None          None   \n",
      "18              None           None   None        None          None   \n",
      "19              None           None   None        None          None   \n",
      "20              None           None   None        None          None   \n",
      "21              None           None   None        None          None   \n",
      "22              None           None   None        None          None   \n",
      "23              None           None   None        None          None   \n",
      "24              None           None   None        None          None   \n",
      "25              None           None   None        None          None   \n",
      "26              None           None   None        None          None   \n",
      "27              None           None   None        None          None   \n",
      "28              None           None   None        None          None   \n",
      "29              None           None   None        None          None   \n",
      "..               ...            ...    ...         ...           ...   \n",
      "470             None           None   None        None          None   \n",
      "471             None           None   None        None          None   \n",
      "472             None           None   None        None          None   \n",
      "473             None           None   None        None          None   \n",
      "474             None           None   None        None          None   \n",
      "475             None           None   None        None          None   \n",
      "476             None           None   None        None          None   \n",
      "477             None           None   None        None          None   \n",
      "478             None           None   None        None          None   \n",
      "479             None           None   None        None          None   \n",
      "480             None           None   None        None          None   \n",
      "481             None           None   None        None          None   \n",
      "482             None           None   None        None          None   \n",
      "483             None           None   None        None          None   \n",
      "484             None           None   None        None          None   \n",
      "485             None           None   None        None          None   \n",
      "486             None           None   None        None          None   \n",
      "487             None           None   None        None          None   \n",
      "488             None           None   None        None          None   \n",
      "489             None           None   None        None          None   \n",
      "490             None           None   None        None          None   \n",
      "491             None           None   None        None          None   \n",
      "492             None           None   None        None          None   \n",
      "493             None           None   None        None          None   \n",
      "494             None           None   None        None          None   \n",
      "495             None           None   None        None          None   \n",
      "496             None           None   None        None          None   \n",
      "497             None           None   None        None          None   \n",
      "498             None           None   None        None          None   \n",
      "499             None           None   None        None          None   \n",
      "\n",
      "    windSpeed      long        lat  \\\n",
      "0        None -8.684325  41.173528   \n",
      "1        None -8.684325  41.173528   \n",
      "2        None -8.684325  41.173528   \n",
      "3        None -8.684325  41.173528   \n",
      "4        None -8.684325  41.173528   \n",
      "5        None -8.684325  41.173528   \n",
      "6        None -8.684325  41.173528   \n",
      "7        None -8.684325  41.173528   \n",
      "8        None -8.684325  41.173528   \n",
      "9        None -8.684325  41.173528   \n",
      "10       None -8.684325  41.173528   \n",
      "11       None -8.684325  41.173528   \n",
      "12       None -8.684325  41.173528   \n",
      "13       None -8.684325  41.173528   \n",
      "14       None -8.684325  41.173528   \n",
      "15       None -8.684325  41.173528   \n",
      "16       None -8.684325  41.173528   \n",
      "17       None -8.684325  41.173528   \n",
      "18       None -8.684325  41.173528   \n",
      "19       None -8.684325  41.173528   \n",
      "20       None -8.684325  41.173528   \n",
      "21       None -8.684325  41.173528   \n",
      "22       None -8.684325  41.173528   \n",
      "23       None -8.684325  41.173528   \n",
      "24       None -8.684325  41.173528   \n",
      "25       None -8.684325  41.173528   \n",
      "26       None -8.684325  41.173528   \n",
      "27       None -8.684325  41.173528   \n",
      "28       None -8.684325  41.173528   \n",
      "29       None -8.684325  41.173528   \n",
      "..        ...       ...        ...   \n",
      "470      None -8.684325  41.173528   \n",
      "471      None -8.684325  41.173528   \n",
      "472      None -8.684325  41.173528   \n",
      "473      None -8.684325  41.173528   \n",
      "474      None -8.684325  41.173528   \n",
      "475      None -8.684325  41.173528   \n",
      "476      None -8.684325  41.173528   \n",
      "477      None -8.684325  41.173528   \n",
      "478      None -8.684325  41.173528   \n",
      "479      None -8.684325  41.173528   \n",
      "480      None -8.684325  41.173528   \n",
      "481      None -8.684325  41.173528   \n",
      "482      None -8.684325  41.173528   \n",
      "483      None -8.684325  41.173528   \n",
      "484      None -8.684325  41.173528   \n",
      "485      None -8.684325  41.173528   \n",
      "486      None -8.684325  41.173528   \n",
      "487      None -8.684325  41.173528   \n",
      "488      None -8.684325  41.173528   \n",
      "489      None -8.684325  41.173528   \n",
      "490      None -8.684325  41.173528   \n",
      "491      None -8.684325  41.173528   \n",
      "492      None -8.684325  41.173528   \n",
      "493      None -8.684325  41.173528   \n",
      "494      None -8.684325  41.173528   \n",
      "495      None -8.684325  41.173528   \n",
      "496      None -8.684325  41.173528   \n",
      "497      None -8.684325  41.173528   \n",
      "498      None -8.684325  41.173528   \n",
      "499      None -8.684325  41.173528   \n",
      "\n",
      "                                             device_id  \n",
      "0    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "1    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "2    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "3    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "4    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "5    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "6    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "7    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "8    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "9    urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "10   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "11   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "12   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "13   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "14   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "15   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "16   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "17   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "18   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "19   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "20   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "21   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "22   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "23   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "24   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "25   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "26   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "27   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "28   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "29   urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "..                                                 ...  \n",
      "470  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "471  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "472  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "473  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "474  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "475  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "476  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "477  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "478  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "479  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "480  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "481  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "482  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "483  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "484  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "485  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "486  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "487  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "488  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "489  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "490  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "491  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "492  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "493  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "494  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "495  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "496  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "497  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "498  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "499  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "\n",
      "[500 rows x 17 columns]\n",
      "WeatherObserved\n",
      "urn:ngsi-ld:WeatherObserved:porto:weather:communityStations:IPORTO39\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "None\n",
      "WeatherObserved\n",
      "urn:ngsi-ld:WeatherObserved:porto:weather:ubiwhere:5b97a1a6e521e3053085c067\n",
      "WeatherObserved\n",
      "    PM1  PM10  PM25 barometricPressure dataProvider             dateObserved  \\\n",
      "0     0     0     0               None         None  2019-03-20T04:29:12.000   \n",
      "1     0     0     0               None         None  2019-03-20T04:38:21.000   \n",
      "2     0     0     0               None         None  2019-03-20T05:13:15.000   \n",
      "3     0     0     0               None         None  2019-03-20T05:26:53.000   \n",
      "4     0     0     0               None         None  2019-03-20T05:36:57.000   \n",
      "5     0     0     0               None         None  2019-03-20T05:43:08.000   \n",
      "6     0     0     0               None         None  2019-03-20T05:52:59.000   \n",
      "7     0     0     0               None         None  2019-03-20T06:24:32.000   \n",
      "8     0     0     0               None         None  2019-03-20T06:26:15.000   \n",
      "9     0     0     0               None         None  2019-03-20T06:37:27.000   \n",
      "10    0     0     0               None         None  2019-03-20T06:43:39.000   \n",
      "11    0     0     0               None         None  2019-03-20T06:53:18.000   \n",
      "12    0     0     0               None         None  2019-03-20T06:59:19.000   \n",
      "13    0     0     0               None         None  2019-03-20T07:09:05.000   \n",
      "14    0     0     0               None         None  2019-03-20T07:12:46.000   \n",
      "15    0     0     0               None         None  2019-03-20T07:22:31.000   \n",
      "16    0     0     0               None         None  2019-03-20T07:28:40.000   \n",
      "17    0     0     0               None         None  2019-03-20T07:38:31.000   \n",
      "18    0     0     0               None         None  2019-03-20T08:23:08.000   \n",
      "19    0     0     0               None         None  2019-03-20T08:29:05.000   \n",
      "20    0     0     0               None         None  2019-03-20T09:07:25.000   \n",
      "21    0     0     0               None         None  2019-03-20T09:13:35.000   \n",
      "22    0     0     0               None         None  2019-03-20T10:23:13.000   \n",
      "\n",
      "                                             location precipitation  \\\n",
      "0   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "1   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "2   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "3   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "4   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "5   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "6   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "7   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "8   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "9   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "10  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "11  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "12  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "13  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "14  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "15  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "16  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "17  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "18  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "19  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "20  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "21  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "22  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "\n",
      "   relativeHumidity solarRadiation source temperature windDirection windSpeed  \\\n",
      "0              None           None   None        None          None      None   \n",
      "1              None           None   None        None          None      None   \n",
      "2              None           None   None        None          None      None   \n",
      "3              None           None   None        None          None      None   \n",
      "4              None           None   None        None          None      None   \n",
      "5              None           None   None        None          None      None   \n",
      "6              None           None   None        None          None      None   \n",
      "7              None           None   None        None          None      None   \n",
      "8              None           None   None        None          None      None   \n",
      "9              None           None   None        None          None      None   \n",
      "10             None           None   None        None          None      None   \n",
      "11             None           None   None        None          None      None   \n",
      "12             None           None   None        None          None      None   \n",
      "13             None           None   None        None          None      None   \n",
      "14             None           None   None        None          None      None   \n",
      "15             None           None   None        None          None      None   \n",
      "16             None           None   None        None          None      None   \n",
      "17             None           None   None        None          None      None   \n",
      "18             None           None   None        None          None      None   \n",
      "19             None           None   None        None          None      None   \n",
      "20             None           None   None        None          None      None   \n",
      "21             None           None   None        None          None      None   \n",
      "22             None           None   None        None          None      None   \n",
      "\n",
      "        long        lat                                          device_id  \n",
      "0  -8.613186  41.171862  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "1  -8.613186  41.171862  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "2  -8.613186  41.171862  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "3  -8.613186  41.171862  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "4  -8.613186  41.171862  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "5  -8.613186  41.171862  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "6  -8.613186  41.171862  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "7  -8.613186  41.171862  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "8  -8.613186  41.171862  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "9  -8.613186  41.171862  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "10 -8.613186  41.171862  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "11 -8.613186  41.171862  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "12 -8.613186  41.171862  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "13 -8.613186  41.171862  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "14 -8.613186  41.171862  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "15 -8.613186  41.171862  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "16 -8.613186  41.171862  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "17 -8.613186  41.171862  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "18 -8.613186  41.171862  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "19 -8.613186  41.171862  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "20 -8.613186  41.171862  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "21 -8.613186  41.171862  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "22 -8.613186  41.171862  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "WeatherObserved\n",
      "urn:ngsi-ld:WeatherObserved:porto:weather:ubiwhere:5b632f2706599b05e998bed8\n",
      "WeatherObserved\n",
      "    PM1  PM10  PM25 barometricPressure dataProvider             dateObserved  \\\n",
      "0     0     0     0               None         None  2019-03-20T04:41:13.000   \n",
      "1     0     0     0               None         None  2019-03-20T04:54:35.000   \n",
      "2     0     0     0               None         None  2019-03-20T05:07:12.000   \n",
      "3     0     0     0               None         None  2019-03-20T05:13:22.000   \n",
      "4     0     0     0               None         None  2019-03-20T05:26:27.000   \n",
      "5     0     0     0               None         None  2019-03-20T05:36:33.000   \n",
      "6     0     0     0               None         None  2019-03-20T05:43:15.000   \n",
      "7     0     0     0               None         None  2019-03-20T05:59:17.000   \n",
      "8     0     0     0               None         None  2019-03-20T06:09:01.000   \n",
      "9     0     0     0               None         None  2019-03-20T06:12:04.000   \n",
      "10    0     0     0               None         None  2019-03-20T06:24:22.000   \n",
      "11    0     0     0               None         None  2019-03-20T06:27:58.000   \n",
      "12    0     0     0               None         None  2019-03-20T06:37:19.000   \n",
      "13    0     0     0               None         None  2019-03-20T06:43:27.000   \n",
      "14    0     0     0               None         None  2019-03-20T06:53:13.000   \n",
      "15    0     0     0               None         None  2019-03-20T06:59:11.000   \n",
      "16    0     0     0               None         None  2019-03-20T07:09:10.000   \n",
      "17    0     0     0               None         None  2019-03-20T07:13:01.000   \n",
      "18    0     0     0               None         None  2019-03-20T07:23:08.000   \n",
      "19    0     0     0               None         None  2019-03-20T07:41:20.000   \n",
      "\n",
      "                                             location precipitation  \\\n",
      "0   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "1   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "2   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "3   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "4   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "5   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "6   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "7   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "8   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "9   {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "10  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "11  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "12  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "13  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "14  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "15  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "16  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "17  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "18  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "19  {'crs': {'properties': {'name': 'EPSG:4326'}, ...          None   \n",
      "\n",
      "   relativeHumidity solarRadiation source temperature windDirection windSpeed  \\\n",
      "0              None           None   None        None          None      None   \n",
      "1              None           None   None        None          None      None   \n",
      "2              None           None   None        None          None      None   \n",
      "3              None           None   None        None          None      None   \n",
      "4              None           None   None        None          None      None   \n",
      "5              None           None   None        None          None      None   \n",
      "6              None           None   None        None          None      None   \n",
      "7              None           None   None        None          None      None   \n",
      "8              None           None   None        None          None      None   \n",
      "9              None           None   None        None          None      None   \n",
      "10             None           None   None        None          None      None   \n",
      "11             None           None   None        None          None      None   \n",
      "12             None           None   None        None          None      None   \n",
      "13             None           None   None        None          None      None   \n",
      "14             None           None   None        None          None      None   \n",
      "15             None           None   None        None          None      None   \n",
      "16             None           None   None        None          None      None   \n",
      "17             None           None   None        None          None      None   \n",
      "18             None           None   None        None          None      None   \n",
      "19             None           None   None        None          None      None   \n",
      "\n",
      "        long        lat                                          device_id  \n",
      "0  -8.672146  41.165162  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "1  -8.672146  41.165162  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "2  -8.672146  41.165162  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "3  -8.672146  41.165162  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "4  -8.672146  41.165162  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "5  -8.672146  41.165162  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "6  -8.672146  41.165162  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "7  -8.672146  41.165162  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "8  -8.672146  41.165162  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "9  -8.672146  41.165162  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "10 -8.672146  41.165162  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "11 -8.672146  41.165162  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "12 -8.672146  41.165162  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "13 -8.672146  41.165162  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "14 -8.672146  41.165162  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "15 -8.672146  41.165162  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "16 -8.672146  41.165162  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "17 -8.672146  41.165162  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "18 -8.672146  41.165162  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n",
      "19 -8.672146  41.165162  urn:ngsi-ld:WeatherObserved:porto:weather:ubiw...  \n"
     ]
    }
   ],
   "source": [
    "import pandas as pd \n",
    "\n",
    "api_url = \"http://history-data.urbanplatform.portodigital.pt\"\n",
    "\n",
    "df = pd.DataFrame()\n",
    "for resource in resource_list_flat:\n",
    "    print(entity)\n",
    "    print(resource)\n",
    "    df1 = getHistoricalData(api_url, device_id = resource, no=500, output=\"df\")\n",
    "    print(df1)\n",
    "    #print(df1.columns)\n",
    "    if df1 is not None:\n",
    "        if df.empty:\n",
    "            df = df1.copy()\n",
    "        else:\n",
    "            df = pd.concat([df,df1], sort=False)\n",
    "        #print(df.columns)  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "# DF operations\n",
    "\n",
    "import  time\n",
    "import datetime\n",
    "\n",
    "# Convert timestamp to unixtime\n",
    "def convert_df_to_unix(s):\n",
    "    time_mask = \"%Y-%m-%dT%H:%M:%S.%f\"\n",
    "    return(time.mktime(datetime.datetime.strptime(s, time_mask).timetuple()))\n",
    " \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['time'] = list(map(convert_df_to_unix, df['dateObserved']))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "./output/IOT_WeatherObserved_barometricPressure.csv\n",
      "./output/IOT_WeatherObserved_precipitation.csv\n",
      "./output/IOT_WeatherObserved_relativeHumidity.csv\n",
      "./output/IOT_WeatherObserved_solarRadiation.csv\n",
      "./output/IOT_WeatherObserved_temperature.csv\n",
      "./output/IOT_WeatherObserved_windDirection.csv\n",
      "./output/IOT_WeatherObserved_windSpeed.csv\n"
     ]
    }
   ],
   "source": [
    "## Save columns to csv in a custom order\n",
    "mandatory_column_list = [\"time\", \"lat\", \"long\"]\n",
    "\n",
    "if (entity is \"AirQualityObserved\"):\n",
    "    data_column_list = [\"CO\", \"NO2\", \"O3\", \"Ox\", \"PM1\", \"PM10\", \"PM25\"]\n",
    "\n",
    "    for data_column in data_column_list:\n",
    "        filepath = \"./output/\" + \"IOT_\" + \"AirQuality_\" + data_column + \".csv\"\n",
    "        print(filepath)\n",
    "        df.to_csv(filepath, columns = mandatory_column_list + [data_column], \n",
    "                  index = False, na_rep = \"\", header = True)\n",
    "\n",
    "elif (entity is \"NoiseLevelObserved\"):\n",
    "    data_column_list = [\"LAeq\"]\n",
    "    \n",
    "    for data_column in data_column_list:\n",
    "        filepath = \"./output/\" + \"IOT_\" + \"NoiseLevelObserved_\" + data_column + \".csv\"\n",
    "        print(filepath)\n",
    "        df.to_csv(filepath, columns = mandatory_column_list + [data_column], \n",
    "                  index = False, na_rep = \"\", header = True)\n",
    "\n",
    "elif (entity is \"TrafficFlowObserved\"):\n",
    "    data_column_list = [\"LAeq\"]\n",
    "    \n",
    "    for data_column in data_column_list:\n",
    "        filepath = \"./output/\" + \"IOT_\" + \"TrafficFlowObserved_\" + data_column + \".csv\"\n",
    "        print(filepath)\n",
    "        df.to_csv(filepath, columns = mandatory_column_list + [data_column], \n",
    "                  index = False, na_rep = \"\", header = True)\n",
    "\n",
    "elif (entity is \"WeatherObserved\"):\n",
    "    data_column_list = ['barometricPressure', 'precipitation', 'relativeHumidity',\n",
    "       'solarRadiation', 'temperature', 'windDirection', 'windSpeed']\n",
    "    \n",
    "    for data_column in data_column_list:\n",
    "        filepath = \"./output/\" + \"IOT_\" + \"WeatherObserved_\" + data_column + \".csv\"\n",
    "        print(filepath)\n",
    "        df.to_csv(filepath, columns = mandatory_column_list + [data_column], \n",
    "                  index = False, na_rep = \"\", header = True)\n",
    "        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Index(['PM1', 'PM10', 'PM25', 'barometricPressure', 'dataProvider',\n",
      "       'dateObserved', 'location', 'precipitation', 'relativeHumidity',\n",
      "       'solarRadiation', 'source', 'temperature', 'windDirection', 'windSpeed',\n",
      "       'long', 'lat', 'device_id', 'time'],\n",
      "      dtype='object')\n"
     ]
    }
   ],
   "source": [
    "print(df.columns)"
   ]
  }
 ],
 "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.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}