使用python将csv数据导入到sqlite中

最新推荐文章于 2025-09-19 07:24:21 发布

原创最新推荐文章于 2025-09-19 07:24:21 发布 · 5.8k 阅读

20 ·

CC 4.0 BY-SA版权

本文介绍了一个用于将CSV文件导入SQLite数据库的Python脚本，包括创建表、读取CSV数据并插入到数据库中。

脚本如下：

#!/usr/bin/env python
# -*- coding: utf-8 -*-
import csv
import sqlite3
def  dataImport(csvpath,dbpath,tablename):
    reader = csv.DictReader(open(csvpath,"rb"),delimiter=',',quoting=csv.QUOTE_MINIMAL)
    conn = sqlite3.connect(dbpath)
    # shz: fix error with non-ASCII input
    conn.text_factory = str
    c = conn.cursor()
    create_query = 'CREATE TABLE '+tablename +' ("cn" TEXT,"en" TEXT,"lat" DOUBLE,"lon" DOUBLE,"points" DOUBLE,"count" INTEGER,"intro" TEXT,"photo" TEXT,"url" TEXT,"content" TEXT)' 
    c.execute(create_query)
    for row in reader:
        print row
        to_db = [row['cn'], row['en'],row['lat'],row['lon'],row['points'],row['count'],row['intro'],row['photo'],row['url'],row['content']]
        c.execute('INSERT INTO '+tablename+' (cn, en, lat,lon,points,count,intro,photo,url,content) VALUES (?, ?, ?,?, ?, ?,?, ?, ?,?);', to_db)
    conn.commit()


查看原文：http://www.giser.net/?p=1337