Categories

Wednesday, May 29, 2024
#919814419350 therichposts@gmail.com
Python

Python 3 Read and Print API JSON Data in Table Format

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
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:

  1. 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

therichpost
the authortherichpost
Hello to all. Welcome to therichpost.com. Myself Ajay Malhotra and I am freelance full stack developer. I love coding. I know WordPress, Core php, Angularjs, Angular 14, Angular 15, Angular 16, Angular 17, Bootstrap 5, Nodejs, Laravel, Codeigniter, Shopify, Squarespace, jQuery, Google Map Api, Vuejs, Reactjs, Big commerce etc.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.