How to make python list to html table

Question

I have this python list

result =[('921', 36638, None, None, 'ron', '28-SEP', 'platform'),
('921', 36637, None, None, 'john', '28-SEP', 'platform')]

The values in this list are dynamic. However the table header is always static.

Table header: 
Issue   Vers    created_on  Build   Author  Commit  Source_Name

I want to change this python output and make into a HTML table.

This is my work so far

z = import result
s =open(z)

table=['<htm><body><table border="1">']
for line in s.splitlines():
    if not line.strip():
        continue
    table.append(r'<tr><td>{}</td><td>{}</td></tr>'.format(*line.split('--- ')))

table.append('</table></body></html>')
print ''.join(table)

I am confused as to put the static header.Thanks

hiro protagonist · Accepted Answer · 2018-10-03 06:50:26Z

3

this may be a case for a jinja template:

from jinja2 import Template

t = Template('''
<html>
  <body>
    <table border="1">

      <tr>
      {%- for col in header %}
        <td>{{col}}</td>
      {%- endfor %}
      </tr>

      {% for row in rows -%}
      <tr>
      {%- for col in row %}
        <td>{{col if col is not none else '' }}</td> 
      {%- endfor %}
      </tr>
      {% endfor %}

    </table>
  </body>
</html>
''')


header = 'Issue Vers created_on Build Author Commit Source_Name'.split()
rows = [('921', 36638, None, None, 'ron', '28-SEP', 'platform'),
        ('921', 36637, None, None, 'john', '28-SEP', 'platform')]

strg = t.render(header=header, rows=rows)

if you do not want the Nones printed in your table, you can replace {{col}} with {{col if col is not none else '' }}.

edited Oct 3, 2018 at 6:50

answered Oct 3, 2018 at 6:37

hiro protagonist

47.3k17 gold badges93 silver badges119 bronze badges

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

Collectives™ on Stack Overflow

How to make python list to html table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related