Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- import sqlalchemy
- df=pd.read_excel(r"C:Usersmazin1-601.xlsx")
- database_username = 'root'
- database_password = 'aUtO1115'
- database_ip = '127.0.0.1'
- database_name = 'patenting in psis'
- database_connection = sqlalchemy.create_engine('mysql+mysqlconnector://{0}:{1}@{2}/{3}'.
- format(database_username, database_password,
- database_ip, database_name), pool_recycle=1, pool_timeout=30).connect()
- df.to_sql(con=database_connection, name='sample', if_exists='replace')
- database_connection.close()
Add Comment
Please, Sign In to add comment