joshlk · August 4, 2016 19:35
diff --git a/pandas_to_sqlite.py b/pandas_to_sqlite.py
 import pandas as pd
 from sqlalchemy import create_engine

 df = pd.read_csv('<INPUT_FILE_PATH>.csv', encoding='utf')  # Needs to be unicode for sqlite
 disk_engine = create_engine('sqlite:///<DB_PATH>.sqlite')
 df.to_sql('<TABLE_NAME>', disk_engine, if_exists='append')
	import pandas as pd
	from sqlalchemy import create_engine

	df = pd.read_csv('<INPUT_FILE_PATH>.csv', encoding='utf') # Needs to be unicode for sqlite
	disk_engine = create_engine('sqlite:///<DB_PATH>.sqlite')
	df.to_sql('<TABLE_NAME>', disk_engine, if_exists='append')