Exporting Sql Query Results To Pandas Dataframe

id date temp prcp 1 2015-01-01 -27.18 0 1 2015-01-02 -25.9 1.03 1 2015-01-03 -17.89 9.44 1 2015-01-04 -17.89 9.44 1 2015-01-05 -1

Solution 1:

You could do something like this:

import sqlite3
   import pandas as pdcon= sqlite3.connect('path_to_your_sql')
   myFrames = pd.read_sql_query('your query', con)

Edit: for non sqlite db you could use this for the connection:

from sqlalchemy importcreate_enginecon= create_engine('dialect+driver://username:password@host:port/database')

docs for create_engine