Skip to Content
Technical Articles
Author's profile photo Frank Schuler

Use SAP Data Intelligence for openSAP Getting Started with Data Science – Unit 3: Data Manipulation

Before, I described how to Use SAP Data Intelligence for openSAP Getting Started with Data Science – Unit 7: Initial Data Analysis and Exploratory Data Analysis.

In Week 2 – Unit 3: Data Manipulation, Stuart is getting hands on again and I will show how to replicate his demonstration in SAP Data Intelligence instead of Orange.

To start with, I load the provided data set into the ML Data Manager as before:

And Edit in Metadata Explorer:

To preview the data:

Then I use Data Preparation to Add Column AGE_GENDER:

Based on an equivalent Expression to that Stuart used:

I get the same result. Cool in SAP Data Intelligence is that these Data Manipulations are executed on a data sample only and recorded in a Recipe to be applied wherever and whenever appropriate:

I would call that enterprise grade Data Manipulation.

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Schalk Klee
      Schalk Klee

      Frank Schuler

      Thanks for this.  How about the binning based on age exercise?

      Author's profile photo Frank Schuler
      Frank Schuler
      Blog Post Author

      Good question, Schalk.

      Data Preparation does not support binning yet. Mathplotlib does, so you can adjust the histogram in Use SAP Data Intelligence for openSAP Getting Started with Data Science – Unit 7: Initial Data Analysis and Exploratory Data Analysis relatively easily with a simple additional parameter. For this blog, I wanted to focus on Data Preparation though.

      Thanks