Python Forum

Full Version: Variances
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Metric |Market |Month |Product Grouping |Business Unit |Age_FL |FRR_Actual |FRR_pred| FRR_PrevYear|Year

Hello,
I'm trying to calculate variances for each month for actual vs TDC Pred and Prev Year

Input :
merged['FRR_Pred VAR]=(merged['FRR Actual']-merged['FRR_Pred'])* * 2
merged['FRR_PrevYear VAR]=(merged['FRR Actual']-merged['FRR_PrevYear'])* * 2

Output :
name'merged' is not defined

Can you help me with this ? please
You'll have to provide more than that. The error indicates the variable "merged" has not been declared before it's called. Without more information, there isn't much help that anyone can provide.