How to fix an issue I have with pandas.json in Python?

Question

I am trying to run a code in Python.

I upload the libraries as follow:

import requests
import json
from datetime import datetime
import pandas as pd
import re
from pandas.io.json import json_normalize

And when I try to extract information from a web site I receive the following error:

C:\Users\Mike\anaconda3\lib\site-packages\ipykernel_launcher.py:1: FutureWarning: pandas.io.json.json_normalize is deprecated, use pandas.json_normalize instead
  """Entry point for launching an IPython kernel.

What am I doing wrong?

Answer 1

Pandas now contains the json_normalize functions as pandas.io.json is deprecated.

Replace this:

from pandas.io.json import json_normalize

With this:

from pandas import json_normalize

Answer 2

Delete from pandas.io.json import json_normalize from your imports, and replace json_normalize with pd.json_normalize in your code.