Joining datasets with inner_join
In the first chapter, you created the votes_processed
dataset, containing information about each country's votes. You'll now combine that with the new descriptions
dataset, which includes topic information about each country, so that you can analyze votes within particular topics.
To do this, you'll make use of the inner_join()
function from dplyr
.
This exercise is part of the course
Case Study: Exploratory Data Analysis in R
Exercise instructions
- Load the
dplyr
package. - Print the
votes_processed
dataset. - Print the new
descriptions
dataset. - Join the two datasets using dplyr's
inner_join()
, using thercid
andsession
columns to match them. Save asvotes_joined
.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Load dplyr package
# Print the votes_processed dataset
# Print the descriptions dataset
# Join them together based on the "rcid" and "session" columns