Flatten Nested Patient JSON | Dataford Interview Questions

Given a messy, nested JSON file of patient demographics, write a Python script to flatten the data and remove duplicates.

Implement flatten_and_deduplicate(records), where records is a list of JSON objects. Return a list of flattened dictionaries, using dot-separated keys for nested objects and numeric indexes for list elements. Preserve the first occurrence of each duplicate record and retain the original record order. Assume object keys do not contain periods and values are valid JSON primitives or nested objects and arrays.

Constraints

1 <= len(records) <= 1000
Each record is a JSON object
Keys do not contain periods
Values are JSON primitives, objects, or arrays
Preserve the first duplicate occurrence and input order

Function Signature

def flatten_and_deduplicate(records):

Your question is Flatten Nested Patient JSON. Start with the requirements in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Given a messy, nested JSON file of patient demographics, write a Python script to flatten the data and remove duplicates.

Constraints

1 <= len(records) <= 1000
Each record is a JSON object
Keys do not contain periods
Values are JSON primitives, objects, or arrays
Preserve the first duplicate occurrence and input order

Function Signature

def flatten_and_deduplicate(records):

Your question is Flatten Nested Patient JSON. Start with the requirements in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.