Born and affiliated
Some countries are, for one or more laureates, both their country of birth ("bornCountry") and a country of affiliation for one or more of their prizes ("prizes.affiliations.country"). You will find the five countries of birth with the highest counts of such laureates.
Este exercício faz parte do curso
Introduction to MongoDB in Python
Instruções do exercício
- Create an index on country of birth ("bornCountry") for
db.laureatesto ensure efficient gathering of distinct values and counting of documents - Complete the skeleton dictionary comprehension to construct
n_born_and_affiliated, the count of laureates as described above for each distinct country of birth. For each call tocount_documents, ensure that you use the value ofcountryto filter documents properly.
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
from collections import Counter
# Ensure an index on country of birth
db.laureates.create_index([(____, 1)])
# Collect a count of laureates for each country of birth
n_born_and_affiliated = {
country: db.laureates.count_documents({
____: ____,
"prizes.affiliations.country": ____
})
for ____ in db.laureates.distinct("bornCountry")
}
five_most_common = Counter(n_born_and_affiliated).most_common(5)
print(five_most_common)