I have a CSV file [insert CSV file] containing sales transaction data from multiple store locations (columns: TransactionID, StoreID, SaleDate, ProductID, Quantity, and Price). Some rows have missing or incorrect StoreIDs, and some of the prices look off. Please outline a step-by-step approach to identify and handle these discrepancies, and provide sample Python code for cleaning tasks like removing or imputing missing StoreIDs and fixing price outliers.
Outlines a systematic approach to identify and handle data discrepancies, such as missing or incorrect IDs and outlier values, and provides sample Python code for cleaning. Use for complex datasets with multiple error types.
Claude Code