Challenge #295: Thanksgiving Feast
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
AYXAcademy
Alteryx
11-22-2021
06:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
A solution to last week’s challenge can be found here.
The Thanksgiving Holiday in the US involves a lot of food! Let's take a closer look at what people typically serve in different US regions.
The dataset contains information about what type of dishes are served at Thanksgiving dinners in US households, including type of protein, cranberry, if they use gravy or not, type of sides, pies and dessert, and in which regions they are. Each row of the dataset corresponds to one household. The challenge is to:
Task 1
Find the total number of food dishes (protein, cranberry, gravy, sides, pies and dessert) served in each household.
Task 2
Find the average number of dishes served for each US region.
Task 3
Determine the total number of pies served for each US region and create a pie chart to show the results in percentage.
BONUS:
What is the most popular combination of side dishes and how many households are serving it?
Data source:
Data and code behind the articles and graphics at FiveThirtyEight - data/thanksgiving-2015 at master · fivethirtyeight/data
Labels:
alexnajm
17 - Castor
11-22-2021
06:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm not seeing an input file in the Alteryx Package. Can you re-post it by chance?
11-22-2021
07:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for letting us know! The file was updated!
patrick_digan
17 - Castor
11-22-2021
07:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Kenda
16 - Nebula
11-22-2021
07:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
balajilolla1
8 - Asteroid
11-22-2021
07:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Spoiler
Solution Attached
chukleswk
11 - Bolide
11-22-2021
07:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This one was a fun one with the holidays approaching!
RolandSchubert
16 - Nebula
11-22-2021
07:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
CHarrison
8 - Asteroid
11-22-2021
08:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
alexnajm
17 - Castor
11-22-2021
08:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy Thanksgiving everyone!