Insert missing data in a dataframe

[ibreeden]

Perhaps I am not the right person to answer your question. Perhaps better tools can be found in pandas, but if everything else fails, you could solve it with elementary python. To calculate with time you need the datetime module with datetime and timedelta. Datetime stores a timestamp in an object. With timedelta you can calculate. So you can make a function to convert a datetime string to a datetimestring two minutes later. Like this.

from datetime import datetime, timedelta

dtformat = "%Y-%m-%d %H:%M:%S"
twominutes = timedelta(minutes=2)

def computenexttime(dtstring: str) -> str:
    """ Input is a string in datetime format, output is the next time in string format. """
    # Make datetime object.
    datetimeobj = datetime.strptime(dtstring, dtformat)
    # Compute next datetime.
    nextdtobj = datetimeobj + twominutes
    # Return next datetime as a string.
    return nextdtobj.strftime(dtformat)

With this function you can check if a line is two minutes later than the previous. Is this enough to handle the problem? Please show us what you made of it.