csv to html table (pandas) - formatting problem

Question

I have a simple .csv containing room numbers and the types of equipment in the room. It looks like this:

room1,[computer]
room2,[computer, printer, fax]
room3,[computer, printer, fax, keurig, shredder]
room4,[computer, fax]

I can easily generate an html table using the pd.to_html function, but the equipment list is formatted in such a way that it is all on a single line. I would like it to look like this:

room1   computer
room2   computer
        printer
        fax
room3   computer
        printer
        fax
        keurig
        shredder

I've tried various options in the pd.to_html function but nothing is working. Is there an easy way to apply a word wrap here at the commas?

user_9163366 · Answer

This might work for you - use a formatter to replace the commas with line breaks in the second column and use escape=False in the .to_html() method:

import pandas as pd
from io import StringIO
from IPython.core.display import display, HTML

with open('test.csv', 'r') as f:
    data = f.read().replace('[', '"').replace(']', '"')

df = pd.read_csv(StringIO(data), header=None)

html_df = df.to_html(index=False, header=False, escape=False,
                    formatters=[None, lambda x: x.replace(', ', '
')])

display(HTML(html_df))

Output:

            room1       computer     
          room2       computer
printer
fax     
          room3       computer
printer
fax
keurig
shredder     
          room4       computer
fax

csv to html table (pandas) - formatting problem

1 Answers