snippet Loading CSV into SQLite

snippet_csv_to_sqlite.py

# this takes a standard csv file and then loads it into a databse
# question: what if instead of a csv file, I had an equivalent <table><tr><td> formatted file?

sourcefile = "skeleton.csv"
dshape = discover(resource(sourcefile))

for game_id in list_game_id:
	sourcefile = "formatted_{g}.csv".format(g=game_id)
	with open(sourcefile,'r') as infile:
	    odo(sourcefile, targetfile, dshape=dshape)

Looks like this is what I'm after: https://pypi.python.org/pypi/xmlutils