Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Variances
#1
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
Reply
#2
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.
Reply


Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020