Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAA solution to last week's challenge can be found here.
Use Designer Desktop or Designer Cloud, Trifacta Classic to solve this week's challenge.
In the UK, National Fish and Chip Day is celebrated every year on the first Friday of June. This special day sees people across the country indulging in the iconic British dish, which is served in various establishments such as fish and chip shops, pub chains, restaurants, and retail outlets.
National Fish and Chip Day was established by the National Edible Oil Distributors’ Association (NEODA) in 2015. According to NEODA, British consumers devour a staggering 382 million portions of fish and chips annually.
For this challenge, we will use a dataset obtained from the UK's Department for Environment, Food & Rural Affairs. This dataset provides information on the average quantity of food and drink purchased by UK households per person, per week. Using the Major Food Code column, let’s determine the following:
The major food code containing fish with the highest per person, per week consumption rate since 2015.
The specific year, starting from 2015, that experienced the highest rate of fish consumption.
The major food code containing potatoes with the highest per person, per week consumption rate since 2015.
The specific year, starting from 2015, that experienced the highest rate of potato consumption.
Hints as you proceed:
Only use the Major Food Code column for the analysis.
If you come across a record that combines 2 years into a single record, for example 201516 or 2021-22, divide the value equally and generate a record for each year.
Note that traditional fish and chips in the UK do not include shellfish!
Source: https://www.gov.uk/government/statistical-data-sets/family-food-datasets
Per my understanding, 2015 is present as a calendar year column and merged with 2016 (201516). For my solution, I took 2015 column only and did not add half of 201516 column to avoid double counting. Also did not include 2021 in the analysis as only half year data is available.
Happy Memorial Day to community members in USA.
Here is my solution
🐟🥔