Skip to content

Add a filter to timeseries pairs

I have a time series plc tag data as below with values in ‘1’ or ‘0’ Using below code I can get the output Output But my requirement is, I only want to query going back 25 hours, so I add a predicate: But this returns the error: Msg 209 Level 16 State 1 Ambiguous column name ‘dat…

Find all 3^4 permutation using lists

Let’s say I have 4 distinguishable balls, and I want to distribute them into 3 cells (that’s 3^4 different ways of doing that) – how would you suggest me to demonstrate all those 81 different distributions using Python? I want my program to return a list that contains 81 lists, each contain …

Check for max value of iterative sum in pandas

I have a pandas dataframe with some data: I’d like to sum them, one at a time, and at every summation check the totalt sum, an then extract the highest value achieved of the total sum. So the first sum would be element 0, with a value of -0.000601, the send would be -0.000601 + 0.000001=-0.0006, and thi…

Python subprocess Popen periodic callback

I am running an HPC simulation on amazon AWS with spot instances. Spot instances can be terminated with 2 minutes notice by AWS. In order to check for termination you need to exectute curl on a spefiic URL every 5 seconds. It is a simple request that returns a json with the termination time, if AWS have initi…

Replacing chunks of numpy array on condition

Let’s say I have the following numpy array, of 1’s and 0’s exclusively: I want to group all elements into chunks of 3, and replace the chunks by a single value, based on a condition. Let’s say I want [0,1,1] to become 5, and [0,1,0] to become 10. Thus the desired output would be: All p…