load_and_analyze_data
Load data from local files or URLs and analyze it to get DataFrame information and metadata. Supports CSV, JSON, HTML, Excel, ODS, Parquet.
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 | ||
| message | Yes | ||
| df_info | Yes | ||
| df_metadata | Yes |