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.
1 maintainer
Release files for tacle 1.2.2
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| tacle-1.2.2.tar.gz | 54.2 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| tacle-1.2.2-py2.py3-none-any.whl | Python 2, Python 3 | none | any | Details |
Total release size: 118.1 kB
Release files / tacle-1.2.2.tar.gz
| Download URL | tacle-1.2.2.tar.gz |
|---|---|
| Size | 54.2 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
488203d9327384245690d1f238ba95c5c873bfdef61d2914ff6dfa0a933e11bd
|
|
BLAKE2b-256 checksum How to use checksums |
ce0464f55648bc1e80e5ba0b0906a2c2ada5fe85040fe38d28cb4b058139079f
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/3.2.0 pkginfo/1.6.0 requests/2.24.0 setuptools/40.8.0 requests-toolbelt/0.9.1 tqdm/4.50.2 CPython/3.7.10
|
Release files / tacle-1.2.2-py2.py3-none-any.whl
| Download URL | tacle-1.2.2-py2.py3-none-any.whl |
|---|---|
| Size | 63.9 kB |
| Tags | Python 2 Python 3 |
|
SHA-256 checksum How to use checksums |
ab6201d5025c2113e0c8c8cab3940f9e9fdea2c48dba3465bc2431824592492d
|
|
BLAKE2b-256 checksum How to use checksums |
7c9eebeadea64133af1ba81b166f1aa5d1b02eb0c55fcd674be367655427cf40
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/3.2.0 pkginfo/1.6.0 requests/2.24.0 setuptools/40.8.0 requests-toolbelt/0.9.1 tqdm/4.50.2 CPython/3.7.10
|
