how do i count the number of cycles per 1.5 seconds on python?

Question

I have a column on time and a column with binary data. every time the binary number changes from 1 to 0, that's 1 cycle. i'd like to add up the number of cycles per 1.5 second.

something like

first 1.5s - 1,0,1,0 -> 2 cycles

second 1.5s - 1,0 -> 1 cycle

third 1.5s - 1,0,1,0,1,0 -> 3 cycles.

thank you!!

score 1 · Answer 1 · answered May 12 '21 at 16:38

Each time a cycle passes, add cycles += 1 into the code:

from time import time, sleep
start = time()
cycles = 0
sleep(0.5)
def cycle_todo(): #Define cycle!
    sleep(0.05)
while True:
    cycle_todo()
    cycles += 1
    print("Average cycles / 1.5 s: {}     ".format(round(cycles/((time()-start)/1.5), 3)),end="")
    print("\r", end="")

score 0 · Answer 2 · answered Apr 16 '21 at 07:59

Assuming your time is equi-distant, so 1.5s are always e.g. 3 rows, you can easily do that in a loop:

for x in range(0, len(df), 3): #df being your dataframe
    total = df.loc[x:x+3, 'Binary_data'].sum()

Otherwise (not equi-distant), you need to:

convert your time-column to datetime-dtype
Use grouper: df.groupby(pd.Grouper(freq='1.5s')).sum(), with pdbeing pandas

how do i count the number of cycles per 1.5 seconds on python?

2 Answers2