1. Learn
    2. /
  2. Courses
    3. /
  3. Data Manipulation in Julia

Exercise

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.

Instructions

100 XP
  • Use left join to join the penguins and penguin_data, using the species and island columns and their respective counterparts.
  • Save the result as penguins_ids.