For example, to extract the first character from the city field, you could write this pipeline:. Different states might have the same city name. Those students achieved a class average of In this assignment you will use the aggregation framework to find the most frequent author of comments on your blog If you notice that while importing, there are a few duplicates fear not, this is expected and will not affect your answer. Those students achieved a class average of The answer for CT and NJ using this data set is

Your task is to calculate the class with the best average student performance. Import it into your mongod using the following command from the command line:. Using the aggregation framework, calculate the sum total of people who are living in a zip code where the city starts with one of those possible first characters. In this assignment you will use the aggregation framework to find the most frequent author of comments on your blog. You will be using the zip code collection data set, which you will find in the ‘handouts’ link in this page.

# Agentur für webbasierte Software aus Hamburg –

Crunching the Zipcode dataset Please calculate the average population of cities in California abbreviation CA and New York NY taken together with populations over 25, Import it into your mongod using the following command from the command line: If you prefer, you may download the handout and perform your analysis on your machine with.

Then homewor, into your blog database as follows:. Using the aggregation framework, calculate the sum total of people who are living in a zip code where the city starts with a digit. You need to group twice to solve this problem. Also, you will need a filtering step to get rid of all documents where the city does not start with the select set of initial characters.

For honework, to extract the first digit homewok the city field, you could write this query: Those students achieved a class average of Type the validation code below.

## Mongodb M101J Homework 1 1 Answers

The answer for CT and NJ using this data set is To help you verify your work before submitting, the author with the fewest comments is Mariela Sherer and she commented times. Now use the aggregation framework to calculate the author with the greatest number of comments.

Let’s suppose you have a five homewogk replica set and want to assure that writes are committed to the journal and are acknowledged by at least 3 nodes before you proceed forward.

If you imported it correctly, you can go to the test database in the mongo shell and conform that. Please choose your answer below for the most prolific comment author: Check all that apply. Some students have three homework homeowrk, etc.

For this problem, assume that a city name that appears in more than one state represents two separate cities. Ankit Raina May 7, at 3: Your task is to calculate the class homswork the best average student performance. Start by downloading the handout zip file for this problem. Friday, 8 September Week 5: In this problem you will calculate the number of people who live in a zip code in the US where the homesork starts with a digit.

# MongoDB university mp chapter 5 homework – bigmongodb

Omit -p from mkdir. You can type rs. At the end I just want to say if you want to learn mongoDB, First practice with youself. Try for your self. In this assignment you will use the aggregation framework to find the most frequent author of comments on your blog. We will be using a data set similar to ones we’ve used before. Which of the following statements are true about choosing and using a shard key?

Note that are three commands. Now use the aggregation framework to calculate the author with the greatest number of comments.

Your task is to calculate the class with the best average student performance. This is why there are only documents ohmework zip codesand all of them are in New York, Connecticut, New Jersey, and California.