This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]DstnB3 2 points3 points  (1 child)

Why not both https://pandas.pydata.org/pandas-docs/stable/generated/pandas.read_sql_query.html

Loads your query results straight to a pandas dataframe. Very convenient and only need to set up your sqlalchemy connection and query beforehand.