Querying Data in the Data Manager

The following operations can be performed on data in the Query Manager tab of the Data Manager:

Priority of operations

Operators in the Query Manager table are performed in this order:

  1. Filter

  2. Group

  3. Apply

  4. Sort

An exception to this rule is given by the case where an apply and a filter is performed on the same attribute simultaneously.

In this case all the filters for the attribute undergoing an apply are performed after the apply.

The priority order is therefore:

  1. Filter of attributes not undergoing an apply

  2. Group

  3. Apply

  4. Filter of attributes undergoing an apply

  5. Sort

Description

Screenshot

In the example above operations are performed in this order:

  1. Filter on age <= 50.

  2. Group on workclass.

  3. Apply Mean on capital-gain.

  4. Sort on education-num.

In this second example a filter is applied on the capital-gain attribute.

Consequently the order of operations will become the following:

  1. Filter on age <= 50.

  2. Group on workclass.

  3. Apply Mean on capital-gain.

  4. Filter on capital-gain > 1000.

  5. Sort on education-num.