Compustat Mongo Db Database and Juypter Notebook Assignment
Compustat Mongo Db Database and Juypter Notebook Assignment
Please submit the Jupyter Notebook and a pdf of the notebook. Use mongoDB queries for the following tasks:
1. Import the compustat csv file into a collection.
2. Get the total number of documents inside the collection.
3. Get the total number of distinct value in field “fqtr”. Please note that the distinct() function returns an array instead of documents.
4. Return fields (datadate, tic, atq, ltq) from documents which have atq larger than 10,000. Please limit the output records to 5.
5. Calculate the average atq for each ticker when the fyearq is larger than 2015. Please limit the output records to 10.
6. Save all output records from question 5 into a new collection.
7. Export the collection from question 6 to a csv file.
"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.
Discount Code: CIPD30
Click ORDER NOW..
