80 lines (56 loc) · 2.02 KB

SmartSheet Agents - Excel/CSV AI Assistant Code

Features:

1. Dynamic Model Selection

Automatically detects all your installed Ollama models Dropdown selection for easy model switching Connection status monitoring

2. AI Agents

Code Generation Agent: Smarter code generation with better prompting
Code Review Agent: Validates code safety and correctness
Data Insight Agent: Provides automatic dataset analysis

3. Safety & Reliability

Code safety validation (blocks dangerous operations)
Error handling and user feedback
Isolated code execution environment

4. User Experience

Responsive UI with sidebar configuration
Predefined example prompts for common tasks
Real-time progress indicators
Advanced settings panel

5. Data Processing

Support for multiple CSV encodings
Excel file handling
Download options for both Excel and CSV formats
Data preview with adjustable row count

6. Smart Code Extraction

Code block parsing from LLM responses
Handles various response formats
Better code cleaning and validation

🔧 Usage Instructions:

Setup Requirements:

python 3.11++ or above
Ollama on local system

Install required Libraries:

pip install requirments.txt

Start the ollama server inside command prompt:

ollama serve  # Start Ollama server

Run the Application:

streamlit run main.py

Use the Interface:

Select your preferred model from the dropdown
Upload CSV/Excel files
Use natural language prompts or example commands
Review generated code before execution
Download processed results

💡 Example Prompts You Can Try:

"Add a profit margin column calculated as (revenue - cost) / revenue * 100"
"Filter rows where sales are above the median value"
"Create a summary table grouped by category"
"Find all rows with missing values and highlight them"
"Calculate running totals for the amount column"