data_dump.py

import pymongo
import pandas as pd
import json

from pymongo.mongo_client import MongoClient
uri = "mongodb+srv://aniket:aniket@cluster.rwhpc65.mongodb.net/"
# Create a new client and connect to the server
client = MongoClient(uri)
# Send a ping to confirm a successful connection


DATA_FILE_PATH =(r"C:\Users\91880\Desktop\Text_Summarisation_Article\Article_Text_Summarization\text_summarization.csv")

DATABASE_NAME ="textsumm"

COLLECTION_NAME="collection"


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)