Breaking News: Grepper is joining You.com. Read the official announcement!

extraer data derde mongo db python

felipe morales answered on August 1, 2023 Popularity 1/10 Helpfulness 1/10

answer extraer data derde mongo db python

extraer data derde mongo db python

Comment

import pandas as pd
from pymongo import MongoClient
mongo_uri = f'mongodb://{mongo_user}:{......}' # Your connection uri
client = MongoClient(mongo_uri)
db = client.get_database('your_db_name')
collection = db.get_collection('collection_name')
# Get a df with full collection:
df = pd.DataFrame(list(collection.find()))
# Get a df with filtered data: (price < 50)
df = pd.DataFrame(list(collection.find({"price": {"$lt": 50}})
# Get a df for todays data, without "_id" field:
from datetime import datetime, time
today = datetime.today()
midnight = datetime.combine(today, time(0, 0))
df = pd.DataFrame(list(collection.find({"date": { "$gt" : midnight}}, {"_id": 0}
# "date" field must exists (date type)

## Exportar a Excel o CSV:
df.to_csv('filename.csv', index=False)
df.to_excel('filename.xlsx', index=False)

Popularity 1/10 Helpfulness 1/10 Language python

Source: xrnogales.medium.com

Tags: python

Link to this answer
Share Copy Link