Pandas TypeError: Object of type DataFrame is not JSON serializable

Question

I want to create a pandas DataFrame from a query_set.QuerySet object but when I go for:

df = pd.DataFrame.from_dict(res)

res being the query set, I get the following error:

TypeError: Object of type DataFrame is not JSON serializable.

What can I do to fix it? Thanks in advance!

Reza Behzadpour · Accepted Answer · 2020-07-25 08:43:03Z

1

Assuming it's Django's QuerySet you can use the following code:

df = pd.DataFrame.from_dict(res.values())

queryset.values() returns list of dicts.

You can find more information at this link.

Reza Behzadpour

7105 silver badges19 bronze badges

answered Jul 24, 2020 at 21:10

icaine

4744 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1