data_dump.py

import pymongo
import pandas as pd
import json

client = pymongo.MongoClient("mongodb+srv://Ambarish_224:mongodb224@ambarish.usag9.mongodb.net/?retryWrites=true&w=majority")

DATA_FILE_PATH = (r"E:\iNeuron FSDS Full Folder\Ambarish Python Practice Set Folder\Resume_Based_Modular_Project_Data_Science\Insurance-Prediction-Project\insurance.csv")
DATABASE_NAME = "INSURANCE"
COLLECTION_NAME = "INSURANCE_PROJECT"
 

if __name__ =="__main__":
    df = pd.read_csv(DATA_FILE_PATH)
    print(f"Rows and Columns: {df.shape}")

    df.reset_index(drop = True, inplace = True)
    json_record = list(json.loads(df.T.to_json()).values())
    print(json_record[0])

    client[DATABASE_NAME][COLLECTION_NAME].insert_many(json_record)