Write a mongodb query in r or python

Assignment Help Other Subject

Reference no: EM132490127

NoSQL databases

Tasks

Follow the lab instructions to install MongoDB into your (virtual or local) environment. Once you have MongoDB installed and running, install mongolite library in R or Pymongo library in Python, at your choice. Use either R or Python to execute the following tasks:

Question 1. Unzip the file students.zip and extract the content. Import the file into a MongoDB collection called students .

Question 2. Write a MongoDB query in R or Python to display all the students having received a score higher than 60 in an exam.

Question 3. Write a MongoDB query in R or Python determine the minimum and the maximum score achieved by the last 5 students inserted in the collection according to their id.

Question 4. Write a MongoDB query in R or Python to visualise the frequency distribution of the average scores achieved by any student.

Question 5. Write a MongoDB query in R or Python to select all the students and save them into csv (comma separated value) table. The structure of the table needs to be: ?id, name, average_score?, where average_score contains the average numerical score of each corresponding student.

Reference no: EM132490127

Questions Cloud

Determine whether each of gianni logisticss vendor : Determine whether each contract conveys the right to control the use of the identified asset to the lessee. Determine whether each of Gianni Logistics's vendor

Gradient in the light dependent reactions : What would happen to the size of the H+ gradient in the light dependent reactions. Explain your reasoning.

Changes that occur during steps 4 and 5 of glycosis : What are the 2 changes that occur during steps 4 and 5 of glycosis?

Prepare the journal entry for samson wholesale beverage : Prepare the journal entry for Samson Wholesale Beverage for the transfer of accounts receivable on April 30, assuming the sale criteria are met.

Write a mongodb query in r or python : Write a MongoDB query in R or Python to display all the students having received a score higher than 60 in an exam - Write a MongoDB query in R or Python

What amount of accrued interest would jackson record : What amount of accrued interest, rounded to the nearest dollar, would Jackson record on its December 31, 2018 Balance Sheet?

Highlight the positive characteristics of fungi : It is not uncommon for fungi to get a bad reputation because of diseases like athlete's foot, ringworm, and yeast infections. You have been hired by AAFL

Prepare required summary journal entries complete : Prepare required summary journal entries complete with explanations for each of the 20X5, 20X6, and 20X7 fiscal years. (Round the percentage)

Childhood illnesses and management : knowledge and other resources to design, implement, and evaluate meaningful, challenging curriculum that promotes comprehensive developmental and learning

User Account

All Pages