Obtain the data from AURN

Download data by a bounds of longitude and latitude

Users can give a bounds of longitude and latitude to download the station data.

Load the ObsAQ package and Define the range

[1]:
import obsaq

lon_min = -9
lon_max = 1.8
lat_min = 49
lat_max = 61
bounds=[lon_min, lon_max, lat_min, lat_max]

Get the station metadata

NOTE: This is the all station information and the next step will choose the stations by bounds.

[2]:
meta = obsaq.meta()
site_table = meta.get_metadata('aurn')

Choose the stations by range

[3]:
final_sites = meta.get_site(bounds=bounds)
final_sites.head(5)
Site is selected by bounds: [-9, 1.8, 49, 61]
[3]:
site_id site_name location_type latitude longitude parameter Parameter_name start_date end_date ratified_to zone agglomeration local_authority
0 ABD Aberdeen Urban Background 57.15736 -2.094278 O3 Ozone 2003-08-01 2021-09-20 2021-09-20 North East Scotland NaN Aberdeen City
1 ABD Aberdeen Urban Background 57.15736 -2.094278 NO Nitric oxide 1999-09-18 2021-09-20 2021-09-20 North East Scotland NaN Aberdeen City
2 ABD Aberdeen Urban Background 57.15736 -2.094278 NO2 Nitrogen dioxide 1999-09-18 2021-09-20 2021-09-20 North East Scotland NaN Aberdeen City
3 ABD Aberdeen Urban Background 57.15736 -2.094278 NOXasNO2 Nitrogen oxides as nitrogen dioxide 1999-09-18 2021-09-20 2021-09-20 North East Scotland NaN Aberdeen City
4 ABD Aberdeen Urban Background 57.15736 -2.094278 SO2 Sulphur dioxide 2001-01-01 2007-09-30 2007-09-30 North East Scotland NaN Aberdeen City

Start to download the selected station data

  • pollutant: See names of pollutants. Define one pollutant, diverse pollutants or all pollutants to download the data for them. Pollutants can be defined as “PM2.5”,”PM10”,”O3”,”NO”,”NO2”,”NOXasNO2” or “SO2”.

  • start: the start date of data to be downloaded.

  • end: the end date of data to be downloaded.

  • year: the year of data to be downloaded. Defaults to 2010.

  • output_dir: the directory to save the downloaded data.

  • download_mode: “Stream” for saving final and intermediate files while “memory” for only the final file.

  • save_per_site: whether save files for every station individually.

  • save_merged: whether save the merged file for all selected data.

  • add_site_id: whether include site id in the downloaded file.

Download data for every station. Decide whether to download the final merged data for all targeted stations by choosing “save_merged=True/False”.

Warnings are normal for merging data with different format. Ingoring them can be fine.

[4]:
merged_df = meta.download_sites(
    port="aurn",
    pollutant="PM2.5",
    start="2017-12-01",
    end="2018-11-30",
    output_dir="data/test_pm25",
    download_mode="stream",
    save_per_site=True,
    save_merged=True,
    add_site_id=True
)
     site_id        site_name     location_type   latitude  longitude  \
0        ABD         Aberdeen  Urban Background  57.157360  -2.094278
1        ABD         Aberdeen  Urban Background  57.157360  -2.094278
2        ABD         Aberdeen  Urban Background  57.157360  -2.094278
3        ABD         Aberdeen  Urban Background  57.157360  -2.094278
6        ABD         Aberdeen  Urban Background  57.157360  -2.094278
...      ...              ...               ...        ...        ...
3057    YK11  York Fishergate     Urban Traffic  53.951889  -1.075861
3058    YK11  York Fishergate     Urban Traffic  53.951889  -1.075861
3059    YK11  York Fishergate     Urban Traffic  53.951889  -1.075861
3060    YK11  York Fishergate     Urban Traffic  53.951889  -1.075861
3061    YK11  York Fishergate     Urban Traffic  53.951889  -1.075861

     parameter                             Parameter_name  start_date  \
