Consider the relation race. Which code would display the number of runners from each country?
(1 point)
Responses
race["country"].info()
race["country"].info()
race["country"].value_counts()
race["country"].value_counts()
country.value_counts()
country.value_counts()
race.value_counts()
race["country"].value_counts()
The correct code to display the number of runners from each country would be:
race["country"].value_counts()
The correct code to display the number of runners from each country in the "race" relation is:
`race["country"].value_counts()`
Explanation:
1. We have a relation named "race" which contains information about the runners.
2. We want to know the number of runners from each country, so we are interested in the "country" column of the "race" relation.
3. In pandas, to access a specific column in a DataFrame (such as "race"), we can use square brackets notation followed by the column name. Hence, `race["country"]` will give us the "country" column of the "race" relation.
4. To count the occurrences of each country in the "country" column, we use the `value_counts()` function. This function returns a series object with the count of each unique value in the specified column.
5. Therefore, `race["country"].value_counts()` will display the number of runners from each country in the "race" relation.