{ "info": { "author": "Xi Rossi LUO", "author_email": "xi.rossi.luo@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 4 - Beta", "Programming Language :: Python" ], "description": "=========\ntabletree\n=========\n\n\nPython package for exploring and linking multiple SQL-like tables\n\nDescription\n===========\n\nThis package will link multiple SQL-tables together to facilitate (potentially large-scale) analysis of data from various sources. All tables are implemented using Pandas Data.Frame objects.\n\n\nExamples\n========\n\nIn the following example, 3 tables are linked together via different columns and different data types. They form a tree: sex -> preference -> fruit. This package enables finding the favoriate fruits for 'M' ids by transversing this table tree automatically. \n\n.. code-block:: python\n\n\n from tabletree import TableNode, TableTree, TableLink\n import pandas as pd\n\n tab1_list = list( zip([1,2,3,4], ['M', 'F', 'M', 'F'] ) )\n tab2_list = list( zip( [1,2,3,4], ['red', 'green', 'yellow', 'blue'] ) )\n tab3_list = list( zip( ['red', 'green', 'yellow', 'blue'], ['apple', 'grape', 'banana', 'berry'] ) )\n tab1 = pd.DataFrame( tab1_list, columns = ['tab1_v1', 'tab1_v2'])\n tab2 = pd.DataFrame( tab2_list, columns = ['tab2_v1', 'tab2_v2'])\n tab3 = pd.DataFrame( tab3_list, columns = ['tab3_v1', 'tab3_v2'])\n tn1 = TableNode('sex', tab1)\n tn2 = TableNode('preference', tab2)\n tn3 = TableNode('fruit', tab3)\n ttree = TableTree(tn1)\n ttree.addChildren(tn2, TableLink('tab1_v1', 'tab2_v1'))\n ttree.addChildren(tn3, TableLink('tab2_v2', 'tab3_v1'))\n ttree.findMatched('fruit', 'sex', tn1.df.tab1_v2 == 'M')\n #tab3_v1 tab3_v2\n #0 red apple\n #2 yellow banana\n\n\n\nNote\n====\n\nGithub: https://github.com/rluo/tabletree", "description_content_type": "", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/rluo/tabletree", "keywords": "", "license": "GPL v3", "maintainer": "", "maintainer_email": "", "name": "tabletree", "package_url": "https://pypi.org/project/tabletree/", "platform": "any", "project_url": "https://pypi.org/project/tabletree/", "project_urls": { "Homepage": "https://github.com/rluo/tabletree" }, "release_url": "https://pypi.org/project/tabletree/0.3.0/", "requires_dist": null, "requires_python": ">= 3.4", "summary": "Python package for exploring and linking multiple SQL-like tables", "version": "0.3.0" }, "last_serial": 5463616, "releases": { "0.2.1": [ { "comment_text": "", "digests": { "md5": "845b24403e052e7354eda9ae67410ac5", "sha256": "0672c4150ad4dd42d4dbde3aa10c274606ebd5c39e92aa3da5b36cadf2d592c3" }, "downloads": -1, "filename": "tabletree-0.2.1.tar.gz", "has_sig": false, "md5_digest": "845b24403e052e7354eda9ae67410ac5", "packagetype": "sdist", "python_version": "source", "requires_python": ">= 3.4", "size": 19798, "upload_time": "2019-06-28T19:42:35", "url": "https://files.pythonhosted.org/packages/95/64/8dd015a99caf93811d77d8f8a62255b801212adf0c0e314b589483a8beca/tabletree-0.2.1.tar.gz" } ], "0.2.2": [ { "comment_text": "", "digests": { "md5": "e29a11569865c58efbe2970b697ff85e", "sha256": "9e93e0fdf8129649dbd5daa6d8d509b9b2a656c671357c20013daa3199dfbc1a" }, "downloads": -1, "filename": "tabletree-0.2.2.tar.gz", "has_sig": false, "md5_digest": "e29a11569865c58efbe2970b697ff85e", "packagetype": "sdist", "python_version": "source", "requires_python": ">= 3.4", "size": 19901, "upload_time": "2019-06-28T20:03:14", "url": "https://files.pythonhosted.org/packages/70/bb/2cc8f5c41f1279de8cebf7ace5d5f2223475b2750dce33cadfd51c8bc01f/tabletree-0.2.2.tar.gz" } ], "0.3.0": [ { "comment_text": "", "digests": { "md5": "6f2c9eb5862a86111f2ef161704a661d", "sha256": "27986b003c27eedea2d0724e11427640ea83903f639a6d31a9d8090ee01a2a39" }, "downloads": -1, "filename": "tabletree-0.3.0.tar.gz", "has_sig": false, "md5_digest": "6f2c9eb5862a86111f2ef161704a661d", "packagetype": "sdist", "python_version": "source", "requires_python": ">= 3.4", "size": 20169, "upload_time": "2019-06-28T21:40:45", "url": "https://files.pythonhosted.org/packages/10/17/813376ddf238892c3b4d1c5dc1eb64405d401395962af784a74c43ed7b40/tabletree-0.3.0.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "6f2c9eb5862a86111f2ef161704a661d", "sha256": "27986b003c27eedea2d0724e11427640ea83903f639a6d31a9d8090ee01a2a39" }, "downloads": -1, "filename": "tabletree-0.3.0.tar.gz", "has_sig": false, "md5_digest": "6f2c9eb5862a86111f2ef161704a661d", "packagetype": "sdist", "python_version": "source", "requires_python": ">= 3.4", "size": 20169, "upload_time": "2019-06-28T21:40:45", "url": "https://files.pythonhosted.org/packages/10/17/813376ddf238892c3b4d1c5dc1eb64405d401395962af784a74c43ed7b40/tabletree-0.3.0.tar.gz" } ] }