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": null,
"docs_url": null,
"requires_python": null,
"maintainer_email": null,
"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": null,
"download_url": "https://files.pythonhosted.org/packages/99/15/9edcd8725e835d654df1d44d72af964591e01d742afa16ecbae5eedff249/adapterio-1.8.0.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.8.0",
"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": "1bc091d2f72f06c72e76d0395ed9dfa81a60670e02740fd3b452a661b02d8599",
"md5": "1de20f04d39514409d4336935cd0da32",
"sha256": "8a39cb57943cc27fbf1ed14726a7b840ff05c314c4b076a4efdca9aa41778ab1"
},
"downloads": -1,
"filename": "adapterio-1.8.0-py3-none-any.whl",
"has_sig": false,
"md5_digest": "1de20f04d39514409d4336935cd0da32",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": null,
"size": 25160,
"upload_time": "2024-11-14T18:16:43",
"upload_time_iso_8601": "2024-11-14T18:16:43.991702Z",
"url": "https://files.pythonhosted.org/packages/1b/c0/91d2f72f06c72e76d0395ed9dfa81a60670e02740fd3b452a661b02d8599/adapterio-1.8.0-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "99159edcd8725e835d654df1d44d72af964591e01d742afa16ecbae5eedff249",
"md5": "e6c1522bbb540402bee6004edfd95ffd",
"sha256": "ea6bd277582d23581302c4b5051994b470f367a8e36e1cf5b05561c81c5de5d0"
},
"downloads": -1,
"filename": "adapterio-1.8.0.tar.gz",
"has_sig": false,
"md5_digest": "e6c1522bbb540402bee6004edfd95ffd",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 26040,
"upload_time": "2024-11-14T18:16:46",
"upload_time_iso_8601": "2024-11-14T18:16:46.183002Z",
"url": "https://files.pythonhosted.org/packages/99/15/9edcd8725e835d654df1d44d72af964591e01d742afa16ecbae5eedff249/adapterio-1.8.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-11-14 18:16:46",
"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"
}
JSON
