Registry / data / pytablereader

pytablereader

library0.31.4pypypiunverified

pytablereader is a Python library to load structured table data from files, strings, or URLs supporting multiple formats: CSV, Excel, Google Sheets, HTML, JSON, LDJSON, LTSV, Markdown, SQLite, TSV. Currently at v0.31.4, with a monthly/bimonthly release cadence and active maintenance.

data serialization

pip install pytablereader

github ↗package ↗docs ↗

INSTALL

IMPORT

SIG · PYTABLEREADER

pytablereader

datapythonv0.31.4

Install

5.3s avg

Import

—

Disk

79MB

Pass rate

10/ 10

Env Coverage10 / 10

glibc

3.9–3.13

musl

3.9–3.13

Install & Compatibility

Where this runs

tested against v0.31.4 · pip install

no network on importno background threads

Install × environment matrix

Each cell = how many times install + import succeeded across repeated harness runs. Partial = flaky.
glibc = Debian/Ubuntu slim · musl = Alpine Linux

musl

py 3.10–3.920 runs

installs and imports cleanly · install 0.0s · import 0.000s · 75MB

glibc

py 3.10–3.920 runs

installs and imports cleanly · install 5.3s · import 0.000s · 75MB

79MB installed

● package 79MB

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

load_tables

✓ from pytablereader import load_tables

✗ from pytablereader import load_tables

Basic usage: load table data from a file path, URL, or file-like object. The function returns a generator of TableData objects.

from pytablereader import load_tables # Load CSV from URL tables = load_tables('https://raw.githubusercontent.com/thombashi/pytablereader/master/example.csv') for table in tables: print(table) # Load from file with open('data.csv') as f: tables = load_tables(f) for table in tables: print(table)

Debug

Known issues

breakingDropped Python 2 support in v0.28.0. Code using Python 2 idioms will break.

fix

Use Python 3.7+ and update any Python 2 specific code.

affects: >=0.28.0

deprecatedThe old type detection for CSV was disabled by default in v0.31.0. Use type_hints argument explicitly if you need automatic type detection.

fix

Pass type_hints=True to load_tables or loader classes to enable type detection.

affects: >=0.31.0

gotchaWhen using Google Sheets, the library requires authentication via gspread. If oauth2 credentials are not set, loading will fail with auth errors.

fix

Set up gspread authentication (service account or OAuth) before calling load_tables with a Google Sheets URL.

affects: all

gotchaFile paths with special characters may cause path validation errors on some platforms. The library uses pathvalidate for validation.

fix

Ensure file paths are valid for the platform; use raw strings or os.path functions.

affects: all

Upgrade

Version history

0.31.4latest on PyPI · released Jun 25, 2023

Audit

Dependencies

SimpleSQLiterequiredDatabase loading support

pathvalidaterequiredPath validation

openpyxloptionalExcel file reading

lxmloptionalHTML/XML parsing

gspreadoptionalGoogle Sheets access

Agent activity

12 hits · last 30 days

node

Resources

githubhttps://github.com/thombashi/pytablereader ↗

packagehttps://pypi.org/project/pytablereader/ ↗

docshttps://pytablereader.rtfd.io/ ↗