T06 CSV cleanup (500 rows)

Category: Data. Pass at 8/8.

All 40 tasks

Prompt

Attached is transactions.csv. Remove exact duplicate rows, then give: the number of rows after deduplication, and the total amount per category (2 decimals). Return the cleaned CSV as a file.

Inputs

Files attached to the chat:

• transactions.csv

Checklist

Pass at 8/8.

• Row count after deduplication right
• 6 category totals exactly match the answer key (6 points)
• Cleaned CSV delivered, without duplicates

The answer key is not published while the task set is in use.