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.
This exercise is part of the course
Data Manipulation in Julia
Exercise instructions
- Use left join to join the
penguinsandpenguin_data, using thespeciesandislandcolumns and their respective counterparts. - Save the result as
penguins_ids.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Use leftjoin on penguins and penguin_data
penguins_ids = ____