Guest User

Untitled

a guest
Feb 9th, 2018
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.61 KB | None | 0 0
  1. import pandas as pd
  2. import sqlalchemy
  3.  
  4. df=pd.read_excel(r"C:Usersmazin1-601.xlsx")
  5.  
  6. database_username = 'root'
  7. database_password = 'aUtO1115'
  8. database_ip = '127.0.0.1'
  9. database_name = 'patenting in psis'
  10. database_connection = sqlalchemy.create_engine('mysql+mysqlconnector://{0}:{1}@{2}/{3}'.
  11. format(database_username, database_password,
  12. database_ip, database_name), pool_recycle=1, pool_timeout=30).connect()
  13.  
  14. df.to_sql(con=database_connection, name='sample', if_exists='replace')
  15. database_connection.close()
Add Comment
Please, Sign In to add comment