Business Problem

You are a Data Engineer at Wells Fargo. The transaction data coming from the core banking system has several quality issues that need to be fixed before it can be used in dashboards. Some transactions are missing merchant_name and transaction_category values (these are typically non-merchant transactions like deposits, transfers, and fees). Additionally, the description column often contains a redundant category suffix in the format "Merchant - Category" (e.g., "Nordstrom - Retail"). You need to clean this data by filling missing values and creating a simplified description that contains only the meaningful part before the - separator.

9276. Clean Transaction Descriptions

Premium Content

Relevant companies

Tags

9276. Clean Transaction Descriptions

Premium Content

Relevant companies

Tags

Premium Content