0           O3                                      Ozone  2003-08-01
1           NO                               Nitric oxide  1999-09-18
2          NO2                           Nitrogen dioxide  1999-09-18
3     NOXasNO2        Nitrogen oxides as nitrogen dioxide  1999-09-18
6         PM10  PM10 particulate matter (Hourly measured)  1999-09-18
...        ...                                        ...         ...
3057     NV2.5       Non-volatile PM2.5 (Hourly measured)  2011-08-31
3058      V2.5           Volatile PM2.5 (Hourly measured)  2011-08-31
3059        wd                    Modelled Wind Direction  2010-08-01
3060        ws                        Modelled Wind Speed  2010-08-01
3061      temp                       Modelled Temperature  2010-08-01

        end_date ratified_to                    zone agglomeration  \
0     2021-09-20  2021-09-20     North East Scotland           NaN
1     2021-09-20  2021-09-20     North East Scotland           NaN
2     2021-09-20  2021-09-20     North East Scotland           NaN
3     2021-09-20  2021-09-20     North East Scotland           NaN
6     2021-09-20  2021-09-20     North East Scotland           NaN
...          ...         ...                     ...           ...
3057  2018-10-10  2018-10-10  Yorkshire & Humberside           NaN
3058  2018-10-10  2018-10-10  Yorkshire & Humberside           NaN
3059     ongoing       Never  Yorkshire & Humberside           NaN
3060     ongoing       Never  Yorkshire & Humberside           NaN
3061     ongoing       Never  Yorkshire & Humberside           NaN

     local_authority
0      Aberdeen City
1      Aberdeen City
2      Aberdeen City
3      Aberdeen City
6      Aberdeen City
...              ...
3057            York
3058            York
3059            York
3060            York
3061            York

[1625 rows x 13 columns]
Saved per-site file: data/test_pm25/ABD_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/ACTH_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/AGRN_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/BEL2_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/BEX_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/BIRR_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/BLC2_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/BMLD_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/BORN_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/BPLE_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/BRS8_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/CA1_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/CARD_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/CARL_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/CHAT_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/CHBO_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/CHBR_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/CHLG_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/CHP_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/CHS7_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/CLL2_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/COAL_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/DERR_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/EAGL_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/EB_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/ECCL_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/ED3_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/GHSR_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/GKA8_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/GLKP_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/GRAN_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/HOPE_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/HORS_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/HRL_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/HUL2_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/INV2_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/KC1_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/LEAM_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/LEAR_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/LECU_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/LED6_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/LEED_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/LN_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/LON6_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/LVP_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/MAN3_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/MID_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/MY1_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/NEWC_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/NO12_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/NOTT_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/NPT3_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/NTN4_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/OX8_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/PEMB_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/PLYM_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/PMTH_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/PRES_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/PT4_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/REA1_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/ROCH_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/SASH_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/SDY_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/SEND_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/SHBR_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/SHDG_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/SOTR_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/SOUT_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/STOK_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/STOR_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/SUN2_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/SWA1_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/TED2_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/TRAN_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/WAR_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/WIG5_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/WREX_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/WTHG_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/YK10_PM2.5_20171201_20181130.csv
Saved per-site file: data/test_pm25/YK11_PM2.5_20171201_20181130.csv
Saved merged file: data/test_pm25/MERGED_aurn_PM2.5_20171201_20181130.csv

Download data by site_id

Load the ObsAQ package and check the site information

[5]:
import obsaq

meta = obsaq.meta()
site_table = meta.get_metadata('aurn')

site_table.head(5)
[5]:
site_id site_name location_type latitude longitude parameter Parameter_name start_date end_date ratified_to zone agglomeration local_authority
0 ABD Aberdeen Urban Background 57.15736 -2.094278 O3 Ozone 2003-08-01 2021-09-20 2021-09-20 North East Scotland NaN Aberdeen City
1 ABD Aberdeen Urban Background 57.15736 -2.094278 NO Nitric oxide 1999-09-18 2021-09-20 2021-09-20 North East Scotland NaN Aberdeen City
2 ABD Aberdeen Urban Background 57.15736 -2.094278 NO2 Nitrogen dioxide 1999-09-18 2021-09-20 2021-09-20 North East Scotland NaN Aberdeen City
3 ABD Aberdeen Urban Background 57.15736 -2.094278 NOXasNO2 Nitrogen oxides as nitrogen dioxide 1999-09-18 2021-09-20 2021-09-20 North East Scotland NaN Aberdeen City
4 ABD Aberdeen Urban Background 57.15736 -2.094278 SO2 Sulphur dioxide 2001-01-01 2007-09-30 2007-09-30 North East Scotland NaN Aberdeen City

