Ggtkuk

I have created a python function within field calculator to calculate the time difference between a timestamp (yyyy-MM-dd HH:mm:ss) in a row and the row after (the interval field in seconds). I have used a update cursor with field calculator to do this, however I am receiving null values for both the first and last row.

The first is correctly missed due to the function being reliant on having a value set by the previous row.

I am unsure as to why the last row is being skipped?

The first row of the attribute is formatted as:

The last:

I have had this issue on several other update cursor functions including those on simple single row condition statements.

Am I missing a statement to close the update cursor loop?

My code is:

import arcpy, time, datetime

from time import strftime

from datetime import timedelta, datetime

from arcpy import da



def FindTime(table,date,interval):



  firstRow = True



  with arcpy.da.UpdateCursor(table, ["interval", "date"]) as cursor:



    for row in cursor:

        gap2 = row[2]



        if firstRow == True:

            gap1 = gap2

            firstRow = False

            continue

        timedelta = gap2 - gap1

        row[0] = timedelta.days * 24 * 3600 + timedelta.seconds

        gap1 = gap2         

        cursor.updateRow(row)

*Updated from below comment's solution:

import arcpy

def FindTime(fc, datefield, daydiff_field):



    all_dates = [i[0] for i in     arcpy.da.SearchCursor(fc,datefield)]



    diff = [(d1-d0).seconds for d0,d1 in zip(all_dates, all_dates[1:])]

    givediff = iter(diff)



    with arcpy.da.UpdateCursor(fc, daydiff_field) as cursor:

        next(cursor) #uncomment this line if you want to calculate row2 diff as row2-row1, =first row no diff

        for row in cursor:

            try:

                row[0] = next(givediff) #Fetch diffs until list is empty...

                cursor.updateRow(row)

            except StopIteration: #...then break the cursor

                break

If your field is type date, code below should work. Last line is not calculated since there is no row after. Or do you want to calculate for example second rows diff as second row-first row?

import arcpy



fc = 'somedates'

datefield = 'date123'

daydiff_field = 'seconddiff_long'



all_dates = [i[0] for i in arcpy.da.SearchCursor(fc,datefield)]



diff = [(d1-d0).seconds for d0,d1 in zip(all_dates, all_dates[1:])]

givediff = iter(diff)



with arcpy.da.UpdateCursor(fc, daydiff_field) as cursor:

#next(cursor) #uncomment this line if you want to calculate row2 diff as row2-row1, =first row no diff

    for row in cursor:

        try:

            row[0] = next(givediff) #Fetch diffs until list is empty...

            cursor.updateRow(row)

        except StopIteration: #...then break the cursor

            break