擅长:python、mysql、java
<p>不需要使用pyodbc来连接MSSQL,SQL Alchemy将为您做到这一点。
我们还可以直接将数据帧插入数据库,而无需使用to_sql()方法迭代数据帧。这是对我有用的代码-</p>
<pre><code># To insert data frame into MS SQL database without iterate the data-frame
import pandas as pd
from sqlalchemy import create_engine, MetaData, Table, select
from six.moves import urllib
params = urllib.parse.quote_plus("DRIVER={SQL
Server};SERVER=serverName;DATABASE=dbName;UID=UserName;PWD=password")
engine = sqlalchemy.create_engine("mssql+pyodbc:///?odbc_connect=%s" % params)
engine.connect()
# suppose df is the data-frame that we want to insert in database
df.to_sql(name='table_name',con=engine, index=False, if_exists='append')
</code></pre>