Pandas DataFrame styler HTML display without index?

Question

I have a pandas dataframe, I'm using the df.style object to make it highlight odd-numbered rows, so:

def highlight_oddRow(s):
    return ['background-color: yellow' if s.name % 2 else '' for v in s]

table = pd.DataFrame(
    {'a': [3,9,8,0,2], 'b': [5,95, 9, 25,5], 'c': [23,54, 2, 3,5], 'row': [1, 2, 3, 4, 5]})

with open ('out.html','w') as out:
    print >> out, table.style.apply(highlight_oddRow, axis=1).render()

However, this always prints out the index. Is there a way to tell it not to do this?

Tomas Farias · Accepted Answer · 2018-06-15 18:39:05Z

21

Since this is the first question that popped up when I searched for this issue on Stack Overflow, I thought it would be good to share a recent development: on Nov-17 a PR was committed to the pandas repo that added the hide_index method to styler objects.

You can just call it before render:

def highlight_oddRow(s):
    return ['background-color: yellow' if s.name % 2 else '' for v in s]

table = pd.DataFrame(
    {'a': [3,9,8,0,2], 'b': [5,95, 9, 25,5], 'c': [23,54, 2, 3,5], 'row': [1, 2, 3, 4, 5]})

with open ('out.html','w') as out:
    print >> out, table.style.apply(highlight_oddRow, axis=1).hide_index().render()

Keep in mind the docs still claim these features are provisional and subject to change. More info here: https://pandas.pydata.org/pandas-docs/stable/style.html#Hiding-the-Index-or-Columns.

answered Jun 15, 2018 at 18:39

Tomas Farias

1,3531 gold badge14 silver badges18 bronze badges

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

Comments

David Beauchemin · Accepted Answer · 2020-08-12 21:12:52Z

13

This can be done by using the hide_index() method such as below

print >> out, table.style.hide_index().apply(highlight_odd_row, axis=1).render()

edited Aug 12, 2020 at 21:12

David Beauchemin

2681 gold badge3 silver badges13 bronze badges

answered Feb 28, 2019 at 12:42

Sambhav Kumar Dash

2213 silver badges4 bronze badges

Comments

Sascha A. · Accepted Answer · 2020-08-12 09:50:49Z

I looked through the source code for pandas.formats.style.Styler, and couldn't find a super-easy way to do it. So instead here is a hacky way. Basically I tell the CSS for the table to not display elements with class row_heading and the top left empty box, which has classes blank level0.

import pandas as pd

def highlight_oddRow(s):
    return ['background-color: yellow' if s.name % 2 else '' for v in s]

table = pd.DataFrame(
    {'a': [3,9,8,0,2], 'b': [5,95, 9, 25,5], 'c': [23,54, 2, 3,5], 'row': [1, 2, 3, 4, 5]})

with open ('out.html','w') as out:
    # Get the styler for the table
    styler = table.style

    # Set the display to none for row headings, and the blank box in the top left corner for the column headings
    styler.set_table_styles(
        [{'selector': '.row_heading',
          'props': [('display', 'none')]},
         {'selector': '.blank.level0',
          'props': [('display', 'none')]}])

    print >> out, styler.apply(highlight_oddRow, axis=1).render()

The result:

Edward Ji · Accepted Answer · 2024-04-09 23:43:26Z

3

The documentation states that the hide_index method has been:

Deprecated since version 1.4.0: This method should be replaced by hide(axis="index", **kwargs)

The code is self-explanatory - it hides the indices. So, an updated solution for this question is:

def highlight_oddRow(s):
    return ['background-color: yellow' if s.name % 2 else '' for v in s]

table = pd.DataFrame({
    'a': [3,9,8,0,2],
    'b': [5,95, 9, 25,5],
    'c': [23,54, 2, 3,5],
    'row': [1, 2, 3, 4, 5]
})

with open("out.html", "w") as out:
    out.write(table.style
              .apply(highlight_oddRow, axis=1)
              .hide(axis="index")  # `hide_index()` was deprecated
              .to_html())          # `render()` was also deprecated

edited Apr 9, 2024 at 23:43

answered Sep 11, 2023 at 10:26

Edward Ji

80011 silver badges20 bronze badges

Comments

B-Rad · Accepted Answer · 2022-07-11 07:02:37Z

0

Maybe a cheat way of doing this, but you could always set one of the other columns of your dataframe as the index? e.g. DataFrame.set_index('a')

edited Jul 11, 2022 at 7:02

answered Jul 11, 2022 at 7:02

B-Rad

11 bronze badge

1 Comment

Community Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

Pandas DataFrame styler HTML display without index?

5 Answers 5

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related