If you have json object and you want print the json object in table format, then you are the right place.
Though I didn't wrote any module, I found one which can help.
There is a module named pytablewriter. You can use that module to print your json object in many formats, checkout their documenration for more information.
Now let's get into business.
Lets say you have a json object like below
obj = [{
'name':
'Fix PRB',
'project':
'PRB',
'status':
'New',
'category':
'work',
'created_on':
'2021-05-13 19:29:39.023231'}, {
'name':
'catalog_broken',
'project':
'zoom',
'status':
'New',
'category':
'work',
'created_on':
'2021-05-13 19:54:42.109463'}]
We need to build couple of parameters first. Create 3 variables with names as table_name, headers, value_matrix.
table_name =
"Todo List"
# this will not print, its just needed.
headers = []
value_matrix = []
Now lets extract keys and values from given json object.
headers = list(obj[
0].keys())
for item
in obj:
value_matrix.append(list(item.values()))
So we built the needed data, now lets print it.
from pytablewriter
import UnicodeTableWriter
writer = UnicodeTableWriter( table_name = table_name, headers = headers, value_matrix = value_matrix )
writer.write_table()
┌──────────────┬───────┬──────┬────────┬──────────────────────────┐
│ name │project│status│category│ created_on │
├──────────────┼───────┼──────┼────────┼──────────────────────────┤
│Fix PRB │PRB │New │work │
2021
-05
-13
19:
29:
├──────────────┼───────┼──────┼────────┼──────────────────────────┤
│catalog_broken│zoom │New │work │
2021
-05
-13
19:
54:
└──────────────┴───────┴──────┴────────┴──────────────────────────┘
And that's it. It will create a table with give json object. Check the pytablewriter documentation for more options.
So I have created a fucntion which you use if you needed in case
def
pyTablePrinter
(json_obj, table_name=
"Todo List")
:
table_name = table_name
headers = []
value_matrix = []
headers = list(json_obj[
0].keys())
for item
in json_obj :
value_matrix.append(list(item.values()))
writer = UnicodeTableWriter( table_name = table_name, headers = headers, value_matrix = value_matrix )
writer.write_table()
Hope it helps.
Thank you
Raja G
