Versions Compared

Version Old Version 1 New Version 2
Changes made by

Juliane Wetzel

Juliane Wetzel

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info
titleINFO

Find here all information about working with columns in Datameer.

Info
titleINFO

Each workbook can contain a maximum of 702 columns.

Table of Contents

Renaming Columns

...

  1. Right-click a column name and select select "Rename" or  or double-click a column name. The column name is marked as editable. 
    INFO: To cancel column renaming, press the 'Escape' key.
    Image RemovedImage Added Image RemovedImage Added
  2. Enter the new column name. 
    INFO: Column names must only contain standard, capital oder lower-case characters, numbers and/ or underscores. A column name cannot begin with a number.
    INFO: Column names in all workbook sheet types are case-sensitive, e.g. the column names 'Foo', 'fOO' etc. are unique columns within the same worksheet. 
     
  3. Confirm the entry with with "Enter" key key. Renaming is finished. 
     

Adding Columns

...

To add a column right-click a column name and select select "Add Column". The new, empty column appears to the left. Adding a column is finished.


Reordering Columns

To remove a column left-click on a column header and drag and drop it at the required location. 
INFO: A trailing mark shows the new location of the removed column by showing the column name during drag and drop. 

Image Added

Resizing Columns

To resize and adapt a column width, place the mouse between two column headings so the icon changes to a double-ended arrow and drag the column marker to the desired width.

Image Added

Splitting Columns

Info
titleINFO

The split column operation can be updated as many times as you like until you have desired split configuration.

To split a workbook:

  1. Right-click on a column header and select "Split Column" or click on the "Split Column" icon in the toolbar. The dialog 'Split to columns' opens in the Workbook Inspector. 
    Image Added or Image Added
  2. Select the required column. 
    INFO: The column name from where the right-click was executed is set per default in the field. You can change the column if needed.
    Image Added
  3. Select the split type from the drop-down. 
    Image Added
  4. Enter the delimiter. 
    INFO: A comma is set as delimiter per default. 
    Image Added
  5. Decide if leading or trailing characters shall be skipped. 
    Image Added
  6. Decide if elements shall be skipped and in how many columns the column shall be divided.
    Image Added
  7. Decide if additional elements shall be either caught in an overflow column or be dropped. Decide also if to Trim Whitespace and how to define empty values by marking the respective checkbox. 
    Image Added
  8. Enter the column prefix for the split column and confirm with "Create Sheet". The split column is displayed in a new sheet. 
    INFO: The new column name begins with 'Name_' per default.
    Image Added

Encoding Columns

Info
titleINFO

Column encoding performs ordinal, one-hot or binned encoding on column data which assigns a unique numeric value to each categorical or continuous value. Once applied, column encoding can be updated as needed until the desired results are achieved.

Columns with a high cardinality are not suited for ordinal/ binned encoding.

...

  1. Right-click on a column header and select "Encoding" or click on the "Encode Column" icon from the toolbar. The 'Encode Column' dialog is displayed on the right. 
    Image RemovedImage Added     or 
  2. If needed, change the column by entering the required column name in 'Column'. 
     
  3. Select the encoding type type "Ordinal Encoding" from  from the drop-down. Further selection options adapt to the needs.
     
  4. Decide how to deal with unknown values by clicking the required statement. 
    INFO: 'Drop Value' ignores values beyond the first 100 most frequent. 'Default Value' shows values, which can not be encoded. 
     
  5. View the top 32 values (by count).
     
  6. If needed, add a new value in the blank field, change the order of the top values or delete single values.
     
  7. Confirm with with "Encode". The encoding result is displayed in a new encoding sheet within the workbook. Ordinal Encoding is finished. 
     

...

  1. Right-click on a column header and select "Encoding" or click on the "Encode Column" icon from the toolbar. The 'Encode Column' dialog is displayed on the right. 
    Image RemovedImage Added     or 
  2. If needed, change the column by entering the required column name in 'Column'.
     
  3. Select the encoding type "1-Hot Encoding" from the drop-down. Further selection options adapt to the needs.
     
  4. Decide how to deal with unknown values by clicking the required statement. 
    INFO: 'Drop Value' ignores values beyond the first 100 most frequent. 'Include at last column' adds a new element to the list that encodes together all values beyond the 100 most frequent. 

  5. Select the output format from the dropdown 'Output'. 
    INFO: 'As List' keeps all binary pairs together in a single column. 'As Column' creates binary pairs each in their own column.

  6. View the top 32 values (by count).
     
  7. If needed, add a new value in the blank field, change the order of the top values or delete single values.
     
  8. Confirm with "Encode". The encoding result is displayed in a new encoding sheet within the workbook. One-hot encoding is finished.
     

Anchor
DM_WB_Encoding_Binned
DM_WB_Encoding_Binned
Binned Encoding

For binned encoding:

  1. Right-click on a column header and select select "Encoding" or  or click on the the "Encode Column" icon  icon from the toolbar. The 'Encode Column' dialog is displayed on the right. 
    Image RemovedImage Added     or 
  2. If needed, change the column by entering the required column name in 'Column'.
     
  3. Select the encoding type type "Binned Encoding" from  from the drop-down. Further selection options adapt to the needs.
     
  4. Select the output format from the dropdown 'Output'.
    INFO: 'As List' keeps all binary pairs together in a single column. 'Ordinal' encodes as ordinal numbers in a single column.
     
  5. View the default value distributions. 
    INFO: The graph changes according to the amount of dividers. 
     
  6. Enter the required bin dividers to change the percentile size of the divider. 
    INFO: There are 3 deviders dividers set as default, e.g. 'Devider Divider 1' contains the 25% of the selected column values. 
    INFO: To delete a divider, click on "x" next to the required divider.
    Image RemovedImage Added 
  7. If needed, click on "Add new Divider" to add a new divider in the field 'Add new Divider'. . 
    INFO: The percentage of the other dividers adjusts with each new dividerClinking the button adds an additional bucket, recalculates the percentile size and the corresponding absolute values. 
    Image RemovedImage Added 
  8. Confirm with "Encode". The encoding result is displayed in a new encoding sheet within the workbook. Binned encoding is finished. 
     

Formatting Columns

Hiding and Expanding Columns

Tip
titleTIP

To hide or expand a larger number of columns at the same time, use the 'Toggle Columns' option.

To hide a column, right-click on a column header and select "Hide Column". The whole column hides.
Image Added 

To expand a hidden column, double-click in the small area where the column was before. The whole column appears. 
Image Added 

Removing Columns

To remove a column right-click on a column name and select "Remove Column". The column is removed. 
INFO: Column deletion is not possible in a source sheet.

Image Added