#!/usr/bin/python import csv import sys reader = csv.reader(sys.stdin, delimiter='\t') writer = csv.writer(sys.stdout, delimiter='\t', quotechar='"', quoting=csv.QUOTE_ALL) for line in reader: #data = line.strip().split("\t") if line[0] == "id" or line[0] == "user_ptr_id": continue # 3 0 1 2 5 6 7 8 9 if(len(line) >= 10): try: int(line[0]) except ValueError: continue ans = [line[3], "B"] + line[:3] + line[5:10] writer.writerow(ans) continue if len(line) == 5: line.insert(1, "A") writer.writerow(line)