Versions Compared

Key

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

...

  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. 
     
    or 
  2. If needed, change the column by entering the required column name in 'Column'.
     
  3. Select the encoding type "Binned Encoding" 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 dividers set as default, e.g. 'Divider 1' contains the 25% of the selected column values. 
    INFO: To delete a divider, click on "x" next to the required divider.
     
  7. If needed, click on "Add new Divider" to add a new divider. 
    INFO: Clinking the button adds an additional bucket, recalculates the percentile size and the corresponding absolute values. 
     
  8. Confirm with "Encode"The encoding result is displayed in a new encoding sheet within the workbook. Binned encoding is finished. 
     

Hiding

...

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.
 

Expanding Columns

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

To expand a long column header, right-click in the column header and select "Expand Column". Only the column header is displayed fully.

Info
titleINFO
When having a longer cell content than the width of the column header is, the cell content is displayed only within the width of the column header width. Further cell content is hidden. 

Image Added

To expand all column headers, right-click in the column header and select "Expand All Columns". Only the column headers are displayed fully.

Info
titleINFO
When having longer cell content than the width of the column header is, the cell content is displayed only within the width of the column headers. Further cell content is hidden. 

Image Added

Removing Columns

...