Create HTML table from 2 lists in python 3

Question

I have looked here but the solution is still not working out for me... I have 2 lists

list1 = ['src_table', 'error_response_code', 'error_count', 'max_dt']

list2 = ['src_periods_43200', 404, 21, datetime.datetime(2020, 5, 26, 21, 10, 7)',
         'src_periods_86400', 404, 19, datetime.datetime(2020, 5, 25, 21, 10, 7)']

The list1 carries the column names of the HTML table.

The second list2 carries the table data.

How do I generate the HTML table out of these 2 lists so that the first list is used for column names and the second as the table data (row-wise)

the result should be:

src_table          |  error_response_code  | error_count  | max_dt                  |
src_periods_43200  |  404                  | 21           | 2020-5-26    21:10:7    |
src_periods_43200  |  404                  | 19           | 2020-5-25    21:10:7    |

many thanks

Supun De Silva · Accepted Answer · 2020-05-28 01:57:17Z

1

This Should do it

import pandas as pd
import datetime

list1 = ['src_table', 'error_response_code', 'error_count', 'max_dt']

list2 = [
    'src_periods_43200', 404, 21, datetime.datetime(2020, 5, 26, 21, 10, 7),
    'src_periods_86400', 404, 19, datetime.datetime(2020, 5, 25, 21, 10, 7)
]


index_break = len(list1)
if len(list2) % index_break != 0:
    raise Exception('Not enough data.')

staged_list = []
current_list = []

for idx in range(0, len(list2)):
    current_list.append(list2[idx])

    if len(current_list) == index_break:
        staged_list.append(current_list.copy())
        current_list = []

df = pd.DataFrame(data=staged_list, columns=list1)

print(df.to_html())

edited May 28, 2020 at 1:57

answered May 27, 2020 at 23:47

Supun De Silva

1,48712 silver badges17 bronze badges

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

2 Comments

Shery Over a year ago

exactly what I was looking for... thanks... do you know how to add a little bit of formatting? @Supun De Silva

Supun De Silva Over a year ago

You can pass a list of css classes to .to_html() function as an array. i.e df.to_html(classes=['my-table-style']) Ref: pandas.pydata.org/pandas-docs/version/0.23.4/generated/…

Krzysiek 'Cookiez' Kukiz · Accepted Answer · 2020-05-27 23:28:24Z

0

You can easily write your function for that Something like:

import datetime

list1 = ['src_table', 'error_response_code', 'error_count', 'max_dt']

list2 = ['src_periods_43200', 404, 21, datetime.datetime(2020, 5, 26, 21, 10, 7), 'src_periods_86400', 404, 19, datetime.datetime(2020, 5, 25, 21, 10, 7)]

print('<table>')
print('<thead><tr>')
for li in list1:
    print(f'<th>{li}</th>')
print('</tr></thead>')
print('<tbody>')
for i in range(0, int(len(list2)/4)):
    print('<tr>')
    print(f'<td>{list2[4*i+0]}</td>')
    print(f'<td>{list2[4*i+1]}</td>')
    print(f'<td>{list2[4*i+2]}</td>')
    print(f'<td>{list2[4*i+3]}</td>')
    print('</tr>')
print('</tbody>')
print('</table>')

answered May 27, 2020 at 23:28

Krzysiek 'Cookiez' Kukiz

461 silver badge9 bronze badges

1 Comment

Krzysiek 'Cookiez' Kukiz Over a year ago

If you don't want to print it, you can make str+= ...., and then send it somewhere

Collectives™ on Stack Overflow

Create HTML table from 2 lists in python 3

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related