dataframe 写入mysql

# encoding = 'utf-8'

from pymysql import * 

# 连接数据库，数据写入
mysql_obj = connect(host='localhost', user='root', password='', db='test_cluster', port=3306,
                    charset='utf8mb4')
print("数据库连接成功")

cur_obj = mysql_obj.cursor()
row, col = sean_cnt_df.shape
for i in range(row):
    row_line = result.values[i]
    season, cnt, label = row_line[0], row_line[1], row_line[2]
    cur_obj.execute('insert into 季节对租车的影响(season, cnt, label) values(%s,%s,%s)', (season, cnt, label))
    mysql_obj.commit()
    
cur_obj.close()
mysql_obj.close()