load_and_analyze_data
Load and analyze data files from absolute local paths or URLs. Supports CSV, JSON, HTML, Excel, ODS, and Parquet formats.
Instructions
Use to understand local or remote data files. Must be called with absolute paths or URLs.
Supported formats:
- CSV (.csv)
- JSON (.json)
- HTML (.html, .htm)
- Excel (.xls, .xlsx)
- OpenDocument Spreadsheet (.ods)
- Parquet (.parquet)
Returns:
DataAnalysisResults object containing DataFrame information and metadata
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path_or_url | Yes | Absolute (important!) local file path or URL to a data file |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| valid | Yes | ||
| df_info | Yes | ||
| message | Yes | ||
| df_metadata | Yes |