This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou 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.
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.