load_and_analyze_data
Load and analyze local or remote data files by providing an absolute path or URL. Supports CSV, JSON, HTML, Excel, ODS, and Parquet formats. Returns DataFrame structure and metadata for quick data understanding.
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 metadataInput 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 | ||
| message | Yes | ||
| df_info | Yes | ||
| df_metadata | Yes |