analyze_excel
Perform statistical analysis on Excel files, extracting insights from specified columns or sheets, and return results in JSON format for easy interpretation.
Instructions
Perform statistical analysis on Excel data.
Args:
file_path: Path to the Excel file
columns: Comma-separated list of columns to analyze (analyzes all numeric columns if None)
sheet_name: Name of the sheet to analyze (for Excel files)
Returns:
JSON string with statistical analysis
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| columns | No | ||
| file_path | Yes | ||
| sheet_name | No |
Input Schema (JSON Schema)
{
"properties": {
"columns": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"title": "Columns"
},
"file_path": {
"title": "File Path",
"type": "string"
},
"sheet_name": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"title": "Sheet Name"
}
},
"required": [
"file_path"
],
"title": "analyze_excelArguments",
"type": "object"
}