Python SQLAlchemy Pandas

예제

from sqlalchemy.engine import create_engine

import pandas as pd 

oracle ='oracle+cx_oracle://scott:TIGER@localhost:1521/?service_name=XE'

engine = create_engine(oracle)

engine

df_post = pd.read_sql_query("SELECT * FROM post", engine)

df_post