Skip to main content

Dataframe

A table (also known as a dataframe) is a two-dimensional structure with named columns of different types. Supported types are: string, bool, int, bigint, double, qnum, datetime.

Dataframes are visualized using the grid viewer.

Column​

Dataframes consist of columns. In addition to the data type, a column can be associated with tags that specify units, data format, semantic type, tooltip content and so forth.

To view column properties, right-click a column header and select Properties... The Context Panel updates to show the column's properties. To edit the column's name and tags, right-click the column header and select Column Properties..., or press F2.

Metadata​

Like columns, each table can be annotated with attributes in the form of key-value pairs. Datagrok automatically annotates certain tables with metadata (such as the source of the table, or time of import, etc). Table metadata is shown in the General pane of the Context Panel, and can be changed through the JS API (df.tags).

Filtering​

You can use these fields to filter tables with smart search:

FieldDescription
ID
name
rowCount
colCount
createdOn
updatedOn
authorUser object
starredByUser object
commentedByUser object

See also: