docker MongoDB pull and run

 

#pull image

docker pull mongodb

#run container

docker run --name mongodb -d -p 27017:27017 mongo

ex) access in python 

import pymongo # package for working with MongoDB

client = pymongo.MongoClient("mongodb://localhost:27017/")

Thank you.

www.marearts.com

mongodb python, Table recode export, loading, save csv, load csv

 refer to below code:

.

#connet db

client = pymongo.MongoClient("mongodb://localhost:27017/")

#connet table

who_table = db["who_table"]

#delete all

who_table.drop()

#load csv to table

df = pd.read_csv('1.csv')

data = df.to_dict('records')

who_table.insert_many(data)

#show all items

for x in who_table.find():

print(x)

#save table to csv

cursor = who_table.find({})

df = pd.DataFrame(list(cursor))

df.to_csv('2.csv', index=False)

.

Thank you.🙇🏻‍♂️

www.marearts.com