How to change numeric data format for html output

Question

I have code to produce a pandas dataframe and send email in html format.
The problem I have is hard to change the scientific format of numeric numbers to general in style

I already tried to set float format, but it did not work.

pd.options.display.float_format = '{:20,.2f}'.format

output:

Col A        Col B
1.00E+06    2.28E+06
3.00E+07    -2.54E+07

expected out:

Col A        Col B
1000420      2281190
30030200    -25383100

what if you convert them to string in the output you sent to email — Menglong Li
– Menglong Li, Commented Sep 12, 2017 at 16:11

pazqo · Accepted Answer · 2017-09-15 14:42:46Z

8

+25

I tried this and it worked:

df = pd.DataFrame([[3.371e17,9.82173e15],[8e12,8e8]],columns=['A','B'])

df.to_html(float_format='{:20,.2f}'.format)

This is not changing the formatting of df in general, just the html output, which is:

<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>A</th>
      <th>B</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>337,100,000,000,000,000.00</td>
      <td>9,821,730,000,000,000.00</td>
    </tr>
    <tr>
      <th>1</th>
      <td>8,000,000,000,000.00</td>
      <td>800,000,000.00</td>
    </tr>
  </tbody>
</table>

answered Sep 15, 2017 at 14:42

pazqo

4773 silver badges9 bronze badges

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

11 Comments

galaxyan Over a year ago

what is difference between your code and my post "pd.options.display.float_format = '{:20,.2f}'.format"

pazqo Over a year ago

You are setting the display option for every representation, not only the html dump. What you did worked for me, but is more pervasive. If this is not working, I need to know in which way is not working for you

galaxyan Over a year ago

any chance you saw my post. it is not working for the email I send out.

pazqo Over a year ago

In which way is it not working? What are you sending via e-mail?

galaxyan Over a year ago

I am using smtplib. the number in html table did not change the format even I set the format for float

|

Cedric Zoppolo · Accepted Answer · 2017-09-20 20:28:38Z

2

I couldn't reproduce your problem with the example you stated. It might be something that changes the dataframe format within your code. But I believe this code can help you:

import pandas as pd
df = pd.DataFrame({"Col A":[1000420, 30030200],"Col B": [2281190, -25383100]})
for col in df:
    df[col] = df[col].apply(lambda x: "%.f" % x)

With this you get as output:

>>> df
      Col A      Col B
0   1000420    2281190
1  30030200  -25383100

answered Sep 20, 2017 at 20:28

Cedric Zoppolo

4,7937 gold badges34 silver badges63 bronze badges

1 Comment

bhansa Over a year ago

I think this can help in OP's issue, since it returns the float values.

Collectives™ on Stack Overflow

How to change numeric data format for html output

2 Answers 2

11 Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

11 Comments

1 Comment

Related