evadb.EvaDBQuery.df#

EvaDBQuery.df(drop_alias: bool = True) → DataFrame[source]#

Execute and fetch all rows as a pandas DataFrame

Parameters:: drop_alias (bool) – whether to drop the table name in the output dataframe. Default: True.
Return type:: pandas.DataFrame

Example:

Runs a SQL query and get a panda Dataframe.

>>> cursor.query("SELECT * FROM MyTable;").df()
    col1  col2
0      1     2
1      3     4
2      5     6