signature_percent_by_constituency.py

import requests
import csv
import sys


populaton_url = "https://petitionmap.unboxedconsulting.com/json/mps/population_ons.json"

req = requests.get(populaton_url)

POULATION_BY_GSS = req.json()

pet_url = "https://petition.parliament.uk/petitions/241584.json"

req = requests.get(pet_url)
PET_DATA = req.json()

BY_CONSTITUENCY = PET_DATA['data']['attributes']['signatures_by_constituency']

fieldnames = ["name", "ons_code", "mp", "signature_count", "population", "signed_percent"]

out_file = csv.DictWriter(sys.stdout, fieldnames=fieldnames, delimiter="\t")

for constituency in BY_CONSTITUENCY:
    constituency['population'] = POULATION_BY_GSS[constituency["ons_code"]]['population']
    constituency['signed_percent'] = round((constituency['signature_count'] / constituency['population'] ) * 100, 2)
    out_file.writerow(constituency)