mongodb导入数据报错:Document is larger than the maximum size,提示文件太大,用pandas读取,然后一行一行写入到数据库,特记此笔记。
import jsonimport pymongoimport pandas as pdclient = pymongo.MongoClient('localhost', 27017) # 连接数据库collection = client['Databasename']["collectionname"] # 加载数据with open("json文件路径", "r", encoding="UTF-8") as f: # 读取json文件datas = json.load(f)df = pd.DataFrame(datas) # 将json转换为dfprint(df.shape)for num_index, valuelists in df.iterrows(): # 按行遍历collection.insert_one(valuelists.to_dict()) # 写入mongodbprint("done")