Get pandas dataframes from lists of alpaca objects

[Derek]

While not a built-in function. I saw a solution from nad that I’ve found very useful. You flatten the object by calling vars(object) on it first. Then handle the indexing as you roll up the dataframe:

@nad

    orders = api.list_orders(status='all', limit=orderTotal, after=today)
    if not orders:
        return
    dfOrders = pd.DataFrame()
    for o in orders:
        # convert dot notation to dict
        d = vars(o)
        # import dict into dataframe
        df = pd.DataFrame.from_dict(d, orient='index')
        # append to dataframe
        dfOrders = dfOrders.append(df, ignore_index=True)