dataframe写入postgresql数据库中

from sqlalchemy import create_engineimport pandas as pdimport numpy as np

连接数据库

engine = create_engine('postgresql://rolename@localhost:5432/databasename') #create_engine说明：dialect[+driver]://user:password@host/dbname[?key=value..]

写入数据库

data = pd.DataFrame(np.arange(15).reshape(3,5),index=['one','two','three'],columns=['a','b','c','d','e'])try:    data.to_sql('tablename',engine,index=False,if_exists='append')except Exception as e:    print(e)