pytablereader 0.1.0

pytablereader is a python library to load structured table data from various data format: CSV/HTML/JSON/MediaWiki/Excel.

pytablereader

Summary

pytablereader is a python library to load structured table data from various data format: CSV/HTML/JSON/MediaWiki/Excel.

Feature

• Extract structured table data from various data format:

  • CSV file/text

  • HTML file/text

  • JSON file/text

  • MediaWiki file/text

  • Microsoft Excel ^TM file

Examples

Load a CSV table

from __future__ import print_function
import pytablereader

file_path = "sample_data.csv"
data = "\n".join([
    '"attr_a","attr_b","attr_c"',
    '1,4,"a"',
    '2,2.1,"bb"',
    '3,120.9,"ccc"',
])

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

# load from a csv file ---
loader = pytablereader.CsvTableFileLoader(file_path)
for table_data in loader.load():
    print("load from file: {:s}".format(table_data))

# load from a csv text ---
loader = pytablereader.CsvTableTextLoader(csv_text)
for table_data in loader.load():
    print("load from text: {:s}".format(table_data))

load from file: table_name=sample_data, header_list=[u'attr_a', u'attr_b', u'attr_c'] record_list=[['1', '4', u'a'], ['2', '2.1', u'bb'], ['3', '120.9', u'ccc']]
load from text: table_name=csv2, header_list=[u'attr_a', u'attr_b', u'attr_c'] record_list=[['1', '4', u'a'], ['2', '2.1', u'bb'], ['3', '120.9', u'ccc']]

For more information

More examples are available at http://pytablereader.readthedocs.org/en/latest/pages/examples/index.html

Installation

pip install pytablereader

Dependencies

Python 2.7+ or 3.3+

Mandatory Python packages

• beautifulsoup4

• DataPropery (Used to extract data types)

• jsonschema

• pathvalidate

• path.py

• pypandoc

• six

• xlrd

Optional (not Python packages)

• lxml (faster HTML convert if installed)

• pandoc (require when loading MediaWiki)

Test dependencies

• pytest

• pytest-runner

• tox

• XlsxWriter

Documentation

http://pytablereader.readthedocs.org/en/latest/

Related Project

• pytablewriter

  • Loaded data by pytablereader can be write another table format with pytablewriter