How to conveniently convert paginate result to pandas DataFrame?

[tisonkun]

Said I fetch the pulls as:

    c = obtain_client()
    prs = c.paginate(
        c.rest.pulls.list,
        owner="apache",
        repo="pulsar",
        state="open")

Now prs is a generator of PullRequestSimple list. How can I convert it to a pandas DataFrame as:

   url id node_id ... draft
0 ... nnn mmm ... False
...

[tisonkun]

I just found a way now:

    c = obtain_client()
    prs = c.paginate(
        c.rest.pulls.list,
        owner="apache",
        repo="pulsar",
        state="open")
    df = pd.DataFrame([vars(pr) for pr in prs])

But I still wonder if we can provide some utilities to interoperate with pandas smoothly.

[yanyongyu]

githubkit uses pydantic model to serialize data. You can search for the way to convert pydantic models into pandas DataFrame. In the code above, you may change the vars(pr) into pr.dict(). More infomation about the usage, you can check the pydantic docs

[tisonkun]

@yanyongyu Thank you!