Difference between revisions of "Tabular Data Manager: Modify"
From Gcube Wiki
(Created page with '== 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:tabular_data_mana…') |
(→Downscale C-Square) |
||
| (13 intermediate revisions by the same user not shown) | |||
| Line 7: | Line 7: | ||
==== Replace ==== | ==== Replace ==== | ||
===== Batch ===== | ===== Batch ===== | ||
| − | :Look at [[Tabular Data Manager#Replace Batch|Replace Batch]] section. | + | :Look at [[Basic Operations (Tabular Data Manager)#Replace Batch|Replace Batch]] section. |
===== By Expression ===== | ===== By Expression ===== | ||
| − | :Look at [[Tabular Data Manager#Replace by Expression|Replace by Expression]] section. | + | :Look at [[Basic Operations (Tabular Data Manager)#Replace by Expression|Replace by Expression]] section. |
===== By External ===== | ===== By External ===== | ||
| Line 47: | Line 47: | ||
==== Filter ==== | ==== Filter ==== | ||
: This function allows delete the columns that does not match with the criteria established by the user, so the tabular resource is modified. | : This function allows delete the columns that does not match with the criteria established by the user, so the tabular resource is modified. | ||
| − | [[Image: | + | [[Image:filter2.png|thumb|800px|center|Tabular Data Manager, Filter Simple]] |
| + | : Note that in the case of filter on multi columns parentheses must correspond correctly. | ||
| + | [[Image:filter.png|thumb|800px|center|Tabular Data Manager, Filter On Multi Column]] | ||
=== Table Menu === | === Table Menu === | ||
| Line 86: | Line 88: | ||
[[Image:tabular_data_manager_modify.png|frame|center|Tabular Data Manager, Modify tab]] | [[Image:tabular_data_manager_modify.png|frame|center|Tabular Data Manager, Modify tab]] | ||
==== C-Square ==== | ==== C-Square ==== | ||
| − | :Allows the creation of C-Square coordinates: | + | :Allows the creation of C-Square coordinates(If necessary, you may have to change column type in Numeric or Integer): |
[[Image:tabular_data_manager_geospatial_cquare.png|frame|center|Tabular Data Manager, C-Square]] | [[Image:tabular_data_manager_geospatial_cquare.png|frame|center|Tabular Data Manager, C-Square]] | ||
:Result | :Result | ||
| Line 92: | Line 94: | ||
==== Downscale C-Square ==== | ==== Downscale C-Square ==== | ||
| + | Note, if necessary, you may have to change column type in Numeric or Integer: | ||
[[Image:tabular_data_manager_geospatial_downscale_csquare.png|frame|center|Tabular Data Manager, Downscale C-Square]] | [[Image:tabular_data_manager_geospatial_downscale_csquare.png|frame|center|Tabular Data Manager, Downscale C-Square]] | ||
:Result | :Result | ||
| Line 111: | Line 114: | ||
[[Image:tabular_data_manager_geometry_points_result.png|frame|center|Tabular Data Manager, Points Result]] | [[Image:tabular_data_manager_geometry_points_result.png|frame|center|Tabular Data Manager, Points Result]] | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
[[Category:Tabular Data Manager]] | [[Category:Tabular Data Manager]] | ||
Latest revision as of 10:35, 5 December 2016
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...)
Tabular Data Manager, Modify tab
Rows Menu
Replace
Batch
- Look at Replace Batch section.
By Expression
- Look at Replace by Expression section.
By External
- You can replace column content using a external tabular resource. In this example you populate the country column using as a reference the code column. Given the following table:
Tabular Data Manager, Replace By External
- Now you indicate that you want to fill country column:
Tabular Data Manager, Replace By External
- You choose a tabular resource from which you will take the data:
Tabular Data Manager, Replace By External
- You indicate which columns to use as reference between the two tabular resources:
Tabular Data Manager, Replace By External
- You choose the column from which we extract the data:
Tabular Data Manager, Replace By External
- The result will be:
Tabular Data Manager, Replace By External
Delete
Selected
- You can delete a row or multiple rows in your Tabular resource by fist selecting and then clicking on the button Delete row.
Duplicate
- You can delete duplicates in one or more columns in your table by selecting the relative columns in the column list.
- After deleting the duplicate, the original tabular resource will appear without the row corresponding to the family duplicate:
Tabular Data Manager, Tabular resource without duplicate
By Expression
- You can delete rows using expression.
Add
- You can add a row to your Tabular resource by clicking on the button Add row.
Filter
- This function allows delete the columns that does not match with the criteria established by the user, so the tabular resource is modified.
- Note that in the case of filter on multi columns parentheses must correspond correctly.
Table Menu
Group by
- In the Table menu, the Group by button allows to group the columns of your Tabular Resource accordingly to their average, counts, max, min etc...
- Once selected the table to work on, the system asks to tick from the column list that one the grouping must replies on:
- then define the criteria, from the aggregation list, by selecting the method and the reference column:
Tabular Data Manager, Column aggregation by the selected criteria- The original table has been transformed into:
Time aggregation
- The Time aggregation allows to order your data according to a time dimensional column. Before execute this function, you need to be sure that the column you want to aggregate is a time dimension type. You can modify your column by using the Column type function in the Structure menu of the Curation tab.
- First select one or more columns you want to use to apply the function
- then define the criteria, from the aggregation list, by selecting the method and the reference column/s:
Tabular Data Manager, Period of time and aggregation criteria to apply on the column/s
Tabular Data Manager, Processed table results
Union
- 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:
- Selection of the column within the table resources to unify:
- The original table has been transformed into:
- 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.
Geospatial Menu
Tabular Data Manager, Modify tab
C-Square
- Allows the creation of C-Square coordinates(If necessary, you may have to change column type in Numeric or Integer):
Tabular Data Manager, C-Square
- Result
Tabular Data Manager, C-Square Result
Downscale C-Square
Note, if necessary, you may have to change column type in Numeric or Integer:
Tabular Data Manager, Downscale C-Square
- Result
Tabular Data Manager, Downscale C-Square Result
Ocean Area
- Allows the creation of Fao Ocean Area coordinates:
Tabular Data Manager, Ocean Area
- Result
Tabular Data Manager, Ocean Area Result
Geometry Menu
Tabular Data Manager, Modify tab
Points
- Allows the creation of Points:
Tabular Data Manager, Points
- Result
Tabular Data Manager, Points Result
