DataDriven
LearnPracticeInterviewDiscussDailyJobs

The Column Shuffle

A medium Python interview practice problem on DataDriven. Write and execute real python code with instant grading.

Domain
Python
Difficulty
medium
Seniority
L6

Problem

A long-format metrics export gives you one record per reading, each carrying an `id` and a single `amount`, and the same `id` can recur across many records. For every id, lay its amounts out in the order they appear under keys `amount_1`, `amount_2`, and so on (an id with three readings gets three keys, an id with one reading gets one), and return a dict per id holding its `id` plus those numbered keys. Emit ids in first-appearance order and keep each id's amounts in input order rather than combining them.

Summary

Rows in, columns out. Number them.

Practice This Problem

Solve this Python problem with real code execution. DataDriven runs your Python code in a real environment and grades it automatically.

Related

  • All Practice Problems
  • Mock Interview Mode
  • Python Interview Questions
  • Data Engineering Interview Prep Guide
  • Daily Challenge
  • Data Engineering Lessons