Data Analyst
Data Analyst answers questions about a CSV or Excel file you attach โ with charts and a short note on how it worked the answer out โ and cleans or extends a workbook by handing back an edited copy with a change log. Your original file is never changed.
At a glance
| Handle | @data-analyst |
|---|---|
| Availability | Seeded in every organisation |
| Tags | data, analysis, charts |
| Model tier | default |
| Autonomy | supervised |
| Tools | code_execution, calculate (and render_chart in web chat) |
| Max turns | 12 |
| Files | CSV, TSV, XLSX, XLSM (read as data โ macros never run). Up to 25 MB per file. |
How it works
-
It sees the shape of your data first
When you attach a spreadsheet, the agent is given its outline โ every sheet, each column with its type, the row count and the first rows โ so the analysis is right the first time. -
The analysis runs in the sandbox
Your file is copied into an isolated sandbox with no network access, and the agent works on it there with pandas. Nothing it writes can leave except the results it hands back. -
Charts from the computed result
A summary table the analysis produces becomes a chart directly โ the numbers are never retyped โ and you can explore it like any chart in chat. -
A Method note, and the script
Every answer ends with which sheet and rows were used, what was excluded and why, and how it was calculated. The script that produced it comes back asanalysis.py, so "show me how" is a download.
Cleaning or changing a workbook
Ask it to "clean up the dates", "add a margin column" or "remove the duplicate
rows" and you get <your file> (edited).xlsx
back. It is edited in place on a copy, so formatting and formulas it did not
touch survive, and it carries a Change log sheet listing every
change โ sheet, cell or column, before, after and why.
.xls format can't be read. Open it in Excel and use
Save As โ Excel Workbook (.xlsx), then attach it again.
How the router finds it
Attach a spreadsheet and ask one question about it, and the request reaches the
agent tagged data before any model is asked. A request that also
asks for something else โ "analyse this and book me a flight" โ is planned
across agents instead, so nothing you asked for is dropped. Without an
attachment, the router decides as usual.