Thingspeak Data Time Interval Python Script

I have a Python3 script that is running on a Raspberry PI that is using a HC-SR04 Ultrasonic Sensor that is reading and posting data to Thingspeak. This setup is monitoring my sump pump pit depth and sump activity. The Thingspeak dashboard link will share with right freelancer

I want to add another field data that stores Time Interval over an X period of time (records).

The current data is :
created_at:
field1: (water_level)
field2: (sump_cycle)
field3: (sump_cycle_frequency)
field4: (gallons_discharged)

Now field3 (sump_cycle_frequency) is really just a time interval since the last sump cycle. This merely just tells me how many minutes since it cycled and not really the frequency over time or over a number of records where the sump cycled.

I would like to add field5 that does a frequency in time - Something that spans over the last X number of records in Thingspeak. Yesterday there were 475 records but only cycled 6 times. So in otherwords if I do a date/time difference of the first cycle and the last cycle the time span is 20 hours, 51 minutes - and it cycled 6 times so if you divide then the time interval is every 3.47500 hours or rather 208.5 minutes.

This is what I want field5 data to store.

So this job is to figure out a little script that reads the right records from my channel feed and then does the date/time math and then division by the number of cycles in that time period and then stores in minutes the sump_cycle_interval in field 5 -

I will share a sample export of the data from Thingspeak and the rows highlighted in yellow are the instances where the pump cycled with shortlisted candidates.

I am open to the time period - ideally in the last 24 hours or at a minimum of the last 12 hours.
About the recuiter
Member since May 20, 2018
Saurabh Salunke
from Uttar Pradesh, India

---

---

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions