Skip to main content

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)

Table of built distributions (wheels) for ticdat 0.2.7
File Interpreter ABI Platform Actions
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.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page