python read json data code example
Example 1: python read json
import json
with open('path_to_file/person.json') as f:
data = json.load(f)
Example 2: python read json file
import json
with open('path_to_file/person.json') as f:
data = json.load(f)
print(data)
Example 3: read json file python
import json
with open('path_to_file/person.json') as f:
data = json.load(f)
print(data)
flx = json.dumps(data, ensure_ascii=False, indent=4)
print(flx)
Example 4: get json from file python
import json
with open('data.txt') as json_file:
data = json.load(json_file)
for p in data['people']:
print('Name: ' + p['name'])
print('Website: ' + p['website'])
print('From: ' + p['from'])
print('')
Example 5: 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