Technical Articles
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.
Frank Schuler
Thanks for this. How about the binning based on age exercise?
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