Difference between revisions of "Tabular Data Manager"

From Gcube Wiki
Jump to: navigation, search
(CSV)
(Extract Codelist)
Line 171: Line 171:
 
select the target column, for example new column:
 
select the target column, for example new column:
 
[[Image:tabular_data_manager_extractcodelisttarget1.png|frame|center|Tabular Data Manager, extract codelist target column]]
 
[[Image:tabular_data_manager_extractcodelisttarget1.png|frame|center|Tabular Data Manager, extract codelist target column]]
 +
 +
fill new column:
 +
[[Image:tabular_data_manager_extractcodelisttargetnew1.png|frame|center|Tabular Data Manager, extract codelist target new  column]]
 +
 +
result of fill:
 +
[[Image:tabular_data_manager_extractcodelisttargetfill1.png|frame|center|Tabular Data Manager, extract codelist target fill  column]]
 +
 +
set a name for new codelist:
 +
[[Image:tabular_data_manager_extractcodelistdetail1.png|frame|center|Tabular Data Manager, extract codelist detail]]
 +
 +
result of extract codelist, new codelist:
 +
[[Image:tabular_data_manager_extractcodelisresult1.png|frame|center|Tabular Data Manager, extract codelist result]]
  
 
== Modify ==
 
== Modify ==

Revision as of 11:18, 2 February 2015

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.

Tabular Data Manager, portlet


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.
Tabular Data Manager, ribbon
Tabular Data Manager, curation
Tabular Data Manager, modify
Tabular Data Manager, analyse


Tools area
The interface has a left side tab panel, which describes the main characteristics of the activated table (i.e table type). 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).
Tabular Data Manager, tools area


Main area


In the center panel, your activated tabular data is displayed. As you can see in the picture, the bottom panel shows the table you are working on.
Tabular Data Manager, main area

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 in the File menu you can find the Open button. A window will appear to show the list of tabular resources already uploaded in your workspace and thus available to be viasualized

Tabular Data Manager, openbutton

Close

A singolar 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.

Tabular Data Manager, closeallbutton

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.

Tabular Data Manager, deletebutton

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

Tabular Data Manager, grid header column menu

Grid Context Menu

Tabular Data Manager, grid context menu

Import

CSV

Users can import their file in .csv format, by clicking on the CSV button in the Import menu of the Home tab.

Tabular Data Manager, Import button in the Home tab

The user can specify using a pop-up window the file source. Two possibility are available: File source, if you want to retrieve your files from your local computer or Workspace, if you want to retrieve them from your workspace.

Tabular Data Manager, CSV source selection

Several pop-up windows will appear for both file configuration and details.

Tabular Data Manager, CSV configuration
Tabular Data Manager, Details on the imported table

A final pop-up window will inform you when the file is successfully imported

Tabular Data Manager, file successfully uploded

SDMX

Export

CSV

JSON

SDMX

Curation

Split Column

CHAR_SEQUENCE
For example, the Tabular Resource when splitted setting char sequence:
Tabular Data Manager, split column by char sequence
is transformed in:
Tabular Data Manager, split column by char sequence result


INDEX
For example, the following Tabular Resource when splitted setting INDEX:
Tabular Data Manager, split column by index
is transformed in:
Tabular Data Manager, split column by index result


REGEX
For example, the following Tabular Resource when splitted setting REGEX:
Tabular Data Manager, split column by regex
is transformed in:
Tabular Data Manager, split column by regex result
N.B. Value is a POSIX Regular Expression

Normalize

For example, the following Tabular Resource:

Tabular Data Manager, normalize

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:

Tabular Data Manager, normalize result

Denormalize

For example, the following Tabular Resource with 'Quantity' column of type integer or numeric:

Tabular Data Manager, denormalize

when denormalized setting as value column name 'Quantity' and as attribute column name 'Year' is transformed in:

Tabular Data Manager, denormalize result

Extract Codelist

For example, if we want to extract a codelist from the following Tabular Resource:

Tabular Data Manager, extract codelist

on the ribbon in curation tab, click on extract codelist button:

Tabular Data Manager, extract codelist button

select the columns choices, 'code' and 'name' for example:

Tabular Data Manager, extract codelist source column

select the target column, for example new column:

Tabular Data Manager, extract codelist target column

fill new column:

Tabular Data Manager, extract codelist target new column

result of fill:

Tabular Data Manager, extract codelist target fill column

set a name for new codelist:

Tabular Data Manager, extract codelist detail

result of extract codelist, new codelist:

Tabular Data Manager, extract codelist result

Modify

Analyse

External links

References

Template:Reflist