Python 3 Read and Print API JSON Data in Table Format

Hello guy’s welcome back to my blog. Today in this blog post, I will tell you, Python 3 Read and Print API JSON Data in Table Format.

Guy’s in this post, I have used python 3.9.6 version.

Working Video

**Python 3 Read and Print API JSON Data in Table Format**

Here is the working video for how to install pandas in python 3.9.6:

Install pandas in python

Guy’s if you are new in Python then please check below link for more Python tutorials:

Python Tutorials

Guy’s here is the working code snippet and please use it carefully:

1. Guy’s very first we need to installed python latest version and I have installed python 3.9.6 version. From below link please download the python latest version:

https://www.python.org/downloads/

2. Now guy’s create empty folder name `demo`(optional) in your system’s any drive and inside demo folder create `HelloWorld.py` and add below code inside it:

import json
import pandas as pd
from urllib.request import urlopen
# store the URL in url as 
# parameter for urlopen
url = "https://www.testjsonapi.com/users/"
  
# store the response of URL
response = urlopen(url)
# Opening JSON file
#f = open(response.read())
  
# returns JSON object as 
# a dictionary
data = json.loads(response.read())
  
df = pd.DataFrame(data)

print(df)
 
# Closing file
response.close()

3. Now guy’s inside your project terminal run below command and run your first python program:

py HelloWorld.py

This is it guy’s. Guy’s if you have any kind of query then please comment below. Guy’s I will come with more demos soon.

For better live working experience please check the above working video.

I will appreciate that if you will tell your views for this post. Nothing matters if your views will be good or bad because with your views, I will make my next posts more good and helpful.

Jassa

Thanks

Tags:Python