python get json code example

Example 1: how to read a json resposnse from a link in python

import urllib, json

url = "put url here"
response = urllib.request.urlopen(url)
data = json.loads(response.read())
print (data)

Example 2: python json string to object

import json

x =  '{ "name":"John", "age":30, "city":"New York"}'
y = json.loads(x)

print(y["age"])

Example 3: load json

import json

with open('data.txt') as json_file:
    data = json.load(json_file)

Example 4: fetch a json from url python

import requests
r = requests.get('url')
print r.json()

Example 5: python to json

# a Python object (dict):
x = {
  "name": "John",
  "age": 30,
  "city": "New York"
}

# convert into JSON:
y = json.dumps(x)

Example 6: python import json data

# Basic syntax:
import ast
# Create function to import JSON-formatted data:
def import_json(filename):
  for line in open(filename):
    yield ast.literal_eval(line)
# Where ast.literal_eval allows you to safely evaluate the json data.
# 	See the following link for more on this:
# 	https://stackoverflow.com/questions/15197673/using-pythons-eval-vs-ast-literal-eval
        
# Import json data
data = list(import_json("/path/to/filename.json"))

# (Optional) convert json data to pandas dataframe:
dataframe = pd.DataFrame.from_dict(data)
# Where keys become column names