pgcom.commuter.Commuter.select

Commuter.select(cmd: Union[str, psycopg2.sql.Composed], values: Optional[Union[Sequence[Any], Mapping[str, Any]]] = None) → pandas.core.frame.DataFrame[source]

Read SQL query into a DataFrame.

Returns a DataFrame corresponding to the result of the query.

Parameters

  • cmd – string SQL query to be executed.

  • values – Parameters to pass to execute method.

Returns

Pandas.DataFrame.