python json import

import json from pymongo import MongoClient client = MongoClient('localhost', 27017) db = client['countries_db'] collection_currency = db['currency'] with open('currencies.json') as f: file_data = json.load(f) # if pymongo < 3.0, use insert() collection_currency.insert(file_data) # if pymongo >= 3.0 use insert_one() for inserting one document collection_currency.insert_one(file_data) # if pymongo >= 3.0 use insert_many() for inserting many documents collection_currency.insert_many(file_data) client.close()

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

Posted by: Guest on November-11-2020

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

Code answers related to "python json import"

Code answers related to "Python"

Browse Popular Code Answers by Language

Answers for "python json import"

Code answers related to "python json import"

Code answers related to "Python"

Python Answers by Framework

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us