Gen AI · Data

Smart CSV / Excel Assistant

Ask questions about your spreadsheet in plain English and get instant answers, tables and insights powered by an LLM over pandas.

Live Demo All Projects

Technical Information

Project Type
Conversational Data AnalysisCSV/Excel Assistant
Tech Stack
PythonFlaskPandasMistral AIOpenPyXLDataTablesPrompt EngineeringLLMSLMNLP
Topics / Modules
Natural-Language QueriesAutomated pandasData StatisticsTabular Display
Links
Live Demo

Project Summary

An assistant that lets you upload a CSV or Excel file and query it conversationally. It translates natural-language questions into pandas operations and returns answers, statistics and interactive tables.

Skills Demonstrated

NL-to-pandasData ProfilingPrompt EngineeringTabular AnalyticsSpreadsheet Automation

Solution

Uploaded data is profiled for stats; a Mistral model converts questions into pandas queries which are executed server-side, with results rendered in interactive DataTables and exportable back to Excel.

Approach

  1. Upload: Accept CSV/Excel and display data with summary statistics.
  2. Ask: Take natural-language questions about the data.
  3. Translate: Use an LLM to generate the corresponding pandas query.
  4. Execute: Run the query and render results in interactive tables.
  5. Deploy: Host the Flask app on Heroku.