import sqlite3
from pandas.io import sql
cnx = sqlite3.connect('mydbfile.sqlite')
data = sql.read_sql('SELECT * FROM data;', cnx)
data.to_hdf('test_store.hdf', 'test', mode='w')
convert python sqlite db to hdf5