profile_column
Profile a column's distribution, outliers, coverage gaps, and dirty values. Adapts to numeric, date, text, or boolean types to reveal skew, missing days, and formatting issues.
Instructions
Profile one column: distribution, outliers, coverage gaps, dirty values.
The profile adapts to the column type:
numeric: min/p25/median/mean/p75/p95/max/stddev, plus a Tukey outlier count and the largest values when the distribution is skewed
date/timestamp: range, distinct days, and the largest gaps in coverage
text/boolean: top values with shares, plus a warning when values differ only by case or formatting
Args: table (str): Table name, case-insensitive. column (str): Column name, case-insensitive.
Returns: str: Markdown profile, ending with the column's definition and any caveats that mention it.
On failure: "Error: Table 'orders' has no column 'x'. Columns: ..."Examples: - Use when: "Is unit_price skewed? Should I use mean or median?" - Use when: "Are there missing days in order_date?" - Use when: a GROUP BY returned more groups than expected. - Don't use when: you want the whole schema (use describe_table).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Table name, e.g. 'orders'. Case-insensitive. | |
| column | Yes | Column name, e.g. 'unit_price'. Case-insensitive. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |