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 Target. The logistics reporting dashboard consumes shipment data, but the raw service_level field contains inconsistent formatting (lowercase with underscores, e.g., two_day), which looks unprofessional in customer-facing reports. Additionally, management wants to distinguish shipments fulfilled by Amazon's own logistics network from those handled by third-party carriers. Finally, some shipments have not yet shipped and are missing a ship_date, which causes errors in downstream date calculations.
You are a Data Engineer at Target. The logistics reporting dashboard consumes shipment data, but the raw service_level field contains inconsistent formatting (lowercase with underscores, e.g., two_day), which looks unprofessional in customer-facing reports. Additionally, management wants to distinguish shipments fulfilled by Amazon's own logistics network from those handled by third-party carriers. Finally, some shipments have not yet shipped and are missing a ship_date, which causes errors in downstream date calculations.