Adding a country column
The country codes in the ccode
column are what's called Correlates of War codes. This isn't ideal for an analysis, since you'd like to work with recognizable country names.
You can use the countrycode
package to translate. For example:
library(countrycode)
# Translate the country code 2
> countrycode(2, "cown", "country.name")
[1] "United States"
# Translate multiple country codes
> countrycode(c(2, 20, 40), "cown", "country.name")
[1] "United States" "Canada" "Cuba"
This exercise is part of the course
Case Study: Exploratory Data Analysis in R
Exercise instructions
- Load the
countrycode
package. - Convert the country code 100 to its country name.
- Add a new
country
column in yourmutate()
statement containing country names, using thecountrycode()
function to translate from theccode
column. Save the result tovotes_processed
.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Load the countrycode package
# Convert country code 100
# Add a country column within the mutate: votes_processed
votes_processed <- votes %>%
filter(vote <= 3) %>%
mutate(year = session + 1945)