#!/usr/bin/env python import sys from datetime import datetime, timedelta #from optparse import OptionParser import csv def main(): filename = sys.argv[1] td = int(sys.argv[2]) try: fptr = open(filename, 'r') except IOError: print "Could not open %s" % filename sys.exit(1) reader = csv.reader(fptr) i = 0 rows = [] prevtime = 0 for row in reader: time = row[2] if prevtime == time: i -= 1 row[2] = " "+modtime(row[2].strip(), i*td) rows.append(row) i += 1 prevtime = time fptr.close() try: fptr = open(filename, 'w') except IOError: print "Could not open %s" % filename sys.exit(1) writer = csv.writer(fptr) writer.writerows(rows) sys.exit(0) def modtime(date, timedel): year = int(date[0:4]) month = int(date[4:6]) day = int(date[6:8]) hour = int(date[8:10]) date = datetime(year, month, day, hour) t = timedelta(hours=int(timedel)) date += -(t) return date.strftime("%Y%m%d%H") ############################################################# if __name__ == '__main__': main()