python 读取本地excel存入数据库

import pandas as pd
import os
from read_pgdata import Postgredata

root_dir = r'root'
file_names = os.listdir(root_dir)[:-1]
print(len(file_names), file_names)

pg = Postgredata()
for i in range(len(file_names)):
    df = pd.read_excel(root_dir + '\\' + file_names[i], index_col=None, header=None)
    dataset = df.loc[2::].values
    data = []
    for k in dataset:
        k = list(k)
        # print(k)
        data.append(k)
    print(data)
        # print(list(data[j]))
    sql = "INSERT INTO ship_trail (mmsi,longitude,latitude,time,speed,shiphead,heading) VALUES (%s,%s,%s,%s,%s,%s,%s)"
    pg.insertManyRow(strings=data, query=sql) #插入用insertManyRow函数

import psycopg2
import json
# import pandas as pd

# 从postgresql获取数据
class Postgredata():
    def __init__(self):
        self.dbname = ""
        self.user =