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.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for ticdat 0.2.0
File Size Uploaded Provenance Actions
ticdat-0.2.0.tar.gz 55.2 kB Without provenance Details for ticdat-0.2.0.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for ticdat 0.2.0
File Interpreter ABI Platform Actions
ticdat-0.2.0-py2.py3-none-any.whl Python 2, Python 3 none any Details for ticdat-0.2.0-py2.py3-none-any.whl

Total release size: 123.1 kB

Release files / ticdat-0.2.0.tar.gz

Download URL ticdat-0.2.0.tar.gz
Size 55.2 kB
Tags Source
SHA-256 checksum
How to use checksums
e199bd671e6ed6b8796e2d5c1e797d993e267fdb0de631787ba81e99bf7ec86e
BLAKE2b-256 checksum
How to use checksums
84e419e584e4f7f6d2948238239b2d107fd77cdcc65b0cdf90bb974618348751
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No

Release files / ticdat-0.2.0-py2.py3-none-any.whl

Download URL ticdat-0.2.0-py2.py3-none-any.whl
Size 67.9 kB
Tags Python 2 Python 3
SHA-256 checksum
How to use checksums
5b6d54cfe6018f43442507f34bc23346590493736af6df6e8d55f80f88f1238a
BLAKE2b-256 checksum
How to use checksums
4f2c66cb43c758dc40e3d31d276034bd38fefaf791f8935cdb00e215cabcde0f
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No

Security for ticdat 0.2.0

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