Choose the stations by site_id

[6]:
final_sites = meta.get_site(site_id='ABD')
final_sites.drop_duplicates(subset='site_id')
Site is selected by site_id: ABD
[6]:
site_id site_name location_type latitude longitude parameter Parameter_name start_date end_date ratified_to zone agglomeration local_authority
0 ABD Aberdeen Urban Background 57.15736 -2.094278 O3 Ozone 2003-08-01 2021-09-20 2021-09-20 North East Scotland NaN Aberdeen City

Start to download the selected station data

  • Use “start” and “end” to define a period of time.

  • Other parameters are the same as “Download data by a bounds of longitude and latitude” part

[7]:
meta.download_sites(
    port="aurn",
    pollutant="PM2.5",
    start="2017-12-01",
    end="2018-11-30",
    output_dir="data/test_pm25_siteid",
    download_mode="stream",
    save_per_site=True,
    save_merged=False,
    add_site_id=True
)
   site_id site_name     location_type  latitude  longitude parameter  \
0      ABD  Aberdeen  Urban Background  57.15736  -2.094278        O3
1      ABD  Aberdeen  Urban Background  57.15736  -2.094278        NO
2      ABD  Aberdeen  Urban Background  57.15736  -2.094278       NO2
3      ABD  Aberdeen  Urban Background  57.15736  -2.094278  NOXasNO2
6      ABD  Aberdeen  Urban Background  57.15736  -2.094278      PM10
7      ABD  Aberdeen  Urban Background  57.15736  -2.094278      NV10
8      ABD  Aberdeen  Urban Background  57.15736  -2.094278       V10
9      ABD  Aberdeen  Urban Background  57.15736  -2.094278     PM2.5
10     ABD  Aberdeen  Urban Background  57.15736  -2.094278     NV2.5
11     ABD  Aberdeen  Urban Background  57.15736  -2.094278      V2.5
12     ABD  Aberdeen  Urban Background  57.15736  -2.094278        wd
13     ABD  Aberdeen  Urban Background  57.15736  -2.094278        ws
14     ABD  Aberdeen  Urban Background  57.15736  -2.094278      temp

                                Parameter_name  start_date    end_date  \
0                                        Ozone  2003-08-01  2021-09-20
1                                 Nitric oxide  1999-09-18  2021-09-20
2                             Nitrogen dioxide  1999-09-18  2021-09-20
3          Nitrogen oxides as nitrogen dioxide  1999-09-18  2021-09-20
6    PM10 particulate matter (Hourly measured)  1999-09-18  2021-09-20
7          Non-volatile PM10 (Hourly measured)  2009-02-20  2019-11-07
8              Volatile PM10 (Hourly measured)  2009-02-20  2019-11-07
9   PM2.5 particulate matter (Hourly measured)  2009-02-20  2021-09-20
10        Non-volatile PM2.5 (Hourly measured)  2009-02-20  2019-11-07
11            Volatile PM2.5 (Hourly measured)  2009-02-20  2019-11-07
12                     Modelled Wind Direction  2010-08-01  2021-09-20
13                         Modelled Wind Speed  2010-08-01  2021-09-20
14                        Modelled Temperature  2010-08-01  2021-09-20

   ratified_to                 zone agglomeration local_authority
