7 Quick Sheet SQL
Streamlit web app for uploading CSV, Parquet, or Excel files, querying them with SQL (pandasql), saving results as named dataframes for further queries, and downloading results as CSV.
Demonstration
Upload multiple files at once (CSV, .parquet, .xlsx/.xls)
Installed Packages
- streamlit
- openpyxl
- pandasql
- streamlit_code_editor
Challenges and Improvements
- File type is limited to csv, xlsx, xls, parquet
- Cannot process large dataset
- Only SQLite Engine available