The `Adapter Python IO` software provides a convenient data table loader from various formats such as `xlsx`, `csv`, `db (sqlite database)`, and `sqlalchemy`. Its main feature is the ability to convert data tables identified in one main and optionally one or more additional input files into `database tables` and `Pandas DataFrames` for downstream usage in any compatible software. `Adapter` builds upon the existing Python packages that allow for the communication between `Python` and `MS Excel`, as well as `databases` and `csv` files. It provides inbuilt capabilities to specify the output location path, as well as a version identifier for a research code run. In addition to the loading capability, an instance of the `Adapter` `IO` object has the write capability. If invoked, all loaded tables are written as either a single `database` or a set of `csv` files, or both. The purpose of this software is to support the development of research and analytical software through allowing for a simple multi-format IO with versioning and output path specification in the input data itself. The package is supported on `Windows` and `macOS`, as well as for `Linux` for the utilization without any `xlsx` inputs.
Raw data
{
"_id": null,
"home_page": "https://github.com/LBNL-ETA/Adapter",
"name": "adapterio",
"maintainer": "",
"docs_url": null,
"requires_python": "",
"maintainer_email": "",
"keywords": "data,tables,IO for research computation,sql,excel,csv,dataframe,connection",
"author": "Milica Grahovac, Youness Bennani, Thomas Burke, Katie Coughlin, Mohan Ganeshalingam, Akhil Mathur, Evan Neill, Akshay Sharma, Zheng He and Lyra Lan",
"author_email": "",
"download_url": "https://files.pythonhosted.org/packages/65/ed/bdc8af22fbf692c1d8715611ebc1f3aff4e208816024ba2b1d462f56adc7/adapterio-1.6.1.tar.gz",
"platform": null,
"description": "The `Adapter Python IO` software provides a convenient data table loader from various formats such as `xlsx`, `csv`, `db (sqlite database)`, and `sqlalchemy`. Its main feature is the ability to convert data tables identified in one main and optionally one or more additional input files into `database tables` and `Pandas DataFrames` for downstream usage in any compatible software. `Adapter` builds upon the existing Python packages that allow for the communication between `Python` and `MS Excel`, as well as `databases` and `csv` files. It provides inbuilt capabilities to specify the output location path, as well as a version identifier for a research code run. In addition to the loading capability, an instance of the `Adapter` `IO` object has the write capability. If invoked, all loaded tables are written as either a single `database` or a set of `csv` files, or both. The purpose of this software is to support the development of research and analytical software through allowing for a simple multi-format IO with versioning and output path specification in the input data itself. The package is supported on `Windows` and `macOS`, as well as for `Linux` for the utilization without any `xlsx` inputs.\n",
"bugtrack_url": null,
"license": "BSD-3-Clause-LBNL",
"summary": "I/O module",
"version": "1.6.1",
"project_urls": {
"Homepage": "https://github.com/LBNL-ETA/Adapter"
},
"split_keywords": [
"data",
"tables",
"io for research computation",
"sql",
"excel",
"csv",
"dataframe",
"connection"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "dff2819359f87b93069fbd4e73ad78af860ee359369dc27d5b7206bb8c146faa",
"md5": "a4e602a39ccc7b026b12dfd36d604040",
"sha256": "bd3f64256ec137a5b62861dd7fca1088b8b7ccd0b2d99ff511107a926aee75a4"
},
"downloads": -1,
"filename": "adapterio-1.6.1-py3-none-any.whl",
"has_sig": false,
"md5_digest": "a4e602a39ccc7b026b12dfd36d604040",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": null,
"size": 25299,
"upload_time": "2023-06-27T02:05:22",
"upload_time_iso_8601": "2023-06-27T02:05:22.100127Z",
"url": "https://files.pythonhosted.org/packages/df/f2/819359f87b93069fbd4e73ad78af860ee359369dc27d5b7206bb8c146faa/adapterio-1.6.1-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "65edbdc8af22fbf692c1d8715611ebc1f3aff4e208816024ba2b1d462f56adc7",
"md5": "892ce4feaedb245fdfe49a04c56d682a",
"sha256": "f1030ba0aa8d8327d7c7e3b368e3c04cc80abf4038ba7dd8325aebc82a991eda"
},
"downloads": -1,
"filename": "adapterio-1.6.1.tar.gz",
"has_sig": false,
"md5_digest": "892ce4feaedb245fdfe49a04c56d682a",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 25883,
"upload_time": "2023-06-27T02:05:24",
"upload_time_iso_8601": "2023-06-27T02:05:24.592029Z",
"url": "https://files.pythonhosted.org/packages/65/ed/bdc8af22fbf692c1d8715611ebc1f3aff4e208816024ba2b1d462f56adc7/adapterio-1.6.1.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-06-27 02:05:24",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "LBNL-ETA",
"github_project": "Adapter",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"lcname": "adapterio"
}