STScI Logo

ttranspose tables



ttranspose -- Transpose or flip a table.


ttranspose intable outtable action


This task can be used to transpose a table so that input rows become output columns and input columns become output rows. Another option is to flip the table horizontally, that is, the first input column is the last output column. Finally, the table can be flipped vertically, i.e., the first input row is the last output row. Any combination of these operations may be performed.

If the table is actually transposed (rather than just flipped horizontally and/or vertically), the data types of all input columns must be the same. In addition, if the columns contain arrays rather than scalars, all the array lengths must be the same. The data type and array size will be preserved in the output table, but the column names of the output table will be "c1", "c2", "c3", etc, with default print format and null units. Actually, some mixing of data types is permitted. If some columns are type real and others are double precision, the output data type will be double precision. Similarly, short integers will be promoted to integers. Boolean columns can be mixed with any other data type; for numeric columns, yes becomes 1 and no becomes 0. When the columns in the input table are character strings, different maximum string lengths are permitted, and the output length will be the maximum of the input lengths. The restrictions on data type are not imposed on text tables, which can contain mixed integer, double precision and text columns.

If the table is only flipped but not transposed, the above restrictions on data type do not apply, and the column names, units and print formats will be preserved. Note that an operation such as "tht" (which happens to be equivalent to "v") does not actually transpose the table, so the data types of the columns need not all be the same.

The tstat task gives statistics for the values in a column, so one application of ttranspose is to get statistics on the values in a row by first transposing the table and then running tstat.

Text tables with too many rows cannot be transposed due to the limit of 1024 on the length of each row of a text table.


intable [file name template]
The list of input table names.
outtable [file name template]
The list of output table names. There must be the same number of input and output names. If the output is to be written to the standard output, however, you can use outtable = "STDOUT" even if there several input tables.
action = "t" [string]
This is a string made up of the letters "t", "h", and "v" which specify the operations to perform on the tables. "t" means transpose (input rows become output columns), "h" means flip horizontally (reverse the order of the columns), and "v" means flip vertically (reverse the order of the rows). The operations are performed in the order given from left to right. Any combination of "t", "h", and "v" may be used, in any order, and the letters may be repeated.

Operations such as "tt", "hh" or "vv" are valid, and they result in a simple copy of input to output.

The symbols "/", "-" and "|" are equivalent to the letters "t", "h" and "v" respectively.

verbose = yes [boolean]
Print the names of the tables as they are processed?


1. The input is the text file "in", and the output is to be displayed on the screen. Each of the three operations ("t", "h", "v") and some combinations are illustrated.

	tt> type in
	one     two     three
	four    five    six
	seven   eight   nine
	ten     eleven  twelve

	tt> ttranspose in STDOUT t
	in --> STDOUT
	one    four   seven  ten   
	two    five   eight  eleven
	three  six    nine   twelve

	tt> ttranspose in STDOUT h
	in --> STDOUT
	three  two    one  
	six    five   four 
	nine   eight  seven
	twelve eleven ten  

	tt> ttranspose in STDOUT v
	in --> STDOUT
	ten   eleven twelve
	seven eight  nine  
	four  five   six   
	one   two    three 

	tt> ttranspose in STDOUT hv
	in --> STDOUT
	twelve eleven ten  
	nine   eight  seven
	six    five   four 
	three  two    one  

	tt> ttranspose in STDOUT th
	in --> STDOUT
	ten    seven  four   one   
	eleven eight  five   two   
	twelve nine   six    three 



This task was written by Phil Hodge.


Type "help ttools opt=sys" for a description of the tables package.

Source Code · Search Form · STSDAS