Qart | Qart merge picture and QR code | QRCode Processing library

# -*- coding: utf-8 -*-

# Import libraries

import pandas as pd 
import urllib.request, json 
from flatten_json import flatten

for station in list(range(1, 80)):

    # Query URL
    url = f'http://opendata-cml.qart.pt/measurements/RULAEQ{str(station).zfill(4)}?startDate=202104010000&endDate=202108310000'
    print(station)
    # Read JSON from URL and decode
    with urllib.request.urlopen(url) as url:
        data = json.loads(url.read().decode())

    # Flatten JSON data

    data_flattened = [flatten(d) for d in data]

    # Create dataframe

    df = pd.DataFrame(data_flattened)

    # Print Dataframe

    print(df)