Tabular Data Manager
This is the user guide to Tabular Data Manager portlet.
Overview
Tabular data manager, is a working environment which ensures the management of tabular resources such as datasets, codelist and generic tables. Different types of data can be imported into the platform and a set of operations performed to create, explore and partially manipulate your file. Tabular Resources are used in different scientific fields ranging from statistics to signal processing and econometrics. Among the available facilities of Tabular Data Manager is the possibility to check for data correctness using codelist files, to perform aggregating and filtering operations. The main strength of the platform is the management of big dataset with more than million of data without having problems in exploring and further process your file.
Basic of Interface
Composition of interface :
- Ribbon menu
- The interface consists of a top ribbon menu of four tabs (i.e Home, Curation, Modify and Analyse) including the main functionalities of the portlet.
- Tools area
- The interface has a left side panel, which describes in the tab properties, the main characteristics of the activated table. In also, you can visualize the list of the performed operations (once you have already manipulated your file) and if those have been validated (i.e validation tab).
- Main area
- In the central panel, your active tabular resource is displayed. As you can see in the picture, the bottom panel shows on which table you are working on.
Basic Operations
This section includes primary operations to open, close, delete, investigating the properties and clone your table.
Open
To open your tabular resource you need to click on the Home tab and on the Open button of the File menu. A window will appear to show the list of tabular resources already uploaded in your workspace and thus available to be viasualized
Close
A singular tabular resources can be closed directly in the bottom menu of the central panel (See Figure in Section "Main area"). You can also use the close buttom on the top of the ribbon menu, Home-> File, which allows to close all the open tables in you working environment.
Delete
It is possible to delete your table resouces using the button Delete on the File menu of the Home tab. The resource will be not anymore available into your workspace. A ppo-up window will appear to confirm the operation.
Properties
The tab properties shows the main characteristics of the activated table, for example:description, type and owner. See image in section Tools Area.
Clone
You can create one or more copies of your table using the Clone button in the File menu.
Grid Menu
A column and a context menu, are available directly on your tabuler resource. By using the column menu, which appear in each column header, you can access to the main functionalities, present in the tabs of the ribbon bar (see image in the section Column Menu). On the other hand, the right click on the cell allows to execute basic operations (see image of the section Contex Menu)
Grid Header Column Menu
Grid Context Menu
Import
CSV
Users can import their file in .csv format, by clicking on the CSV button in the Home tab.
The user can specify using a pop-up window the file source. There are two possibilities: File source, if you want to retrieve your files from your local computer or Workspace, if you want to retrieve them from your workspace.
After, several pop-up windows will appear for both file configuration and detail.
A final pop-up window will inform you when the file is successfully imported
SDMX
Export
CSV
JSON
SDMX
Curation
Split Column
- CHAR_SEQUENCE
- Here below, an example of the application of the CHAR SEQUENCE method in the Column Split function:
Tabular Data Manager, split column and char sequence method
- The original table is transformed into:
Tabular Data Manager, split column by char sequence
- INDEX
- Here below an example of the application of the INDEX method in the Column Split function:
Tabular Data Manager, split column and index method
- The original table is transformed into:
Tabular Data Manager, split column by index
- REGEX
- Here below an example of the application of the REGEX method in the Column Split function:
Tabular Data Manager, split column and regex method
- The original table is transformed into:
Tabular Data Manager, split column by regex
- N.B. Value is a POSIX Regular Expression
Normalize
For example, the following Tabular Resource:
when normalized setting as normalized column name 'Year', as value column name 'Quantity' and with columns to normalize '1998', '1999' and '2000' is transformed in:
Denormalize
For example, the following Tabular Resource with 'Quantity' column of type integer or numeric:
when denormalized setting as value column name 'Quantity' and as attribute column name 'Year' is transformed in:
Extract Codelist
For example, if we want to extract a codelist from the following Tabular Resource:
on the ribbon in curation tab, click on extract codelist button:
select the columns choices, 'code' and 'name' for example:
select the target column, for example new column:
fill new column:
result of fill:
set a name for new codelist:
result of extract codelist, new codelist:
