{ "info": { "author": "Teradata Corporation", "author_email": "", "bugtrack_url": null, "classifiers": [ "License :: Other/Proprietary License", "Operating System :: MacOS :: MacOS X", "Operating System :: Microsoft :: Windows", "Operating System :: POSIX :: Linux", "Programming Language :: Python :: 3.5", "Programming Language :: Python :: 3.6", "Programming Language :: Python :: 3.7", "Programming Language :: Python :: 3 :: Only", "Topic :: Database :: Front-Ends" ], "description": "## Teradata Python package for Advanced Analytics.\n\nteradataml makes available to Python users a collection of analytic functions that reside on Teradata Vantage. This allows users to perform analytics on Teradata Vantage with no SQL coding. In addition, the teradataml library provides functions for scaling data manipulation and transformation, data filtering and sub-setting, and can be used in conjunction with other open-source python libraries. \n\nFor community support, please visit the [Connectivity Forum](http://community.teradata.com/t5/Tools/bd-p/DevXToolsBoard).\n\nFor Teradata customer support, please visit [Teradata Access](https://access.teradata.com/).\n\nCopyright 2019, Teradata. All Rights Reserved.\n\n### Table of Contents\n* [Release Notes](#release-notes)\n* [Installation and Requirements](#installation-and-requirements)\n* [Using the Teradata Python Package](#using-the-teradata-python-package)\n* [Documentation](#documentation)\n* [License](#license)\n\n## Release Notes:\n#### teradataml 16.20.00.03\n* Fixed the garbage collection issue observed with `remove_context()` when context is created using a SQLAlchemy engine.\n* Added 4 new NewSQL Engine analytic functions supported only on Vantage 1.1:\n * `Antiselect`, `Pack`, `StringSimilarity`, and `Unpack`.\n* Updated the Machine Learning Engine `NGrams` function to work with Vantage 1.1.\n\n#### teradataml 16.20.00.02\n* Python version 3.4.x will no longer be supported. The Python versions supported are 3.5.x, 3.6.x, and 3.7.x.\n* Major issue with the usage of formula argument in analytic functions with Python3.7 has been fixed, allowing this package to be used with Python3.7 or later.\n* Configurable alias name support for analytic functions has been added.\n* Support added to create_context (connect to Teradata Vantage) with different logon mechanisms.\n Logon mechanisms supported are: 'TD2', 'TDNEGO', 'LDAP' & 'KRB5'.\n* copy_to_sql function and DataFrame 'to_sql' methods now provide following additional functionality:\n * Create Primary Time Index tables.\n * Create set/multiset tables.\n* New DataFrame methods are added: 'median', 'var', 'squeeze', 'sort_index', 'concat'.\n* DataFrame method 'join' is now updated to make use of ColumnExpressions (df.column_name) for the 'on' clause as opposed to strings.\n* Series is supported as a first class object by calling squeeze on DataFrame.\n * Methods supported by teradataml Series are: 'head', 'unique', 'name', '\\_\\_repr__'.\n * Binary operations with teradataml Series is not yet supported. Try using Columns from teradataml.DataFrames.\n* Sample datasets and commands to load the same have been provided in the function examples.\n* New configuration property has been added 'column_casesenitive_handler'. Useful when one needs to play with case sensitive columns.\n\n#### teradataml 16.20.00.01\n* New support has been added for Linux distributions: Red Hat 7+, Ubuntu 16.04+, CentOS 7+, SLES12+.\n* 16.20.00.01 now has over 100 analytic functions. These functions have been organized into their own packages for better control over which engine to execute the analytic function on. Due to these namespace changes, the old analytic functions have been deprecated and will be removed in a future release. See the Deprecations section in the Teradata Python Package User Guide for more information.\n* New DataFrame methods `shape`, `iloc`, `describe`, `get_values`, `merge`, and `tail`.\n* New Series methods for NA checking (`isnull`, `notnull`) and string processing (`lower`, `strip`, `contains`).\n\n#### teradataml 16.20.00.00\n* `teradataml 16.20.00.00` is the first release version. Please refer to the _Teradata Python Package User Guide_ for a list of Limitations and Usage Considerations.\n\n## Installation and Requirements\n\n### Package Requirements:\n* Python 3.5 or later\n\nNote: 32-bit Python is not supported.\n\n### Minimum System Requirements:\n* Windows 7 (64Bit) or later\n* macOS 10.9 (64Bit) or later\n* Red Hat 7 or later versions\n* Ubuntu 16.04 or later versions\n* CentOS 7 or later versions\n* SLES 12 or later versions\n* Teradata Vantage NewSQL Engine:\n * NewSQL Engine 16.20 Feature Update 1 or later\n\nFor a Teradata Vantage system with the ML Engine:\n * Teradata Machine Learning Engine 08.00.03.01 or later\n\n### Installation\n\nUse pip to install the Teradata Python Package for Advanced Analytics.\n\nPlatform | Command\n-------------- | ---\nmacOS/Linux | `pip install teradataml`\nWindows | `py -3 -m pip install teradataml`\n\nWhen upgrading to a new version of the Teradata Python Package, you may need to use pip install's `--no-cache-dir` option to force the download of the new version.\n\nPlatform | Command\n-------------- | ---\nmacOS/Linux | `pip install --no-cache-dir -U teradataml`\nWindows | `py -3 -m pip install --no-cache-dir -U teradataml`\n\n## Using the Teradata Python Package\n\nYour Python script must import the `teradataml` package in order to use the Teradata Python Package:\n\n```\n>>> import teradataml as tdml\n>>> from teradataml import create_context, remove_context\n>>> create_context(host = 'hostname', username = 'user', password = 'password')\n>>> df = tdml.DataFrame('iris')\n>>> df\n\n SepalLength SepalWidth PetalLength PetalWidth Name\n0 5.1 3.8 1.5 0.3 Iris-setosa\n1 6.9 3.1 5.1 2.3 Iris-virginica\n2 5.1 3.5 1.4 0.3 Iris-setosa\n3 5.9 3.0 4.2 1.5 Iris-versicolor\n4 6.0 2.9 4.5 1.5 Iris-versicolor\n5 5.0 3.5 1.3 0.3 Iris-setosa\n6 5.5 2.4 3.8 1.1 Iris-versicolor\n7 6.9 3.2 5.7 2.3 Iris-virginica\n8 4.4 3.0 1.3 0.2 Iris-setosa\n9 5.8 2.7 5.1 1.9 Iris-virginica\n\n>>> df = df.select(['Name', 'SepalLength', 'PetalLength'])\n>>> df\n\n Name SepalLength PetalLength\n0 Iris-versicolor 6.0 4.5\n1 Iris-versicolor 5.5 3.8\n2 Iris-virginica 6.9 5.7\n3 Iris-setosa 5.1 1.4\n4 Iris-setosa 5.1 1.5\n5 Iris-virginica 5.8 5.1\n6 Iris-virginica 6.9 5.1\n7 Iris-setosa 5.1 1.4\n8 Iris-virginica 7.7 6.7\n9 Iris-setosa 5.0 1.3\n\n>>> df = df[(df.Name == 'Iris-setosa') & (df.PetalLength > 1.5)]\n>>> df\n\n Name SepalLength PetalLength\n0 Iris-setosa 4.8 1.9\n1 Iris-setosa 5.4 1.7\n2 Iris-setosa 5.7 1.7\n3 Iris-setosa 5.0 1.6\n4 Iris-setosa 5.1 1.9\n5 Iris-setosa 4.8 1.6\n6 Iris-setosa 4.7 1.6\n7 Iris-setosa 5.1 1.6\n8 Iris-setosa 5.1 1.7\n9 Iris-setosa 4.8 1.6\n```\n\n## Documentation\n\nGeneral product information, including installation instructions, is available in the [Teradata Documentation website](https://docs.teradata.com/)\n\n## License\n\nUse of the Teradata Python Package is governed by the *License Agreement for the Teradata Python Package for Advanced Analytics*. \nAfter installation, the `LICENSE` and `LICENSE-3RD-PARTY` files are located in the `teradataml` directory of the Python installation directory.\n\n\n", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "http://www.teradata.com/", "keywords": "Teradata", "license": "Teradata License Agreement", "maintainer": "", "maintainer_email": "", "name": "teradataml", "package_url": "https://pypi.org/project/teradataml/", "platform": "MacOS X, Windows, Linux", "project_url": "https://pypi.org/project/teradataml/", "project_urls": { "Homepage": "http://www.teradata.com/" }, "release_url": "https://pypi.org/project/teradataml/16.20.0.3/", "requires_dist": [ "teradatasql", "teradatasqlalchemy (>=16.20.0.7)", "pandas (>=0.22)", "psutil" ], "requires_python": ">=3.5", "summary": "Teradata Vantage Python package for Advanced Analytics", "version": "16.20.0.3" }, "last_serial": 5671177, "releases": { "16.20.0.0": [ { "comment_text": "", "digests": { "md5": "9c2aab51883905e13873d7ef14d7de31", "sha256": "08154fae8aef02a0c76fe37591971a502c8a13e4c1b2bd8ac845295c21100bd5" }, "downloads": -1, "filename": "teradataml-16.20.0.0-py3-none-any.whl", "has_sig": false, "md5_digest": "9c2aab51883905e13873d7ef14d7de31", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.4.3", "size": 1053599, "upload_time": "2018-10-10T21:32:56", "url": "https://files.pythonhosted.org/packages/ce/a1/6051775e90814f9fe65fe58cc5ad6ff16d0bba5d9e5a8dfe4ab2c2585ecd/teradataml-16.20.0.0-py3-none-any.whl" } ], "16.20.0.1.post0": [ { "comment_text": "", "digests": { "md5": "a3aff6e07cd5d527ca135c2c8b2f0b58", "sha256": "c60601a71c2b3ca743d347be27091216653eff6b6c5f912da2cddde0615ea2da" }, "downloads": -1, "filename": "teradataml-16.20.0.1.post0-py3-none-any.whl", "has_sig": false, "md5_digest": "a3aff6e07cd5d527ca135c2c8b2f0b58", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.4.3", "size": 1984633, "upload_time": "2019-01-17T01:08:54", "url": "https://files.pythonhosted.org/packages/1e/bf/b471f978f115a8fe60077e96a389944f19e04a7aba8f43ae03d7858c1f11/teradataml-16.20.0.1.post0-py3-none-any.whl" } ], "16.20.0.2": [ { "comment_text": "", "digests": { "md5": "eec604bfc47e8608a675a5848dd970fe", "sha256": "a15f573807bd0b1ad8d15ccff0cec5a4a8518e4687771efb3aa1870d1372d730" }, "downloads": -1, "filename": "teradataml-16.20.0.2-py3-none-any.whl", "has_sig": false, "md5_digest": "eec604bfc47e8608a675a5848dd970fe", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.5", "size": 2452282, "upload_time": "2019-07-02T04:50:55", "url": "https://files.pythonhosted.org/packages/5d/5a/efc297a4c7223c6c6f2a253a9255ce407f11a92ee70829dbf5a8589fbbeb/teradataml-16.20.0.2-py3-none-any.whl" } ], "16.20.0.3": [ { "comment_text": "", "digests": { "md5": "912d00364fd7cd88be78aaea118cf683", "sha256": "7061e639d33f76153c656125fbe95bb5e7057d8e3f075bf097420e79e3f0643f" }, "downloads": -1, "filename": "teradataml-16.20.0.3-py3-none-any.whl", "has_sig": false, "md5_digest": "912d00364fd7cd88be78aaea118cf683", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.5", "size": 2455776, "upload_time": "2019-08-13T10:31:28", "url": "https://files.pythonhosted.org/packages/18/69/a1e6bfb9cc7d7545e405e8ea51304545026e4dce053315ec06e17b60f796/teradataml-16.20.0.3-py3-none-any.whl" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "912d00364fd7cd88be78aaea118cf683", "sha256": "7061e639d33f76153c656125fbe95bb5e7057d8e3f075bf097420e79e3f0643f" }, "downloads": -1, "filename": "teradataml-16.20.0.3-py3-none-any.whl", "has_sig": false, "md5_digest": "912d00364fd7cd88be78aaea118cf683", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.5", "size": 2455776, "upload_time": "2019-08-13T10:31:28", "url": "https://files.pythonhosted.org/packages/18/69/a1e6bfb9cc7d7545e405e8ea51304545026e4dce053315ec06e17b60f796/teradataml-16.20.0.3-py3-none-any.whl" } ] }