python通过sqlalchemy库将dataframe写入sql server

from sqlalchemy import create_engine
import sqlalchemy
import pandas as pd
import numpy as np


data = np.ones((2, 4))
df = pd.DataFrame(data)
# xxx处分别写入user，password，ip，端口号，数据库名
engine = create_engine('mssql+pymssql://xx:xxx@xxx.x.x.x:xxxx/xxx?charset=utf8')
#xxx处写入表名
df.to_sql('xxx', engine)

这样做中间有几行顺序是乱的，不知道为什么，也可以用循环遍历的方式，保证顺序是对的

from sqlalchemy import create_engine
import sqlalchemy
import pandas as pd
import numpy as np
import pymssql


df = pd.read_excel('xxx.xlsx')
data = df.values

conn = pymssql.connect(host='localhost', user='xx', password='xxx', database='xxxxx')
cur = conn.cursor()

for i in range(data.shape[0]):
    sql = "insert into earth_pressure_all values ({}, {}, {}, {}, {}, {}, {})".format(
        data[i, 0], data[i, 1], data[i, 2], data[i, 3], data[i, 4], data[i, 5], data[i, 6])
    print(sql)
    cur.execute(sql)

conn.commit()
cur.close()
conn.close()


print('done')