ComeçarComece de graça

Removing duplicates while combining tables

The same list of data tables as the last exercise, gdp, is available in your workspace. Your goal this time is to build a data.table in which each country appears only once, even if it is located in more than one continent.

Este exercício faz parte do curso

Joining Data with data.table in R

Ver curso

Instruções do exercício

  • Use the funion() (docs) function to build a new data.table containing all countries in either Europe or Asia, with each country appearing only once in the result.
  • Concatenate all data.tables in gdp and assign it to gdp_all.
  • Use the unique() function to remove duplicate rows fromgdp_all so that each country occurs only once in the result.

Exercício interativo prático

Experimente este exercício completando este código de exemplo.

# Get all countries in either Asia or Europe
___

# Concatenate all data tables
gdp_all <- ___

# Print all unique countries
___
Editar e executar o código