SQLite | Python3导入csv到SQLite3

sqlite3 drugbank.db     #创建drugbank.db数据库
.open drugbank.db       #打开drugbank.db数据库

import pandas
import csv, sqlite3

conn= sqlite3.connect("drugbank.db")

df = pandas.read_csv('drugbank.csv')
df.to_sql('drugbank', conn, if_exists='append', index=False) 

cursor = conn.cursor()

cursor.execute("select name from sqlite_master where type='table' order by name")
print (cursor.fetchall())

[('drugbank',)][('drugbank',)]

cursor.execute("select * from drugbank")
col_name_list = [tuple[0] for tuple in cursor.description]
print (col_name_list)

# 执行查询语句:
cursor.execute('select smiles from drugbank ')
# 获得查询结果集:
values = cursor.fetchall()
# 遍历打印输出
for smile in values:
    print(smile)