Skip to main content

un-xtab.py is a Python module and command-line program that rearranges data from a crosstabulated format to a normalized format. It takes data in this form:

Station

2006-05-23

2006-06-15

2006-07-19

WQ-01

4.5

3.7

6.8

WQ-02

9.7

5.1

7.2

WQ-03

10

6.1

8.8

and rearranges it into this form:

Station

Date

Value

WQ-01

2006-05-23

4.5

WQ-02

2006-05-23

3.7

WQ-03

2006-05-23

6.8

WQ-01

2006-06-15

9.7

WQ-02

2006-05-15

5.1

WQ-03

2006-06-15

7.2

WQ-01

2006-07-19

10

WQ-02

2006-07-19

6.1

WQ-03

2006-07-19

8.8

Input and output are both text (CSV) files.

You can use the un-xtab program to rearrange data that have been provided in a format designed for readability into a format that is more suitable for storage in a database, or for use with statistical, modeling, graphics, or other software.

The un-xtab program can deal with crosstabbed formats that include multiple rows of column headers and groups of data values that were crosstabbed together.

A row number can be added to assist with post-processing of the output file, if necessary.

Complete documentation is at ReadTheDocs: https://un-xtab.readthedocs.io/.

Metadata

Release files for un-xtab 1.2.2

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for un-xtab 1.2.2
File Size Uploaded Provenance Actions
un-xtab-1.2.2.tar.gz 14.1 kB Without provenance Details for un-xtab-1.2.2.tar.gz

Release files / un-xtab-1.2.2.tar.gz

Download URL un-xtab-1.2.2.tar.gz
Size 14.1 kB
Tags Source
SHA-256 checksum
How to use checksums
a0867ffad4cd26cf93efec91bffc6e1faf2d5dccf0ba329726dd2c313c100879
BLAKE2b-256 checksum
How to use checksums
b2759f39ab116d4212b81862abba5afd80eb029602a672b5416ea1a737a902e8
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/4.0.2 CPython/3.10.12

Security for un-xtab 1.2.2

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.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page