pandas read json not working on MultiIndex

This is not implemented ATM, see the issue here: https://github.com/pydata/pandas/issues/4889.

You can simply reset the index first, e.g

df.reset_index().to_json(...)

and it will work.

Or you can just write json with orient = 'table'

df.to_json(path_or_buf='test.json', orient='table')

read multi_index json

pd.read_json('test.json', orient='table')

Related