如何使用pandas DataFrame.style? [英] How do I use pandas DataFrame.style?

问题描述

我正在尝试使用新包含的'style '在熊猫0.19中.我正在尝试使用完全相同的脚本来复制相同的内容，但得到了一个Styler对象.

I am trying to format my dataframe in HTML using the newly included 'style' in Pandas 0.19. I am trying to replicate the same things using the exact same scripts but I get a Styler object.

>>> df
              Security       Price  Change Percentage  ChgNetValue  LastClose
10     Japan Five-Year   -0.207000          -4.020000    -0.008000  -0.199000
13        U.S. 10-Year   97.406250        5274.434452    95.593850   1.812500
20        U.S. 30-Year   93.156250        3481.253980    90.555031   2.601562
23      U.S. 3M T-Bill    0.355000          -2.068966    -0.007500   0.362500
31      U.S. Five-Year  100.015625        7803.952347    98.750237   1.265625
36  Eurozone Five-Year   -0.423000          -3.171000    -0.013000  -0.410000
43       U.S. Two-Year   99.898438       12271.036276    99.090919  25.875000
44      U.K. Five-Year    0.529000          -3.114000    -0.017000   0.546000    
>>> df.style
    <pandas.formats.style.Styler object at 0x0000000008133F28>
>>> s = df.style.applymap(color_negative_red)
>>> s
    <pandas.formats.style.Styler object at 0x00000000035116A0>

我具有与文档中完全相同的功能color_negative_red.我是在Eclipse中执行此操作，而不是IPython.

I have the exact same function, color_negative_red, as in the documentation. I am doing this in Eclipse, not IPython.

我想要的是使用to_html()并将条件格式应用于数据框中的每个数字.有更好的方法吗?

What I want is to use to_html() and apply conditional formatting to each number in the dataframe. Is there a better way to do this?

推荐答案

请参见下面的说明Out [2]

See the note below Out [2] here. Styler objects define a _repr_html_ which renders the HTML in the notebook.

要获取实际的HTML字符串，请调用styler.render().

To get the actual HTML string, you call styler.render().

这篇关于如何使用pandas DataFrame.style?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！