Error when trying to import from Database with Pandas and SQLAlchemy
Question: I am using portable python 2.7.6.1 and I want to import a query from an oracle
database into python pandas. I have searched a couple of examples and came up
with the following code:

    
    
    from sqlalchemy import create_engine
    import pandas as pd
    
    engine = create_engine('oracle://user:pass@host:port/schema', echo=False)
    df = pd.read_sql('select * from databasetable', engine, index_col = index)
    
    print df.describe()
    

The program stops at the 'pd.read_sql'-statement with this Error Message:

    
    
    AttributeError: 'module' object has no attribute 'read_sql'
    

The Database connection is working and according to the examples this code
should work. Can anyone help?


Answer: The pandas module imports read_sql from a submodule; you could try getting it
from the submodule:

    
    
    df = pd.io.sql.read_sql('select * from databasetable', engine, index_col = index)
    

You could also print `pd.__dict__` to see what's available in the `pd` module.
Do you get `AttributeError` if you try to use other things from the `pd`
module, for example, `pd.Series()`?

