Omid - Challenge 7

data-challenges
advanced-exercises
🔰 Filter rows with quantity equal to 9 and display the entire result in unhidden cells.
Published

March 24, 2026

Illustration for Omid - Challenge 7

Challenge Description

🔰 Filter rows with quantity equal to 9 and display the entire result in unhidden cells.

Solutions

library(tidyverse)
library(readxl)

# Task based on visibility of rows, nothing analytical.

  • Logic:

    • Applies the workbook rule directly and returns the expected output shape

  • Strengths:

    • The R solution stays close to the workbook rule and keeps the transformation compact.

  • Areas for Improvement:

    • The code assumes the sheet structure and source ranges remain stable.

  • Gem:

    • The strongest part of the solution is choosing the right intermediate representation before shaping the final output.

No Python file is included for this challenge because the original task is non-analytical and was explicitly described in the source as visibility/dashboard work rather than a data-transformation puzzle.

  • Logic:

    • The source material itself treats this challenge as outside the scope of a meaningful analytical code translation.

  • Strengths:

    • Avoids forcing an artificial Python solution where the task is primarily visual or interface-driven.

  • Areas for Improvement:

    • If the business rule is later formalized into data logic, a real Python solution can be added.

  • Gem:

    • This is one of the rare cases where the correct engineering choice is to not pretend the problem is a standard dataframe transformation.

Difficulty Level

This task is moderate:

  • The business rule is readable, but the workbook still requires careful implementation to reach the expected layout.