GUI report menu for data selection across multiple filters in Java, PHP, Python, R, SAS, and VBA (MS Access/Excel).
Using the U.S. Department of Energy fuel economy data of vehicle makes and models from 1984 - 2017, scripts connect to attached SQLite database to query filterable aggregagte MPG data.
REQUIREMENTS
- JAVA 1.8+: awt/swing, sqlite-jdbc
- PHP 5.4+: php-gtk2
- Python 3+: no additional modules
- R 3.2+: gWidgets2, gWidgets2tcltk, RSQLite packages
- SAS 9.2+: SAS/AF (catalog/frame/scl), SQLite3 ODBC driver, attached catalog.sas7bcat
- MS Access 2007+: SQLite3 ODBC driver
- MS Excel 2007+: SQLite3 ODBC driver