namedtuple + pandas

namedtuple_pandas.py

import pandas as pd
from collections import namedtuple

Employee = namedtuple("Employee", "name, id")

employees = []
next_employee = some_api_query("first")
while next_employee:
    employees.append(Employee(name=next_employee.first_name + " " + next_employee.last_name,
                              id=next_employee.id))
    next_employee = next_employee.next
    
employees_df = pd.DataFrame(data=employees)