|
|
| (314 intermediate revisions by 4 users not shown) |
| Line 6: |
Line 6: |
| | | | |
| | == Overview == | | == Overview == |
| − | <!--Prima era scritto cosi:-->
| + | 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 be 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 offers facilities supporting the management of the entire life-cycle(creation, curation, manipulation and publication) of Tabular Resources such as datasets, codelist or generic table. i.e. tabular data representing observations of a given event or phenomenon at different time intervals. Tabular Resource are used in many domains ranging from statistics to signal processing and econometrics. Tabular Data Manager offers a rich set of facilities ranging from those supporting the assessment of data correctness to those supporting the verification of the compliance of data with given code lists, the aggregation and filtering of data.-->
| + | |
| | | | |
| − | <!--Chiara consiglia:-->
| + | [[Image:tabular_data_manager1.png|thumb|center|740px|Tabular Data Manager, portlet]] |
| − | 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.
| + | |
| | | | |
| − | [[Image:tabular_data_manager1.png|frame|center|Tabular Data Manager, portlet]] | + | == Main Topics== |
| | + | * [[Tabular Data Manager: Basic Operations|Basic Operations]] |
| | + | * [[Tabular Data Manager: Curation| Curation]] |
| | + | * [[Tabular Data Manager: Modify| Modify]] |
| | + | * [[Tabular Data Manager: Rule| Rule]] |
| | + | * [[Tabular Data Manager: Template Management| Template]] |
| | + | * [[Tabular Data Manager: Analyse| Analyse]] |
| | | | |
| | + | <!-- |
| | + | ==References== |
| | + | {{Reflist}} --> |
| | | | |
| − | === Basic of Interface ===
| |
| − | Composition of interface :
| |
| | | | |
| − | ;Ribbon menu
| + | <!-- |
| − | <!--Prima era scritto cosi:--> | + | [[Template:Tabular Data Manager]] |
| − | <!--:The interface offer on top a ribbon menu, it consists of tabs: Home, Curation, Modify and Analyse.-->
| + | --> |
| | | | |
| − | <!--Chiara consiglia:-->
| + | [[Category:Tabular Data Manager]] |
| − | :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.
| + | [[Category:User's Guide]] |
| − | [[Image:tabular_data_manager_ribbon1.png|frame|center|Tabular Data Manager, Ribbon menu]] | + | |
| − | [[Image:tabular_data_manager_curation.png|frame|center|Tabular Data Manager, Curation tab ]] | + | |
| − | [[Image:tabular_data_manager_modify.png|frame|center|Tabular Data Manager, Modify tab]]
| + | |
| − | [[Image:tabular_data_manager_analyse.png|frame|center|Tabular Data Manager, Analyse tab]]
| + | |
| − | | + | |
| − | | + | |
| − | ;Tools area
| + | |
| − | <!--Prima era scritto cosi:-->
| + | |
| − | <!--:The interface offer on left side a tab panel in which the manipolation tools will be activated.-->
| + | |
| − | | + | |
| − | <!--Chiara consiglia:-->
| + | |
| − | :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).
| + | |
| − | [[Image:tabular_data_manager_tools1.png|frame|center|Tabular Data Manager, tools area]]
| + | |
| − | | + | |
| − | | + | |
| − | ;Main area
| + | |
| − | <!--Prima era scritto cosi:-->
| + | |
| − | <!--:The interface offer on center side a panel in which the grids with data be activated.-->
| + | |
| − | | + | |
| − | | + | |
| − | <!--Chiara consiglia:-->
| + | |
| − | :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.
| + | |
| − | [[Image:tabular_data_manager_main1.png|frame|center|Tabular Data Manager, main area]]
| + | |
| − | | + | |
| − | == Basic Operations ==
| + | |
| − | <!--Prima era scritto cosi:-->
| + | |
| − | <!--The basic operations are those that enable interaction with a tabular resource and are: open, close, delete, properties and clone.-->
| + | |
| − | <!--Chiara suggerisce:-->
| + | |
| − | This section includes primary operations to open, close, delete, investigating the properties and clone your table.
| + | |
| − | | + | |
| − | === Open ===
| + | |
| − | <!--Prima era scritto cosi:-->
| + | |
| − | <!--For open a tabular resource yuo must click on ribbon Home and so in group File you select open button.
| + | |
| − | A window will show the list of tabular resource available to the user.
| + | |
| − | [[Image:tabular_data_manager_open1.png|frame|center|Tabular Data Manager, open]]-->
| + | |
| − | <!--Chiara consiglia:-->
| + | |
| − | 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
| + | |
| − | [[Image:tabular_data_manager_openbutton.png|frame|center|Tabular Data Manager, Open button in the Home tab]]
| + | |
| − | | + | |
| − | === Close ===
| + | |
| − | <!--Prima era scritto cosi:-->
| + | |
| − | <!--Tabular resource can be closed looking in the main area and clicking on the x next to its name. To close all open tabular resource go into the ribbon menu, home group, and click on close all button.-->
| + | |
| − | <!--Chiara suggerisce:-->
| + | |
| − | 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.
| + | |
| − | [[Image:tabular_data_manager_closeall.png|frame|center|Tabular Data Manager, close button in the Home tab]]
| + | |
| − | | + | |
| − | === 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.
| + | |
| − | [[Image:tabular_data_manager_delete.png|frame|center|Tabular Data Manager, deletebutton]]
| + | |
| − | | + | |
| − | === Properties ===
| + | |
| − | <!--Chiara suggests-->
| + | |
| − | 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 ==
| + | |
| − | <!--Prima era scritto:-->
| + | |
| − | <!--When a tabular resource is open, you can access the column header menu and the context menu.-->
| + | |
| − | <!--Chiara suggerisce:-->
| + | |
| − | 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 ===
| + | |
| − | [[Image:tabular_data_manager_grid_header_menu1.png|frame|center|Tabular Data Manager, grid header column menu]]
| + | |
| − | | + | |
| − | === Grid Context Menu ===
| + | |
| − | [[Image:tabular_data_manager_grid_context_menu1.png|frame|center|Tabular Data Manager, grid context menu]]
| + | |
| − | | + | |
| − | == Import ==
| + | |
| − | === CSV ===
| + | |
| − | <!---Chiara suggests-->
| + | |
| − | Users can import their file in .csv format, by clicking on the CSV button in the Home tab.
| + | |
| − | [[Image:import.png|frame|center|Tabular Data Manager, Import 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.
| + | |
| − | [[Image:source_csv.png|frame|center|Tabular Data Manager, CSV source selection]]
| + | |
| − | After, several pop-up windows will appear for both file configuration and detail.
| + | |
| − | [[Image:csv_configuration.png|frame|center|Tabular Data Manager, CSV configuration]]
| + | |
| − | [[Image:detail_table.png|frame|center|Tabular Data Manager, Details on the imported table]]
| + | |
| − | | + | |
| − | A final pop-up window will inform you when the file is successfully imported
| + | |
| − | [[Image:success_import.png|frame|center|Tabular Data Manager, file successfully uploded]]
| + | |
| − | | + | |
| − | === SDMX ===
| + | |
| − | | + | |
| − | == Export ==
| + | |
| − | === CSV ===
| + | |
| − | === JSON ===
| + | |
| − | === SDMX ===
| + | |
| − | | + | |
| − | == Curation ==
| + | |
| − | === Split Column ===
| + | |
| − | ;CHAR_SEQUENCE
| + | |
| − | :Here below, an example of the application of the char sequence method in the Split Column function:
| + | |
| − | :[[Image:tabular_data_manager_split_char_sequence1.png|frame|center|Tabular Data Manager, split column by char sequence]]
| + | |
| − | | + | |
| − | :is transformed in:
| + | |
| − | :[[Image:tabular_data_manager_split_char_sequence_result1.png|frame|center|Tabular Data Manager, split column by char sequence result]]
| + | |
| − | | + | |
| − | | + | |
| − | ;INDEX
| + | |
| − | :For example, the following Tabular Resource when splitted setting INDEX:
| + | |
| − | :[[Image:tabular_data_manager_split_index1.png|frame|center|Tabular Data Manager, split column by index]]
| + | |
| − | | + | |
| − | :is transformed in:
| + | |
| − | :[[Image:tabular_data_manager_split_regex_index1.png|frame|center|Tabular Data Manager, split column by index result]]
| + | |
| − | | + | |
| − | | + | |
| − | ;REGEX
| + | |
| − | :For example, the following Tabular Resource when splitted setting REGEX:
| + | |
| − | :[[Image:tabular_data_manager_split_regex1.png|frame|center|Tabular Data Manager, split column by regex]]
| + | |
| − | | + | |
| − | :is transformed in:
| + | |
| − | :[[Image:tabular_data_manager_split_regex_result1.png|frame|center|Tabular Data Manager, split column by regex result]]
| + | |
| − | | + | |
| − | :N.B. Value is a [http://en.wikipedia.org/wiki/Regular_expression POSIX Regular Expression]
| + | |
| − | | + | |
| − | === Normalize ===
| + | |
| − | | + | |
| − | For example, the following Tabular Resource:
| + | |
| − | [[Image:tabular_data_manager_normalize1.png|frame|center|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:
| + | |
| − | [[Image:tabular_data_manager_normalize_result1.png|frame|center|Tabular Data Manager, normalize result]]
| + | |
| − | | + | |
| − | === Denormalize ===
| + | |
| − | For example, the following Tabular Resource with 'Quantity' column of type integer or numeric:
| + | |
| − | [[Image:tabular_data_manager_denormalize1.png|frame|center|Tabular Data Manager, denormalize]]
| + | |
| − | | + | |
| − | when denormalized setting as value column name 'Quantity' and as attribute column name 'Year' is transformed in:
| + | |
| − | | + | |
| − | [[Image:tabular_data_manager_denormalize_result1.png|frame|center|Tabular Data Manager, denormalize result]]
| + | |
| − | | + | |
| − | === Extract Codelist ===
| + | |
| − | For example, if we want to extract a codelist from the following Tabular Resource:
| + | |
| − | [[Image:tabular_data_manager_extractcodelist1.png|frame|center|Tabular Data Manager, extract codelist]]
| + | |
| − | | + | |
| − | on the ribbon in curation tab, click on extract codelist button:
| + | |
| − | [[Image:tabular_data_manager_extractcodelistbutton1.png|frame|center|Tabular Data Manager, extract codelist button]]
| + | |
| − | | + | |
| − | select the columns choices, 'code' and 'name' for example:
| + | |
| − | [[Image:tabular_data_manager_extractcodelistsource1.png|frame|center|Tabular Data Manager, extract codelist source column]]
| + | |
| − | | + | |
| − | select the target column, for example new 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 ==
| + | |
| − | | + | |
| − | == Analyse ==
| + | |
| − | | + | |
| − | == External links ==
| + | |
| − | * [http://en.wikipedia.org/wiki/Regular_expression POSIX Regular Expression]
| + | |
| − | | + | |
| − | ==References==
| + | |
| − | {{Reflist}}
| + | |
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 be 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.
