How do I set the column width when using pandas.DataFrame.to_html?

Question

I have read this, but I am still confused about how I set the column width when using pandas.DataFrame.to_html.

import datetime
import pandas

data = {'Los Angles': {datetime.date(2018, 9, 24): 20.5, datetime.date(2018, 9, 25): 1517.1},
        'London': {datetime.date(2018, 9, 24): 0, datetime.date(2018, 9, 25): 1767.4},
        'Kansas City': {datetime.date(2018, 9, 24): 10, datetime.date(2018, 9, 25): 1.4}}

df = pandas.DataFrame(data=data)

html = df.to_html()

The above code results in :

How do I go about forcing the column width so that they are the same?

Irfanuddin · Accepted Answer · 2018-09-30 19:52:29Z

28

Try this:

import datetime
import pandas

data = {'Los Angles': {datetime.date(2018, 9, 24): 20.5, datetime.date(2018, 9, 25): 1517.1},
        'London': {datetime.date(2018, 9, 24): 0, datetime.date(2018, 9, 25): 1767.4},
        'Kansas City': {datetime.date(2018, 9, 24): 10, datetime.date(2018, 9, 25): 1.4}}

df = pandas.DataFrame(data=data)
pandas.set_option('display.max_colwidth', 40)

html = df.to_html()

edited Sep 30, 2018 at 19:52

answered Sep 30, 2018 at 17:42

Irfanuddin

2,6353 gold badges18 silver badges29 bronze badges

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

2 Comments

Irfanuddin Over a year ago

I have edited the answer, see if it works. Also you can read more here and here

fazistinho_ Over a year ago

the max_colwidth property doesn't help to set the minimum column width, which is often an issue for columns that wrap around. Is there anyway to fix that? Thank you. I have read the link you have above and it doesn't address this at all.

bender · Accepted Answer · 2020-05-12 13:40:29Z

4

I find it better to use the set_table_attributes function. You are then able to set e.g. a CSS-class to the table. In case you have many tables on your output it is much better readable.

import datetime
import pandas

data = {'Los Angles': {datetime.date(2018, 9, 24): 20.5, datetime.date(2018, 9, 25): 1517.1},
        'London': {datetime.date(2018, 9, 24): 0, datetime.date(2018, 9, 25): 1767.4},
        'Kansas City': {datetime.date(2018, 9, 24): 10, datetime.date(2018, 9, 25): 1.4}}

df = pandas.DataFrame(data=data)

html = df.set_table_attributes('class="table-style"').to_html()

Your CSS could look something like that:

    .table-style {
                  width: 100%;
}

    .table-style td {
                  width: 100px;
}

answered May 12, 2020 at 13:40

bender

513 bronze badges

2 Comments

rpb Over a year ago

Hi @bender, may I know where should I place the .table-style in the code?

bender Over a year ago

Hey, your CSS goes either in a css-file (which is e.g. called style.css) and is linked in the head-section of your HTML file or you can place your css directly in the head-section of the HTML file. The former is cleaner. I normally use first the latter version and when things get complicated/huge switch to the cleaner version with CSS code in a different file. Here's a description of how to implement CSS: w3schools.com/Css/css_howto.asp

LuWil · Accepted Answer · 2022-06-23 10:38:09Z

2

Another option is

df.style.set_table_styles([dict(selector='th', props='min-width: 60px;'),])

answered Jun 23, 2022 at 10:38

LuWil

563 bronze badges

Comments

mh-anwar · Accepted Answer · 2021-08-24 16:30:05Z

1

You can now set the col_space argument of to_html. col_space specifies the min width of all the columns.

df.to_html(col_space='75px')

edited Aug 24, 2021 at 16:30

mh-anwar

1514 silver badges12 bronze badges

answered May 19, 2021 at 11:56

Jamie

1467 bronze badges

Collectives™ on Stack Overflow

How do I set the column width when using pandas.DataFrame.to_html?

4 Answers 4

2 Comments

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related