Tables

Tables are a useful means for storing and accessing structured data. A table is composed of columns or fields of a particular type like text, integers, or real numbers. Each row or record is an instance of data. Each record or row has a unique identifier (called a primary key) which is often chosen as an integer starting at one. In comparison, ID numbers issued to citizens are similarly unique for identification purposes.

Create TableCreate Table from DataView Data in Table

List Tables

One can view all the tables in a project by using the navigation bar and selecting the “Tables” section.

View Table

After selecting one of the listed tables inside a project one will be able to inspect the data contained within the table.

Create Table

One can create a new table from the page that lists the existing tables inside a project.

To create a table one must provide a unique name for the table.

An optional description can be added and is recommended to document useful information.

A primary key column must be created for a table to uniquely identify every data record, or row in the table. It is noteworthy that Excel and Google sheets do use a mechanism akin to primary keys in the form of row numbers.

One can add more columns by selecting the round plus button. When columns are added a unique name must be chosen. Each column must specify the data type (integers, real, text) of the values stored within.

Import Data

Instead of manually adding all the columns to create a table, one can import data (including columns and data) from csv or tsv files. Note that files have to be uploaded to storage (see section on storage) in order for it to be accessible.

After choosing to import data from storage, one may have to navigate through folders depending on how data has been organized in your project.

Press select to import an appropriate csv file.

The column and data from the csv file is pulled into the table outline. The platform automatically detects the data type and name for each column. It might be necessary to make manual adjustments.

Add Column

One can select any of the highlighted plus signs to add more columns.

A popup menu allows one to create a new column

Each column must have a name and a chosen data type.

Update Column

To update or alter a column select the edit button.

Column details can be altered and updated. Select the update button to apply changes. Keep in mind that if there is data in the table, changes may fail due to data type mismatch. In some cases it is better to create a new column, instead of altering an existing column data type.

Remove Column

Deleting or removing a column is a straightforward process. After selecting to edit a column one can select the delete button and confirm the choice. Note that all data in the column will be destroyed by the action.

Add Row

Adding a row is similar to adding a column by selecting one of the appropriate addition symbols to add a new row.

To add a row, one must provide data for the columns. Note that the row number or primary key is handled in the background.

Update Row

Select the edit row button

Make any necessary changes and update the row or data entries.

Remove Row

Select rows to be deleted with the checkbox. Select the delete rows button

Sorting

One can sort rows by tapping the ordering button in a column. Tapping it again swaps between ascending and descending order.

Exporting

Clicking the export button exports the table and its data to a tab separated value file in a downloads folder one can find under storage.

Searching

Analysing

Analysis works best on a desktop environment. One can generate a template Python or R script to pull data from the table stored on the information hub to your machine for analysis and processing.