interpret_column_data
Scans a CSV or Excel file to return the complete value distribution for specified columns, including dtype, null counts, and frequency counts sorted by most common.
Instructions
Return the complete value distribution of one or more columns.
For each requested column, reports dtype, total/null/unique counts and the
value frequencies (sorted most-common first). Unlike read_metadata,
this scans the whole file rather than a sample, so it is ideal for
understanding categorical columns. Frequencies are capped at 200 distinct
values per column.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes | Path to a CSV/TSV or Excel (.xlsx/.xls) file. | |
| sheet_name | No | Excel sheet name; ignored for CSV files. | |
| column_names | Yes | Columns to analyze. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||