0   2021-09-20  North East Scotland           NaN   Aberdeen City
1   2021-09-20  North East Scotland           NaN   Aberdeen City
2   2021-09-20  North East Scotland           NaN   Aberdeen City
3   2021-09-20  North East Scotland           NaN   Aberdeen City
6   2021-09-20  North East Scotland           NaN   Aberdeen City
7   2019-11-07  North East Scotland           NaN   Aberdeen City
8   2019-11-07  North East Scotland           NaN   Aberdeen City
9   2021-09-20  North East Scotland           NaN   Aberdeen City
10  2019-11-07  North East Scotland           NaN   Aberdeen City
11  2019-11-07  North East Scotland           NaN   Aberdeen City
12       Never  North East Scotland           NaN   Aberdeen City
13       Never  North East Scotland           NaN   Aberdeen City
14       Never  North East Scotland           NaN   Aberdeen City
Saved per-site file: data/test_pm25_siteid/ABD_PM2.5_20171201_20181130.csv

Read the data from AURN

Read the site data by a bounds of longitude and latitude

Users can give a bounds of longitude and latitude to read the site data.

Load the ObsAQ package and Define the range

[8]:
import obsaq

lon_min = -1
lon_max = 2
lat_min = 50
lat_max = 55
bounds=[lon_min, lon_max, lat_min, lat_max]

Get the station metadata

NOTE: This is the all station information and the next step will choose the stations by bounds.

[9]:
meta = obsaq.meta()
site_table = meta.get_metadata('aurn')

Choose the stations by range

[10]:
final_sites = meta.get_site(bounds=bounds)
final_sites.head(5)
Site is selected by bounds: [-1, 2, 50, 55]
[10]:
site_id site_name location_type latitude longitude parameter Parameter_name start_date end_date ratified_to zone agglomeration local_authority
93 AYLA Aylesbury A4157 Urban Traffic 51.822161 -0.793884 PM2.5 PM2.5 particulate matter (Hourly measured) 2025-08-11 ongoing 2025-09-30 South East NaN Aylesbury Vale
94 AYLA Aylesbury A4157 Urban Traffic 51.822161 -0.793884 wd Modelled Wind Direction 2025-08-11 ongoing Never South East NaN Aylesbury Vale
95 AYLA Aylesbury A4157 Urban Traffic 51.822161 -0.793884 ws Modelled Wind Speed 2025-08-11 ongoing Never South East NaN Aylesbury Vale
96 AYLA Aylesbury A4157 Urban Traffic 51.822161 -0.793884 temp Modelled Temperature 2025-08-11 ongoing Never South East NaN Aylesbury Vale
386 BDMP Borehamwood Meadow Park Urban Background 51.661229 -0.270550 NO Nitric oxide 2017-10-01 ongoing 2025-09-30 Eastern NaN Hertsmere

Choose a site by site_id and read it directly

[11]:
obsaq.read_sites('BDMP', 'aurn', year=2018)
[11]:
Date time Nitric oxide status unit Nitrogen dioxide status.1 unit.1 Nitrogen oxides as nitrogen dioxide status.2 unit.2
0 01-01-2018 01:00 0.25166 R ugm-3 4.75500 R ugm-3 5.14087 R ugm-3
1 01-01-2018 02:00 0.12583 R ugm-3 6.87575 R ugm-3 7.06869 R ugm-3
2 01-01-2018 03:00 0.28312 R ugm-3 5.78313 R ugm-3 6.21723 R ugm-3
3 01-01-2018 04:00 0.22020 R ugm-3 3.75899 R ugm-3 4.09663 R ugm-3
4 01-01-2018 05:00 0.18874 R ugm-3 3.27707 R ugm-3 3.56647 R ugm-3
... ... ... ... ... ... ... ... ... ... ... ...
8755 31-12-2018 20:00 0.28836 R ugm-3 12.08703 R ugm-3 12.52918 R ugm-3
8756 31-12-2018 21:00 0.18023 R ugm-3 8.29340 R ugm-3 8.56974 R ugm-3
8757 31-12-2018 22:00 0.10814 R ugm-3 5.52928 R ugm-3 5.69508 R ugm-3
8758 31-12-2018 23:00 0.07209 R ugm-3 4.77096 R ugm-3 4.88150 R ugm-3
8759 31-12-2018 24:00 0.00000 R ugm-3 4.17640 R ugm-3 4.17640 R ugm-3

