Example of executing and reading a query into a pandas dataframe

cx_oracle_to_pandas.py

import cx_Oracle
import pandas

connection = cx_Oracle.connect('username/pwd@host:port/dbname')

def read_query(connection, query):
    cursor = connection.cursor()
    try:
        cursor.execute( query )
        names = [ x[0] for x in cursor.description]
        rows = cursor.fetchall()
        return pandas.DataFrame( rows, columns=names)
    finally:
        if cursor is not None:
            cursor.close()

It works also for jaydebeapi for fetching data from hive using JDBC driver. Thanks