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/.
1 maintainer
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
File details
Details for the file un-xtab-1.2.2.tar.gz.
File metadata
- Download URL: un-xtab-1.2.2.tar.gz
- Upload date:
- Size: 14.1 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via:
twine/4.0.2 CPython/3.10.12
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
a0867ffad4cd26cf93efec91bffc6e1faf2d5dccf0ba329726dd2c313c100879
|
|
| MD5 |
ec7fc892d512c5299d483dfc36d9119e
|
|
| BLAKE2b-256 |
b2759f39ab116d4212b81862abba5afd80eb029602a672b5416ea1a737a902e8
|
