The Gaps Between

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

Domain

Python

Difficulty

hard

Seniority

L4

Problem

A data-quality job profiles raw record exports before they load into the warehouse, and the records are dicts that don't all carry the same columns. For every column that appears in any record, report how many records hold a real value versus how many are blank, where blank means the value is `None` or the column is absent from that record entirely. Each column maps to its own `null_count` and `non_null_count`, and an empty batch produces an empty result.

Summary

The data is not as clean as it looks.

Practice This Problem

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