Penguin joins
The colonies of different penguins from the penguins dataset can be described by an area code that is unique for each combination of species and island. The area codes are stored in the penguin_data dataset in the ids column. Let's join the two datasets together!
Important columns in penguins:
species, containing the species of the penguin;island, containing the island where the penguin was observed.
Important columns in penguin_data:
penguin, containing the species of the penguin;location, containing the island where the penguin was observed;ids, containing the identification number of the penguin colony.
The penguins and penguin_data, as well as DataFrames package, have been loaded for you.
Cet exercice fait partie du cours
Data Manipulation in Julia
Instructions
- Use left join to join the
penguinsandpenguin_data, using thespeciesandislandcolumns and their respective counterparts. - Save the result as
penguins_ids.
Exercice interactif pratique
Essayez cet exercice en complétant cet exemple de code.
# Use leftjoin on penguins and penguin_data
penguins_ids = ____