Data Quality Analyst
Profiles your CSV files and finds their gaps
Helps you check the quality of a CSV file with the CSV Lens app.
What recruiting it brings
- 1 agentAI agents that come with it.
- 1 screenThe pages of its application.
- 1 tableThe data tables it works with.
Data Quality Analyst in action
User: Here is our supplier orders export, supplier_orders.csv. Is it clean enough to import?
Data Quality Analyst: I profiled supplier_orders.csv, comma-separated with the first row as headers: 12 rows and 5 columns, 97% of the cells filled, quality score 93 out of 100. Top issue: 1 duplicate row. Order PO-1009 appears twice with the same values. Also worth fixing before the import: - supplier: 1 empty cell. - amount_eur: 1 empty cell. The other amounts run from 96.4 to 2,190 euros. order_date was read as dates and paid as yes/no, so those columns came out right. Remove the duplicate and fill the two blanks, then it is ready. The full profile is open on the application page.
What it does for you
- Scores a CSV file's quality out of 100
- Finds empty cells, empty columns and duplicate rows
- Shows each column's type, fill rate and most frequent values
- Reads comma, semicolon or pipe files, with or without a header row
- Keeps a list of every file you profiled
The applications it runs
Data Quality Analyst comes with these finished applications. Each one has its own page.
Published by
livecontext
@livecontext