filter_excel
Filter Excel spreadsheet data using pandas query strings to extract specific rows based on conditions like Age > 30 and Department == 'Sales'.
Instructions
Filter Excel data using a pandas query string.
Args:
file_path: Path to the Excel file
query: Pandas query string (e.g., "Age > 30 and Department == 'Sales'")
sheet_name: Name of the sheet to filter (for Excel files)
Returns:
Filtered data as string
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes | ||
| query | Yes | ||
| sheet_name | No |