CSV to XLS with Pandas

csv_to_xls.py

import unicodecsv
from pandas import DataFrame

def csv_to_xls(fname, delimiter=';'):
    with open(fname, 'r') as f:
        stream = StringIO(f.read())

    reader = unicodecsv.reader(stream, delimiter=delimiter)
    df = DataFrame(list(reader))

    with ExcelWriter(fname.replace('csv', 'xls')) as ew:
        df.to_excel(ew, 'Sheet 1', index=False, header=False)
        ew.save()

def run():
    import os
    files = os.listdir('.')
    t = len(files)
    for i, fname in enumerate(files, 1):
        if os.path.splitext(fname)[-1] == '.csv' and fname.startswith('driver_'):
            csv_to_xls(fname)
        print "{} of {}".format(i, t)