How to format IPython html display of Pandas dataframe?

by

HTML receives a custom string of html data. Nobody forbids you to pass in a style tag with the custom CSS style for the .dataframe class (which the to_html method adds to the table).

So the simplest solution would be to just add a style and concatenate it with the output of the df.to_html:

style="<style>.dataframe td { text-align: right; }</style>"
HTML( style + df.to_html( formatters=frmt ) )

But I would suggest to define a custom class for a DataFrame since this will change the style of all the tables in your notebook (style is “global”).

style="<style>.right_aligned_df td { text-align: right; }</style>"
HTML(style + df.to_html(formatters=frmt, classes="right_aligned_df"))

You can also define the style in one of the previous cells, and then just set the classes parameter of the to_html method:

# Some cell at the begining of the notebook
In [2]: HTML('''<style>
                    .right_aligned_df td { text-align: right; }
                    .left_aligned_df td { text-align: right; }
                    .pink_df { background-color: pink; }
                </style>''')

...

# Much later in your notebook
In [66]: HTML(df.to_html(classes="pink_df"))

More Related Contents:

  1. How to display pandas DataFrame of floats using a format string for columns?
  2. How can I display full (non-truncated) dataframe information in HTML when converting from Pandas dataframe to HTML?
  3. How to embed HTML into IPython output?
  4. Progress indicator during pandas operations
  5. Pandas to_html() truncates string contents
  6. Selection with .loc in python
  7. Coloring Cells in Pandas
  8. How to dynamically update a plot in a loop in IPython notebook (within one cell)
  9. How to read a .xlsx file using the pandas Library in iPython?
  10. How to iterate over consecutive chunks of Pandas dataframe efficiently
  11. pandas read_html ValueError: No tables found
  12. How to show a bar and line graph on the same plot
  13. Change the color of text within a pandas dataframe html table python using styles and css
  14. pd.read_html() imports a list rather than a dataframe
  15. Replacing values represented by 'UN' with NaN
  16. Pandas: convert categories to numbers
  17. Pandas – Plotting a stacked Bar Chart
  18. pandas select from Dataframe using startswith
  19. What’s the fastest way in Python to calculate cosine similarity given sparse matrix data?
  20. How to give a pandas/matplotlib bar graph custom colors
  21. Import multiple excel files into python pandas and concatenate them into one dataframe
  22. Pandas dataframe with multiindex column – merge levels
  23. Plotting multiple lines, in different colors, with pandas dataframe
  24. Pandas dataframe total row
  25. How do I get interactive plots again in Spyder/IPython/matplotlib?
  26. Converting strings to floats in a DataFrame
  27. How to combine multiple rows into a single row with pandas [duplicate]
  28. How to replace a value in pandas, with NaN?
  29. DataFrame with MultiIndex to dict
  30. Pandas: Nesting Dataframes

Leave a Comment