dropColumns!
Syntax
dropColumns!(table, colNames)
Alias: drop!
Arguments
table is a table object. It is an in-memory table or a DFS table (for OLAP engine only).
colNames is a STRING scalar/vector indicating a column name. If table is a DFS table, it must be a scalar.
Details
Delete one or multiple columns from a table.
Note that deleting a partitioning column from a DFS table, or deleting a column of SYMBOL type is not supported.
Examples
t=table(1 2 3 as x, 4 5 6 as y, 7..9 as z, 10..12 as a, 13..15 as b, 16..18 as c);
t;
x | y | z | a | b | c |
---|---|---|---|---|---|
1 | 4 | 7 | 10 | 13 | 16 |
2 | 5 | 8 | 11 | 14 | 17 |
3 | 6 | 9 | 12 | 15 | 18 |
t.dropColumns!(`x);
y | z | a | b | c |
---|---|---|---|---|
4 | 7 | 10 | 13 | 16 |
5 | 8 | 11 | 14 | 17 |
6 | 9 | 12 | 15 | 18 |
dropColumns!(t, `a`b);
y | z | c |
---|---|---|
4 | 7 | 16 |
5 | 8 | 17 |
6 | 9 | 18 |