TaCLe is a tool for learning constraints and formulas in spreadsheets.
Project description
TaCle: Tabular Constraint Learner
TaCLe is a constraint learner designed for usage in spreadsheets and tabular data.
Installation
pip install tacle
Using TaCLe
Running TaCLe from command line
TaCLe can be used from command line to analyze a CSV file:
python -m tacle data/magic_ice_cream.csv
This returns a list of constraints in the file:
ALLDIFFERENT(T2[:, 1])
ALLDIFFERENT(T1[:, 4])
ALLDIFFERENT(T1[:, 5])
ALLDIFFERENT(T1[:, 6])
T1[:, 1] -> T2[:, 1]
T1[:, 6] = SUM(T1[:, 3:5], row)
Filter output
If you are interested in specific types of constraints, you can filter the output:
python -m tacle data/magic_ice_cream.csv -f "foreign-key" # Report only foreign keys
python -m tacle data/magic_ice_cream.csv -f "<f>" # Report only formulas -- use <c> for only constraints
Tables
To view the tables that TaCLe finds in a file you can run:
python -m tacle data/magic_ice_cream.csv -t
This returns the tables and blocks found by TaCLe:
Table T1, (1:9, 0:7)
Columns 0-2 (string), Columns 2-6 (int), Columns 6-7 (string)
Table T2, (11:15, 0:2)
Columns 0-1 (string), Columns 1-2 (int)
Papers
Read more about how TaCLe works in one of our two papers journal version, demo paper.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
tacle-1.1.3.tar.gz
(53.8 kB
view hashes)
Built Distribution
tacle-1.1.3-py2.py3-none-any.whl
(63.5 kB
view hashes)
Close
Hashes for tacle-1.1.3-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0f3e71d42922ead8242c657f24f4df0a9a4889c8c59a77c917b7f4aaf4c9e6f2 |
|
MD5 | 09027eabc1f58be6508ca55ecd7663ce |
|
BLAKE2b-256 | 70933c2cd9acd8a0d7c561c55f2c9fbe0b7d1581bcd3fa8eefe22c26d2a67a76 |