Quick and dirty script to generate a html table from a json array

jsontable.py

from __future__ import print_function
import json
import tempfile
import sys
import os

data = json.load(sys.stdin)
cols = []

for item in data:
    for k, v in item.iteritems():
        if k not in cols:
            cols.append(k)

output = tempfile.NamedTemporaryFile(suffix = '.html', delete = False)

def p(text):
    print(text, file=output)

p("""
<style>
    * {
        font-family: sans-serif;
        font-size: 10pt;
    }
    table {
        border-collapse: collapse;
    }
    td {
        padding-left: 5px;
        padding-right: 5px;
        border: 1px solid #777;
    }
</style>
""")

p('<table>')
p('<thead>')
p('<tr>')
for c in cols:
    p('<td>{}</td>'.format(c))
p('</tr>')
p('<tbody>')
for item in data:
    p('<tr>')
    for k in cols:
        p('<td>{}</td>'.format(item[k] if k in item else ''))
    p('</tr>')
p('</tbody>')
output.close()

os.system("open {}".format(output.name))