dr = csv.DictReader(open('data.csv', delimiter=','))
to_db = [(i['col1'], i['col2']) for i in dr]
c.executemany('insert into t (col1, col2) values (?, ?);', to_db)
Python in memory table data structures for analysis (dict, list, combo)