{ "info": { "author": "iuvbio", "author_email": "cryptodemigod@protonmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 3 - Alpha", "License :: OSI Approved :: MIT License", "Programming Language :: Python :: 3.7", "Topic :: Utilities" ], "description": "pandas_ods_reader\n===\n\nProvides a function to read in an ODS file and returns a pandas DataFrame.\n\nIt uses `ezodf` to read in the ods file. If a range is specified in the sheet\nto be imported, it seems that `ezodf` imports empty cells as well. Therefore,\ncompletely empty rows and columns are dropped from the DataFrame, before it is\nreturned. Only trailing empty rows and columns are dropped.\n\nIf the ODS file contains duplicated column names, they will be numbered and the\nnumber is appended to the column name in the resulting DataFrame.\n\nDependencies\n---\n\n- `ezodf`\n- `lxml`\n- `pandas`\n\nInstallation\n---\n\n`pip install pandas_ods_reader`\n\nUsage\n---\n\n```Python\nfrom pandas_ods_reader import read_ods\n\npath = \"path/to/file.ods\"\n\n# load a sheet based on its index (1 based)\nsheet_idx = 1\ndf = read_ods(path, sheet_idx)\n\n# load a sheet based on its name\nsheet_name = \"sheet1\"\ndf = read_ods(path, sheet_name)\n\n# load a file that does not contain a header row\n# if no columns are provided, they will be numbered\ndf = read_ods(path, 1, headers=False)\n\n# load a file and provide custom column names\n# if headers is True (the default), the header row will be overwritten\ndf = read_ods(path, 1, columns=[\"A\", \"B\", \"C\"])\n```\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://github.com/iuvbio/pandas_ods_reader", "keywords": "data io pandas ods", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "pandas-ods-reader", "package_url": "https://pypi.org/project/pandas-ods-reader/", "platform": "", "project_url": "https://pypi.org/project/pandas-ods-reader/", "project_urls": { "Homepage": "http://github.com/iuvbio/pandas_ods_reader" }, "release_url": "https://pypi.org/project/pandas-ods-reader/0.0.7/", "requires_dist": [ "ezodf", "pandas", "lxml" ], "requires_python": "", "summary": "Read in an ODS file and return it as a pandas.DataFrame", "version": "0.0.7" }, "last_serial": 5375505, "releases": { "0.0.1": [ { "comment_text": "", "digests": { "md5": "d759ca6cbd4834601fc4c4aa46617ba8", "sha256": "f0d0d0a9d381ea9bd581b61ab9b81ccde1ecb383518a5ed3262d9d89e30c95ca" }, "downloads": -1, "filename": "pandas_ods_reader-0.0.1-py3-none-any.whl", "has_sig": false, "md5_digest": "d759ca6cbd4834601fc4c4aa46617ba8", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 3365, "upload_time": "2019-01-28T20:25:14", "url": "https://files.pythonhosted.org/packages/5b/ed/950151e850f9b0b5bb1709529201abeff29539fbf4fd8e4d89ffae7f78ea/pandas_ods_reader-0.0.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "8fb389452c9aa927d378fed7df187dee", "sha256": "d236ad2a8736a3722563ff7b1f40f86027db5564f395ccfd3b83e03e920c0fca" }, "downloads": -1, "filename": "pandas_ods_reader-0.0.1.tar.gz", "has_sig": false, "md5_digest": "8fb389452c9aa927d378fed7df187dee", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2529, "upload_time": "2019-01-28T20:54:48", "url": "https://files.pythonhosted.org/packages/49/20/b2f1a68fdfe6459ef7531e255067fd2c90399416765d329012832ca9a248/pandas_ods_reader-0.0.1.tar.gz" } ], "0.0.2": [ { "comment_text": "", "digests": { "md5": "14c23dfc32a3dc0411ac17bede9f2199", "sha256": "45449bea52477eef07bd2abbe8b16755917efd00f2356f4683d83767acf88c00" }, "downloads": -1, "filename": "pandas_ods_reader-0.0.2-py3-none-any.whl", "has_sig": false, "md5_digest": "14c23dfc32a3dc0411ac17bede9f2199", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 4323, "upload_time": "2019-01-28T20:54:46", "url": "https://files.pythonhosted.org/packages/f3/29/e2c745732120e9555815315cedb41d4d82ba9d2319a0e6113661aadd3165/pandas_ods_reader-0.0.2-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "d17d5f067f2cd936cd48d16d7bd7a632", "sha256": "da90f403391df73f5c321fd48335410caebf04feddebe67f739d23c8d224684e" }, "downloads": -1, "filename": "pandas_ods_reader-0.0.2.tar.gz", "has_sig": false, "md5_digest": "d17d5f067f2cd936cd48d16d7bd7a632", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3458, "upload_time": "2019-01-28T20:54:50", "url": "https://files.pythonhosted.org/packages/53/59/b4f483c00291576d82985e74679268941024b47d1bc0d5fcf4b28132ff0d/pandas_ods_reader-0.0.2.tar.gz" } ], "0.0.3": [ { "comment_text": "", "digests": { "md5": "4ba303fc607a921bb4572c2162036438", "sha256": "c321d2935626216834be7e28bdd00b31d50313788ee49063d09b7938672d92fb" }, "downloads": -1, "filename": "pandas_ods_reader-0.0.3-py3-none-any.whl", "has_sig": false, "md5_digest": "4ba303fc607a921bb4572c2162036438", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 6048, "upload_time": "2019-01-28T22:36:28", "url": "https://files.pythonhosted.org/packages/81/d4/bd85bceec4434e10820f8c37759c897a877f3f1b2acdb8bd606240699d62/pandas_ods_reader-0.0.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "cb5252a6a45967f4f2a94c5539b02080", "sha256": "907364acdfd6a8ad3e1fd769d52bc95529976fd56d39c71fcec060a1f3ed3d3d" }, "downloads": -1, "filename": "pandas_ods_reader-0.0.3.tar.gz", "has_sig": false, "md5_digest": "cb5252a6a45967f4f2a94c5539b02080", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3620, "upload_time": "2019-01-28T22:36:29", "url": "https://files.pythonhosted.org/packages/36/a3/e30cfb0d2212e2bd755360cd578b455e3e798ba7abbb132d7a3474a14c65/pandas_ods_reader-0.0.3.tar.gz" } ], "0.0.6": [ { "comment_text": "", "digests": { "md5": "4f72e7ecaf738cde5903cb73cb10e787", "sha256": "0f7d510639c8957a06aa1227b9f84d1be47a437dfd306464ce803b91cf5eeec4" }, "downloads": -1, "filename": "pandas_ods_reader-0.0.6-py3-none-any.whl", "has_sig": false, "md5_digest": "4f72e7ecaf738cde5903cb73cb10e787", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 6616, "upload_time": "2019-01-31T22:47:29", "url": "https://files.pythonhosted.org/packages/7b/6a/2e3d7597c5e13791182dc8637e396d131df8214b4d641f50333515257a78/pandas_ods_reader-0.0.6-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "a314d2b06d378a174f4a11d0c6ffcea5", "sha256": "d85ef58fc3aeac1616028d22954b6ef2e8983ab9bae015e1e90ce3979d138553" }, "downloads": -1, "filename": "pandas_ods_reader-0.0.6.tar.gz", "has_sig": false, "md5_digest": "a314d2b06d378a174f4a11d0c6ffcea5", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4137, "upload_time": "2019-01-31T22:47:31", "url": "https://files.pythonhosted.org/packages/74/0b/e3e5eb8a794c5606102e6484f15654cc86898eafe5c4b9ce13e9a5aa56ad/pandas_ods_reader-0.0.6.tar.gz" } ], "0.0.7": [ { "comment_text": "", "digests": { "md5": "47bd9d42cdaed2927f67713aab0e7517", "sha256": "d2d6e4f9cd2850da32808bbc68d433a337911058387992026d3987ead1f4a7c8" }, "downloads": -1, "filename": "pandas_ods_reader-0.0.7-py3-none-any.whl", "has_sig": false, "md5_digest": "47bd9d42cdaed2927f67713aab0e7517", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7085, "upload_time": "2019-06-08T14:27:10", "url": "https://files.pythonhosted.org/packages/d9/f8/c1097f90411ec2cdfee9686c469a8acabff678185d761345975fc559c9fc/pandas_ods_reader-0.0.7-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "db3ab49910e3b188afa1cc94f8aa8866", "sha256": "d4d6781cc46e782e265b48681416f636e7659343dec948c6fccc4236af6fa1e6" }, "downloads": -1, "filename": "pandas_ods_reader-0.0.7.tar.gz", "has_sig": false, "md5_digest": "db3ab49910e3b188afa1cc94f8aa8866", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4617, "upload_time": "2019-06-08T14:27:14", "url": "https://files.pythonhosted.org/packages/e2/97/4bc2c64226920db8bea7834b1123053b7717e7a366753e71493f5d928239/pandas_ods_reader-0.0.7.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "47bd9d42cdaed2927f67713aab0e7517", "sha256": "d2d6e4f9cd2850da32808bbc68d433a337911058387992026d3987ead1f4a7c8" }, "downloads": -1, "filename": "pandas_ods_reader-0.0.7-py3-none-any.whl", "has_sig": false, "md5_digest": "47bd9d42cdaed2927f67713aab0e7517", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7085, "upload_time": "2019-06-08T14:27:10", "url": "https://files.pythonhosted.org/packages/d9/f8/c1097f90411ec2cdfee9686c469a8acabff678185d761345975fc559c9fc/pandas_ods_reader-0.0.7-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "db3ab49910e3b188afa1cc94f8aa8866", "sha256": "d4d6781cc46e782e265b48681416f636e7659343dec948c6fccc4236af6fa1e6" }, "downloads": -1, "filename": "pandas_ods_reader-0.0.7.tar.gz", "has_sig": false, "md5_digest": "db3ab49910e3b188afa1cc94f8aa8866", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4617, "upload_time": "2019-06-08T14:27:14", "url": "https://files.pythonhosted.org/packages/e2/97/4bc2c64226920db8bea7834b1123053b7717e7a366753e71493f5d928239/pandas_ods_reader-0.0.7.tar.gz" } ] }