Create a python script that will perform the following actions on MongoDB: 1. Export the "shipwrecks" collection from th

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Create a python script that will perform the following actions on MongoDB: 1. Export the "shipwrecks" collection from th

Post by answerhappygod »

Create a python script that will perform the following actions on MongoDB:
1. Export the "shipwrecks" collection from the "sample_geospacial" database in your Atlas cluster to a csv file. This collection is imported when you import test data into your Atlas Cluster.
2. Import the csv file into your local Mongo instance. Put the records in the database "project_scripts" and collection "shipwrecks".
3. Remove all records where the depth field is less than 10. You can do this before you import the data or after.
4. Allow importing and exporting to be performed independently via command line arguments. It is acceptable if your script does nothing if no options are specified.
5. Remove some records before importing and some after. For example remove all records from the DataFrame that have a depth less than 5 before importing the data, then remove all records with a depth less than 10 from the collection.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply