JSON - Serialize pandas dataframe with numpy arrays entries

Question

I have a pandas.DataFrame with numpy.ndarrays entries (of different sizes). How can I serialize it to json?

It seems that pandas doesn't support serialization of ndarrays at the moment:

pandas.DataFrame([{'a': numpy.array(1)}, {'a': numpy.array((1,2))}]).to_json()
TypeError: array(1) (0d array) is not JSON serializable at the moment

Closely related questions whose answers won't solve my problem:

Storing Dataframe with Array Entries: I can't use the nice trick there because my dataframe consists of arrays with varying sizes.

Convert numpy type to python: If there was a way to use MyEncoder in DataFrame.to_json()

Binyamin Even · Accepted Answer · 2017-07-03 14:18:30Z

-1

You can of course use to_pickle()

answered Jul 3, 2017 at 14:18

Binyamin Even

3,4021 gold badge22 silver badges54 bronze badges

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

2 Comments

True, but I would really prefer json as it is the most readable serialization I know. I updated now my question to be specifically about json. Thanks

This doesn't answer the question at all.