📊 CSV Analyzer VS Code Extension

A powerful Visual Studio Code extension that allows users to upload and analyze CSV files directly inside the editor using a sleek and interactive Streamlit-based web interface.

🚀 Features

• 🔐 User Authentication (Sign up / Login)
• 📁 Upload CSV files
• 📉 View descriptive statistics
• 📊 Correlation matrix
• 📃 PDF report generation
• 🌐 Runs inside VS Code (WebView panel, not external browser)

🛠️ How It Works

This extension opens a WebView panel inside VS Code and loads a hosted Streamlit web app, giving users a seamless in-editor experience.

🌍 Live App

This extension uses a publicly hosted Streamlit app: https://csv-analyzer.onrender.com

📦 Installation

Option A: From VS Code Marketplace

Search for CSV Analyzer in the Extensions tab and click Install.

Option B: Manual Install

1. Download csv-analyzer-x.x.x.vsix

2. Run:

   code --install-extension csv-analyzer-x.x.x.vsix
   

🚧 Development Setup

Requirements:

• Node.js & npm
• Python 3
• Streamlit

Compile the extension:

npm install
npm run compile

📁 Project Structure

csv-analyzer/
├── extension/               # VS Code extension code (TypeScript)
├── streamlit-app/           # Streamlit backend code
│   ├── main.py
│   ├── analyze.py
│   ├── auth.py
│   ├── database.py
│   ├── pdf_report.py
│   ├── requirements.txt
│   └── .streamlit/config.toml
├── README.md
├── LICENSE
└── csv-analyzer.vsix

🧹 Recommended Cleanup for Publishing

To reduce package size:

✅ Keep:

• main.py, requirements.txt, and essential files

❌ Remove before publishing:

• Unused .csv or .db files (like users.db, if not required)
• Development-only logs or temp files
• Local __pycache__/
• .vscode/
• Old .vsix builds (only keep latest one if needed)

Add to .vscodeignore:

**/*.csv
**/*.db
**/__pycache__/
.vscode/
*.vsix

📝 License

See LICENSE for full license.

This project is licensed under the MIT License.

✨ Author

Sanidhya Mehra

🙌 Contributions

Pull requests are welcome! For major changes, open an issue first to discuss.

💬 Feedback

Have suggestions or bugs? Feel free to open an issue or connect via GitHub!

🧠 Credits

Built with ❤️ using Streamlit and VS Code Extension API.