Convert a CSV file to a Markdown table

csv2md.py

from __future__ import print_function
import csv

def print_row(row, maxlen):
    for elem, len in zip (row, maxlen):
        print('| {} '.format(elem.ljust(len)), end='')
    print('|')

def print_hline(maxlen):
    for len in maxlen:
        print('| {} '.format(''.ljust(len, '-')), end='')
    print('|')

def csv2md(filename, has_header=True):
    with open(filename, newline='') as csvfile:
        sniffer = csv.Sniffer()
        dialect = sniffer.sniff(csvfile.read(1024))
        csvfile.seek(0)
        reader = csv.reader(csvfile, dialect)
        maxlen = None
        rows = []
        for row in reader:
            if maxlen is None:
                maxlen = [0] * len(row)
            else:
                maxlen = [max(maxlen[i], len(row[i])) for i in range(len(maxlen))]
            rows.append(row)
        for idx, row in enumerate(rows):
            print_row(row, maxlen)
            if has_header and idx == 0:
                print_hline(maxlen)

if __name__ == '__main__':
    import argparse
    parser = argparse.ArgumentParser(description='Converts a CSV file to a Markdown table.')
    parser.add_argument('filename', help='name of the csv file')
    parser.add_argument('--no_header', '-nh',
                        help='The CSV file has no header', action='store_true')
    args = parser.parse_args()
    csv2md(args.filename, not args.no_header)

usage:

python csv2md.py [-h] [--no_header] filename.csv