The Puzzle Guild Archives

🧩 The Puzzle Guild Archives

🍂 The Story

On a foggy morning, Luca was browsing through dusty manuscripts in an old library.

On a table hidden between the shelves, he found a leather-bound journal.

On the first page, it said:

"If you are reading this, it means you have found the Puzzle Guild archive."

Luca blinked.

— Puzzle Guild?

He continued reading.

"Every year we organize challenges for the best puzzle-solving teams in the world.
But this year our archive was corrupted... and the team styles were lost."

Luca sighed.

— Perfect. Exactly what I needed today... a mysterious database.

On the last page was a handwritten note:

"If you manage to reconstruct the team styles and decipher the competition statistics, you will officially become a member of the Puzzle Guild."

Luca looked at his laptop.

— Alright... challenge accepted.

Now you must help him.

📁 The Data

You have received two files from the guild archive.

data.csv

Contains information about competition rounds.

⚠️ The problem is that most values in style are missing.

Possible values are:

Luca raised an eyebrow.

— Whoever made this data really wants me to suffer.

🧠 What you need to do

The Puzzle Guild archive contains three enigmas.

Luca read the instructions out loud.

🔎 Subtask 1 — A Suspicious Pattern

A note appears in the journal:

"Sometimes the most interesting things happen in libraries."

You need to find out how many rounds simultaneously meet the conditions:

1location        = "The Old Library"2tech_assist     = 1

Formal: count all rows that simultaneously satisfy both conditions.

Luca murmured:

— If I find a secret door in a library, I promise I won't open it... probably.

📊 Subtask 2 — Guild Statistics

A quick calculation appears in the journal:

"In Crystal Cave, teams that solve logical or sequential puzzles with technology have an interesting performance."

You need to calculate:

S = mean(skill_level) + mean(teamwork_score)

Conditions:

1location        = Crystal Cave2tech_assist     = 13puzzle_type     = Logic,Sequence

where mean(x) represents the arithmetic mean of the respective column.

The final result must be rounded to exactly 2 decimal places.

Luca noted the formula in a corner of the page.

— Ok... this is the easy part... I hope.

🌀 Subtask 3 — Lost Styles

Here the mystery begins.

Most style labels have been lost.

All we know is that there are three different solving styles:

After a closer analysis, Luca noticed something curious.

The points seemed to form a spiral pattern in a latent space.

— Ah... brilliant. Obviously it's a spiral.

You must reconstruct the correct style for each round.

📊 Evaluation Metric

For subtask 3, the following is used:

Adjusted Rand Index (ARI)

-1 <= ARI <= 1

Luca looked at the table and said:

— Ok... so if I get -0.5 it means I did something very impressively bad.

🧮 Score for Subtask 3

The score for clustering is calculated as follows:

• if ARI >= 0.965 → 70 points (maximum score)
• if ARI <= 0.50 → 0 points
• for 0.50 < ARI < 0.965 → proportional score between 0 and 70

📄 Submission Format

The submission.csv file must contain:

🏆 Final Score

• S1 = 15 points
• S2 = 15 points
• S3 = 70 points

At the end of the journal, Luca found one last sentence:

"If you've made it this far and reconstructed the styles... congratulations.
The Puzzle Guild is watching you."

Luca closed the journal.

— Ok... that got a little creepy.

Then he opened his laptop.

— Let's see if we can beat this spiral.