Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

Python appending values from one dictionary to another with the same keys

Evening,

I’m trying to append another set of values to the same set of keys in a dictionary.

currently, I pull the some postcode attributes from an api which stores the request in a dictionary and returns the outcome in a dataframe. But If I wanted to return another postcode attributes from the same api how would I append the values from it to the same dictionary so they appear as a second row in the dataframe.

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

current bit of code:

import requests
import pandas as pd

url = "https://api.getthedata.com/postcode/ST87HL"
req = requests.get(url)
data = req.json()
entries = data["data"]

df = pd.DataFrame([entries])
print(df)

Really appreciate all the help, thank you.

>Solution :

If you have your postcodes in the list, iterate over this list and append result into another list. As last step, create a DataFrame from this list:

import requests
import pandas as pd

postcodes = ["ST87HL", "ST87EZ"]

all_data = []
for p in postcodes:
    url = "https://api.getthedata.com/postcode/{}".format(p)
    req = requests.get(url)
    data = req.json()
    entries = data["data"]
    all_data.append(entries)


df = pd.DataFrame(all_data)
print(df)

Prints:

  postcode status usertype  easting  northing  positional_quality_indicator  country   latitude  longitude postcode_no_space postcode_fixed_width_seven postcode_fixed_width_eight postcode_area postcode_district postcode_sector outcode incode
0  ST8 7HL   live    small   388982    357799                             1  England  53.117254  -2.166072            ST87HL                    ST8 7HL                   ST8  7HL            ST               ST8           ST8 7     ST8    7HL
1  ST8 7EZ   live    small   389017    358349                             1  England  53.122198  -2.165568            ST87EZ                    ST8 7EZ                   ST8  7EZ            ST               ST8           ST8 7     ST8    7EZ
Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading