transpose

transpose(X)

alias: flip(X)

X is a tuple, matrix, table, or dictionary.

If X is a tuple: all elements of the tuple must have the same length. Return a tuple of the same length as each element of X. The n-th element of the result is a vector composed of the n-th element of each element of X.

If X is a matrix: return the transpose of X.

If X is a table: convert X into an ordered dictionary. The dictionary keys are column names. Each dictionary value is a vector of the corresponding column.

If X is a dictionary: convert X into a table. The dictionary keys must be of STRING type, and dictionary values must be vectors of the same length. The columns names of the table are the dictionary keys, and each column is the corresponding dictionary value.

Example 1: transpose of a tuple:

x=(`A`B`C,1 2 3);
x.transpose();
// output
(("A",1),("B",2),("C",3))

Example 2: transpose of a matrix:

x=1..6 $ 3:2;
x;

transpose x;

Example 3: convert a table into a dictionary:

timestamp = [09:34:07,09:36:42,09:36:51,09:36:59,09:32:47,09:35:26,09:34:16,09:34:26,09:38:12]
sym = `C`MS`MS`MS`IBM`IBM`C`C`C
price= 49.6 29.46 29.52 30.02 174.97 175.23 50.76 50.32 51.29
qty = 2200 1900 2100 3200 6800 5400 1300 2500 8800
t = table(timestamp, sym, qty, price);
t;

transpose(t);
// output
timestamp->[09:34:07,09:36:42,09:36:51,09:36:59,09:32:47,09:35:26,09:34:16,09:34:26,09:38:12]
sym->[C,MS,MS,MS,IBM,IBM,C,C,C]
qty->[2200,1900,2100,3200,6800,5400,1300,2500,8800]
price->[49.6,29.46,29.52,30.02,174.97,175.23,50.76,50.32,51.29]

Example 4: convert a dictionary into a table:

z=dict(`id`val,[`a`b`c,1 2 3]);
z;
// output
val->[1,2,3]
id->[a,b,c]

transpose(z);