Summarize by country, year, and topic

In previous exercises, you summarized the votes dataset by country, by year, and by country-year combination.

Now that you have topic as an additional variable, you can summarize the votes for each combination of country, year, and topic (e.g. for the United States in 2013 on the topic of nuclear weapons.)

This exercise is part of the course

Case Study: Exploratory Data Analysis in R

View Course

Exercise instructions

Print the votes_tidied dataset to the console.
In a single summarize() call, compute both the total number of votes (total) and the percentage of "yes" votes (percent_yes) for each combination of country, year, and topic. Save this as by_country_year_topic. Make sure that you ungroup() after summarizing.
Print the by_country_year_topic dataset to the console.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# Print votes_tidied


# Summarize the percentage "yes" per country-year-topic


# Print by_country_year_topic

Edit and Run Code