import json in python code example
Example 1: python import json into pymongo
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()
Example 2: json load from file python 3
import json
with open('file_to_load.json', 'r') as file:
data = json.load(file)
Example 3: python json string to object
import json
x = '{ "name":"John", "age":30, "city":"New York"}'
y = json.loads(x)
print(y["age"])
Example 4: python json stringify
import json
json.dumps(['foo', {'bar': ('baz', None, 1.0, 2)}])
'["foo", {"bar": ["baz", null, 1.0, 2]}]'
print(json.dumps({"c": 0, "b": 0, "a": 0}, sort_keys=True))
{"a": 0, "b": 0, "c": 0}
Example 5: Json in python
import json
json_file = json.load(open("your file.json", "r", encoding="utf-8"))
# For see if you don't have error:
print(json_file)
Example 6: python to json
# a Python object (dict):
x = {
"name": "John",
"age": 30,
"city": "New York"
}
# convert into JSON:
y = json.dumps(x)