fname = input('Enter the file name: ') fname1=input('Enter the file name to write:') try: fhand = open(fname) fhand1= open(fname1,"w") except: print('File cannot be opened:', fname) quit() count = 1 count1=0 test=None fhand1.write("Time Code,") fhand1.write("Time\n") for line in fhand: if count1==0 or count1==1: count1=count1+1 continue line = line.replace('\n','') line =line.replace(',','') fhand1.write(line) if(test==None): test=int(line) print(test) fhand1.write(",") fhand1.write(line) else: if(line==''): fhand1.write(line) count=0 else: test1=int(line) fhand1.write(",") if test1==test: fhand1.write(str(count)) else: count=count+1 fhand1.write(str(count)) test=test1 fhand1.write("\n")