Question: How to create a table name when converting a dataframe to html file in Python? In Python, I create a new dataframe and save it
How to create a table name when converting a dataframe to html file in Python?
In Python, I create a new dataframe and save it as html file using the following code:
html = df.to_html()
text_file = open("summary.html", "w") text_file.write(html) text_file.close()
After that, I will get a file which looks like the following.
And the HTML code is:
'
| Equity with Loan Value total dollar value | Initial Margin total dollar value | Excess Liquidity total dollar value | Margin(Initial Margin/ Equity with Loan Value) | |
|---|---|---|---|---|
| Morries | 52,321,711 USD | 17,104,372 USD | 35,240,636 USD | 0.33 |
| Bruce | 10,453,883 USD | 2,945,544 USD | 7,522,473 USD | 0.28 |
| Grand Total | 62,775,594 USD | 20,049,916 USD | 42,763,109 USD | 0.32 |
'
What I want to do, is to add a Title like "Summary" in the final HTML document, on the top of the table, which needs to be Centred.
What should I do? Is there any functions can do that in the to_html() function?
Thanks
Equity with Loan Value total dollar value Initial Margin total dollar value Excess Liquidity total dollar value Margin(Initial Margin/ Equity with Loan Value) Morries 52,321,711 USD 17,104,372 USD 35,240,636 USD 0.33 Bruce ||10,453,883 USD |(2,945,544 USD 17,522,473 USD 0.28 Grand Total|62,775,594 USD 20,049,916 USD |42,763,109 USD 0.32
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
