SQLalchemy interface in pandas.io

[wesm]

[wesm]

from "SQLAlchemy bridge" thread on pystatsmodels

def getattr_recursively(object, name):
   """Same as getattr() built-in, but first split *name* into parts
and
   descend into object hierarchy.

   Return *None* if any of the attributes along the way is *None*.

   """

   current_object = object
   for n in name.split('.'):
       try:
           current_object = getattr(current_object, n)
       except AttributeError as err:
           if current_object is None:
               break
           else:
               raise err
   return current_object


columns = ('age_id', 'is_working.value')
list_of_lists = [[getattr_recursively(row, col) for col in columns]
for row in qry_result]
data = DataFrame.from_records(list_of_lists, columns=columns)

[jreback]

closing in favor of master issue #4163