how to json a list code example
Example 1: print json python
import json
uglyjson = '{"firstnam":"James","surname":"Bond","mobile":["007-700-007","001-007-007-0007"]}'
#json.load method converts JSON string to Python Object
parsed = json.loads(uglyjson)
print(json.dumps(parsed, indent=2, sort_keys=True))
Example 2: list to json python
import json
friends_list = [
'John','Rambo','Sam',
]
json_format = json.dumps(friends_list)
print(json_format)
print(type(json_format))
#PYTHON OUTPUT
["John", "Rambo", "Sam"]
<class 'str'>
Example 3: 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