@misc{35224,
  author = {Milica Grahovac and Youness Bennani Smires and Thomas A Burke and Katie Coughlin and Mohan Ganeshalingam and Akhil Mathur and Evan Neil and Akshay Sharma},
  title = {Adapter Python IO (Adapter) v1.0. Computer Software},
  abstract = {<p dir="auto">The\&nbsp;<code>Adapter Python IO</code>\&nbsp;software provides a convenient data table loader from various formats such as\&nbsp;<code>xlsx</code>,\&nbsp;<code>csv</code>,\&nbsp;<code>db (sqlite database)</code>, and\&nbsp;<code>sqlalchemy</code>. Its main feature is the ability to convert data tables identified in one main and optionally one or more additional input files into\&nbsp;<code>database tables</code>\&nbsp;and\&nbsp;<code>Pandas DataFrames</code>\&nbsp;for downstream usage in any compatible software.</p><p dir="auto"><code>Adapter</code>\&nbsp;builds upon the existing Python packages that allow for the communication between\&nbsp;<code>Python</code>\&nbsp;and\&nbsp;<code>MS Excel</code>, as well as\&nbsp;<code>databases</code>\&nbsp;and\&nbsp;<code>csv</code>\&nbsp;files. It provides inbuilt capabilities to specify the output location path, as well as a version identifier for a research code run.</p><p dir="auto">In addition to the loading capability, an instance of the\&nbsp;<code>Adapter</code>\&nbsp;<code>IO</code>\&nbsp;object has the write capability. If invoked, all loaded tables are written as either a single\&nbsp;<code>database</code>\&nbsp;or a set of\&nbsp;<code>csv</code>\&nbsp;files, or both.</p><p dir="auto">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.</p><p dir="auto">The package is supported on\&nbsp;<code>Windows</code>\&nbsp;and\&nbsp;<code>macOS</code>, as well as for\&nbsp;<code>Linux</code>\&nbsp;for the utilization without any\&nbsp;<code>xlsx</code>\&nbsp;inputs.</p>},
  year = {2021},
  month = {04/2021},
  doi = {doi:10.11578/dc.20210514.3},
  language = {eng},
}