The Stingray Schema-Based File Reader
Spreadsheet format files are the lingua franca of data processing. CSV, Tab, XLS, XSLX and ODS files are used widely. Python’s csv module handles two common formats. Add-on packages are required for the variety of other physical file formats.
The problem is that each add-on package has a unique view of the underlying data.
The Stingray Schema-Based File Reader offers several features to help process files in spreadsheet formats.
It wraps format-specific modules with a unified “workbook” Facade to make applications able to work with any of the physical formats.
It extends the workbook concept to include non-delimited files, including COBOL files encoded in any of the Unicode encodings, as well as ASCII and EBCDIC.
It provides a uniform way to load and use schema information based on JSONSchema. A schema can be as small as header rows in the individual sheets of a workbook, or it can be separate schema information in another spreadsheet, a JSONSchema document, or COBOL “copybook” data definitions.
It provides a suite of data conversions that cover the most common cases.
Additionally, the Stingray Reader provides some guidance on how to structure file-processing applications so that they are testable and composable.
Stingray 5.1 requires Python >= 3.12. The code is fully annotated with type hints.
This depends on additional projects to read .XLS, .XLSX, .ODS, and .NUMBERS files.
CSV files are built-in using the csv module.
COBOL files are built-in using the estruct and cobol_parser modules.
NDJSON or JSON Newline files are JSON with an extra provision that each document must be complete on one physical line. These use the built-in json module.
XLS files are read via the xlrd project: http://www.lexicon.net/sjmachin/xlrd.htm
XLSX files are read via two projects: https://openpyxl.readthedocs.io/en/stable/
Numbers (v13 and higher) usees protobuf and and snappy compression. See https://pypi.org/project/numbers-parser/.
YAML files can be a sequence of documents, permitting a direct mapping to a Workbook with a single Sheet.
TOML files are – in effect – giant dictionaries with flexible syntax and can be described by a JSONSchema.
XML files can be wrapped in a Workbook. There’s no automated translation from XSD to JSONSchema here. A sample is provided, but this may not solve very many problems in general.
ODS files are read via http://docs.pyexcel.org/. NOTE. Currently, ODS file processing has problems with the 0.7.0 release.
A file-suffix registry is used to map a suffix to a Workbook subclass that handles the physical format. A decorator is used to add or replace file suffix mappings, permitting an application to fold in extensions.
Installation
python -m pip install stingray-reader
Or. Using uv.
uv add stingray-reader
Note that there’s a tall stack of dependencies.
Metadata
Release files for stingray-reader 5.1.1
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | Actions |
|---|---|---|---|---|
| stingray_reader-5.1.1.tar.gz | 1.4 MB | Without provenance | Details for stingray_reader-5.1.1.tar.gz |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Actions Reset |
|---|---|---|---|---|
| stingray_reader-5.1.1-py3-none-any.whl | Python 3 | none | any | Details for stingray_reader-5.1.1-py3-none-any.whl |
Total release size: 1.4 MB
Release files / stingray_reader-5.1.1.tar.gz
| Download URL | stingray_reader-5.1.1.tar.gz |
|---|---|
| Size | 1.4 MB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
bb9fc24171b21583ab0975227c8a632d9a27e395b883b552e13392b83a0b59e4
|
|
BLAKE2b-256 checksum How to use checksums |
0f145b9adaca1f42aa08c7321c16ffedca1b725751406949a33c26a6f64aafac
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
uv/0.4.20
|
Release files / stingray_reader-5.1.1-py3-none-any.whl
| Download URL | stingray_reader-5.1.1-py3-none-any.whl |
|---|---|
| Size | 48.2 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
4d07f9909fcf07f83b50b1892c7dc07af1cae200542fdd55a98ccec47d82b56e
|
|
BLAKE2b-256 checksum How to use checksums |
304f484b27d8523692bd4e317ef146d2660701581882ef3a22854002f4dcd637
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
uv/0.4.20
|
Security for stingray-reader 5.1.1
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.