Parsing/Looping over JSON objects from a text file (Python)

Question

simple question. I have a text file containing JSON objects which hold real estate information, like so:

     {
      "marketing_package_url": "http://www.capitalpacific.com/inquiry/TrailsEndMarketplaceExecSummary.pdf",
     "title": "TRAILS END MARKETPLACE",
      "location": "OREGON CITY, OR"
      }

In my script, I have a list of marketing package URLS. I want to cross-check the URLS from that list with the URL's in the json objects in this text file so I can find the 'new' URLS. Any suggestions? I was thinking along the lines of importing the json objects into a separate list, and then using the URL's from that list.

import json
with open('properties.txt', 'r') as filename:
           data = json.loads('properties.txt')

how to split it up and send URLS to a list?

Can you show what data looks like? import pprint; pprint.pprint(data) would be helpful — jedwards
– jedwards, Commented Mar 6, 2015 at 6:03

Ashique PS · Accepted Answer · 2015-03-06 06:30:36Z

3

You can use the following code to get the list of marketing_package_urls to list, if the data is a list of dictionaries.

list = [x['marketing_package_url'] for x in data]

answered Mar 6, 2015 at 6:30

Ashique PS

7011 gold badge12 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Parsing/Looping over JSON objects from a text file (Python)

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related