1. Learn
    2. /
  2. Courses
    3. /
  3. Joining Data with data.table in R
Connected

Exercise

Identifying observations shared by multiple tables

The list of data tables, gdp, is available in your workspace. Your goal is to find the countries that are located in more than one continent, i.e., rows that are present in more than one data.table in gdp.

Instructions

100 XP
  • Use the fintersect() (docs) function to build a new data.table containing countries located in both Europe and Asia.
  • Concatenate all data.tables in gdp and assign it to gdp_all.
  • Use the duplicated() function to filter gdp_all to rows that are duplicates to find all countries located in more than one continent.