Prototype (Streamlit) App to deconstruct / summarise etc Excel workbooks. Add button to upload Excel file (no-PII data please!) and then parse it for data - possibly push to SQLite / summary (data quality?) / charts(?) / insights.
Building this Streamlit App as just a .py script (not Notebooks via nbdev) to compare workflows.
Minimal setup to work with Poetry, Sphinx and Streamlit out of the box.
See here for details:
- streamlit for quick dashboards
- Poetry package and environment manager
- pytest and Github Actions testing pipeline
- Sphinx documentation with:
- markdown support via powerful myst-parser
- beautiful PyData theme
- publishing documentation to Github Pages
- justfile for just command runner
- MIT license