Remove spaces padded to columns in CSV with progress indicator

remove_csv_space.py

#!/usr/bin/python3

import sys
from tqdm import tqdm
from os.path import splitext, basename, dirname, abspath, join, getsize

def main():
    if len(sys.argv) < 2:
        print('Usage: %s ...csv_files' % sys.argv[0])
        exit()

    for fname in sys.argv[1:]:
        print('Trimming %s...' % fname)
        with open(fname, 'r') as fin:
            dest = '%s.trim.csv' % (splitext(basename(fname))[0])
            dest = join(dirname(abspath(fname)), dest)
            fout = open(dest, 'w')
            with tqdm(total=getsize(fname), unit='byte') as bar:
                for line in fin:
                    bar.update(len(line.encode('utf8')) + 1)
                    fout.write(','.join(map(lambda x: x.strip(), line.split(','))) + '\n')
            fout.close()

if __name__ == '__main__':
    main()