Load raw json files to MongoDB

mongodb-load.py

import glob
import json
from pymongo import MongoClient

# fill in hostname and port
HOST = "hostname"
PORT = 27017

client = MongoClient(HOST, PORT)
# fill in dbname and colname
db = client.dbname
col = db["colname"]

path = "/path/to/files"

for file in glob.glob(path + "*.json"):
    # print file # if you want to see the file name
    print(file)
    with open(file, "r") as f:
        tweets = []
        content = f.readlines()
        content = [x.strip() for x in content]
        for line in content:
            col.insert_one(json.loads(line))