Frequency Table

Modified on Tue, 25 Feb 2020 at 04:02 PM

In Brief

Function: Provides the frequency of observations across specified fields

Typical Use Case: If a user had a large number of fields and wanted to find the number of occurrences of specific subsets


Case Study

Using the bond prices data set, we would like to figure out how often each Ticker appears in the data set.

Workflow

Workflow for Frequency Table

Workflow for Frequency Table

Input data:

For this example, the input data consists of bond names and various other fields specifying bond properties.

Example bond prices input data for Frequency Table

Example bond prices input data for Frequency Table

Options

Once the data is connected, we can configure it.

Options for Frequency Table

Options for Frequency Table


Fields: Select here the fields for which you want to count frequencies.

Sort by frequency: Choose whether the output data should be sorted.

Output

We are only interested in the names, so we only select “Ticker” from the list of fields. Running the workflow produces the following output:

Example Output for Frequency Table

Example Output for Frequency Table

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article