Jump to content

Iterative Calculation in Seeq Data Lab


Kin How

Recommended Posts

  • Seeq Team

A few weeks ago in Office Hours, a Seeq user asked how to perform iterative calculation in which the next value of the calculation relies on its previous values. This functionality is currently logged as a feature request. In the meantime, users can utilize Seeq Data Lab and push the calculated result from Seeq Data Lab to Seeq Workbench. Let's check out the example below:

There are a total of 4 signals, Signal G, Signal H, Signal J, and Signal Y added to Seeq workbench. The aim is to calculate the value of Signal Y, under the selected
period. 

AMWts8B3my04_2dkDyhIs_0JzBJJC1y_cwlRtuwo

AMWts8DPRfMBwUaJL_AKMpeBZGQ98NPu3Mp5okYi

 

Step 1: Set the start date and end date of the calculation.

#Set the start date and end date of calculation
startdate = '2023-01-01'
enddate = '2023-01-09'

 

Step 2: Set the workbook URL and workbook ID.

#Set the workbook URL and workbook ID
workbook_url = 'workbook_url'
workbook_id = 'workbook_id'

 

Step 3: Retrieve all raw data points for the time interval specified in Step 1 using spy.pull().

#Retrieve all raw data points for the time internal specified in Step 1:
data = spy.pull(workbook_url, start = startdate, end = enddate, grid = None)
data

AMWts8AAGFvQ1qgO5HQHRtN-1Y8pDflFGutCsWLN

 

Step 4: Calculate the value of Signal Y, (Yi = Gi * Y(i-1) + Hi * Ji)

#Calculate the value of Signal Y (Yi = Gi * Y(i-1) + Hi * Ji)
for n in range(len(data)-1):
    data['Signal Y'][n+1] = data['Signal G'][n+1] * data['Signal Y'][n] + data['Signal H'][n+1] * data['Signal J'][n+1]
data

AMWts8A987aqzQEJnOyTgnlFxS_sq0KmyQ_XTN3-

 

Step 5: Push the calculated value of Signal Y to the source workbook using spy.push().

#Push the calculated result of Signal Y to the source workbook
spy.push(data = data[['Signal Y']], workbook = workbook_id)

AMWts8AvSIOyFVONcGX4phtcJBldtYoMGDWHeop0

  • Like 4
  • Thanks 3
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...