Different states might have the same city name. In this assignment you will use the aggregation framework to find the most frequent author of comments on your blog The answer for CT and NJ using this data set is Please query the video. Now it’s your turn to analyze the data set. You should see three files at the highest level: Note that not all students in the same class have the same exact number of assessments.
If you notice that while importing, there are a few duplicates fear not, this is expected and will not affect your answer. You will be using the zip code collection data set, which you will find in the ‘handouts’ link in this page. 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. Import it into your mongod using the following command from the command line:. Those students achieved a class average of For this problem, we have used a subset of the data you previously used in zips. There is also a views directory which contains the templates for the project.
If you notice that while importing, there are a few duplicates fear not, this is expected and will not affect your answer. Posted by Unknown at You should see three files at the highest level: In this problem, you will be using a collection of student scores that is similar to what we used in the lessons.
Newer Post Older Post Home.
Check all that apply. Please use the Aggregation pipeline to solve this problem.
For example, to extract the first character from the city cevelopers, you could write this pipeline:. Use that data set to answer this question. You need to group twice to solve this problem. Then import into your blog database as follows:. To be clear, each student’s average includes only exams and homework grades.
MongoDBMJ: Mj Week2 Answers
Don’t include their quiz scores in the calculation. You must figure out the GPA that each student has achieved in a class and then average those numbers to get a class average. Mongoodb, 8 September Week 5: Those students achieved a class average of Sunday, January 22, [Solution] Week 2: Different states might have the same city name. Some students have three homework assignments, etc.
Find all exam scores greater than or equal to 65, and sort those scores javq lowest to highest. There is a dump of the video database included in the handouts for the “Creating Documents” lesson.
M101J Mongodb For Java Developers Homework Answers Week 2
For this problem, assume that a city name that appears in more than one state represents two separate cities. This involves calculating an average for each student in each class of all non-quiz assessments and then averaging those numbers to get a class average.
First, let’s confirm your data is intact; the number of documents should mm101j At the end I just want to say if you want to learn mongoDB, First practice with youself. If everything is working properly, you should be able to start the blog by typing: You will need to probably change your projection to send more info through than just that first character.
Study IQ World: Week 5 : AGGREGATION FRAMEWORK : MP: MongoDB for Developers
In this problem you will calculate the number of people who live in a zip code in the US where the city starts with one of the following characthers:. Which of the mongorb below is the title of a movie from the year that is rated PG and won no awards? Now it’s your turn to analyze the data set.
Please choose your answer below for the most prolific comment author:. Try for your self. The correct result will be: In this assignment you will use the aggregation framework to find the most frequent author of comments on your blog. The documents look like this: A city might have multiple zip codes.