import pandas as pd #IO
import sqlite3 #To write database
import glob #loop through working directory
cxn = sqlite3.connect('mydb.sqlite3')
for file in glob.glob('*.csv'):
table_name = file[:-4] #File name without .csv
df = pd.read_csv(file)
df.to_sql(table_name, cxn, index = False)
我找到了解决办法
相关问题 更多 >
编程相关推荐