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()

score -1 · Answer 1 · answered Jul 03 '17 at 14:18

-1

You can of course use to_pickle()

answered Jul 03 '17 at 14:18

Binyamin Even

1

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 – nivniv Jul 03 '17 at 14:19
2

This doesn't answer the question at all. – episodeyang Aug 22 '18 at 21:39

1 Answers1