Metadata-Version: 2.1
Name: un-xtab
Version: 1.2.2
Summary: Un-crosstab data in a text file.
Home-page: https://osdn.net/projects/un-xtab/
Author: Dreas Nielsen
Author-email: cortice@tutanota.com
License: GPL
Keywords: CSV,crosstab
Classifier: Environment :: Console
Classifier: Intended Audience :: End Users/Desktop
Classifier: License :: OSI Approved :: GNU General Public License (GPL)
Classifier: Operating System :: OS Independent
Classifier: Topic :: Office/Business
License-File: LICENSE.txt

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