I am working with two very large data sets containing information on thousands of locations. I have provided two example data sets of the two files I am working with. These are the outputs after about 50 other tools are used to get the data into this format.
Now what I am trying to do is to take the workflow to the next step and this is where I am struggling. I am looking to understand the improved efficiency of a location from a utility bill cost and kWh usage. I would like to average the Power Bill before and after the Equipment Updates. The Month/Year of the Equipment Updates vary so I need the workflow to look at the Location average usage up to the Month/Year before the Equipment update and output one result. Then once the workflow notices an Equipment Update took place, Month/Year, ignore that Month/Year (because the days of the month also vary) and output the new Location average from the next month after that point and beyond.