목록create_engine (1)

Small Asteroid Blog

[python] dataframe db에 저장

import pandas as pd import pymysql pymysql.install_as_MySQLdb() pd_data = pd.DataFrame(resultlist) print(pd_data) engine = create_engine('mysql://root:'+'password'+'@localhost/db_name',encoding='utf-8') pd_data.to_sql('table_name',engine,if_exists='replace',index=False, index_label=None, chunksize=500) print('ok') 'if_exists' 옵션에는 {'fail', 'replace', 'append'}의 3개가 존재하고, 디폴트는 'fail' 옵션입니다. if_ex..
백엔드/Python 2020. 10. 7. 14:40
이전 Prev 1 Next 다음