How many prizes were awarded to immigrants?
How many prizes were awarded to people who had no affiliation in their country of birth at the time of the award?
Este exercício faz parte do curso
Introduction to MongoDB in Python
Instruções do exercício
- In your aggregation pipeline
pipeline, use the "gender" field to limit results to people (that is, not organizations). - Count prizes for which the laureate's "bornCountry" is not also the "country" of any of their affiliations for the prize. Be sure to use field paths (precede a field name with
"$") when appropriate.
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
pipeline = [
# Limit results to people; project needed fields; unwind prizes
{____: {____: {"$ne": "org"}}},
{"$project": {"bornCountry": 1, "prizes.affiliations.country": 1}},
{"$unwind": "$prizes"},
# Count prizes with no country-of-birth affiliation
{"$addFields": {"bornCountryInAffiliations": {"$in": [____, "$prizes.affiliations.country"]}}},
{____: {"bornCountryInAffiliations": False}},
{"$count": "awardedElsewhere"},
]
print(list(db.laureates.aggregate(pipeline)))