Vincenzo Pota vincepota-zz
rufuspollock
/ csv2sqlite.py
Last active
April 14, 2016 14:22
UPDATED VERSION NOW AT https://github.com/rgrp/csv2sqlite [Script to load CSV to SQLite]
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/usr/bin/env python | |
| # A simple Python script to convert csv files to sqlite (with type guessing) | |
| # | |
| # @author: Rufus Pollock | |
| # Placed in the Public Domain | |
| import csv | |
| import sqlite3 | |
| def convert(filepath_or_fileobj, dbpath, table='data'): | |
| if isinstance(filepath_or_fileobj, basestring): |