chkcsv.py is a Python library and program that checks the format of data in a CSV file. It can check whether required columns and data are present, and the type of data in each column. Pattern matching using regular expressions is suppo...
A Python program that runs a SQL script stored in a text file against a PostgreSQL, MS-Access, SQLite, MS-SQL-Server, MySQL, MariaDB, Firebird, or Oracle database, or an ODBC DSN. execsql also supports a set of special commands (metacom...
Scripts for the execsql.py script processor that generate SQL to compare attribute values in a base table and a staging table of the same structure. SQL can be generated to produce several types of comparison results. The scripts int...
Scripts for the execsql.py SQL script processor that allow the user to easily create a glossary of terms to accompany a database export. A typical use is to create a glossary of all of the column names that appear in the export. The s...
Scripts for the execsql.py script processor that perform automated upsert operations (insert or update) on multiple tables simultaneously. The scripts dynamically create and execute SQL based on the database's information schema, and t...
__A simple map explorer for coordinate data__
MapData is intended to be a fast and easy way of viewing any data set containing geographic coordinates. Coordinate data can be read from a CSV file, spreadsheet, or database.
Differe...
A Python library that simplifies the construction of Tkinter user interfaces by allowing the developer to specify the structure of the interface elements from the inside out.
Whereas Tkinter requires that nested frames and other wi...
TkPane is a Python package designed to simplify the construction of a Tkinter user interface by encapsulating one or more widgets into ‘pane’ objects that have no direct dependence on any other UI elements. Panes interact with other app...
A Python module and command-line program that rearranges data from a crosstabulated format to a normalized format. See https://pypi.org/project/un-xtab/
rdnielsen