Column name suffixes
The three data.tables containing information about the geography and population of Australia have been loaded into your R session: capitals, area, and population. Both area and population now have a column named "percentage". The "percentage" column in area contains the percentage of total land mass each state occupies. The "percentage" column in population contains the percentage of the total population living in each city.
This exercise is part of the course
Joining Data with data.table in R
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Inner join
capital_pop <- ___(capitals, population, ___)
# Left join
___