References:
https://blogs.msdn.microsoft.com/azuredev/2017/05/27/data-cleansing-tools-in-azure-machine-learning/
https://docs.microsoft.com/en-us/azure/machine-learning/studio-module-reference/clip-values

Explanation:
Box 1: pandas as df
Pandas takes data (like a CSV or TSV file, or a SQL database) and creates a Python object with rows and columns called data frame that looks very similar to table in a statistical software (think Excel or SPSS for example.
Box 2: transpose[ProductCategoryMapping]
Reshape the data from the pandas Series to columns.
Reference:
https://datascienceplus.com/linear-regression-in-python/

Reference:
https://notebooks.azure.com/

Reference:
https://docs.microsoft.com/en-us/python/api/azureml-core/azureml.core.compute.computetarget

Explanation/Reference:
Explanation:
Typical metadata changes might include marking columns as features.
References:
https://docs.microsoft.com/en-us/azure/machine-learning/studio-module-reference/edit-metadata Testlet 1 Case study Overview You are a data scientist in a company that provides data science for professional sporting events. Models will use global and local market data to meet the following business goals:
Understand sentiment of mobile device users at sporting events based on audio from crowd reactions.

Assess a user's tendency to respond to an advertisement.

Customize styles of ads served on mobile devices.

Use video to detect penalty events

Current environment
Media used for penalty event detection will be provided by consumer devices. Media may include

images and videos captured during the sporting event and shared using social media. The images and videos will have varying sizes and formats.
The data available for model building comprises of seven years of sporting event media. The sporting

event media includes; recorded video transcripts or radio commentary, and logs from related social media feeds captured during the sporting events.
Crowd sentiment will include audio recordings submitted by event attendees in both mono and stereo

formats.
Penalty detection and sentiment
Data scientists must build an intelligent solution by using multiple machine learning models for penalty

event detection.
Data scientists must build notebooks in a local environment using automatic feature engineering and

model building in machine learning pipelines.
Notebooks must be deployed to retrain by using Spark instances with dynamic worker allocation.

Notebooks must execute with the same code on new Spark instances to recode only the source of the

data.
Global penalty detection models must be trained by using dynamic runtime graph computation during

training.
Local penalty detection models must be written by using BrainScript.

Experiments for local crowd sentiment models must combine local penalty detection data.

Crowd sentiment models must identify known sounds such as cheers and known catch phrases.

Individual crowd sentiment models will detect similar sounds.
All shared features for local models are continuous variables.

Shared features must use double precision. Subsequent layers must have aggregate running mean

and standard deviation metrics available.
Advertisements
During the initial weeks in production, the following was observed:
Ad response rated declined.

Drops were not consistent across ad styles.

The distribution of features across training and production data are not consistent

Analysis shows that, of the 100 numeric features on user location and behavior, the 47 features that come from location sources are being used as raw features. A suggested experiment to remedy the bias and variance issue is to engineer 10 linearly uncorrelated features.
Initial data discovery shows a wide range of densities of target states in training data used for crowd

sentiment models.
All penalty detection models show inference phases using a Stochastic Gradient Descent (SGD) are

running too slow.
Audio samples show that the length of a catch phrase varies between 25%-47% depending on region

The performance of the global penalty detection models shows lower variance but higher bias when

comparing training and validation sets. Before implementing any feature changes, you must confirm the bias and variance using all training and validation cases.
Ad response models must be trained at the beginning of each event and applied during the sporting

event.
Market segmentation models must optimize for similar ad response history.

Sampling must guarantee mutual and collective exclusively between local and global segmentation

models that share the same features.
Local market segmentation models will be applied before determining a user's propensity to respond to

an advertisement.
Ad response models must support non-linear boundaries of features.

The ad propensity model uses a cut threshold is 0.45 and retrains occur if weighted Kappa deviated

from 0.1 +/- 5%.
The ad propensity model uses cost factors shown in the following diagram:


The ad propensity model uses proposed cost factors shown in the following diagram:


Performance curves of current and proposed cost factor scenarios are shown in the following diagram: