Challenge #407: Single Biggest Lottery Winner

[AYXAcademy]

Hi Maveryx team, Happy New Year!

A solution to last week’s challenge can be found here.

I hope you all had a wonderful holiday season. Are you ready to dive into a new year of weekly challenges? In December, we tackled some complex spatial problems, macros, and advanced tools. To start the year, we will go a little bit easier on you. Who is up for feeling like a lottery winner?

You have a dataset that provides details of the winners of a lottery from November 3, 1996, to October 27, 2018. In this lottery, players select 6 numbers, and the objective is to match all 6 numbers to win.

Your tasks:

1. During this period, how many times was there just one winner (matched 6 out of 6 numbers) who claimed the entire accumulated jackpot?
2. Identify the date and the highest jackpot amount ever won by a single winner who matched 6 out of 6 numbers.

Hint: The dataset is from a lottery in Brazil, and the numeric punctuation is different from what is used in the United States. Portuguese uses a period to separate thousands (for example, 2.367.900 = 2,367,900) and it uses a comma to mark the decimal place (for example, 1,5 = 1.5). Be sure to convert the winning amount for a US-based audience.

Good luck, Maveryx!

Source: Adapted and translated from https://www.kaggle.com/code/lidialucena/mega-sena.

[alacoume]

My solution:

Spoiler

[alexnajm]

@AYXAcademy I would upload the .yxzp to make it easier for everyone, plus for consistency!

Otherwise perfectly fine challenge once the prompt was understood 😊

Spoiler

[RolandSchubert]

Spoiler

[ggruccio]

Fun way to start the year!

Spoiler

If I understood the first question (or data) then I get to 364 times.  Then finding the highest is simply a matter of Sort and Sample tools.

[ARussell34]

Great first challenge of the new year!

[PhilipMannering]

Solution attached.

Spoiler

[Kenda]

Spoiler

[balajilolla2]

Spoiler

My Solution

[AYXAcademy]

 Done. Thanks @alexnajm !