Using Python in a Traditional Office
summary
Shows how to use Python tools to give non‑programmers editable results: Quarto to render qmd notebooks into company‑styled Word (with editable figures and tables) and produce Word/HTML/PDF from the same source; GeoPandas with Streamlit or Shiny to build geospatial apps that accept GPS points in Excel, do spatial joins, and return downloadable XLSX; and xlwings to populate locked Excel templates without breaking validations. Live demos prove these solutions are usable by field staff.
AI-written summary · about
chapters (8)
- 0:00Introduction
- 3:00Traditional office in environmental science
- 6:09Python optimizes processes
- 8:05Generate Word docs with Quarto
- 18:22Share complex solutions with apps
- 24:10Fill official forms with XLWings
- 27:10Python challenges and future
- 29:14Q&A
related talks
43mInstall Python. Quarto Render All the Things
29mTake Your Technical Presentations to the Next Level with Python + Quarto
30mReproducible Publications with Python and Quarto
01h 25mAdvanced Excel Analytics: Python Integration Workshop
14mHow Python can handle and help you with repetitive tasks!
41mPublishing Jupyter Notebooks with Quarto
42mProgram Your Own Computer in Python
01h 29mTurning Jupyter Notebooks into Data Applications