Read Collection (Table) from MongoDB using Python | MongoDB | Python | PyMongo

[@uwaisahamedimad556]

clear audio clear cut knowledge transfer.Thanks

[@StatsWire]

You're welcome

[@victorroquez3649]

Bro, you're helping me so much , thanks and new suscriber

[@StatsWire]

H! Thank you.

[@brunabraxton]

Great video, from my favorite teacher

[@StatsWire]

Thank you Bruna

[@rabianaeem1333]

it was so so sooooo helpful. thank you very very much

[@StatsWire]

I'm so glad!

[@abdulazizshaikh2255]

is there any way to iterate over document in collection and save it as dataframe

[@StatsWire]

Yes, you can. Please check the official documentation for more details.

[@abdulazizshaikh2255]

@@StatsWire I didn't find it in document can you help me with the link

[@StatsWire]

@@abdulazizshaikh2255 I will share with you shortly

[@jlawre23]

Great video. Very helpful showing the pandas dataframe stuff

[@StatsWire]

Thank you!

[@nikhilgupta110]

Is there a convenient way creating pyspark dataframe instead of pandas??

[@StatsWire]

Pandas is the easiest way I would say

[@nikhilgupta110]

@@StatsWire yeah, I know but to maintain the consistency, I have to do it with pyspark Or glue dynamic frame 🤦‍♂️🤷‍♂️

[@dwhloading6865]

Thanks for the video .. i need to compare the Source data in mongoDb and Target (Snowflake ) after ETL i.e is loading into Datawarehouse.

[@StatsWire]

You're welcome!

[@ArunKumar-sg6jf]

if i want to laod large data from mongodb to pyspark how to speed up the process very fasily of readig data and writimg data

[@StatsWire]

You will need more memory to read faster. Your local computer has limited RAM but if you are doing it on server it will be faster because server has more RAM

[@ajaykushwaha-je6mw]

Collection saved in mongo Db is saved on your system or on server ?

[@StatsWire]

This mongodb is in my system i.e local but if your mongdb is configured on the server then it will be saved on the server.

[@1UniverseGames]

How can I write code to show List of Outer Most field from that text documents???

[@StatsWire]

Sorry, I am not getting your point.

[@chandranravi7774]

am trying in colab its error
FileNotFoundError: [Errno 2] No such file or directory: 'C:\\Users\\Ravi\\OneDrive\\Desktop\\streamlit\\jagan.csv'

[@StatsWire]

You have to give proper path

[@dhanuschannel2445]

Nice 👍

[@StatsWire]

Thank you

[@Mac3Ent]

How can I display MongoDB collection in an HTML using ajax dataTable?

[@omkarkharkar5998]

Hi, Do you find any method

[@StatsWire]

Please refer to the below link on stack overflow
stackoverflow.com/questions/67730969/need-assistance-with-mongodb-python-html-and-ajax

[@StatsWire]

Please refer to the below link on stack overflow
stackoverflow.com/questions/67730969/need-assistance-with-mongodb-python-html-and-ajax

[@Mac3Ent]

​@@StatsWire This is actually my post on Stack.

[@Mac3Ent]

@@StatsWire This is actually my post on Stack. But now I need a way to display multiple collections.

[@dharmendrachaudhary3895]

Thanks for this informative video can you please CREATE VIDEO ON how can you fetch data batch by batch, instead of fetching all the data using find

[@StatsWire]

You're welcome. Thanks for the suggestion. I can make a video on this soon maybe next week because this week I am occupied.

[@Umar-lw6nh]

@@StatsWire Did you make this video? please share the url?

[@ChrisRestrepo]

Se merece el like, era algo sencillo

[@StatsWire]

Thank you

[@mohitkushwaha8974]

Thanks bro

[@StatsWire]

You're welcome

[@jstaguan]

thanks!

[@StatsWire]

You're welcome!

[@krishshah3974]

nice

[@StatsWire]

Thank you

[@AlexandreSiedschlag]

nice bell.. too much volume

[@StatsWire]

Haha sorry

[@zubee6011]

I tried using the count method in pandas, I keep getting this error;
AttributeError: 'Cursor' object has no attribute 'count'
This is the code;
dw_db = client.doctorwho
tc = dw_db.test_collection
tc.insert_one({'name': 'William', 'birthyear': 1908})
# Insert a few (zip takes some lists and returns a list of tuples)
for n, b in zip('Patrick Jon Tom Peter Colin Sylvester Paul Christopher David Matt Peter'.split(),
[1920, 1919, 1934, 1951, 1943, 1943, 1959, 1964, 1971, 1982, 1958]):
tc.insert_one({'name': n, 'birthyear': b})
dw_db.tc.find({'name': 'Peter'}).count()

[@StatsWire]

Hello, I think count method is deprecated, use the new method count_documents and let me if you still facing issue

[@zubee6011]

@@StatsWire I used it and still had the same issue