Skip to main content

Un-crosstab data in a text file.

Project description

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/.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

un-xtab-1.2.0.tar.gz (12.6 kB view hashes)

Uploaded Source

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page