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 Sun, 27 Oct 2019, 14:48 Mike Bayer, <[email protected]> wrote: > > > 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 there any plans to create "Table"Proxy equivalent to > RowProxy? > > > > The "row proxy" is no longer a "proxy" in 1.4, however this is an > implementation detail that won't be noticable. > > The table equivalent is the Table object. Just like the Row(Proxy) > represents a row in a database fetched over, Table represents the structure > of the Table, which can be fetched over if you use Table(..., > autoload_with=connection). > > What this has to do with a dataframe, not really sure, which suggests this > is not really what you're asking, so, would use some more specifics. > > > > > -- > 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 message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/sqlalchemy/1d279f8b-f95a-49a9-b724-b12cc520c616%40googlegroups.com > . > > > -- > 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 message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/sqlalchemy/c0ad4211-6677-4cdd-bd14-92d9899b2c30%40www.fastmail.com > <https://groups.google.com/d/msgid/sqlalchemy/c0ad4211-6677-4cdd-bd14-92d9899b2c30%40www.fastmail.com?utm_medium=email&utm_source=footer> > . > -- 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 message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/CAN14jWRyWKkP_gVKvt1-QxLnkkrTeBvi6mWxVtoRuFdEe9FOTg%40mail.gmail.com.
