Create DataFrames from Dictionaries and Records in Pandas

Question

Given an API response returning a list of dictionaries with variable keys, create a clean DataFrame with typed columns, filling missing keys with `None`.

Accepted Answer

Optimal Solution:
import pandas as pd

api_records = [
    {"id": 1, "name": "Aarav", "score": 92},
    {"id": 2, "name": "Bhavna"}
]

# pd.DataFrame automatically aligns keys and fills missing keys with NaN
df = pd.DataFrame.from_records(api_records)

Technical Explanation:
`pd.DataFrame.from_records()` parses lists of dicts, creating unified schema columns and inserting `np.nan` for missing dictionary keys.

id	name	score
1	Aarav	92
2	Bhavna	NULL