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

function-img
Upload multiple files at once (CSV, .parquet, .xlsx/.xls)

Language / Framework

PYTHON

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

More detail

Contact Me