How to convert an SQL query result to a Pandas DataFrame in Python

Converting an SQL query result to a Pandas DataFrame creates a pandas.DataFrame object with the result of the SQL query.

Solution for How to convert an SQL query result to a Pandas DataFrame in Python : You can use pandas.read_sql() to convert SQL query results to a pandas data frame Call pandas.read_sql(query, connection) with query as an SQL query and connection as a database connection (or engine) object to convert the result of query to a pandas.DataFrame object. The given example uses sqlite3, but any database API that conforms to PEP 0249 can be used.


how-to-convert-an-sql-query-result-to-a-pandas-dataframe-in-python