load_and_analyze_data
Load and analyze local or remote data files (CSV, JSON, Excel, etc.) to obtain DataFrame information and metadata.
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 |