SQL · Tesla · Hard
Requirements Build a cleaning pipeline whose input is a customer-transaction CSV containing the columns date, amount, customer_id, payment_method, and notes. Account for the following data-quality problems: Dates may use YYYY-MM-DD, MM/DD/YYYY, or text forms such as Jan 5, 2024. Amounts may contain currency symbols and thousands separators, for example $1,234.56. Excel processing may remove leading zeros from customer_id values. payment_method values may have spelling errors…
Checking your access…