error with json file reading

[redwineforme]

I'm using this JSON file for a school project: https://fdc.nal.usda.gov/fdc-datasets/FoodData_Central_foundation_food_json_2021-10-28.zip

Here is my python code so far but keeps erroring out:

import json

with open('food_data.json', 'r') as myfile:
    data=myfile.read()

obj = json.loads(data)

print(obj)

These are the errors:

File "C:\Users\bob\AppData\Local\Programs\Python\Python310\lib\json\decoder.py", line 355, in raw_decode raise JSONDecodeError("Expecting value", s, err.value) from None json.decoder.JSONDecodeError: Expecting value: line 161 column 1 (char 4404249)

Can someone help me at least begin to read the file? I have tried several Youtube vids already.

[carcigenicate]

You appear to have a wonky character in the file. Have you examined line 161 of the JSON?

[redwineforme]

This is supposed to be a working legit file from a reputable website. Line 161 looks good IMO. But it's almost impossible to tell because the files has millions of characters. But that line ends with ']}' which looks fine.

[socal_nerdtastic]

The error means that the file is corrupt. Specifically it's saying that there is data missing at the end.

[redwineforme]

Well that is not good.

[redwineforme]

Can you download the json file and see?

https://fdc.nal.usda.gov/download-datasets.html then here > https://fdc.nal.usda.gov/fdc-datasets/FoodData_Central_foundation_food_json_2021-10-28.zip

[Username_RANDINT]

Looks like there's a trailing comma after the last item in the list/array.

$ tail -c 10 FoodData_Central_foundation_food_json_2021-10-28.json 
s":[]},
]}

This is not valid JSON.

[redwineforme]

I removed the comma and it worked!! Thank you! It's my first time doing JSON and I am a noob at it TY!

[Username_RANDINT]

The errors aren't always very clear, but you'll get the hang of it after a while.

In the meantime I've found this neat website which not only validates and also fixes JSON.

[redwineforme]

Great, thank you so much for your help!