The solution to Homework 5.2 (Hands-On) M101JS: MongoDB for Node.js Developers
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,000. For this problem, assume that a city name that appears in more than one state represents two separate cities. Please round the answer to a whole number.
Hint: The answer for CT and NJ (using this data set) is 38177.
Please note:
- Different states might have the same city name.
- A city might have multiple zip codes.
For purposes of keeping the Hands-On shell quick, we have used a subset of the data you previously used in zips.json, not the full set. This is why there are only 200 documents (and 200 zip codes), and all of them are in New York, Connecticut, New Jersey, and California.
If you prefer, you may download the handout and perform your analysis on your machine with
> mongoimport -d test -c zips --drop small_zips.json
Solution:
Run the following query and find the answer:
db.zips.aggregate([
{ $match: {$or: [ {state: "CA"}, {state: "NY"} ] } },
{ $group: { _id: { city: "$city" }, pop: { $sum: "$pop" } } },
{ $match: { "pop": { $gt: 25000 } } },
{ $group: { _id: null, avg_pop_of_city: { $avg: "$pop" } } }
])
I got the following answer and submit and it is correct for me. let me know if you got any other results and an easy way to proceed through it.
