BUG: `All arrays must be of the same length` fatal error using `pd.read_json()` about pandas

[Aloqeely]

Thanks for your report! It will be hard to guess what is causing the error since that JSON file is not small.
Could you provide a simpler JSON file that reproduces the error and show why it is a valid JSON object to pass to pd.read_json?

[kuhlaid]

This is a shorter version of the JSON than what I am trying to use. I'm not aware of any different versions or exceptions for JSON validation. I'm only using a validator such as https://jsonlint.com/.

[Aloqeely]

Ah, I see.
Your file is in fact a valid JSON file, but I was talking about whether it is appropriate to pass it to a DataFrame.
Maybe you want to parse it to a dictionary instead? You can do that using the json module.

[kuhlaid]

This is more of a documentation issue than anything or maybe changing the error text is more appropriate. Maybe saying All arrays must be of the same length. Check that your JSON is appropriately organized for conversion to a Dataframe. In other words, the documentation seems to suggest that the read_json function will process any JSON, which it is not meant to do.

[kuhlaid]

Just consider changing the documentation to note the appropriate JSON organization for Dataframes since the organization of the JSON matters. :)