subset
Filter, select, or sample table rows and columns using query, regex, or variance criteria; preview results and optionally save the output as a new table.
Instructions
Filter / select / sample rows and columns of a table; preview a few rows; optionally store the result as new_name.
where: pandas query string, e.g. "iv > 0.3 and maturity_days <= 30" (backtick-quote odd column names). columns: list of names, "re:", or "top_variance:". top_variance keeps the k highest-variance numeric features. This is the only way to read raw rows; preview is capped (200 rows x 60 cols).
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"name": "<name>"
},
"name": "subset"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | ||
| seed | No | ||
| where | No | ||
| sample | No | ||
| columns | No | ||
| preview | No | ||
| sort_by | No | ||
| new_name | No | ||
| ascending | No | ||
| top_variance | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |