Sections in this category

Managing Columns for an Analysis

  • Updated

By default, Sisu performs an analysis on all columns contained within the dataset. However, In certain cases, some columns are not relevant to the Analysis being constructed. These columns can be removed, making the Analysis more manageable and clear.

 

Related Articles:



Managing Columns for Analysis

  1. Go to the Projects module, and select the Project and Analysis that contains the columns you want to manage.
  2. Click Manage Columns.
    The Edit columns screen will be displayed showing all available columns from your data and their data type.

    Select_Manage_Columns.png

  3. Uncheck the box for any column you wish to exclude from the Analysis
  4. Select a column in the list to display its settings, which will differ depending on the data type as described below.
  5. When you have finished editing a column or columns, click Save and re-run your analysis, if desired.
tip_icon_-_small.png If you are making changes to multiple columns, you only need to click Save once when you’re done.

 

info_icon.png

For details about changing and managing text-based columns, refer to Transforming a Column: Keyword Analysis.

For details about changing and managing numeric-based columns, refer to Transforming a Column: Binning Numerical Columns.

 

Advanced Settings

Click Show advanced settings to display additional options that you can change for any column, no matter the type:

Maximum subgroup size

This number is a percentage. Sisu will include only factors from this column if the subgroup size for that factor does NOT exceed the max size. (Note that a “factor” is a column-value pair.)


For example, if your data is 90% female and 10% male, and you set this value at 80%, Sisu will exclude facts that use the factor of (gender=female), since that is over 80%.

Exclude null values

Check this box to have Sisu automatically exclude rows that have a null value in this column.

Exclude facts with empty strings

Check this box to have Sisu automatically exclude rows that have empty strings.