Misleading error messages when opening inexistent json file

[datapythonista]

When opening a json file that doesn't exist with read_json, we get a ValueError with error messages like:

>>> import pandas
>>> pandas.read_json('no_file.json')
ValueError: Unexpected character found when decoding 'null'

>>> pandas.read_json('a_dir/no_file.json')
ValueError: Expected object or value

It'd probably be better to raise an exception like:

FileNotFoundError: No such file: 'no_file.json'

[mohitanand001]

Hi, @datapythonista can I take this up?

[datapythonista]

sure, thanks

[deepandas11]

Hi! Would like to work on this if it is still open.

[sathyz]

take

[kevin-meyers]

Hey @sathyz if you don't finish it by the end of the month I think I'll give it a shot.

[devjeetr]

take