Get startedGet started for free

Splitting by multiple groups

gdp_by_industry_oceania contains the GDP generated by the agriculture and tourism industries in both 1995 and 2010. Your goal is to create a wide format data.table containing columns of GDP for each year and industry.

This exercise is part of the course

Joining Data with data.table in R

View Course

Exercise instructions

  • Print gdp_by_industry_oceania.
  • Convert gdp_by_industry_oceania to a wide format with each country as a row, splitting the "gdp" column so that the result has columns containing the gdp for each industry and each year.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# Split gdp by industry and year
___
Edit and Run Code