ticdat is an easy-to-use, lightweight, relational, data library. It provides a simple interface for defining a data schema, and a factory class for creating TicDat data objects that confirm to this schema.
It is primarily intended to simplify the process of developing proof-of-concept mathematical engines that read from one schema and write to another. It provides easy routines for reading and/or writing an entire data set for a range of stand-alone file types (Excel, .csv, Access or SQLite). For Access or SQLite, it can be used as a very condensed representation of the database schema.
For archiving test suites, ticdat is a useful way to convert data instances into .sql text files that can be archived in source code control systems.
When primary keys are specified, each table is a dictionary of dictionaries. Otherwise, each table is an enumerable of dictionaries. The inner dictionaries are data rows indexed by field names (as in csv.DictReader/csv.DictWriter).
- When foreign keys are specified, they can be used for a variety of purposes:
find_foreign_key_failures can find the data rows in child tables that fail to cross reference with their parent table.
obfusimplify can be used to cascade entity renaming throughout the data set. This can facilitate troubleshooting by shortening and simplifying entity names. It can also be used to anonymize data sets in order to remove proprietary information.
When enable_foreign_key_links is true, links are automatically created between the data rows of the parent table and the matching data rows of the child table.
When default values are provided, unfrozen TicDat objects will use them during the addition of new rows. In general, unfrozen TicDat data tables behave like a defaultdict. There are a variety of other overrides to facilitate the addition of new data rows.
Alternately, TicDat data objects can be frozen. This facilitates good software development by insuring that code that is supposed to read from a data set without editing it behaves properly.
Finally, the “dict-of-dicts” representation of a table can be eschewed entirely in favor of pandas.DataFrame. In this case, ticdat can be used as a shim library that facilitates schema level definitions and query abstraction for pandas developers.
Although ticdat was specifically designed with Mixed Integer Programming data sets in mind, it can be used for rapidly developing a wide variety of mathematical engines. It facilitates creating one definition of your input data schema and one solve module, and reusing this same code, unchanged, on data from different sources. This “separation of model from data” enables a user to move easily from small, testing data sets to larger, more realistic examples. In addition, Opalytics Inc (the developer of ticdat) can support cloud deployments of solve engines that use ticdat data objects.
Metadata
Release files for ticdat 0.2.7
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Actions Reset |
|---|---|---|---|---|
| ticdat-0.2.7-py2.py3-none-any.whl | Python 2, Python 3 | none | any | Details for ticdat-0.2.7-py2.py3-none-any.whl |
Release files / ticdat-0.2.7-py2.py3-none-any.whl
| Download URL | ticdat-0.2.7-py2.py3-none-any.whl |
|---|---|
| Size | 111.4 kB |
| Tags | Python 2 Python 3 |
|
SHA-256 checksum How to use checksums |
4305c6aa772df86127c27f0fd0edb5c6eb0961ea0cd3b6fd9056790783b9d925
|
|
BLAKE2b-256 checksum How to use checksums |
bb28e2cfb8620f1dda41b7650f2cdc5aaf4e6bb7f45195f24352309624ea0640
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
Security for ticdat 0.2.7
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.