Inner Join With Missing Values | Dataford Interview Questions

Given two tables, write a Python script to perform an inner join and handle missing values.

Use the provided accounts and account_attributes tables. Return only records with matching account IDs, replacing missing output values with clear default labels.

Output

One row per matching account ID
Columns: account_id, account_name, segment, contact_email
Replace missing names, segments, and email addresses with Unnamed account, Unknown, and Not provided
Order by account_id ascending

Schema

accounts

Column	Type	Description
account_idPK	INT	Unique account identifier
account_name	VARCHAR(100)	Display name of the account

account_attributes

Column	Type	Description
account_idPK	INT	Account identifier associated with the attributes
segment	VARCHAR(50)	Account segment
contact_email	VARCHAR(150)	Primary contact email address

Your question is Inner Join With Missing Values. Start with the requirements and the two tables 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