xlsx_value_counts
Count unique values in a spreadsheet column, sorted by frequency with percentage. Shows distribution of categorical data in a markdown table.
Instructions
pandas-style Series.value_counts() on one column of a LOCAL .xlsx file — count each unique value, sorted by frequency desc, with percentage. Excludes nulls by default; pass include_nulls=true to count them.
USE WHEN: the user asks "what's the distribution of X?" / "how often does each value appear?". Returns a markdown table.
DO NOT USE WHEN: the user wants groupby + multi-column aggregations (use xlsx_aggregate). Or for upload/attached files.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| column | Yes | ||
| file_b64 | Yes | ||
| options | No |