Profile a table (CSV, JSON, XLSX)
ai_csv_profileProfiles CSV, TSV, JSON, or Excel tables before analysis: counts rows/columns, infers column types, summarizes missing values, uniques, stats, and flags data-quality issues.
Instructions
Profile a table to understand and clean it before analysis: row and column counts, and per column the inferred type (integer, number, boolean, date, datetime, string), non-null and null counts, unique count, top 5 values, sample values, min/max/mean/median/stddev for numbers, min/max for ISO dates, min/max length for text, plus data-quality warnings (mixed types, leading/trailing spaces, mostly missing, constant columns, duplicate rows, ragged headers). Input: "file" (local path or base64 of CSV, TSV, JSON array, JSONL or .xlsx, first sheet or "sheet") or inline "csv" / "json". Empty cells, "null" and "NULL" count as missing. Runs locally; nothing is uploaded.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| csv | No | Or: CSV/TSV text inline (delimiter detected; first row is the header). | |
| file | No | A table file: local path (absolute, or relative to --root) or base64. CSV, TSV, JSON array, JSONL or .xlsx. | |
| json | No | Or: JSON inline: an array of objects (or of arrays, first one the header), as a value or as JSON/JSONL text. | |
| sheet | No | For .xlsx: the sheet name to read (default: the first sheet). | |
| format | No | Force the file format (default "auto": by extension, then by content). | auto |
| columns | No | Only profile these columns (default: all). |