How to read JSON file in Python using Pandas

You can read the JSON file in Python using Pandas with the following code. I highly recommend you This book to learn Python.

Read JSON File

# Import the Pandas libraray as pd
import pandas as pd

# Read json file
data = pd.read_json('Data.json', orient='index')

# Display the Data
print(data)

Output:

  Students  Scores
0    Harry      77
1     John      59
2  Hussain      88
3   Satish      93

Free Learning Resources