BUG: "styler.format.thousands" option doesn't work for integers

[vladpy8]

BUG: "styler.format.thousands" option doesn't work for integers

[attack68]

The above was not correct. The following works:

pd.set_option('styler.format.precision', 3)
pd.set_option('styler.format.thousands', "+")
pd.set_option('styler.format.decimal', "-")
df = pd.DataFrame([
    [10000.0, 20000],
    [30000.0, 40000]
])
df.style

as does

pd.set_option('styler.format.precision', 3)
pd.set_option('styler.format.thousands', "+")
pd.set_option('styler.format.decimal', "-") 
df = pd.DataFrame(data=[{'field': 1234567890}], dtype='int64',)
df.style

I misread your issue. The styler pandas options only impact the Styler class. These options are available for people who regularly use Styler. They do not impact DataFrame and the options associated with that class and any of its data input, wrangling, or (in your case) output methods. This is desired behaviour.
If your do not call .style you will not produce a Styler and these options will not apply.

[attack68]

Agreed. This needs fixing, also for decimal option.

The solution, I believe, is in style_render:

#edited out

change to:

#edited out

and replace all the defaultdicts with the new ddict.

Needs tests.

[mroeschke]

Yeah given the above it seems like the OP is the expected behavior so closing

[vladpy8]

The styler pandas options only impact the Styler class.

They do not impact DataFrame and the options associated with that class and any of its data input, wrangling, or (in your case) output methods.

I see, thank you!