Organizations and prizes over time
How many organizations won prizes before 1945 versus in or after 1945?
This exercise is part of the course
Introduction to MongoDB in Python
Exercise instructions
- You won't need the
$elemMatch
operator at all for this exercise. - Save a filter
before
to count organization laureates with prizes won before 1945. Recall that organization status is encoded with the"gender"
field, and that dot notation is needed to access a laureate's"year"
field within its"prizes"
array. - Save a filter
in_or_after
to count organization laureates with prizes won in or after 1945.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Save a filter for organization laureates with prizes won before 1945
before = {
____: ____,
____: {____: "1945"},
}
# Save a filter for organization laureates with prizes won in or after 1945
in_or_after = {
____: ____,
____: {____: "1945"},
}
n_before = db.laureates.count_documents(before)
n_in_or_after = db.laureates.count_documents(in_or_after)
ratio = n_in_or_after / (n_in_or_after + n_before)
print(ratio)