Examples ========== Load a CSV table

import pytablereader as ptr import pytablewriter as ptw

# prepare data --- filepath = "sampledata.csv" csv_text = "\n".join([ '"attra","attrb","attr_c"', '1,4,"a"', '2,2.1,"bb"', '3,120.9,"ccc"', ])

with open(file_path, "w") as f: f.write(csv_text)

# load from a csv file --- loader = ptr.CsvTableFileLoader(file_path) for table_data in loader.load(): print("\n".join([ "load from file", "==============", "{:s}".format(ptw.dumpstabledata(tabledata)), ]))

# load from a csv text --- loader = ptr.CsvTableTextLoader(csv_text) for table_data in loader.load(): print("\n".join([ "load from text", "==============", "{:s}".format(ptw.dumpstabledata(tabledata)), ]))

:Output: .. code-block::

load from file ============== .. table:: sample_data

====== ====== ====== attra attrb attr_c ====== ====== ====== 1 4.0 a 2 2.1 bb 3 120.9 ccc ====== ====== ======

load from text ============== .. table:: csv2

====== ====== ====== attra attrb attr_c ====== ====== ====== 1 4.0 a 2 2.1 bb 3 120.9 ccc ====== ====== ======

Get loaded table data as pandas.DataFrame instance

:Sample Code: .. code-block:: python

import pytablereader as ptr

loader = ptr.CsvTableTextLoader( "\n".join([ "a,b", "1,2", "3.3,4.4", ])) for table_data in loader.load(): print(tabledata.asdataframe())

:Output: .. code-block::

a b 0 1 2 1 3.3 4.4

For more information

Installation ============

Install from PyPI

pip install pytablereader

Some of the formats require additional dependency packages, you can install the dependency packages as follows:

• Excel

• Google Sheets

• Markdown

• Mediawiki

• SQLite

• Load from URLs

• All of the extra dependencies

Install from PPA (for Ubuntu)

sudo add-apt-repository ppa:thombashi/ppa sudo apt update sudo apt install python3-pytablereader

Dependencies ============

Optional Python packages