Challenge #281: Holidays
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
Alteryx
08-16-2021
05:57 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.
This dataset contains a list of holiday dates that are observed by each country from Feb. to Dec. 2020.
Your Challenge is to figure out for that period:
- Which country has the most holidays and how many?
- Some holidays are only observed by one country. Which country has the most unique days off and how many?
- Which day is the most shared in the world as a holiday and which countries are sharing this holiday?
Labels:
- Labels:
- Basic
- Core
- Data Preparation
- Preparation
- Transform
L_T
8 - Asteroid
08-16-2021
06:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Blake
12 - Quasar
08-16-2021
06:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Aaron_Harter
11 - Bolide
08-16-2021
06:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Looking forward to another holiday!
Spoiler
I used unique holiday names in my answer for #4 as we can celebrate more than one holiday on the same calendar date!

17 - Castor
08-16-2021
06:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
14 - Magnetar
08-16-2021
06:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
16 - Nebula
08-16-2021
06:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Spoiler
I always believed we had so many holidays in Germany ...
I always believed we had so many holidays in Germany ...
16 - Nebula
08-16-2021
06:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
16 - Nebula
08-16-2021
06:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
18 - Pollux
08-16-2021
07:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My interpretation of the second question seems to be different than most, but I am sticking to it.