ImportError: cannot import name 'json_normalize' from 'pandas.io.json'

Question

python 3.9.2-3
pandas 2.0.0
pandas-io           0.0.1

Error: 
from pandas.io.json import json_normalize
ImportError: cannot import name 'json_normalize' from 'pandas.io.json' (/home/casaos/.local/lib/python3.9/site-packages/pandas/io/json/__init__.py)

Apparently this was a problem early on in the pre 1x days of pandas, but seems to have resurfaced. Suggestions?

I'm running a script which was functional previously, but migrating it to a new host. It errors out on the line:

from pandas.io.json import json_normalize

and throws the error

ImportError: cannot import name 'json_normalize' from 'pandas.io.json' (/home/casaos/.local/lib/python3.9/site-packages/pandas/io/json/__init__.py)

I've attempted to reinstall pandas ('install' option), remove and reinstall, and 'install --force-reinstall' all performed as root so that the base install of python3 has it installed as opposed to a single user

pandas.io.json.json_normalize was deprecated and removed in the newest version. Use pandas.json_normalize. Also, the tutorial you were following is most probably severely outdated. You are on your own now. — Ξένη Γήινος
– Ξένη Γήινος, Commented Apr 23, 2023 at 7:48

Joe Greene · Accepted Answer · 2023-06-07 01:39:16Z

12

This was indeed the solution simply removing the import line. I'd have liked an attribute to check to determine the pandas version installed easily, but have to settle for a try:except: to determine if the import is needed.

pandas.io.json.json_normalize was deprecated and removed in the newest version. Use pandas.json_normalize. Also, the tutorial you were following is most probably severely outdated. You are on your own now. – Ξένη Γήινος Apr 23 at 7:48

answered Jun 7, 2023 at 1:39

Joe Greene

3511 gold badge2 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

cottontail · Accepted Answer · 2024-08-24 09:58:12Z

1

The pandas.io.json.json_normalize import has been deprecated since pandas 1.0.0 and was removed in pandas 2.0.0. Pandas 1.0.0 was released on Jan 30, 2020, and pandas.json_normalize has been a valid import since that date, so unless you're using an extremely old version of pandas, e.g. pandas<=0.25.3, you can safely remove the import from pandas.io.json import json_normalize from your code if it exists and replace function calls such as json_normalize(...) or pd.io.json.json_normalize(...) by pd.json_normalize(...).

answered Aug 24, 2024 at 9:58

cottontail

25.5k25 gold badges184 silver badges176 bronze badges

Collectives™ on Stack Overflow

ImportError: cannot import name 'json_normalize' from 'pandas.io.json'

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related