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
dplyrpackage. - Print the
votes_processeddataset. - Print the new
descriptionsdataset. - Join the two datasets using dplyr's
inner_join(), using thercidandsessioncolumns 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