Python and Data Manipulation | Dataford Interview Questions

Describe Python and how you handle data manipulation.

For this PostgreSQL exercise, demonstrate the same data preparation principles by producing a clean user-level summary from the provided tables. Include only active users and treat completed records with non-null, non-negative amounts as valid.

Output

One row per active user, including users without valid records
Columns: user_id, user_name, completed_count, total_amount, and latest_completed_date
Sort by user_id ascending

Schema

users

Column	Type	Description
user_idPK	INT	Unique user identifier
user_name	VARCHAR(100)	User display name
account_status	VARCHAR(20)	Current account status

records

Column	Type	Description
record_idPK	INT	Unique record identifier
user_id	INT	User associated with the record
status	VARCHAR(20)	Processing status of the record
amount	NUMERIC(10,2)	Recorded amount
record_date	DATE	Date associated with the record

Your question is Python and Data Manipulation. 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