obj-tables 1.0.14
Tools for creating and reusing high-quality spreadsheets
License: MIT
Keywords: object model,schema,workbook,XLSX,Excel,validation

|PyPI package| |Documentation| |Test results| |Test coverage| |Code
analysis| |License| |Analytics|

*ObjTables*: Tools for creating and reusing high-quality spreadsheets
=====================================================================

*ObjTables* is a toolkit which makes it easy to use spreadsheets (e.g.,
XLSX workbooks) to work with complex datasets by combining spreadsheets
with rigorous schemas and an object-relational mapping system (ORM;
similar to Active Record (Ruby), Django (Python), Doctrine (PHP),
Hibernate (Java), Propel (PHP), SQLAlchemy (Python), etc.). This
combination enables users to use programs such as Microsoft Excel,
LibreOffice Calc, and OpenOffice Calc to view and edit spreadsheets and
use schemas and the *ObjTables* software to validate the syntax and
semantics of datasets, compare and merge datasets, and parse datasets
into object-oriented data structures for further querying and analysis
with languages such as Python.

*ObjTables* makes it easy to:

-  Use collections of tables (e.g., an XLSX workbook) to represent
   complex data consisting of multiple related objects of multiple types
   (e.g., rows of worksheets), each with multiple attributes (e.g.,
   columns).
-  Use complex data types (e.g., numbers, strings, numerical arrays,
   symbolic mathematical expressions, chemical structures, biological
   sequences, etc.) within tables.
-  Use progams such as Excel and LibreOffice as a graphical interface
   for viewing and editing complex datasets.
-  Use embedded tables and grammars to encode relational information
   into columns and groups of columns of tables.
-  Define clear schemas for tabular datasets.
-  Use schemas to rigorously validate tabular datasets.
-  Use schemas to parse tabular datasets into data structures for
   further analysis in languages such as Python.
-  Compare, merge, split, revision, and migrate tabular datasets.

The *ObjTables* toolkit includes five components:

-  Format for schemas for tabular datasets
-  Numerous data types
-  Format for tabular datasets
-  Software tools for parsing, validating, and manipulating tabular
   datasets
-  Python package for more flexibility and analysis

Please see https://objtables.org for more information.

Installing the command-line program and Python API
--------------------------------------------------

Please see the
`documentation <https://docs.karrlab.org/obj_tables/installation.html>`__.

Examples, tutorials, and documentation
--------------------------------------

Please see the `user documentation <https://www.objtables.org>`__,
`developer documentation <https://docs.karrlab.org/obj_tables>`__, and
`tutorials <https://sandbox.karrlab.org>`__.

License
-------

*ObjTables* is released under the `MIT license <LICENSE>`__.

Development team
----------------

*ObjTables* was developed by the `Karr Lab <https://www.karrlab.org>`__
at the Icahn School of Medicine at Mount Sinai in New York, USA and the
`Applied Mathematics and Computer Science, from Genomes to the
Environment research unit <https://maiage.inra.fr/>`__ at the `National
Research Institute for Agriculture, Food and
Environment <https://www.inrae.fr/en/centres/ile-france-jouy-josas-antony/>`__
in Jouy en Josas, FR.

-  `Jonathan Karr <https://www.karrlab.org>`__
-  `Arthur
   Goldberg <https://www.mountsinai.org/profiles/arthur-p-goldberg>`__
-  `Wolfram
   Liebermeister <http://genome.jouy.inra.fr/~wliebermeis/index_en.html>`__
-  `John Sekar <https://www.linkedin.com/in/john-sekar/>`__
-  `Bilal Shaikh <https://www.bshaikh.com>`__

Questions and comments
----------------------

Please contact the `developers <mailto:info@objtables.org>`__ with any
questions or comments.

.. |PyPI package| image:: https://img.shields.io/pypi/v/obj_tables.svg
   :target: https://pypi.python.org/pypi/obj_tables
.. |Documentation| image:: https://readthedocs.org/projects/obj-tables/badge/?version=latest
   :target: https://docs.karrlab.org/obj_tables
.. |Test results| image:: https://circleci.com/gh/KarrLab/obj_tables.svg?style=shield
   :target: https://circleci.com/gh/KarrLab/obj_tables
.. |Test coverage| image:: https://coveralls.io/repos/github/KarrLab/obj_tables/badge.svg
   :target: https://coveralls.io/github/KarrLab/obj_tables
.. |Code analysis| image:: https://api.codeclimate.com/v1/badges/164d7483a2d3bb68b3ca/maintainability
   :target: https://codeclimate.com/github/KarrLab/obj_tables
.. |License| image:: https://img.shields.io/github/license/KarrLab/obj_tables.svg
   :target: LICENSE
.. |Analytics| image:: https://ga-beacon.appspot.com/UA-86759801-1/obj_tables/README.md?pixel