Get startedGet started for free

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.

This exercise is part of the course

Joining Data with data.table in R

View Course

Exercise instructions

  • 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.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# Obtain countries in both Asia and Europe
___

# Concatenate all data tables
gdp_all <- ___

# Find all countries that span multiple continents
___
Edit and Run Code