def add_columns(header, c, clear=False):
    for column in header:
        try:
            c.execute('ALTER TABLE samples ADD COLUMN {0}'.format(column))
        except:
            pass
        if clear:
            c.execute("UPDATE samples set {0} = NULL;".format(column))
add any missing columns to the samples table
dataset/ETHPy150Open arq5x/gemini/gemini/gemini_amend.py/add_columns