This component adds a Pareto Plot to SAP Predictive Analytics.


It also outputs the aggregated data that underlies the plot, so that the transformed data can be used elsewhere.

/wp-content/uploads/2016/02/1_882299.png


Disclaimer

Please note that this component is not an official release by SAP and that it is provided as-is without any guarantee or support. Please test the component to ensure it works for your purposes.


Prerequisites

  • Libraries dplyr and gplots have to be installed.

Limitations

Please let me know should you encounter any limitations.

Usage

These parameters can be set by the user:

Parameter Description
Categorical Variable

The label column by which the numerical variable will be summarised.

Numerical Variable The column, which will be summarised by the lables found in the categorical variable.

Output columns:

Column Description
Label

The values found in the categorical variable.

Value The numerical variable summarised by the row’s label. The data is sorted descendingly on this column.
ValueCumulated The cumulated value.
Percent The row’s percentual contribution to the total sum of the numerical variable.
PercentCumulated The cumulated percentage.

How to Implement

The component can be downloaded as .spar file from GitHub. Then deploy it as described here. You just need to import it through the option “Import/Model Component”, which you will find by clicking on the plus-sign at the bottom of the list of the available algorithms.


Example

You can try the pareto plot on the attached dataset, which lists how many passengers embarked on an airplane at San Francisco airport. Select “PassengerCount” as numerical variable and choose a categorical column.

2.PNG


You can see the resulting pareto plot. Here the plot is broken down by geographical region.

/wp-content/uploads/2016/02/3_882317.png


You can also see the aggregated data that was used to build the plot.

/wp-content/uploads/2016/02/4_882318.png

You could use that data for instance in the “Prepare” tab to easily produce a more interactive pareto plot.

/wp-content/uploads/2016/02/5_882320.png



To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply