{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Explore ERDDAP timeseries data using Jupyter Widgets"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from erddapy import ERDDAP\n",
    "\n",
    "\n",
    "server = 'http://www.neracoos.org/erddap'\n",
    "e = ERDDAP(server=server)\n",
    "\n",
    "e.protocol = 'tabledap'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pendulum\n",
    "\n",
    "\n",
    "initial_standard_name = 'significant_height_of_wind_and_swell_waves'\n",
    "\n",
    "zoom = 6\n",
    "center = [42.5, -68]\n",
    "nchar = 3 # number of characters for short dataset name\n",
    "cdm_data_type = 'TimeSeries'\n",
    "\n",
    "max_time = pendulum.utcnow()\n",
    "min_time = pendulum.utcnow().subtract(weeks=2) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "\n",
    "url = '{}/categorize/standard_name/index.csv'.format(server)\n",
    "df = pd.read_csv(url, skiprows=[1, 2])\n",
    "variables = df['Category'].values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "import ipywidgets\n",
    "\n",
    "dpdown = ipywidgets.Dropdown(options=variables, value=initial_standard_name)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "def point(dataset, lon, lat, nchar):\n",
    "    geojsonFeature = {\n",
    "        \"type\": \"Feature\",\n",
    "        \"properties\": {\n",
    "            \"datasetID\": dataset,\n",
    "            \"short_dataset_name\": dataset[:nchar]\n",
    "        },\n",
    "        \"geometry\": {\n",
    "            \"type\": \"Point\",\n",
    "            \"coordinates\": [lon, lat]\n",
    "        }\n",
    "    };\n",
    "    geojsonFeature['properties']['style'] = {'color': 'Grey'}\n",
    "    return geojsonFeature"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "def adv_search(e, standard_name, cdm_data_type, min_time, max_time):\n",
    "    try:\n",
    "        search_url = e.get_search_url(\n",
    "            response='csv',\n",
    "            cdm_data_type=cdm_data_type.lower(),\n",
    "            items_per_page=100000,\n",
    "            standard_name=standard_name,\n",
    "            min_time=min_time,\n",
    "            max_time=max_time\n",
    "        )\n",
    "        df = pd.read_csv(search_url)\n",
    "    except:\n",
    "        df = []\n",
    "        if len(var)>14:\n",
    "            v = '{}...'.format(standard_name[:15])\n",
    "        else:\n",
    "            v = standard_name\n",
    "        figure.title = 'No {} found in this time range. Pick another variable.'.format(v)\n",
    "        figure.marks[0].y = 0.0 * figure.marks[0].y\n",
    "    return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "def alllonlat(e, cdm_data_type, min_time, max_time):\n",
    "    url='{}/tabledap/allDatasets.csv?datasetID%2CminLongitude%2CminLatitude&cdm_data_type=%22{}%22&minTime%3C={}&maxTime%3E={}'.format(e.server,cdm_data_type,max_time,min_time)\n",
    "    df = pd.read_csv(url, skiprows=[1])\n",
    "    return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "def stdname2geojson(e, standard_name, min_time, max_time, nchar):\n",
    "    dfa = adv_search(e, standard_name, cdm_data_type, min_time, max_time)\n",
    "    if isinstance(dfa, pd.DataFrame):\n",
    "        datasets = dfa['Dataset ID'].values\n",
    "        dfll = alllonlat(e, cdm_data_type, min_time, max_time)\n",
    "        dfr = dfll[dfll['datasetID'].isin(dfa['Dataset ID'])]\n",
    "        geojson = {'features':[point(row[1],row[2],row[3],nchar) for row in dfr.itertuples()]}\n",
    "    else:\n",
    "        geojson = {'features':[]}\n",
    "        datasets = []\n",
    "    return geojson, datasets"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "def click_handler(event=None, id=None, properties=None):\n",
    "    datasetID = properties['datasetID']\n",
    "    kwargs = {'time>=': min_time, 'time<=': max_time}\n",
    "    df, var = get_data(datasetID, dpdown.value, kwargs)\n",
    "    figure.marks[0].x = df.index\n",
    "    figure.marks[0].y = df[var]\n",
    "    figure.title = '{} - {}'.format(properties['short_dataset_name'], var)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "import ipyleaflet\n",
    "\n",
    "\n",
    "def update_dpdown(change):\n",
    "    standard_name = change['new']\n",
    "    data, datasets = stdname2geojson(e, standard_name, min_time, max_time, nchar)\n",
    "    feature_layer = ipyleaflet.GeoJSON(data=data)\n",
    "    feature_layer.on_click(click_handler)\n",
    "    m.layers = [m.layers[0], feature_layer]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "dpdown.observe(update_dpdown, names=['value'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_data(dataset, standard_name, kwargs):\n",
    "    var = e.get_var_by_attr(\n",
    "        dataset_id=dataset,\n",
    "        standard_name=lambda v: str(v).lower() == standard_name)[0]\n",
    "    e.dataset_id = dataset\n",
    "    e.variables = ['time', var]\n",
    "    e.constraints = kwargs\n",
    "    df = e.to_pandas(index_col='time', parse_dates=True, skiprows=[1])\n",
    "    return df, var"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "m = ipyleaflet.Map(\n",
    "    center=center,\n",
    "    zoom=zoom,\n",
    ")\n",
    "\n",
    "data, datasets = stdname2geojson(e, initial_standard_name, min_time, max_time, nchar)\n",
    "feature_layer = ipyleaflet.GeoJSON(data=data)\n",
    "feature_layer.on_click(click_handler)\n",
    "m.layers = [m.layers[0], feature_layer]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "import bqplot\n",
    "\n",
    "\n",
    "dt_x = bqplot.DateScale()\n",
    "sc_y = bqplot.LinearScale()\n",
    "\n",
    "initial_dataset = datasets[0]\n",
    "kwargs = {'time>=': min_time, 'time<=': max_time}\n",
    "df, var = get_data(initial_dataset, initial_standard_name, kwargs)\n",
    "time_series = bqplot.Lines(x=df.index, y=df[var], scales={'x': dt_x, 'y': sc_y})\n",
    "ax_x = bqplot.Axis(scale=dt_x, label='Time')\n",
    "ax_y = bqplot.Axis(scale=sc_y, orientation='vertical')\n",
    "figure = bqplot.Figure(marks=[time_series], axes=[ax_x, ax_y])\n",
    "figure.title = '{} - {}'.format(initial_dataset[:nchar], var)\n",
    "figure.layout.height = '300px'\n",
    "figure.layout.width = '800px'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "66401cc9002944c283c043fd5d0d2a96",
       "version_major": 2,
       "version_minor": 0
      },
      "text/html": [
       "<p>Failed to display Jupyter Widget of type <code>VBox</code>.</p>\n",
       "<p>\n",
       "  If you're reading this message in the Jupyter Notebook or JupyterLab Notebook, it may mean\n",
       "  that the widgets JavaScript is still loading. If this message persists, it\n",
       "  likely means that the widgets JavaScript library is either not installed or\n",
       "  not enabled. See the <a href=\"https://ipywidgets.readthedocs.io/en/stable/user_install.html\">Jupyter\n",
       "  Widgets Documentation</a> for setup instructions.\n",
       "</p>\n",
       "<p>\n",
       "  If you're reading this message in another frontend (for example, a static\n",
       "  rendering on GitHub or <a href=\"https://nbviewer.jupyter.org/\">NBViewer</a>),\n",
       "  it may mean that your frontend doesn't currently support widgets.\n",
       "</p>\n"
      ],
      "text/plain": [
       "VBox(children=(Dropdown(index=110, options=('air_temperature', 'air_temperature_data_quality', 'altitude', 'altitude_data_quality', 'altitude_max', 'altitude_max_data_quality', 'altitude_min', 'altitude_min_data_quality', 'barometric_pressure', 'barometric_pressure_data_quality', 'beam_attenuation_data_quality', 'chlorophyll_concentration_in_sea_water', 'chlorophyll_data_quality', 'concentration_of_chlorophyll_in_sea_water', 'concentration_of_colored_dissolved_organic_matter_in_sea_water_expressed_as_equivalent_mass_fraction_of_quinine_sulfate_dihydrate', 'conductivity_data_quality', 'current_direction_data_quality', 'current_speed_data_quality', 'depth', 'depth_status_flag', 'direction_of_sea_water_velocity', 'direction_of_sea_water_velocity_data_quality', 'dissolved_oxygen_data_quality', 'dominant_wave_period_data_quality', 'eastward_sea_water_velocity', 'eastward_sea_water_velocity_data_quality', 'eastward_sea_water_velocity_status_flag', 'ed_par_data_quality', 'fractional_saturation_of_oxygen_in_sea_water', 'latitude', 'latitude_status_flag', 'longitude', 'longitude_status_flag', 'mass_concentration_of_oxygen_in_sea_water', 'mean_wave_direction', 'mean_wave_direction_qc', 'mole_concentration_of_nitrate_in_sea_water', 'nitrate_data_quality', 'northward_sea_water_velocity', 'northward_sea_water_velocity_data_quality', 'northward_sea_water_velocity_status_flag', 'northward_wind', 'offset_time', 'oxygen_saturation_data_quality', 'percent_oxygen_saturation', 'percent_oxygen_saturation_data_quality', 'period', 'period_data_quality', 'principal_wave_direction', 'principal_wave_direction_qc', 'quinine_sulfate_equivalent_data_quality', 'quinine_sulfate_equivalent_in_sea_water', 'r1', 'r1_qc', 'r2', 'r2_qc', 'relative_humidity', 'salinity_data_quality', 'sea_surface_mean_wave_direction_spread', 'sea_surface_mean_wave_direction_spread_qc', 'sea_surface_mean_wave_from_direction', 'sea_surface_mean_wave_from_direction_qc', 'sea_surface_pricipal_wave_direction_spread', 'sea_surface_pricipal_wave_direction_spread_qc', 'sea_surface_principal_wave_from_direction', 'sea_surface_principal_wave_from_direction_qc', 'sea_surface_swell_and_wind_wave_separation_frequency', 'sea_surface_swell_and_wind_wave_separation_frequency_qc', 'sea_surface_wave_dominant_period', 'sea_surface_wave_dominant_period_3', 'sea_surface_wave_dominant_period_3_qc', 'sea_surface_wave_dominant_period_qc', 'sea_surface_wave_maximum_height', 'sea_surface_wave_maximum_height_3', 'sea_surface_wave_maximum_height_3_qc', 'sea_surface_wave_maximum_height_qc', 'sea_surface_wave_significant_height', 'sea_surface_wave_significant_height_3', 'sea_surface_wave_significant_height_3_qc', 'sea_surface_wave_significant_height_qc', 'sea_surface_wave_steepness', 'sea_surface_wave_steepness_qc', 'sea_surface_wave_swell_height', 'sea_surface_wave_swell_height_qc', 'sea_surface_wave_swell_period', 'sea_surface_wave_swell_period_qc', 'sea_surface_wave_to_direction', 'sea_surface_wave_wind_height', 'sea_surface_wave_wind_height_qc', 'sea_surface_wave_wind_period', 'sea_surface_wave_wind_period_qc', 'sea_water_density', 'sea_water_density_data_quality', 'sea_water_density_status_flag', 'sea_water_electrical_conductivity', 'sea_water_electrical_conductivity_status_flag', 'sea_water_percent_transmission', 'sea_water_pressure', 'sea_water_pressure_data_quality', 'sea_water_pressure_status_flag', 'sea_water_salinity', 'sea_water_salinity_data_quality', 'sea_water_salinity_status_flag', 'sea_water_sigma_t', 'sea_water_temperature', 'sea_water_temperature_data_quality', 'sea_water_temperature_status_flag', 'sea_water_velocity', 'sea_water_velocity_data_quality', 'sigma_t_data_quality', 'significant_height_of_wind_and_swell_waves', 'significant_height_of_wind_and_swell_waves_data_quality', 'significant_wave_height_data_quality', 'station_name', 'temperature_data_quality', 'time', 'time_status_flag', 'transmission_volts', 'transmissivity_data_quality', 'transmissivity_voltage_data_quality', 'turbidity_data_quality', 'turbidity_date_quality', 'turbidity_of_sea_water', 'visibility_data_quality', 'visibility_in_air', 'visibility_in_air_data_quality', 'volume_beam_attenuation_coefficient_of_radiative_flux_in_sea_water', 'volume_fraction_of_oxygen_in_sea_water', 'water_level', 'wind_direction_data_quality', 'wind_from_direction', 'wind_from_direction_data_quality', 'wind_gust_1s_data_quality', 'wind_gust_data_quality', 'wind_gust_time_data_quality', 'wind_min_data_quality', 'wind_percent_good', 'wind_percent_good_data_quality', 'wind_source', 'wind_speed', 'wind_speed_data_quality', 'wind_speed_of_gust'), value='significant_height_of_wind_and_swell_waves'), Map(basemap={'url': 'https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png', 'max_zoom': 19, 'attribution': 'Map data (c) <a href=\"https://openstreetmap.org\">OpenStreetMap</a> contributors'}, center=[42.5, -68], default_tiles=TileLayer(base=True, max_zoom=19, min_zoom=1, options=['attribution', 'detect_retina', 'max_zoom', 'min_zoom', 'tile_size']), layers=(TileLayer(base=True, max_zoom=19, min_zoom=1, options=['attribution', 'detect_retina', 'max_zoom', 'min_zoom', 'tile_size']), GeoJSON(data={'features': [{'type': 'Feature', 'properties': {'datasetID': 'A01_accelerometer_all', 'short_dataset_name': 'A01', 'style': {'color': 'Grey'}}, 'geometry': {'type': 'Point', 'coordinates': [-70.56606, 42.51825]}}, {'type': 'Feature', 'properties': {'datasetID': 'B01_accelerometer_all', 'short_dataset_name': 'B01', 'style': {'color': 'Grey'}}, 'geometry': {'type': 'Point', 'coordinates': [-70.42755, 43.17927]}}, {'type': 'Feature', 'properties': {'datasetID': 'E01_accelerometer_all', 'short_dataset_name': 'E01', 'style': {'color': 'Grey'}}, 'geometry': {'type': 'Point', 'coordinates': [-69.35537, 43.714079999999996]}}, {'type': 'Feature', 'properties': {'datasetID': 'F01_accelerometer_all', 'short_dataset_name': 'F01', 'style': {'color': 'Grey'}}, 'geometry': {'type': 'Point', 'coordinates': [-68.99826, 44.05341]}}, {'type': 'Feature', 'properties': {'datasetID': 'M01_accelerometer_all', 'short_dataset_name': 'M01', 'style': {'color': 'Grey'}}, 'geometry': {'type': 'Point', 'coordinates': [-67.8798, 43.4907]}}]})), options=['attribution_control', 'basemap', 'bounce_at_zoom_limits', 'box_zoom', 'center', 'close_popup_on_click', 'double_click_zoom', 'dragging', 'inertia', 'inertia_deceleration', 'inertia_max_speed', 'keyboard', 'keyboard_pan_offset', 'keyboard_zoom_offset', 'max_zoom', 'min_zoom', 'scroll_wheel_zoom', 'tap', 'tap_tolerance', 'touch_zoom', 'world_copy_jump', 'zoom', 'zoom_animation_threshold', 'zoom_control', 'zoom_start'], zoom=6), Figure(axes=[Axis(label='Time', scale=DateScale()), Axis(orientation='vertical', scale=LinearScale())], fig_margin={'top': 60, 'bottom': 60, 'left': 60, 'right': 60}, layout=Layout(height='300px', min_width='125px', width='800px'), marks=[Lines(colors=['#1f77b4', '#ff7f0e', '#2ca02c', '#d62728', '#9467bd', '#8c564b', '#e377c2', '#7f7f7f', '#bcbd22', '#17becf'], interactions={'hover': 'tooltip'}, scales={'x': DateScale(), 'y': LinearScale()}, scales_metadata={'x': {'orientation': 'horizontal', 'dimension': 'x'}, 'y': {'orientation': 'vertical', 'dimension': 'y'}, 'color': {'dimension': 'color'}}, tooltip_style={'opacity': 0.9}, x=array(['2018-02-02T22:00:00.000000000', '2018-02-02T22:30:00.000000000',\n",
       "       '2018-02-02T23:00:00.000000000', '2018-02-02T23:30:00.000000000',\n",
       "       '2018-02-03T00:00:00.000000000', '2018-02-03T00:30:00.000000000',\n",
       "       '2018-02-03T01:00:00.000000000', '2018-02-03T01:30:00.000000000',\n",
       "       '2018-02-03T02:00:00.000000000', '2018-02-03T02:30:00.000000000',\n",
       "       '2018-02-03T03:00:00.000000000', '2018-02-03T03:30:00.000000000',\n",
       "       '2018-02-03T04:00:00.000000000', '2018-02-03T04:30:00.000000000',\n",
       "       '2018-02-03T05:00:00.000000000', '2018-02-03T05:30:00.000000000',\n",
       "       '2018-02-03T06:00:00.000000000', '2018-02-03T06:30:00.000000000',\n",
       "       '2018-02-03T07:00:00.000000000', '2018-02-03T07:30:00.000000000',\n",
       "       '2018-02-03T08:00:00.000000000', '2018-02-03T08:30:00.000000000',\n",
       "       '2018-02-03T09:00:00.000000000', '2018-02-03T09:30:00.000000000',\n",
       "       '2018-02-03T10:00:00.000000000', '2018-02-03T10:30:00.000000000',\n",
       "       '2018-02-03T11:00:00.000000000', '2018-02-03T11:30:00.000000000',\n",
       "       '2018-02-03T12:00:00.000000000', '2018-02-03T12:30:00.000000000',\n",
       "       '2018-02-03T13:00:00.000000000', '2018-02-03T13:30:00.000000000',\n",
       "       '2018-02-03T14:00:00.000000000', '2018-02-03T14:30:00.000000000',\n",
       "       '2018-02-03T15:00:00.000000000', '2018-02-03T15:30:00.000000000',\n",
       "       '2018-02-03T16:00:00.000000000', '2018-02-03T16:30:00.000000000',\n",
       "       '2018-02-03T17:00:00.000000000', '2018-02-03T17:30:00.000000000',\n",
       "       '2018-02-03T18:00:00.000000000', '2018-02-03T18:30:00.000000000',\n",
       "       '2018-02-03T19:00:00.000000000', '2018-02-03T19:30:00.000000000',\n",
       "       '2018-02-03T20:00:00.000000000', '2018-02-03T20:30:00.000000000',\n",
       "       '2018-02-03T21:00:00.000000000', '2018-02-03T21:30:00.000000000',\n",
       "       '2018-02-03T22:00:00.000000000', '2018-02-03T22:30:00.000000000',\n",
       "       '2018-02-03T23:00:00.000000000', '2018-02-03T23:30:00.000000000',\n",
       "       '2018-02-04T00:00:00.000000000', '2018-02-04T00:30:00.000000000',\n",
       "       '2018-02-04T01:00:00.000000000', '2018-02-04T01:30:00.000000000',\n",
       "       '2018-02-04T02:00:00.000000000', '2018-02-04T02:30:00.000000000',\n",
       "       '2018-02-04T03:00:00.000000000', '2018-02-04T03:30:00.000000000',\n",
       "       '2018-02-04T04:00:00.000000000', '2018-02-04T04:30:00.000000000',\n",
       "       '2018-02-04T05:00:00.000000000', '2018-02-04T05:30:00.000000000',\n",
       "       '2018-02-04T06:00:00.000000000', '2018-02-04T06:30:00.000000000',\n",
       "       '2018-02-04T07:00:00.000000000', '2018-02-04T07:30:00.000000000',\n",
       "       '2018-02-04T08:00:00.000000000', '2018-02-04T08:30:00.000000000',\n",
       "       '2018-02-04T09:00:00.000000000', '2018-02-04T09:30:00.000000000',\n",
       "       '2018-02-04T10:00:00.000000000', '2018-02-04T10:30:00.000000000',\n",
       "       '2018-02-04T11:00:00.000000000', '2018-02-04T11:30:00.000000000',\n",
       "       '2018-02-04T12:00:00.000000000', '2018-02-04T12:30:00.000000000',\n",
       "       '2018-02-04T13:00:00.000000000', '2018-02-04T13:30:00.000000000',\n",
       "       '2018-02-04T14:00:00.000000000', '2018-02-04T14:30:00.000000000',\n",
       "       '2018-02-04T15:00:00.000000000', '2018-02-04T15:30:00.000000000',\n",
       "       '2018-02-04T16:00:00.000000000', '2018-02-04T16:30:00.000000000',\n",
       "       '2018-02-04T17:00:00.000000000', '2018-02-04T17:30:00.000000000',\n",
       "       '2018-02-04T18:00:00.000000000', '2018-02-04T18:30:00.000000000',\n",
       "       '2018-02-04T19:00:00.000000000', '2018-02-04T19:30:00.000000000',\n",
       "       '2018-02-04T20:00:00.000000000', '2018-02-04T20:30:00.000000000',\n",
       "       '2018-02-04T21:00:00.000000000', '2018-02-04T21:30:00.000000000',\n",
       "       '2018-02-04T22:00:00.000000000', '2018-02-04T22:30:00.000000000',\n",
       "       '2018-02-04T23:00:00.000000000', '2018-02-04T23:30:00.000000000',\n",
       "       '2018-02-05T00:00:00.000000000', '2018-02-05T00:30:00.000000000',\n",
       "       '2018-02-05T01:00:00.000000000', '2018-02-05T01:30:00.000000000',\n",
       "       '2018-02-05T02:00:00.000000000', '2018-02-05T02:30:00.000000000',\n",
       "       '2018-02-05T03:00:00.000000000', '2018-02-05T03:30:00.000000000',\n",
       "       '2018-02-05T04:00:00.000000000', '2018-02-05T04:30:00.000000000',\n",
       "       '2018-02-05T05:00:00.000000000', '2018-02-05T05:30:00.000000000',\n",
       "       '2018-02-05T06:00:00.000000000', '2018-02-05T06:30:00.000000000',\n",
       "       '2018-02-05T07:00:00.000000000', '2018-02-05T07:30:00.000000000',\n",
       "       '2018-02-05T08:00:00.000000000', '2018-02-05T08:30:00.000000000',\n",
       "       '2018-02-05T09:00:00.000000000', '2018-02-05T09:30:00.000000000',\n",
       "       '2018-02-05T10:00:00.000000000', '2018-02-05T10:30:00.000000000',\n",
       "       '2018-02-05T11:00:00.000000000', '2018-02-05T11:30:00.000000000',\n",
       "       '2018-02-05T12:00:00.000000000', '2018-02-05T12:30:00.000000000',\n",
       "       '2018-02-05T13:00:00.000000000', '2018-02-05T13:30:00.000000000',\n",
       "       '2018-02-05T14:00:00.000000000', '2018-02-05T14:30:00.000000000',\n",
       "       '2018-02-05T15:00:00.000000000', '2018-02-05T15:30:00.000000000',\n",
       "       '2018-02-05T16:00:00.000000000', '2018-02-05T16:30:00.000000000',\n",
       "       '2018-02-05T17:00:00.000000000', '2018-02-05T17:30:00.000000000',\n",
       "       '2018-02-05T18:00:00.000000000', '2018-02-05T18:30:00.000000000',\n",
       "       '2018-02-05T19:00:00.000000000', '2018-02-05T19:30:00.000000000',\n",
       "       '2018-02-05T20:00:00.000000000', '2018-02-05T20:30:00.000000000',\n",
       "       '2018-02-05T21:00:00.000000000', '2018-02-05T21:30:00.000000000',\n",
       "       '2018-02-05T22:00:00.000000000', '2018-02-05T22:30:00.000000000',\n",
       "       '2018-02-05T23:00:00.000000000', '2018-02-05T23:30:00.000000000',\n",
       "       '2018-02-06T00:00:00.000000000', '2018-02-06T00:30:00.000000000',\n",
       "       '2018-02-06T01:00:00.000000000', '2018-02-06T01:30:00.000000000',\n",
       "       '2018-02-06T02:00:00.000000000', '2018-02-06T02:30:00.000000000',\n",
       "       '2018-02-06T03:00:00.000000000', '2018-02-06T03:30:00.000000000',\n",
       "       '2018-02-06T04:00:00.000000000', '2018-02-06T04:30:00.000000000',\n",
       "       '2018-02-06T05:00:00.000000000', '2018-02-06T05:30:00.000000000',\n",
       "       '2018-02-06T06:00:00.000000000', '2018-02-06T06:30:00.000000000',\n",
       "       '2018-02-06T07:00:00.000000000', '2018-02-06T07:30:00.000000000',\n",
       "       '2018-02-06T08:00:00.000000000', '2018-02-06T08:30:00.000000000',\n",
       "       '2018-02-06T09:00:00.000000000', '2018-02-06T09:30:00.000000000',\n",
       "       '2018-02-06T10:00:00.000000000', '2018-02-06T10:30:00.000000000',\n",
       "       '2018-02-06T11:00:00.000000000', '2018-02-06T11:30:00.000000000',\n",
       "       '2018-02-06T12:00:00.000000000', '2018-02-06T12:30:00.000000000',\n",
       "       '2018-02-06T13:00:00.000000000', '2018-02-06T13:30:00.000000000',\n",
       "       '2018-02-06T14:00:00.000000000', '2018-02-06T14:30:00.000000000',\n",
       "       '2018-02-06T15:00:00.000000000', '2018-02-06T15:30:00.000000000',\n",
       "       '2018-02-06T16:00:00.000000000', '2018-02-06T16:30:00.000000000',\n",
       "       '2018-02-06T17:00:00.000000000', '2018-02-06T17:30:00.000000000',\n",
       "       '2018-02-06T18:00:00.000000000', '2018-02-06T18:30:00.000000000',\n",
       "       '2018-02-06T19:00:00.000000000', '2018-02-06T19:30:00.000000000',\n",
       "       '2018-02-06T20:00:00.000000000', '2018-02-06T20:30:00.000000000',\n",
       "       '2018-02-06T21:00:00.000000000', '2018-02-06T21:30:00.000000000',\n",
       "       '2018-02-06T22:00:00.000000000', '2018-02-06T22:30:00.000000000',\n",
       "       '2018-02-06T23:00:00.000000000', '2018-02-06T23:30:00.000000000',\n",
       "       '2018-02-07T00:00:00.000000000', '2018-02-07T00:30:00.000000000',\n",
       "       '2018-02-07T01:00:00.000000000', '2018-02-07T01:30:00.000000000',\n",
       "       '2018-02-07T02:00:00.000000000', '2018-02-07T02:30:00.000000000',\n",
       "       '2018-02-07T03:00:00.000000000', '2018-02-07T03:30:00.000000000',\n",
       "       '2018-02-07T04:00:00.000000000', '2018-02-07T04:30:00.000000000',\n",
       "       '2018-02-07T05:00:00.000000000', '2018-02-07T05:30:00.000000000',\n",
       "       '2018-02-07T06:00:00.000000000', '2018-02-07T06:30:00.000000000',\n",
       "       '2018-02-07T07:00:00.000000000', '2018-02-07T07:30:00.000000000',\n",
       "       '2018-02-07T08:00:00.000000000', '2018-02-07T08:30:00.000000000',\n",
       "       '2018-02-07T09:00:00.000000000', '2018-02-07T09:30:00.000000000',\n",
       "       '2018-02-07T10:00:00.000000000', '2018-02-07T10:30:00.000000000',\n",
       "       '2018-02-07T11:00:00.000000000', '2018-02-07T11:30:00.000000000',\n",
       "       '2018-02-07T12:00:00.000000000', '2018-02-07T12:30:00.000000000',\n",
       "       '2018-02-07T13:00:00.000000000', '2018-02-07T13:30:00.000000000',\n",
       "       '2018-02-07T14:00:00.000000000', '2018-02-07T14:30:00.000000000',\n",
       "       '2018-02-07T15:00:00.000000000', '2018-02-07T15:30:00.000000000',\n",
       "       '2018-02-07T16:00:00.000000000', '2018-02-07T16:30:00.000000000',\n",
       "       '2018-02-07T17:00:00.000000000', '2018-02-07T17:30:00.000000000',\n",
       "       '2018-02-07T18:00:00.000000000', '2018-02-07T18:30:00.000000000',\n",
       "       '2018-02-07T19:00:00.000000000', '2018-02-07T19:30:00.000000000',\n",
       "       '2018-02-07T20:00:00.000000000', '2018-02-07T20:30:00.000000000',\n",
       "       '2018-02-07T21:00:00.000000000', '2018-02-07T21:30:00.000000000',\n",
       "       '2018-02-07T22:00:00.000000000', '2018-02-07T22:30:00.000000000',\n",
       "       '2018-02-07T23:00:00.000000000', '2018-02-07T23:30:00.000000000',\n",
       "       '2018-02-08T00:00:00.000000000', '2018-02-08T00:30:00.000000000',\n",
       "       '2018-02-08T01:00:00.000000000', '2018-02-08T01:30:00.000000000',\n",
       "       '2018-02-08T02:00:00.000000000', '2018-02-08T02:30:00.000000000',\n",
       "       '2018-02-08T03:00:00.000000000', '2018-02-08T03:30:00.000000000',\n",
       "       '2018-02-08T04:00:00.000000000', '2018-02-08T04:30:00.000000000',\n",
       "       '2018-02-08T05:00:00.000000000', '2018-02-08T05:30:00.000000000',\n",
       "       '2018-02-08T06:00:00.000000000', '2018-02-08T06:30:00.000000000',\n",
       "       '2018-02-08T07:00:00.000000000', '2018-02-08T07:30:00.000000000',\n",
       "       '2018-02-08T08:00:00.000000000', '2018-02-08T08:30:00.000000000',\n",
       "       '2018-02-08T09:00:00.000000000', '2018-02-08T09:30:00.000000000',\n",
       "       '2018-02-08T10:00:00.000000000', '2018-02-08T10:30:00.000000000',\n",
       "       '2018-02-08T11:00:00.000000000', '2018-02-08T11:30:00.000000000',\n",
       "       '2018-02-08T12:00:00.000000000', '2018-02-08T12:30:00.000000000',\n",
       "       '2018-02-08T13:00:00.000000000', '2018-02-08T13:30:00.000000000',\n",
       "       '2018-02-08T14:00:00.000000000', '2018-02-08T14:30:00.000000000',\n",
       "       '2018-02-08T15:00:00.000000000', '2018-02-08T15:30:00.000000000',\n",
       "       '2018-02-08T16:00:00.000000000', '2018-02-08T16:30:00.000000000',\n",
       "       '2018-02-08T17:00:00.000000000', '2018-02-08T17:30:00.000000000',\n",
       "       '2018-02-08T18:00:00.000000000', '2018-02-08T18:30:00.000000000',\n",
       "       '2018-02-08T19:00:00.000000000', '2018-02-08T19:30:00.000000000',\n",
       "       '2018-02-08T20:00:00.000000000', '2018-02-08T20:30:00.000000000',\n",
       "       '2018-02-08T21:00:00.000000000', '2018-02-08T21:30:00.000000000',\n",
       "       '2018-02-08T22:00:00.000000000', '2018-02-08T22:30:00.000000000',\n",
       "       '2018-02-08T23:00:00.000000000', '2018-02-08T23:30:00.000000000',\n",
       "       '2018-02-09T00:00:00.000000000', '2018-02-09T00:30:00.000000000',\n",
       "       '2018-02-09T01:00:00.000000000', '2018-02-09T01:30:00.000000000',\n",
       "       '2018-02-09T02:00:00.000000000', '2018-02-09T02:30:00.000000000',\n",
       "       '2018-02-09T03:00:00.000000000', '2018-02-09T03:30:00.000000000',\n",
       "       '2018-02-09T04:00:00.000000000', '2018-02-09T04:30:00.000000000',\n",
       "       '2018-02-09T05:00:00.000000000', '2018-02-09T05:30:00.000000000',\n",
       "       '2018-02-09T06:00:00.000000000', '2018-02-09T06:30:00.000000000',\n",
       "       '2018-02-09T07:00:00.000000000', '2018-02-09T07:30:00.000000000',\n",
       "       '2018-02-09T08:00:00.000000000', '2018-02-09T08:30:00.000000000',\n",
       "       '2018-02-09T09:00:00.000000000', '2018-02-09T09:30:00.000000000',\n",
       "       '2018-02-09T10:00:00.000000000', '2018-02-09T10:30:00.000000000',\n",
       "       '2018-02-09T11:00:00.000000000', '2018-02-09T11:30:00.000000000',\n",
       "       '2018-02-09T12:00:00.000000000', '2018-02-09T12:30:00.000000000',\n",
       "       '2018-02-09T13:00:00.000000000', '2018-02-09T13:30:00.000000000',\n",
       "       '2018-02-09T14:00:00.000000000', '2018-02-09T14:30:00.000000000',\n",
       "       '2018-02-09T15:00:00.000000000', '2018-02-09T15:30:00.000000000',\n",
       "       '2018-02-09T16:00:00.000000000', '2018-02-09T16:30:00.000000000',\n",
       "       '2018-02-09T17:00:00.000000000', '2018-02-09T17:30:00.000000000',\n",
       "       '2018-02-09T18:00:00.000000000', '2018-02-09T18:30:00.000000000',\n",
       "       '2018-02-09T19:00:00.000000000', '2018-02-09T19:30:00.000000000',\n",
       "       '2018-02-09T20:00:00.000000000', '2018-02-09T20:30:00.000000000',\n",
       "       '2018-02-09T21:00:00.000000000', '2018-02-09T21:30:00.000000000',\n",
       "       '2018-02-09T22:00:00.000000000', '2018-02-09T22:30:00.000000000',\n",
       "       '2018-02-09T23:00:00.000000000', '2018-02-09T23:30:00.000000000',\n",
       "       '2018-02-10T00:00:00.000000000', '2018-02-10T00:30:00.000000000',\n",
       "       '2018-02-10T01:00:00.000000000', '2018-02-10T01:30:00.000000000',\n",
       "       '2018-02-10T02:00:00.000000000', '2018-02-10T02:30:00.000000000',\n",
       "       '2018-02-10T03:00:00.000000000', '2018-02-10T03:30:00.000000000',\n",
       "       '2018-02-10T04:00:00.000000000', '2018-02-10T04:30:00.000000000',\n",
       "       '2018-02-10T05:00:00.000000000', '2018-02-10T05:30:00.000000000',\n",
       "       '2018-02-10T06:00:00.000000000', '2018-02-10T06:30:00.000000000',\n",
       "       '2018-02-10T07:00:00.000000000', '2018-02-10T07:30:00.000000000',\n",
       "       '2018-02-10T08:00:00.000000000', '2018-02-10T08:30:00.000000000',\n",
       "       '2018-02-10T09:00:00.000000000', '2018-02-10T09:30:00.000000000',\n",
       "       '2018-02-10T10:00:00.000000000', '2018-02-10T10:30:00.000000000',\n",
       "       '2018-02-10T11:00:00.000000000', '2018-02-10T11:30:00.000000000',\n",
       "       '2018-02-10T12:00:00.000000000', '2018-02-10T12:30:00.000000000',\n",
       "       '2018-02-10T13:00:00.000000000', '2018-02-10T13:30:00.000000000',\n",
       "       '2018-02-10T14:00:00.000000000', '2018-02-10T14:30:00.000000000',\n",
       "       '2018-02-10T15:00:00.000000000', '2018-02-10T15:30:00.000000000',\n",
       "       '2018-02-10T16:00:00.000000000', '2018-02-10T16:30:00.000000000',\n",
       "       '2018-02-10T17:00:00.000000000', '2018-02-10T17:30:00.000000000',\n",
       "       '2018-02-10T18:00:00.000000000', '2018-02-10T18:30:00.000000000',\n",
       "       '2018-02-10T19:00:00.000000000', '2018-02-10T19:30:00.000000000',\n",
       "       '2018-02-10T20:00:00.000000000', '2018-02-10T20:30:00.000000000',\n",
       "       '2018-02-10T21:00:00.000000000', '2018-02-10T21:30:00.000000000',\n",
       "       '2018-02-10T22:00:00.000000000', '2018-02-10T22:30:00.000000000',\n",
       "       '2018-02-10T23:00:00.000000000', '2018-02-10T23:30:00.000000000',\n",
       "       '2018-02-11T00:00:00.000000000', '2018-02-11T00:30:00.000000000',\n",
       "       '2018-02-11T01:00:00.000000000', '2018-02-11T01:30:00.000000000',\n",
       "       '2018-02-11T02:00:00.000000000', '2018-02-11T02:30:00.000000000',\n",
       "       '2018-02-11T03:00:00.000000000', '2018-02-11T03:30:00.000000000',\n",
       "       '2018-02-11T04:00:00.000000000', '2018-02-11T04:30:00.000000000',\n",
       "       '2018-02-11T05:00:00.000000000', '2018-02-11T05:30:00.000000000',\n",
       "       '2018-02-11T06:00:00.000000000', '2018-02-11T06:30:00.000000000',\n",
       "       '2018-02-11T07:00:00.000000000', '2018-02-11T07:30:00.000000000',\n",
       "       '2018-02-11T08:00:00.000000000', '2018-02-11T08:30:00.000000000',\n",
       "       '2018-02-11T09:00:00.000000000', '2018-02-11T09:30:00.000000000',\n",
       "       '2018-02-11T10:00:00.000000000', '2018-02-11T10:30:00.000000000',\n",
       "       '2018-02-11T11:00:00.000000000', '2018-02-11T11:30:00.000000000',\n",
       "       '2018-02-11T12:00:00.000000000', '2018-02-11T12:30:00.000000000',\n",
       "       '2018-02-11T13:00:00.000000000', '2018-02-11T13:30:00.000000000',\n",
       "       '2018-02-11T14:00:00.000000000', '2018-02-11T14:30:00.000000000',\n",
       "       '2018-02-11T15:00:00.000000000', '2018-02-11T15:30:00.000000000',\n",
       "       '2018-02-11T16:00:00.000000000', '2018-02-11T16:30:00.000000000',\n",
       "       '2018-02-11T17:00:00.000000000', '2018-02-11T17:30:00.000000000',\n",
       "       '2018-02-11T18:00:00.000000000', '2018-02-11T18:30:00.000000000',\n",
       "       '2018-02-11T19:00:00.000000000', '2018-02-11T19:30:00.000000000',\n",
       "       '2018-02-11T20:00:00.000000000', '2018-02-11T20:30:00.000000000',\n",
       "       '2018-02-11T21:00:00.000000000', '2018-02-11T21:30:00.000000000',\n",
       "       '2018-02-11T22:00:00.000000000', '2018-02-11T22:30:00.000000000',\n",
       "       '2018-02-11T23:00:00.000000000', '2018-02-11T23:30:00.000000000',\n",
       "       '2018-02-12T00:00:00.000000000', '2018-02-12T00:30:00.000000000',\n",
       "       '2018-02-12T01:00:00.000000000', '2018-02-12T01:30:00.000000000',\n",
       "       '2018-02-12T02:00:00.000000000', '2018-02-12T02:30:00.000000000',\n",
       "       '2018-02-12T03:00:00.000000000', '2018-02-12T03:30:00.000000000',\n",
       "       '2018-02-12T04:00:00.000000000', '2018-02-12T04:30:00.000000000',\n",
       "       '2018-02-12T05:00:00.000000000', '2018-02-12T05:30:00.000000000',\n",
       "       '2018-02-12T06:00:00.000000000', '2018-02-12T06:30:00.000000000',\n",
       "       '2018-02-12T07:00:00.000000000', '2018-02-12T07:30:00.000000000',\n",
       "       '2018-02-12T08:00:00.000000000', '2018-02-12T08:30:00.000000000',\n",
       "       '2018-02-12T09:00:00.000000000', '2018-02-12T09:30:00.000000000',\n",
       "       '2018-02-12T10:00:00.000000000', '2018-02-12T10:30:00.000000000',\n",
       "       '2018-02-12T11:00:00.000000000', '2018-02-12T11:30:00.000000000',\n",
       "       '2018-02-12T12:00:00.000000000', '2018-02-12T12:30:00.000000000',\n",
       "       '2018-02-12T13:00:00.000000000', '2018-02-12T13:30:00.000000000',\n",
       "       '2018-02-12T14:00:00.000000000', '2018-02-12T14:30:00.000000000',\n",
       "       '2018-02-12T15:00:00.000000000', '2018-02-12T15:30:00.000000000',\n",
       "       '2018-02-12T16:00:00.000000000', '2018-02-12T16:30:00.000000000',\n",
       "       '2018-02-12T17:00:00.000000000', '2018-02-12T17:30:00.000000000',\n",
       "       '2018-02-12T18:00:00.000000000', '2018-02-12T18:30:00.000000000',\n",
       "       '2018-02-12T19:00:00.000000000', '2018-02-12T19:30:00.000000000',\n",
       "       '2018-02-12T20:00:00.000000000', '2018-02-12T20:30:00.000000000',\n",
       "       '2018-02-12T21:00:00.000000000', '2018-02-12T21:30:00.000000000',\n",
       "       '2018-02-12T22:00:00.000000000', '2018-02-12T22:30:00.000000000',\n",
       "       '2018-02-12T23:00:00.000000000', '2018-02-12T23:30:00.000000000',\n",
       "       '2018-02-13T00:00:00.000000000', '2018-02-13T00:30:00.000000000',\n",
       "       '2018-02-13T01:00:00.000000000', '2018-02-13T01:30:00.000000000',\n",
       "       '2018-02-13T02:00:00.000000000', '2018-02-13T02:30:00.000000000',\n",
       "       '2018-02-13T03:00:00.000000000', '2018-02-13T03:30:00.000000000',\n",
       "       '2018-02-13T04:00:00.000000000', '2018-02-13T04:30:00.000000000',\n",
       "       '2018-02-13T05:00:00.000000000', '2018-02-13T05:30:00.000000000',\n",
       "       '2018-02-13T06:00:00.000000000', '2018-02-13T06:30:00.000000000',\n",
       "       '2018-02-13T07:00:00.000000000', '2018-02-13T07:30:00.000000000',\n",
       "       '2018-02-13T08:00:00.000000000', '2018-02-13T08:30:00.000000000',\n",
       "       '2018-02-13T09:00:00.000000000', '2018-02-13T09:30:00.000000000',\n",
       "       '2018-02-13T10:00:00.000000000', '2018-02-13T10:30:00.000000000',\n",
       "       '2018-02-13T11:00:00.000000000', '2018-02-13T11:30:00.000000000',\n",
       "       '2018-02-13T12:00:00.000000000', '2018-02-13T12:30:00.000000000',\n",
       "       '2018-02-13T13:00:00.000000000', '2018-02-13T13:30:00.000000000',\n",
       "       '2018-02-13T14:00:00.000000000', '2018-02-13T14:30:00.000000000',\n",
       "       '2018-02-13T15:00:00.000000000', '2018-02-13T15:30:00.000000000',\n",
       "       '2018-02-13T16:00:00.000000000', '2018-02-13T16:30:00.000000000',\n",
       "       '2018-02-13T17:00:00.000000000', '2018-02-13T17:30:00.000000000',\n",
       "       '2018-02-13T18:00:00.000000000', '2018-02-13T18:30:00.000000000',\n",
       "       '2018-02-13T19:00:00.000000000', '2018-02-13T19:30:00.000000000',\n",
       "       '2018-02-13T20:00:00.000000000', '2018-02-13T20:30:00.000000000',\n",
       "       '2018-02-13T21:00:00.000000000', '2018-02-13T21:30:00.000000000',\n",
       "       '2018-02-13T22:00:00.000000000', '2018-02-13T22:30:00.000000000',\n",
       "       '2018-02-13T23:00:00.000000000', '2018-02-13T23:30:00.000000000',\n",
       "       '2018-02-14T00:00:00.000000000', '2018-02-14T00:30:00.000000000',\n",
       "       '2018-02-14T01:00:00.000000000', '2018-02-14T01:30:00.000000000',\n",
       "       '2018-02-14T02:00:00.000000000', '2018-02-14T02:30:00.000000000',\n",
       "       '2018-02-14T03:00:00.000000000', '2018-02-14T03:30:00.000000000',\n",
       "       '2018-02-14T04:00:00.000000000', '2018-02-14T04:30:00.000000000',\n",
       "       '2018-02-14T05:00:00.000000000', '2018-02-14T05:30:00.000000000',\n",
       "       '2018-02-14T06:00:00.000000000', '2018-02-14T06:30:00.000000000',\n",
       "       '2018-02-14T07:00:00.000000000', '2018-02-14T07:30:00.000000000',\n",
       "       '2018-02-14T08:00:00.000000000', '2018-02-14T08:30:00.000000000',\n",
       "       '2018-02-14T09:00:00.000000000', '2018-02-14T09:30:00.000000000',\n",
       "       '2018-02-14T10:00:00.000000000', '2018-02-14T10:30:00.000000000',\n",
       "       '2018-02-14T11:00:00.000000000', '2018-02-14T11:30:00.000000000',\n",
       "       '2018-02-14T12:00:00.000000000', '2018-02-14T12:30:00.000000000',\n",
       "       '2018-02-14T13:00:00.000000000', '2018-02-14T13:30:00.000000000',\n",
       "       '2018-02-14T14:00:00.000000000', '2018-02-14T14:30:00.000000000',\n",
       "       '2018-02-14T15:00:00.000000000', '2018-02-14T15:30:00.000000000',\n",
       "       '2018-02-14T16:00:00.000000000', '2018-02-14T16:30:00.000000000',\n",
       "       '2018-02-14T17:00:00.000000000', '2018-02-14T17:30:00.000000000',\n",
       "       '2018-02-14T18:00:00.000000000', '2018-02-14T18:30:00.000000000',\n",
       "       '2018-02-14T19:00:00.000000000', '2018-02-14T19:30:00.000000000',\n",
       "       '2018-02-14T20:00:00.000000000', '2018-02-14T20:30:00.000000000',\n",
       "       '2018-02-14T21:00:00.000000000', '2018-02-14T21:30:00.000000000',\n",
       "       '2018-02-14T22:00:00.000000000', '2018-02-14T22:30:00.000000000',\n",
       "       '2018-02-14T23:00:00.000000000', '2018-02-14T23:30:00.000000000',\n",
       "       '2018-02-15T00:00:00.000000000', '2018-02-15T00:30:00.000000000',\n",
       "       '2018-02-15T01:00:00.000000000', '2018-02-15T01:30:00.000000000',\n",
       "       '2018-02-15T02:00:00.000000000', '2018-02-15T02:30:00.000000000',\n",
       "       '2018-02-15T03:00:00.000000000', '2018-02-15T03:30:00.000000000',\n",
       "       '2018-02-15T04:00:00.000000000', '2018-02-15T04:30:00.000000000',\n",
       "       '2018-02-15T05:00:00.000000000', '2018-02-15T05:30:00.000000000',\n",
       "       '2018-02-15T06:00:00.000000000', '2018-02-15T06:30:00.000000000',\n",
       "       '2018-02-15T07:00:00.000000000', '2018-02-15T07:30:00.000000000',\n",
       "       '2018-02-15T08:00:00.000000000', '2018-02-15T08:30:00.000000000',\n",
       "       '2018-02-15T09:00:00.000000000', '2018-02-15T09:30:00.000000000',\n",
       "       '2018-02-15T10:00:00.000000000', '2018-02-15T10:30:00.000000000',\n",
       "       '2018-02-15T11:00:00.000000000', '2018-02-15T11:30:00.000000000',\n",
       "       '2018-02-15T12:00:00.000000000', '2018-02-15T12:30:00.000000000',\n",
       "       '2018-02-15T13:00:00.000000000', '2018-02-15T13:30:00.000000000',\n",
       "       '2018-02-15T14:00:00.000000000', '2018-02-15T14:30:00.000000000',\n",
       "       '2018-02-15T15:00:00.000000000', '2018-02-15T15:30:00.000000000',\n",
       "       '2018-02-15T16:00:00.000000000', '2018-02-15T16:30:00.000000000',\n",
       "       '2018-02-15T17:00:00.000000000', '2018-02-15T17:30:00.000000000',\n",
       "       '2018-02-15T18:00:00.000000000', '2018-02-15T18:30:00.000000000',\n",
       "       '2018-02-15T19:00:00.000000000', '2018-02-15T19:30:00.000000000',\n",
       "       '2018-02-15T20:00:00.000000000', '2018-02-15T20:30:00.000000000',\n",
       "       '2018-02-15T21:00:00.000000000', '2018-02-15T21:30:00.000000000',\n",
       "       '2018-02-15T22:00:00.000000000', '2018-02-15T22:30:00.000000000',\n",
       "       '2018-02-15T23:00:00.000000000', '2018-02-15T23:30:00.000000000',\n",
       "       '2018-02-16T00:00:00.000000000', '2018-02-16T00:30:00.000000000',\n",
       "       '2018-02-16T01:00:00.000000000', '2018-02-16T01:30:00.000000000',\n",
       "       '2018-02-16T02:00:00.000000000', '2018-02-16T02:30:00.000000000',\n",
       "       '2018-02-16T03:00:00.000000000', '2018-02-16T03:30:00.000000000',\n",
       "       '2018-02-16T04:00:00.000000000', '2018-02-16T04:30:00.000000000',\n",
       "       '2018-02-16T05:00:00.000000000', '2018-02-16T05:30:00.000000000',\n",
       "       '2018-02-16T06:00:00.000000000', '2018-02-16T06:30:00.000000000',\n",
       "       '2018-02-16T07:00:00.000000000', '2018-02-16T07:30:00.000000000',\n",
       "       '2018-02-16T08:00:00.000000000', '2018-02-16T08:30:00.000000000',\n",
       "       '2018-02-16T09:00:00.000000000', '2018-02-16T09:30:00.000000000',\n",
       "       '2018-02-16T10:00:00.000000000', '2018-02-16T10:30:00.000000000',\n",
       "       '2018-02-16T11:00:00.000000000', '2018-02-16T11:30:00.000000000',\n",
       "       '2018-02-16T12:00:00.000000000', '2018-02-16T12:30:00.000000000',\n",
       "       '2018-02-16T13:00:00.000000000', '2018-02-16T13:30:00.000000000',\n",
       "       '2018-02-16T14:00:00.000000000', '2018-02-16T14:30:00.000000000',\n",
       "       '2018-02-16T15:00:00.000000000', '2018-02-16T15:30:00.000000000',\n",
       "       '2018-02-16T16:00:00.000000000', '2018-02-16T16:30:00.000000000',\n",
       "       '2018-02-16T17:00:00.000000000', '2018-02-16T17:30:00.000000000',\n",
       "       '2018-02-16T18:00:00.000000000', '2018-02-16T18:30:00.000000000',\n",
       "       '2018-02-16T19:00:00.000000000', '2018-02-16T19:30:00.000000000',\n",
       "       '2018-02-16T20:00:00.000000000', '2018-02-16T20:30:00.000000000',\n",
       "       '2018-02-16T21:00:00.000000000'], dtype='datetime64[ns]'), y=array([1.1800781 , 1.239122  , 1.3275846 , 1.3509958 , 1.3604097 ,\n",
       "       1.4268982 , 1.4002063 , 1.2691324 , 1.4709682 , 1.4312291 ,\n",
       "       1.4380323 , 1.2593193 , 1.2106168 , 1.2357525 , 1.1843417 ,\n",
       "       1.2073144 , 1.1430012 , 1.1976529 , 1.0418861 , 1.0281513 ,\n",
       "       0.9462591 , 0.98366225, 0.93811315, 0.7527226 , 0.7458004 ,\n",
       "       0.6829935 , 0.7057101 , 0.6637191 , 0.7351182 , 0.7233138 ,\n",
       "       0.73983186, 0.7472818 , 0.7879517 , 0.8097894 , 0.7687782 ,\n",
       "       0.8154573 , 0.87070024, 0.9047054 , 0.84228814, 0.7302177 ,\n",
       "       0.86203897, 0.8266562 , 0.7782325 , 0.7967029 , 0.76078475,\n",
       "       0.69579065, 0.73154545, 0.74848324, 0.8029035 , 0.8453038 ,\n",
       "       0.8032242 , 0.8898096 , 1.1300107 , 0.862231  , 0.94813514,\n",
       "       0.98764   , 1.1350542 , 1.0589914 , 1.1435047 , 1.1700798 ,\n",
       "       1.0871288 , 1.0045869 , 1.1136328 , 1.0124662 , 1.1980754 ,\n",
       "       1.1514761 , 1.1599241 , 1.3716085 , 1.4947375 , 1.4573426 ,\n",
       "       1.2816316 , 1.2199355 , 1.2892494 , 1.2313287 , 1.2962698 ,\n",
       "       1.1827959 , 1.1820732 , 1.3534795 , 1.3587142 , 1.1445633 ,\n",
       "       1.1253275 , 1.0747598 , 1.0233209 , 1.0672575 , 0.989351  ,\n",
       "       1.111385  , 1.033074  , 1.1496775 , 1.0929967 , 1.0305252 ,\n",
       "       0.9409236 , 0.8662808 , 0.8579985 , 0.7716737 , 0.7697254 ,\n",
       "       0.85249245, 1.0122864 , 0.99670184, 1.2667037 , 1.577876  ,\n",
       "       1.1458377 , 1.4054266 , 1.3085904 , 1.3631756 , 1.6795206 ,\n",
       "       1.539928  , 1.5541072 , 1.5741496 , 1.6670899 , 1.5386369 ,\n",
       "       1.4957844 , 1.2913121 , 1.1498184 , 1.0839342 , 1.0413489 ,\n",
       "       0.8665929 , 0.8218501 , 0.9290239 , 0.9625346 , 0.9938219 ,\n",
       "       1.0244269 , 1.0393194 , 0.9593416 , 1.1122425 , 0.60071045,\n",
       "       0.5046899 , 1.2612966 , 1.6575222 , 1.4863001 , 1.4000739 ,\n",
       "       1.4956062 , 1.3184268 , 1.2323512 , 1.0046538 , 1.6236529 ,\n",
       "       1.2100025 , 1.6568502 , 1.8127431 , 1.2127272 , 1.1730794 ,\n",
       "       1.7010367 , 1.507619  , 1.5676868 , 1.5664276 , 1.5977504 ,\n",
       "       1.4080627 , 0.7931246 , 1.3442479 , 0.6330973 , 1.3617415 ,\n",
       "       1.3288683 , 0.6626136 , 0.632596  , 1.3721082 , 1.2237104 ,\n",
       "       0.5165573 , 1.435058  , 1.5750573 , 1.2880819 , 1.0474609 ,\n",
       "       1.3113707 , 1.3019414 , 1.2804637 , 1.3149909 , 1.1612711 ,\n",
       "       1.3748052 , 0.9986443 , 0.9691221 , 0.84026074, 0.7608973 ,\n",
       "       1.0897008 , 1.0201272 , 1.2372917 , 1.091978  , 1.2561336 ,\n",
       "       1.1585374 , 1.0397379 , 1.2278825 , 1.3000027 , 1.202229  ,\n",
       "       1.3170693 , 0.61556   , 1.4442414 , 1.3712527 , 1.3205173 ,\n",
       "       1.3852708 , 1.2633015 , 0.47082287, 1.2169007 , 1.1159655 ,\n",
       "       1.0493307 , 1.2445401 , 1.2614225 , 1.1947385 , 1.5211896 ,\n",
       "       1.455168  , 1.230031  , 1.5541941 , 1.2689575 , 1.127162  ,\n",
       "       1.0204551 , 1.2593439 , 1.1876117 , 1.2094922 , 1.2529281 ,\n",
       "       1.006127  , 0.93931115, 0.91953397, 0.82693565, 0.74617934,\n",
       "       0.7322291 , 0.83184344, 0.73633695, 0.77164584, 1.0245491 ,\n",
       "       0.76969934, 0.6778304 , 0.9345874 , 0.74677545, 0.82513   ,\n",
       "       0.68244255, 0.65806484, 0.68344086, 0.91190803, 0.9801122 ,\n",
       "       0.88452786, 0.78316575, 0.8271828 , 0.5391882 , 1.1153549 ,\n",
       "       0.8599398 , 1.0902364 , 0.99627215, 0.96626496, 0.97553015,\n",
       "       1.1202087 , 1.1768894 , 1.493712  , 1.3703972 , 1.6292104 ,\n",
       "       1.5219083 , 1.5956023 , 1.5010723 , 1.5638345 , 1.5856436 ,\n",
       "       1.4153999 , 1.5767766 , 1.2980136 , 1.3621395 , 1.3552308 ,\n",
       "       1.5611447 , 1.3621448 , 1.5641301 , 1.1962299 , 1.338665  ,\n",
       "       1.4704878 , 1.5985888 , 1.4197812 , 1.3985168 , 1.168225  ,\n",
       "       1.4455001 , 1.2860917 , 1.0264627 , 1.1605524 , 1.1422805 ,\n",
       "       1.1784023 , 1.2902542 , 1.0730113 , 1.3818213 , 1.0261723 ,\n",
       "       1.2169597 , 1.0391787 , 0.92524743, 0.7821953 , 0.8110422 ,\n",
       "       0.8775045 , 1.018475  , 0.67005914, 1.0509636 , 0.64800775,\n",
       "       0.61080027, 0.71234024, 1.116599  , 0.6171465 , 0.65784144,\n",
       "       0.6272405 , 0.61203575, 0.66420865, 0.43114632, 0.89915824,\n",
       "       0.49338782, 1.0734321 , 0.52987343, 0.86949396, 0.48683712,\n",
       "       0.9056446 , 0.8319841 , 0.7362993 , 0.80346763, 0.920934  ,\n",
       "       0.9780131 , 0.7114041 , 0.67456925, 0.41492504, 0.45417246,\n",
       "       0.806952  , 0.7180327 , 1.002358  , 0.8315188 , 1.0625325 ,\n",
       "       0.6777964 , 0.6633959 , 0.7263085 , 0.7877345 , 0.87258595,\n",
       "       0.7548184 , 0.7474462 , 0.6687004 , 0.64921355, 0.5453635 ,\n",
       "       0.5540503 , 0.54701525, 0.4322376 , 0.56355065, 0.3860466 ,\n",
       "       0.38148156, 0.41418153, 0.40409067, 0.55313236, 0.32658485,\n",
       "       0.30511197, 0.50348127, 0.41561753, 0.40720016, 0.3932017 ,\n",
       "       0.3863416 , 0.3928081 , 0.37808838, 0.30006924, 0.5591785 ,\n",
       "       0.73006886, 0.82693404, 0.96789926, 0.9701071 , 0.94144773,\n",
       "       1.071323  , 1.0537748 , 0.967368  , 0.89214766, 0.814284  ,\n",
       "       0.8263982 , 0.870003  , 0.9969309 , 0.9915326 , 1.0869684 ,\n",
       "       1.135471  , 1.0266801 , 1.0483571 , 1.1214392 , 1.0346189 ,\n",
       "       1.0767117 , 1.0476452 , 1.1746236 , 1.1330274 , 0.9960071 ,\n",
       "       1.0251396 , 1.0992364 , 0.94381845, 0.8714495 , 0.9091378 ,\n",
       "       0.7907717 , 0.71601224, 0.62652653, 0.713112  , 0.5486573 ,\n",
       "       0.54919314, 0.6453429 , 0.6718623 , 0.69556266, 0.803314  ,\n",
       "       0.7756292 , 0.8179616 , 0.8330223 , 0.83814186, 0.74756575,\n",
       "       0.7717435 , 0.81573385, 0.7661887 , 0.831096  , 0.8630474 ,\n",
       "       0.85519946, 0.7835784 , 0.84137374, 0.80320734, 0.71676177,\n",
       "       0.8034686 , 0.72735703, 0.6891029 , 0.6528552 , 0.68195635,\n",
       "       0.639877  , 0.7239649 , 0.6827006 , 0.5776616 , 0.67869663,\n",
       "       0.7086312 , 0.69031614, 0.66732633, 0.6595762 , 0.738026  ,\n",
       "       0.7377489 , 0.7611417 , 0.66095936, 0.7303914 , 0.41328257,\n",
       "       0.7714249 , 0.7976213 , 0.8510234 , 0.784565  , 0.94474626,\n",
       "       0.97272   , 1.0046095 , 0.95062566, 0.7815754 , 1.047161  ,\n",
       "       0.92942166, 1.0183727 , 0.96341854, 1.1614972 , 1.0169504 ,\n",
       "       0.9678055 , 1.1067599 , 1.0623343 , 1.1200503 , 1.1120765 ,\n",
       "       0.9977555 , 0.9976016 , 0.8516821 , 0.8215348 , 0.9882888 ,\n",
       "       0.79972607, 0.7978945 , 0.90495175, 0.88373893, 0.9221129 ,\n",
       "       0.9259283 , 0.65998006, 0.90867525, 0.95100456, 0.8988717 ,\n",
       "       0.9122108 , 1.019874  , 1.0745782 , 0.9301324 , 1.0527413 ,\n",
       "       1.0798341 , 0.98646605, 0.9679311 , 1.0601747 , 1.1040132 ,\n",
       "       1.0760665 , 0.9249719 , 1.0355617 , 0.5174206 , 1.0970702 ,\n",
       "       0.90907174, 0.9692445 , 0.9350799 , 1.1103754 , 0.5253708 ,\n",
       "       0.97427976, 0.8571422 , 0.5717885 , 0.88257   , 1.0046499 ,\n",
       "       0.85703117, 0.5271113 , 1.0496957 , 0.6433854 , 0.8860377 ,\n",
       "       0.8660585 , 0.9129329 , 0.4707356 , 0.89137626, 0.4776168 ,\n",
       "       0.46089607, 0.87467533, 0.50557756, 0.5336518 , 0.53698355,\n",
       "       0.4929499 , 0.5087069 , 0.57516503, 0.54722995, 0.518098  ,\n",
       "       1.302295  , 0.8678179 , 0.84974253, 0.9295875 , 0.9397722 ,\n",
       "       1.0678071 , 1.1349428 , 0.97170347, 0.95405215, 0.8948298 ,\n",
       "       0.8620502 , 0.8545132 , 0.88485175, 0.91312206, 0.9701885 ,\n",
       "       0.891299  , 0.7627469 , 0.7185001 , 0.922277  , 0.6275409 ,\n",
       "       0.6474189 , 0.81539506, 0.75363344, 0.51679564, 0.62726116,\n",
       "       0.60467017, 0.62499624, 0.5935751 , 0.6604314 , 0.6920424 ,\n",
       "       0.6467726 , 0.6090828 , 0.6403331 , 0.6129194 , 0.6440024 ,\n",
       "       0.5719086 , 0.6240135 , 0.6259589 , 0.4713698 , 0.499585  ,\n",
       "       0.5443537 , 0.63693464, 0.7370951 , 0.90121186, 0.96974206,\n",
       "       1.0923697 , 1.0351443 , 0.9356248 , 1.0228604 , 0.9533354 ,\n",
       "       0.852047  , 0.8638    , 0.8064278 , 0.8531578 , 0.77126044,\n",
       "       0.81365675, 0.76412   , 0.7927644 , 0.75265175, 0.7380975 ,\n",
       "       0.78066075, 0.9304619 , 0.8579008 , 0.885464  , 0.9360931 ,\n",
       "       1.0885499 , 1.0885488 , 1.1819948 , 0.99962074, 0.8794643 ,\n",
       "       0.8623826 , 0.8550291 , 0.75017893, 0.75328374, 0.6844286 ,\n",
       "       0.60633034, 0.5692001 , 0.55966043, 0.5056053 , 0.52520764,\n",
       "       0.54513156, 0.53625876, 0.5674256 , 0.55283844, 0.48796508,\n",
       "       0.55763704, 0.4446053 , 0.40457067, 0.41841048, 0.42819872,\n",
       "       0.4522102 , 0.52810544, 0.6240842 , 0.67395705, 0.6478322 ,\n",
       "       0.64609855, 0.54513955, 0.58500695, 0.64117163, 0.6633999 ,\n",
       "       0.598012  , 0.5211742 , 0.5179315 , 0.44251275, 0.4320233 ,\n",
       "       0.37473366, 0.3434858 , 0.41971487, 0.3981644 , 0.38259408,\n",
       "       0.54134226, 0.50191087, 0.40899095, 0.52940655, 0.44381043,\n",
       "       0.5127755 , 0.41512814, 0.44468346, 0.4962555 , 0.444705  ,\n",
       "       0.5233534 , 0.442421  , 0.4456879 , 0.4679502 , 0.48957753,\n",
       "       0.4851089 , 0.6038452 , 0.66263527, 0.710959  , 0.30861598,\n",
       "       0.27906224, 0.6897058 , 0.29216757, 0.3225503 , 0.33021733,\n",
       "       0.3828008 , 0.5538873 , 0.50110096, 0.39187846, 0.41000035,\n",
       "       0.44049624, 0.45528653, 0.36645904, 0.5934218 , 0.61407053,\n",
       "       0.5336921 , 0.65880996, 0.41167262, 0.42986184, 0.6978338 ,\n",
       "       0.7379771 , 0.73842114, 0.7290857 , 0.66446775, 0.59518903,\n",
       "       0.70481473, 0.64052343, 0.7575113 , 0.6144797 , 0.66356695,\n",
       "       0.6633253 , 0.6029684 , 0.5891654 , 0.49471948, 0.46335194,\n",
       "       0.5133265 , 0.45702127, 0.5420507 , 0.5066207 , 0.5592262 ,\n",
       "       0.53542256, 0.4448768 , 0.6144282 , 0.61474144, 0.4944016 ,\n",
       "       0.55753237]))], scale_x=LinearScale(allow_padding=False, max=1.0, min=0.0), scale_y=LinearScale(allow_padding=False, max=1.0, min=0.0), title='A01 - significant_wave_height')))"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "ipywidgets.VBox([dpdown, m, figure])"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python [default]",
   "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.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}