Rank

Rank Node icon

The Clario Rank node allows you to rank records in a data stream by looking at the values of an attribute and assigning them a ‘score’ based on their relative value to all values within the attribute. The node connector can be connected to a variety of nodes, (e.g. Read File, Outliers, Missing, etc.), but requires a valid stream of data.

Configuration

The Rank node has only one configuration tab.

Configuration Tab

Configuration Tab

The Configuration Tab contains four different areas requiring your interaction. Selecting a key attribute to rank by, selecting a Tie Break Method (mean, low, high), selecting number of segments (rank groups), and name a New Rank Attribute. The Available Attributes box displays all of the attributes for the input data stream connected to the input link node connector. The Tie Break Method drop down displays options for ranking scores that are tied (‘mean’ is the default).

The Segments box defines the number of groups into which observations should be ranked. The maximum value for number of segments is 999, however the number of segments must be less than or equal to the number of rows of the selected attribute to rank by. As an example, if 5 segments are selected, the observations will be ranked into 5 relatively equal groups with a rank value of 1-5. The rank of 5 separates the group with the highest 20% of values for the ranked attribute.

And finally, the Rank node enables you to edit the name of the new attribute by typing in the ‘New Rank Attribute’ text box (the default name is ‘<Attribute Name>_Rank’). This ranks the values in ascending order, the lowest values receive a rank of 1.

Note

Only one attribute can be selected to define the rank.

Results

There are no results for the Rank node. It is assumed the Rank node will be connected to another node to analyze the data set by Rank or written out to a file using the Write File node.

Output Stream

The newly ranked dataset is ready for immediate use in various nodes located throughout Clario. The data can be exported using the Write File node and can then be used again by reading in the file with the Read File node.