Misión 114Data Munging Boss
+500 XP
Boss Challenge 13: Data Pipeline Normalization
Iniciar terminal interactiva para esta misión→Sin instalación requerida • Se ejecuta en el navegador
Concepto y descripción general
ETL DATA INCIDENT: A legacy mainframe exported /home/learner/messy_data.csv using unconventional formatting: fields are separated by colons and rows end with semicolons (alice:dev:engineering;).
The analytics ingestion engine rejects this format. Transform the file into clean CSV format at /home/learner/clean_users.csv, containing only the user and department (fields 1 and 3) separated by commas (alice,engineering), with semicolons stripped.
Instrucciones de la misión
Process
/home/learner/messy_data.csv and write clean records into /home/learner/clean_users.csv formatted as name,dept without semicolons.Referencia de sintaxis de comandos
| Command / Syntax | Description |
|---|---|
cat messy_data.csv | View raw delimited data |
awk / sed / cut / tr | Filter, translate delimiters, and cut fields |
> clean_users.csv | Write normalized data to output file |
Objetivos de verificación
- ○Generate /home/learner/clean_users.csv with clean comma-separated name,dept records