Pass nested JSON data into Html table format

Question

I am trying to create an HTML report which contains the field and its value over tabular Html format using python.

data.json

[
    {
      "count": 0,
      "company": "abc",
      "state": {
        "city": {}
      },
      "name": "Techno",
      "age": 17,
      "file": "cubix.so"
    },
    {
        "count": 12,
        "company": "def",
        "state": {
          "city": {}
        },
        "name": "Uni",
        "age": 8,
        "file": "cyp.so"
      }
]

The requirement is to read JSON and fetch the file, name, and age values to pass in the Html report file.

def all_details():
    company=0
    age=0
    with open("data.json") as file:
        data = json.loads(file.read())
        for obj in data:
            print(obj['company'], obj['age'])
            message+="""<tr><th style="border:1px solid black;">File Name</th><th style="border:1px solid black;">Company</th><th style="border:1px solid black;">Age</th>"""
            for name in obj[file]:
                message += """<tr><td style="border:1px solid black;">""" + name + "</td>"
                message += """<td style="border:1px solid black;">""" + company + "</td>"
                message += """<td style="border:1px solid black;">""" + age + "</td>"
                message += "</tr>"
            message+="</table>"
            f = open('file.html','w')
            f.write(message)
            f.close()

need the expected Output in file.html:

@KlausD. requirement is to get the JSON values as attached in image in tabular format — rowoc
– rowoc, Commented Aug 10, 2022 at 7:25
Well, that is still no question. You have to ask a specific question about programming. So far you posted a task and some code and did not provide any hint what is wrong with it. — Klaus D.
– Klaus D., Commented Aug 10, 2022 at 7:56

Ruban Bob · Accepted Answer · 2022-08-10 08:02:04Z

2

Approach 1: You can convert JSON to pandas data frames and from DF to html

import pandas as pd


df = pd.read_json('data.json')   # convert JSON to dataframe
df = df[["file","company","age"]] # select only required columns

html = df.to_html() # convert DF to html

print(html)

Approach 2 : your method - just corrected few errors

def all_details():
    with open("data.json") as file:
        data = json.loads(file.read())
        message ="<table>"
        message +="""<tr><th style="border:1px solid black;">File Name</th><th style="border:1px solid black;">Company</th><th style="border:1px solid black;">Age</th>"""
        for obj in data:
            print(obj)
            print(obj['company'], obj['age'])
            
            if "name" in obj:
                message += """<tr><td style="border:1px solid black;">""" +  str(obj['name']) + "</td>"
                message += """<td style="border:1px solid black;">""" + str(obj['company']) + "</td>"
                message += """<td style="border:1px solid black;">""" + str( obj['age']) + "</td>"
                message += "</tr>"
        message+="</table>"
        f = open('file.html','w')
        f.write(message)
        f.close()

edited Aug 10, 2022 at 8:02

answered Aug 10, 2022 at 7:39

Ruban Bob

777 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

rowoc Over a year ago

Without df approach

Ruban Bob Over a year ago

adding to same answer

Collectives™ on Stack Overflow

Pass nested JSON data into Html table format

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related