Automated Report Writing Using Data from a Relational Database
summary
An automated report generator uses pandas with ODBC to read normalized tables from relational databases, ingests and validates messy CSVs, joins records by primary keys, and fills Word templates to produce landscape/portrait reports plus CPR map exports. The code supports multiple DBMS, ArcGIS Pro plot exports, handles duplicate parties and missing addresses, and is packaged as redeployable scripts that delivered about 50% time savings in real deployments for medium and large datasets.
AI-written summary · about
chapters (6)
- 0:00Automated report writing
- 4:15Database structure
- 8:33Data sources and parameters
- 12:07Connecting databases with ODBC
- 15:45Handling data errors
- 17:33Future automation plans
related talks
21mCreating reproducible static reports
42mJSON data + RML template = PDF report
42mJSON data + RML template = PDF report
16mSometimes you just need words
20mUsing Quarto to Improve Formatting/Automate the Generation of Hundreds of Reports
19mBranding and Packaging Reports with R Markdown
17mA case study: Ditching the paper for Drupal
24mStory Telling Through Reports