#!/usr/bin/env python
# coding: utf-8

# # DEFRA AURN Data Downloader
# 
# From https://github.com/davidcarslaw/openair it looks like there are R packages available. So we can perhaps reverse engineer that R package to find a way in to the data downloads from Python...
# 
# 

# In[11]:


get_ipython().system('pip3 install --user pyreadr')


# In[1]:


import pyreadr


# In[4]:


metadata_url='http://uk-air.defra.gov.uk/openair/R_data/AURN_metadata.RData'

fn = metadata_url.split('/')[-1]


# In[14]:


get_ipython().system('wget $metadata_url')


# In[20]:


import pandas as pd
pyreadr.read_r(fn)['AURN_metadata'].head()


# In[26]:


package_url_base = 'https://uk-air.defra.gov.uk/openair/R_data/{fn}'


# In[34]:


site = 'kc1'
year = 2019

fn = '{site}_{year}.RData'.format(site=site.upper(), year=year)

url = package_url_base.format(fn=fn)
get_ipython().system('wget $url')


# In[35]:


pyreadr.read_r(fn)[fn.split('.')[0]].head()


# In[ ]: