import requests
from requests.auth import HTTPBasicAuth
from urllib.parse import urlencode

import pandas as pd
import matplotlib.pyplot as plt

# set host, like http://localhost:8000, to where your Data Hub is running
HOST = ''
# in case of basic auth set to HTTPBasicAuth('user', 'password')
AUTH = None

q = {
    'datalayer_key': 'dhs_drinkwater',

    # Optional filters to narrow down the returned data:
    #'shape_id': '',
    #'shape_type': '',
    #'start_date': '',
    #'end_date': '',
}
d = requests.get(f"{HOST}/api/datalayers/data/?{urlencode(q)}", auth=AUTH).json()
dhs_drinkwater_df = pd.DataFrame(d['data'])
dhs_drinkwater_df['year'] = pd.to_datetime(dhs_drinkwater_df['year'], format="%Y")