Skip to main content

select_df

Select rows from a table and return a pandas DataFrame.

Parameters

NameDescriptionTypeDefault
table (required)Name of the table to select from.strNone
whereDictionary of conditions for the WHERE clause.dictNone
order_byColumn name to order by.strNone
order_descWhether to order in descending order. Defaults to False.boolFalse
limitMaximum number of rows to return.intNone
offsetNumber of rows to skip. pandas.DataFrame: DataFrame containing the rows matching the query.intNone