json formatter python code example

Example 1: pretty json python

print(json.dumps(dict, indent=4))

Example 2: 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

Example 3: python format json file

python3 -m json.tool unformatted.json > formatted.json

Example 4: json.loads

>>> import json
>>> json.loads('["foo", {"bar":["baz", null, 1.0, 2]}]')
['foo', {'bar': ['baz', None, 1.0, 2]}]
>>> json.loads('"\\"foo\\bar"')
'"foo\x08ar'
>>> from io import StringIO
>>> io = StringIO('["streaming API"]')
>>> json.load(io)
['streaming API']