8760 rows × 11 columns

Read data by a point of longitude and latitude

Users can give a point of longitude and latitude to read the station data.

Load the ObsAQ package and Define the point

[12]:
import obsaq

lon = 0.0
lat = 55.0
point = [lon, lat]

Get the station metadata

NOTE: This is the all station information and the next step will choose the stations by point.

[13]:
meta = obsaq.meta()
site_table = meta.get_metadata('aurn')

site_table.head(5)
[13]:
site_id site_name location_type latitude longitude parameter Parameter_name start_date end_date ratified_to zone agglomeration local_authority
0 ABD Aberdeen Urban Background 57.15736 -2.094278 O3 Ozone 2003-08-01 2021-09-20 2021-09-20 North East Scotland NaN Aberdeen City
1 ABD Aberdeen Urban Background 57.15736 -2.094278 NO Nitric oxide 1999-09-18 2021-09-20 2021-09-20 North East Scotland NaN Aberdeen City
2 ABD Aberdeen Urban Background 57.15736 -2.094278 NO2 Nitrogen dioxide 1999-09-18 2021-09-20 2021-09-20 North East Scotland NaN Aberdeen City
3 ABD Aberdeen Urban Background 57.15736 -2.094278 NOXasNO2 Nitrogen oxides as nitrogen dioxide 1999-09-18 2021-09-20 2021-09-20 North East Scotland NaN Aberdeen City
4 ABD Aberdeen Urban Background 57.15736 -2.094278 SO2 Sulphur dioxide 2001-01-01 2007-09-30 2007-09-30 North East Scotland NaN Aberdeen City

Choose the stations by point

[14]:
final_sites = meta.get_site(point=point)
final_sites
Site is selected by point: [0.0, 55.0]
[14]:
site_id site_name location_type latitude longitude parameter Parameter_name start_date end_date ratified_to zone agglomeration local_authority
1267 HM High Muffles Rural Background 54.334497 -0.80882 O3 Ozone 1987-07-16 ongoing 2025-09-30 Yorkshire & Humberside NaN Ryedale

Read the station data

[15]:
obsaq.read_sites('HM', 'aurn', year=2018)
[15]:
Date time Nitric oxide status unit Nitrogen dioxide status.1 unit.1 Nitrogen oxides as nitrogen dioxide status.2 unit.2 Ozone status.3 unit.3
0 01-01-2018 01:00 0.36708 R ugm-3 1.00358 R ugm-3 1.56642 R ugm-3 65.32591 R ugm-3
1 01-01-2018 02:00 0.28550 R ugm-3 1.06600 R ugm-3 1.50376 R ugm-3 65.85810 R ugm-3
2 01-01-2018 03:00 0.27531 R ugm-3 1.22261 R ugm-3 1.64474 R ugm-3 67.15531 R ugm-3
3 01-01-2018 04:00 0.24472 R ugm-3 1.26951 R ugm-3 1.64474 R ugm-3 66.40692 R ugm-3
4 01-01-2018 05:00 0.30590 R ugm-3 2.16255 R ugm-3 2.63159 R ugm-3 66.20735 R ugm-3
... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
8755 31-12-2018 20:00 0.30417 R ugm-3 1.38387 R ugm-3 1.85025 R ugm-3 70.34843 R ugm-3
8756 31-12-2018 21:00 0.23657 R ugm-3 1.27605 R ugm-3 1.63879 R ugm-3 70.39832 R ugm-3
8757 31-12-2018 22:00 0.33796 R ugm-3 1.17346 R ugm-3 1.69166 R ugm-3 69.89939 R ugm-3
8758 31-12-2018 23:00 0.50694 R ugm-3 1.44300 R ugm-3 2.22030 R ugm-3 68.85165 R ugm-3
8759 31-12-2018 24:00 0.40556 R ugm-3 1.70419 R ugm-3 2.32603 R ugm-3 67.85380 R ugm-3

8760 rows × 14 columns