将csv文件导入mysql数据库中

# -*- coding: utf-8 -*-
"""
Spyder Editor

This is a temporary script file.
"""
import pandas as pd
from os import walk
import pymysql

db= pymysql.connect(host='10.24.3.3',user='penglin',password='501501',port=3306,db='web of science 1')
cursor= db.cursor()
for f,_,i in walk("C:\\Users\\83469\\Desktop\\新建文件夹"):
    for j in i:
        data_info=pd.read_csv(f+"\\"+j,iterator=True,chunksize=1)
        file_name=j[:-4]
        sql='create table if not exists `'+file_name+'`(id int auto_increment primary key,title text,abstract text,year text,article_author text,article_keywords text)'
        cursor.execute(sql)
        for t,data in enumerate(data_info):
            data=data.fillna('')
            data=data.values[0]
            sql='insert into `'+file_name+'`(title,abstract,year,article_author,article_keywords) values("%s","%s","%s","%s","%s")'\
                %(data[4],data[2],data[1],data[0],data[3])
            try:
                cursor.execute(sql)
                db.commit()
            except:
                db.rollback()
    db.close