I have a large (2GB)and messy json file and when I try to load it in pandas I get an error:
Error = “All arrays must be of the same length”
Can anyone recommend a tool I can use to inspect and clean up json so I can tidy up the source json file?
Have you looked at any of the online tools? I saw this one and thought it might be hopeful.
@PHolder you are the best! Thank you! I will keep this in mind. My file is 2GB+ of json so I am going to need a installable utility.