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
.
Diese Übung ist Teil des Kurses
Joining Data with data.table in R
Anleitung zur Übung
- Use the
fintersect()
(docs) function to build a newdata.table
containing countries located in both Europe and Asia. - Concatenate all
data.table
s ingdp
and assign it togdp_all
. - Use the
duplicated()
function to filtergdp_all
to rows that are duplicates to find all countries located in more than one continent.
Interaktive Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
# Obtain countries in both Asia and Europe
___
# Concatenate all data tables
gdp_all <- ___
# Find all countries that span multiple continents
___