Re: [sqlalchemy] TableProxy equivalent to RowProxies

2019-10-28 Thread sumau
Crystal clear thanks! -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this

Re: [sqlalchemy] TableProxy equivalent to RowProxies

2019-10-28 Thread Mike Bayer
On Sun, Oct 27, 2019, at 2:48 PM, Soumaya Mauthoor wrote: > With a dataframe you can do df.columns to get the column labels and > df[["col1","col2"]] to extract column1 and column2 I'm going to guess this means that you're getting the col1/col2 from multiple rows at once. In python we use a

Re: [sqlalchemy] TableProxy equivalent to RowProxies

2019-10-27 Thread Soumaya Mauthoor
With a dataframe you can do df.columns to get the column labels and df[["col1","col2"]] to extract column1 and column2 rowProxy has similar functionality as explained before However if I use s= fetchmany() I return a string and it's not possible to do the equivalent s.keys() and s["col1"]. On Su

Re: [sqlalchemy] TableProxy equivalent to RowProxies

2019-10-27 Thread Mike Bayer
On Sun, Oct 27, 2019, at 7:06 AM, sumau wrote: > RowProxy have useful functionality like row.keys() and row['column'] > > If I use fetchmany/fetchall I return a list of RowProxies. Is the best way of > keeping the functionality of RowProxies to convert the list to a pandas data > frame? Are th

[sqlalchemy] TableProxy equivalent to RowProxies

2019-10-27 Thread sumau
RowProxy have useful functionality like row.keys() and row['column'] If I use fetchmany/fetchall I return a list of RowProxies. Is the best way of keeping the functionality of RowProxies to convert the list to a pandas data frame? Are there any plans to create "Table"Proxy equivalent to RowProxy