import csv import os.path as op from glob import glob for fname in glob("*.csv"): with open(fname) as f: reader = csv.reader(f) oname, _ = op.splitext(fname) oname = oname + ".txt" with open(oname, "w") as of: for i, row in enumerate(reader): if i == 0: continue if row[-1] == "": row = row[:-1] of.write("\t".join(row) + "\n")