I think what you need to do is to ensure you're getting a structured Json output. Then once you get that, you can flatten it can convert it to python with some python codes.

Expecting agents to give you direct dataframe as output might not work well.