Versions Compared

Old Version 2

changes.mady.by.user ZAHER-ext, Ahmed

Saved on

compared with

New Version Current

changes.mady.by.user ZAHER-ext, Ahmed

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The new features created at this stage are presented in this table:

GBUNameType in DataikuGrouping levelRecipe in DataikuDescriptionFunctions in the codeUsed in the model
NC

CS SpP

n_customers_per_productProduct Featurematerial_codecompute_Price_drivers_featuresNumber of customer per materialcreate_n_customers_per_productYes
NC

CS SpP

n_products_per_customerCustomer Featureshipto_codecompute_Price_drivers_featuresNumber of product per shiptocreate_n_products_per_customerYes
NC
CS SpPcpc_revenue_logCPC Levelsoldto_code, soldto_group, material_code & gbu_product_familycompute_Price_drivers_featuresRevenue per CPC in log scalecreate_cpc_featuresNo
NC
CS SpPcpc_volume_logCPC Levelsoldto_code, soldto_group, material_code & gbu_product_familycompute_Price_drivers_featuresVolume per CPCin log scalecreate_cpc_featuresYes
NC
CS SpPcpc_price_logCPC Levelsoldto_code, soldto_group, material_code & gbu_product_familycompute_Price_drivers_featuresPrice per CPC in log scalecreate_cpc_featuresYes
NC SpP
CS rev_within_soldto_grp_but_cpcCPC Levelsoldto_code compute_Price_drivers_featuresSold-to revenue but CPCcreate_cpc_featuresNo
SpPrev_within_shipto_grp_but_cpcCPC Levelshipto_code compute_Price_drivers_featuresShip-to revenue but CPCcreate_cpc_featuresNo
NC

CS SpP

rev_within_family_but_cpcCPC Levelgbu_product_familycompute_Price_drivers_featuresFamily revenue but CPCcreate_cpc_featuresNo
NC SpP
CS group_revenue_within_family_but_cpcCPC Levelsoldto_group & gbu_product_familycompute_Price_drivers_featuresSold-to group revenue within Family but CPCcreate_cpc_featuresNo
NC SpP
SpPgroup_revenue_within_family_but_cpcCPC Levelshipto_group & gbu_product_familycompute_Price_drivers_featuresShip-to group revenue within Family but CPCcreate_cpc_featuresNo
CS rev_outside_familyGroup Featuresoldto_code & gbu_product_familycompute_Price_drivers_featuresSold-to revenue outside Familycreate_cpc_featuresYes
SpPrev_outside_familyGroup Featureshipto_code & gbu_product_familycompute_Price_drivers_featuresShip-to revenue outside Familycreate_cpc_featuresYes
NC
CS SpPcpc_revenue_share_wrt_grp_family_revenueCPC Levelsoldto_group & gbu_product_familycompute_Price_drivers_featuresCPC ratio with respect to group revenue within the familycreate_cpc_featuresYes
NC SpP
CS cpc_revenue_share_wrt_grp_soldto_revenueCPC Levelsoldto_groupcompute_Price_drivers_featuresCPC ratio with respect to group revenue across all familiescreate_cpc_featuresNo
NC SpP
SpPcpc_revenue_share_wrt_grp_shipto_revenueCPC Levelshipto_groupcompute_Price_drivers_featuresCPC ratio with respect to group revenue across all familiescreate_cpc_featuresNo
CS group_volume_within_family_but_cpcCPC Levelsoldto_group & gbu_product_familycompute_Price_drivers_featuresSold-to group volume within Family but CPCcreate_cpc_featuresNo
NC SpP
SpPgroup_volume_within_family_but_cpcCPC Levelshipto_group & gbu_product_familycompute_Price_drivers_featuresShip-to group volume within Family but CPCcreate_cpc_featuresNo
CS group_volume_but_cpc_labelCPC Levelsoldto_group & gbu_product
_familysoldto_group
_familycompute_Price_drivers_featuresSplit group_volume_within_family_but_cpc into categories using quartilescreate_group_volume_featureYes
SpPgroup_volume_but_cpc_labelCPC Levelshipto_group & gbu_product_familycompute_Price_drivers_featuresSplit group_volume_within_family_but_cpc into categories using quartilescreate_group_volume_featureYes
NC
CS SpPhistorical_unit_price_coalesce_ratio_on_12CPC LevelCPCcompute_Sales_evolution_featuresPrice evolution ratio between the last 1, 3 or 6 months and the last 12 months for a CPCcompute_coalesce_evolution_ratioYes
NC
CS SpPhistorical_sales_coalesce_ratio_on_12CPC LevelCPCcompute_Sales_evolution_featuresSales evolution ratio between the last 1, 3 or 6 months and the last 12 months for a CPCcompute_coalesce_evolution_ratioYes
NC
CSCOMPONENT_ratioProduct Featurematerial_codecompute_product_characteristics_featuresthe ratio contained by product for Component substanceproduct_composition_ratiosYes
NC
CSIMPURITY_ratioProduct Featurematerial_codecompute_product_characteristics_featuresthe ratio contained by product for Impurity substanceproduct_composition_ratiosYes
NC
CSSOLVENT_ratioProduct Featurematerial_codecompute_product_characteristics_featuresthe ratio contained by product for Solvent substanceproduct_composition_ratiosYes
NC
CSn_componentsProduct Featurematerial_codecompute_product_characteristics_featuresthe total count of substances by productproduct_composition_counts_by_productYes
NC
CSUnit ICM/Price ratiosCPC LevelCPC & historical_monthcompute_Sales_evolution_features

The ratio between Unit ICM and Unit Price for one or average of several month.

The activation of these features is managed by the "ICM_features" dictionary, in which the size of the interval of historical months can also be modified.

"ICM_features": {
    "use_ICM_features": false,
    "interval_sizes": [1, 3, 6, 9, 12]
 }

A coalesce ratio ("ratio_icm_sales_coalesce_ratio") is then created to obtain the first available value by ranking the intervals in descending order. 

get_ICM_price_ratioNo