[Sqlalchemy-tickets] Issue #3542: Design for Pandas access to Query (zzzeek/sqlalchemy)
Brought to you by:
zzzeek
|
From: Maximilian R. <iss...@bi...> - 2015-09-24 14:04:12
|
New issue 3542: Design for Pandas access to Query https://bitbucket.org/zzzeek/sqlalchemy/issues/3542/design-for-pandas-access-to-query Maximilian Roos: Over at Pandas, there's a question on the best way to load a pandas DataFrame from a SQLAlchemy Query object. https://github.com/pydata/pandas/issues/11181#issuecomment-142915059 Do you have any guidance on what the design should be? Currently something like `pd.read_sql_query(Query().selectable, engine)` or `pd.read_sql(query.statement, query.session.bind)` will work. But is there a better way that we could add to pandas, vs just executing the SQL string? [SO question](http://stackoverflow.com/questions/29525808/sqlalchemy-orm-conversion-to-pandas-dataframe) Thanks |