Budget-Py

An open source data analysis & prototyping tool developed in Python for EPA analysts and released under the MIT license.

Features

• Mutliple data providers including SQLite, MS Access, and SQL Servers Express Edition through pyodbc
• Charting, plotting and reporting with matplotlib, dash, and pandas.
• Pre-defined schema for 100 environmental data tables.
• Access to editors for SQLite, MS Access, and SQL CE.
• Easily add agency/region/division-specific branding.

Providers

• SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. Learn more here
• SQL Server Express Edition is a scaled down, free edition of SQL Server, which includes the core database engine. Learn more here
• MS Access is a database management system (DBMS) from Microsoft that combines the relational Access Database Engine (ACE) with a graphical user interface and software-development tools. Learn more here

System requirements

• You will need these Requirements

Documentation

• See the User Guide for steps to get started.

Code

• Minion - other tools used and available in BudgetPy.
• Booger - controls for the user interface and related functionality.
• Data - data access layer with environmental budget data models.
• FileSys - classes for interacting with the file system and input/output.
• Static - enumerations used in budgetary data analysis.
• Schema - schema definitions of the BudgetPy data tables.
• Ninja- budget data model classes for environmental programs.

Credits