No project description provided
Go here for project status and installation instructions.
ticdat is a Python package that provides lightweight, ORM style functionality around either a dict-of-dicts or
pandas.DataFrame representation of tables. It is well suited for defining and validating the input data for complex
solve engines (i.e. optimization and scheduling-type problems).
ticdat functionality is organized around two classes -
PanDatFactory. Both classes define a
simple database style schema on construction. Data integrity rules can then be added in the form of foreign key
relationships, data field types (to include numerical ranges and allowed strings) and row predicates
(functions that check if a given row violates a particular data condition). The factory classes can then be used to
PanDat objects that contain tables consistent with the defined schema. By design,
ticdat, allows these data objects to violate the data integrity rules while providing convenient bulk query functions
to determine where those violations occur.
TicDat objects (created by a
TicDatFactory) contain tables in a dict-of-dict format. The outer dictionary maps
primary key values to data rows. The inner dictionaries are data rows indexed by field names (similar to
csv.DictReader/csv.DictWriter). Tables that do not have primary keys are rendered as a list of data row dictionaries.
PanDat objects (created by
PanDatFactory) render tables as
pandas.DataFrame objects. The columns in each
DataFrame will contain all of the primary key and data fields that were defined in the
PanDatFactory schema. The
PanDatFactory code can be thought of as implementing a shim library that organizes
DataFrame objects into a
predefined schema, and facilitates rich integrity checks based on schema defined rules.
ticdat example library is focused on two patterns for building optimization engines - using
gurobipy and using
PanDatFactory in conjunction with
amplpy. That said,
ticdat can also be
used with libraries like
xpress. It also has functionality to support the OPL and
LINGO modeling languages, although the AMPL support is far more mature.
ticdat's association with AMPL is particularly strong. The design goals of
ticdat were inspired by AMPL’s pattern
of cleanly separating model from data, as well as its ability to thoroughly validate input data prior to solving.
AMPL Optimization has endorsed
ticdat as their preferred library for bridging the world’s leading modeling language
(AMPL) with Python’s most powerful data analysis package (
ticdat library is distributed under the BSD2 open source license.
Release history Release notifications
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
|Filename, size & hash SHA256 hash help||File type||Python version||Upload date|
|ticdat-0.2.16-py2.py3-none-any.whl (155.7 kB) Copy SHA256 hash SHA256||Wheel||py2.py3|
|ticdat-0.2.16.tar.gz (129.2 kB) Copy SHA256 hash SHA256||Source||None|