python连接oracle数据库

import cx_Oracle
import pandas as pd
#引用模块cx_Oracle
'''
conn=cx_Oracle.connect('XXX/XXX@172.18.49.XXX:1521/orcl')    #连接数据库
c=conn.cursor()                                           #获取cursor
x=c.execute('select sysdate from dual')                   #使用cursor进行各种操作
print(x.fetchone())
c.close()                                                 #关闭cursor
conn.close() 

'''

from sqlalchemy import create_engine
sql="select * from TAXI_GPS where rownum=1"
engine = create_engine('oracle://XXX:XXX@172.18.49.XXX:1521/orcl')
data=pd.read_sql(sql,engine)
GPStrack=data.track
print(GPStrack.str.split(';')[0][1])
tmp=str(GPStrack.str.split(';')[0])
GPSdf=pd.DataFrame(GPStrack.str.split(';')[0])