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
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
___