Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- from sqlalchemy import create_engine
- import cx_Oracle
- dsn_tns = "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<host>)(PORT=1521))
- (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=<servicename>)))"
- pwd = input('Please type in password:')
- engine = create_engine('oracle+cx_oracle://myusername:' + pwd + '@%s' % dsn_tns)
- df.to_sql('test_table', engine.connect(), if_exists='replace')
- id name premium created_date init_p term_number uprate value score group action_reason
- 160442353 LDP: Review 1295.619617 2014-01-20 1130.75 1 7 -42 236.328243 6 pass
- 164623435 TRU: Referral 453.224880 2014-05-20 0.00 11 NaN -55 38.783290 1 suppress
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement