|
|
| (243 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]] |
| | | | |
| − | == Main interface features == | + | <!-- |
| − | Composition of the interface :
| + | ==References== |
| | + | {{Reflist}} --> |
| | | | |
| − | ;Ribbon menu
| |
| − | <!--Chiara consiglia:-->
| |
| − | :The interface consists of a top ribbon menu of four tabs (i.e Home, Curation, Modify and Analyse) which includes the main functionalities of the portlet.
| |
| − | [[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]]
| |
| | | | |
| | + | <!-- |
| | + | [[Template:Tabular Data Manager]] |
| | + | --> |
| | | | |
| − | ;Tools area
| + | [[Category:Tabular Data Manager]] |
| − | <!--Chiara consiglia:-->
| + | [[Category:User's Guide]] |
| − | :The interface has a left side panel, which reports the main characteristics of the activated table (i.e tab properties). In also, you can visualize the list of the performed operations (once you have already manipulated your file) and if those have been successfully validated (i.e validation tab).
| + | |
| − | [[Image:tabular_data_manager_tools1.png|frame|center|Tabular Data Manager, tools area]] | + | |
| − | | + | |
| − | | + | |
| − | ;Main area
| + | |
| − | <!--Chiara consiglia:-->
| + | |
| − | :In the central panel, your active tabular resource is displayed. The picture shows on which table you are working on as confirmed by the bottom panel.
| + | |
| − | [[Image:tabular_data_manager_main1.png|frame|center|Tabular Data Manager, main area]] | + | |
| − | | + | |
| − | == Home ==
| + | |
| − | | + | |
| − | === File Menu ===
| + | |
| − | <!--Chiara suggerisce:-->
| + | |
| − | : This section includes basic operations to open, close, delete, investigating the properties and clone your table.
| + | |
| − | | + | |
| − | ;Open
| + | |
| − | : A window will show the list of tabular resource available to the user.
| + | |
| − | <!--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 visualized
| + | |
| − | [[Image:tabular_data_manager_openbutton.png|frame|center|Tabular Data Manager, Open button in the Home tab]]
| + | |
| − | | + | |
| − | ;Close
| + | |
| − | <!--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 button 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 resources using the button Delete on the File menu of the Home tab. The resource will not be available into your workspace anymore. A po-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
| + | |
| − | <!--Chiara suggerisce:-->
| + | |
| − | :A column and a context menu, are available directly on your tabular 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)
| + | |
| − | | + | |
| − | :Example of the Grid Header Column Menu
| + | |
| − | [[Image:tabular_data_manager_grid_header_menu1.png|frame|center|Tabular Data Manager, grid header column menu]]
| + | |
| − | | + | |
| − | :Example of the Context Menu
| + | |
| − | [[Image:tabular_data_manager_grid_context_menu1.png|frame|center|Tabular Data Manager, grid context menu]]
| + | |
| − | | + | |
| − | === Import Menu ===
| + | |
| − | ;CSV
| + | |
| − | <!---Chiara suggests-->
| + | |
| − | :Users can import their file in .csv format, by clicking on the CSV button of the Import menu.
| + | |
| − | [[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 Menu ===
| + | |
| − | ;CSV
| + | |
| − | <!---Chiara suggests-->
| + | |
| − | :Users can export their file in a .csv format, by clicking on the CSV button in the Export menu.
| + | |
| − | | + | |
| − | [[Image:export.png|frame|center|Tabular Data Manager, Export .csv file in the Home tab]]
| + | |
| − | | + | |
| − | :Using a pop-up window, the user specifies the folder into the workspace where the file will be saved. From the workspace the file can be downloaded in local.
| + | |
| − | | + | |
| − | [[Image:exportWork.png|frame|center|Tabular Data Manager, Export your CSV in your Workspace folder]]
| + | |
| − | | + | |
| − | :A pop-up windows will help you to configure your file for the export.
| + | |
| − | [[Image:exportCsv.png|frame|center|Tabular Data Manager, Configure the export of your CSV file]]
| + | |
| − | | + | |
| − | :A final pop-up window will inform you the success of the export procedure.
| + | |
| − | [[Image:exportComplete.png|frame|center|Tabular Data Manager, the file has been successfully exported]]
| + | |
| − | | + | |
| − | ;JSON
| + | |
| − | ;SDMX
| + | |
| − | | + | |
| − | === Template Menu ===
| + | |
| − | ;New
| + | |
| − | | + | |
| − | ;Open
| + | |
| − | | + | |
| − | ;Delete
| + | |
| − | | + | |
| − | === Share ===
| + | |
| − | :
| + | |
| − | | + | |
| − | === Tasks Menu ===
| + | |
| − | ;Timeline
| + | |
| − | | + | |
| − | ;Background
| + | |
| − | | + | |
| − | | + | |
| − | === History Menu ===
| + | |
| − | ;History
| + | |
| − | ;Undo
| + | |
| − | | + | |
| − | === Help ===
| + | |
| − | | + | |
| − | == Curation ==
| + | |
| − | === Validation Menu ===
| + | |
| − | ; Duplicate Detection
| + | |
| − | :
| + | |
| − | ; Apply Template
| + | |
| − | :
| + | |
| − | | + | |
| − | === Structure Menu ===
| + | |
| − | ;Split Column
| + | |
| − | : The column of a tabular resource can be split accordingly to different criteria: 'char_sequence', 'index', and 'regex'.
| + | |
| − | <!--Chiara suggests-->
| + | |
| − | :Here below, an example of the application of the CHAR SEQUENCE method in the Column Split function:
| + | |
| − | :[[Image:tabular_data_manager_split_char_sequence1.png|frame|center|Tabular Data Manager, split column and char sequence method]]
| + | |
| − | | + | |
| − | :The original table is transformed into:
| + | |
| − | :[[Image:tabular_data_manager_split_char_sequence_result1.png|frame|center|Tabular Data Manager, split column by char sequence]]
| + | |
| − | | + | |
| − | :Here below an example of the application of the INDEX method in the Column Split function:
| + | |
| − | :[[Image:tabular_data_manager_split_index1.png|frame|center|Tabular Data Manager, split column and index method]]
| + | |
| − | | + | |
| − | :The original table is transformed into:
| + | |
| − | :[[Image:tabular_data_manager_split_regex_index1.png|frame|center|Tabular Data Manager, split column by index ]]
| + | |
| − | | + | |
| − | :Here below an example of the application of the REGEX method in the Column Split function:
| + | |
| − | :[[Image:tabular_data_manager_split_regex1.png|frame|center|Tabular Data Manager, split column and regex method]]
| + | |
| − | | + | |
| − | :The original table is transformed into:
| + | |
| − | :[[Image:tabular_data_manager_split_regex_result1.png|frame|center|Tabular Data Manager, split column by regex]]
| + | |
| − | | + | |
| − | :N.B. Value is a [http://en.wikipedia.org/wiki/Regular_expression POSIX Regular Expression]
| + | |
| − | | + | |
| − | ; Normalize
| + | |
| − | <!--Chiara suggests-->
| + | |
| − | :If you want to normalize the data in your Tabular resource, you can continue as follow:
| + | |
| − | [[Image:tabular_data_manager_normalize1.png|frame|center|Tabular Data Manager, normalize]]
| + | |
| − | :Considering the structure of our table you will name a Normalized and a Value column. The system will create these two new columns at the end of the normalization.
| + | |
| − | :In the pop-up setting windows, the Normalized Column will be the column containing the normalized variables, whereas the Value column will contain the values of the normalized data (i.e Normalized column: 'Year', Value column:'Quantity' and columns to normalize '1998', '1999' and '2000' )
| + | |
| − | | + | |
| − | :The original table is transformed into:
| + | |
| − | [[Image:tabular_data_manager_normalize_result1.png|frame|center|Tabular Data Manager, normalize result]]
| + | |
| − | | + | |
| − | ; Denormalize
| + | |
| − | :A table resource can be denormalized using the Denormalize button in the Structure menu of the Curation tab:
| + | |
| − | :The original table, can be transformed by selecting the Value column and the Attribute column.
| + | |
| − | :Using the normalized table of the previous section, by setting 'Quantity' as value column and 'Year' as attribute column we will obtain the original table:
| + | |
| − | | + | |
| − | [[Image:tabular_data_manager_denormalize_result1.png|frame|center|Tabular Data Manager, denormalized table]]
| + | |
| − | | + | |
| − | === Helper Menu ===
| + | |
| − | ; Extract Codelist
| + | |
| − | :There is the possibility to extract a codelist from Tabular resources. Let's use the table below:
| + | |
| − | [[Image:tabular_data_manager_extractcodelist1.png|frame|center|Tabular Data Manager, extract codelist]]
| + | |
| − | | + | |
| − | :Click on the Extract codelist button, in the Helper menu of the Curation tab:
| + | |
| − | [[Image:tabular_data_manager_extractcodelistbutton1.png|frame|center|Tabular Data Manager, extract codelist button]]
| + | |
| − | | + | |
| − | :Select the columns, for example 'code' and 'name':
| + | |
| − | [[Image:tabular_data_manager_extractcodelistsource1.png|frame|center|Tabular Data Manager, extract codelist source column]]
| + | |
| − | | + | |
| − | :Define the target column, for example new column:
| + | |
| − | [[Image:tabular_data_manager_extractcodelisttarget1.png|frame|center|Tabular Data Manager, extract codelist target column]]
| + | |
| − | | + | |
| − | :Define the label and the type of your new column:
| + | |
| − | [[Image:tabular_data_manager_extractcodelisttargetnew1.png|frame|center|Tabular Data Manager, extract codelist target new column]]
| + | |
| − | | + | |
| − | :The target column should appear as follow:
| + | |
| − | [[Image:tabular_data_manager_extractcodelisttargetfill1.png|frame|center|Tabular Data Manager, extract codelist target fill column]]
| + | |
| − | | + | |
| − | :Choose a name for the new codelist:
| + | |
| − | [[Image:tabular_data_manager_extractcodelistdetail1.png|frame|center|Tabular Data Manager, extract codelist detail]]
| + | |
| − | | + | |
| − | :A new codelist is extracted now:
| + | |
| − | [[Image:tabular_data_manager_extractcodelisresult1.png|frame|center|Tabular Data Manager, extract codelist result]]
| + | |
| − | | + | |
| − | :If you want to directly connect the tabular resource to the codelist extracted, you must set attach on detail so:
| + | |
| − | [[Image:tabular_data_manager_extractcodelisdetailattach1.png|frame|center|Tabular Data Manager, extract codelist attach]]
| + | |
| − | | + | |
| − | :The original tabular resource is attached to new codelist:
| + | |
| − | [[Image:tabular_data_manager_extractcodelisresultattach1.png|frame|center|Tabular Data Manager, extract codelist result by attach ]]
| + | |
| − | | + | |
| − | :Note: in this case the extracted codelist is set to final automatically.
| + | |
| − | | + | |
| − | | + | |
| − | ; Map Import
| + | |
| − | | + | |
| − | == Modify ==
| + | |
| − | :The modify tab includes several functions in the Table menu to work on your Tabular Resources (i.e group, add, delete, unify table etc...)
| + | |
| − | :[[Image:modifyTab.png|frame|center|Tabular Data Manager, Modify tab ]]
| + | |
| − | | + | |
| − | === Table Menu ===
| + | |
| − | ;Union
| + | |
| − | <!--Chiara suggests-->
| + | |
| − | :In the Table menu, the Union button allows to relate one or more columns of your tables resources in one file.
| + | |
| − | :Here below, an example of the functionality of the Union button with one tabular resources.
| + | |
| − | :Selection of the files:
| + | |
| − | :[[Image:union_file.png|frame|center|Tabular Data Manager, Selection of the files]]
| + | |
| − | :Selection of the column within the table resources to unify:
| + | |
| − | :[[Image:mapping.png|frame|center|Tabular Data Manager, Columns selection]]
| + | |
| − | :The original table has been transformed into:
| + | |
| − | :[[Image:result_union.png|frame|center|Tabular Data Manager, Table resulting from the Union function]]
| + | |
| − | | + | |
| − | :A final pop-up window will inform you about the success of the union procedure.
| + | |
| − | | + | |
| − | :Note: The system will report a question mark for the fields that are not involved in the union.The same if,in the selected column, there are empty fields.
| + | |
| − | | + | |
| − | ; Group by
| + | |
| − | | + | |
| − | ; Time aggregation
| + | |
| − | | + | |
| − | ; Replace by External
| + | |
| − | | + | |
| − | ; Add row
| + | |
| − | | + | |
| − | ; Delete row
| + | |
| − | | + | |
| − | ; Delete duplicate
| + | |
| − | | + | |
| − | == Analyse ==
| + | |
| − | === Chart Menu ===
| + | |
| − | ; Create Chart
| + | |
| − | :
| + | |
| − | | + | |
| − | === Process Menu ===
| + | |
| − | ; R studio
| + | |
| − | | + | |
| − | ; Statistical
| + | |
| − | | + | |
| − | ; Spread
| + | |
| − | | + | |
| − | === GIS Menu ===
| + | |
| − | ; Create Map
| + | |
| − | | + | |
| − | == 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.
