pretty_html_table exists to convert a pandas DataFrame into a pretty html table for use in email. The intended target audience is anyone who needs to send reports via email and would like to make their tables look more attractive.
12 different color themes are available. The output of the package embeds nicely with other packages used to send html emails, such as email or O365. The html formatting is set at the DataFrame row level, which allows nearly every email provider to parse it. This obviates the need to grok out how the CSS may interact with the sending/recieving email provider.
Use pip to install the package:
pip install pretty_html_table
A simple example to load an Excel file to a pandas DataFrame, convert it to html, and then save to an html file:
from pretty_html_table import build_table
df = pd.read_excel('df.xlsx')
html_table_blue_light = build_table(df, 'blue_light')
# Save to html file
with open('pretty_table.html', 'w') as f:
f.write(html_table_blue_light)
# Compare to the pandas .to_html method:
with open('pandas_table.html', 'w') as f:
f.write(df.to_html())
Use any browser to open pretty_table.html to see how the table would appear in an html email.
Output is ready to be sent via any Python package used to send emails. Insert the result of this package to the body of the email and voila.
| Name | font style | Header | Rows |
|---|---|---|---|
| 'blue_light' | Century Gothic | Bold: yes / Background color: white / Font color: dark blue | Odd background color: light blue / Even background color: white |
| 'blue_dark' | Century Gothic | Bold: yes / Background color: dark blue / Font color: white | Odd background color: light blue / Even background color: white |
| 'grey_light' | Century Gothic | Bold: yes / Background color: white / Font color: dark grey | Odd background color: light grey / Even background color: white |
| 'grey_dark' | Century Gothic | Bold: yes / Background color: dark grey / Font color: white | Odd background color: light grey / Even background color: white |
| 'orange_light' | Century Gothic | Bold: yes / Background color: white / Font color: dark orange | Odd background color: light orange / Even background color: white |
| 'orange_dark' | Century Gothic | Bold: yes / Background color: dark orange / Font color: white | Odd background color: light orange / Even background color: white |
| 'yellow_light' | Century Gothic | Bold: yes / Background color: white / Font color: dark yellow | Odd background color: light yellow / Even background color: white |
| 'yellow_dark' | Century Gothic | Bold: yes / Background color: dark yellow / Font color: white | Odd background color: light yellow / Even background color: white |
| 'green_light' | Century Gothic | Bold: yes / Background color: white / Font color: dark green | Odd background color: light green / Even background color: white |
| 'green_dark' | Century Gothic | Bold: yes / Background color: dark green / Font color: white | Odd background color: light green / Even background color: white |
| 'red_light' | Century Gothic | Bold: yes / Background color: white / Font color: dark red | Odd background color: light red / Even background color: white |
| 'red_dark' | Century Gothic | Bold: yes / Background color: dark red / Font color: white | Odd background color: light red / Even background color: white |
First, create a function to send an email:
from O365 import Account
# Never hard code credentials or store them in a repo
# Use environmental variables instead
credentials = (o365credid, o365credpwd)
account = Account(credentials)
def send_email(account, to, subject, start, body, end):
m = account.new_message()
m.to.add(to)
m.subject = subject
m.body = start + body + end
m.send()
Then create the start and end of an email in html:
start = """<html>
<body>
<strong>Data table here:</strong><br />"""
end = """ </body>
</html>"""
Finally we can utilize pretty_table_html to convert our Excel file and send the email:
from pretty_html_table import build_table
html_table_blue_light = build_table(pd.read_excel('df.xlsx'), 'blue_light')
send_email(account
, 'test@any.com'
, 'test table'
, start
, html_table_blue_light
, end
)
Here are all of the currently available colors:
Several optional arguments now exist that allow the user to control the table's font, font size, and alignment:
font_size - accepts absolute keywords (medium) and pixel values (20px)font_family - best practice is to include a generic font family in case a recipient's client cannot render the chosen font. The example below designates Open Sans as a font, but designates the generic sans-serif family as a fallback. It's possible that the fallback font may be utilized in case a recipient has web fonts blocked for security reasons, or if they are viewing the email on a client that does not have acces to Google Fonts.text_align - accepts standard html property values such as left, right, center, justify.width - accepts string representation of pixels. For instance, for the columns to have a width of 100px, you would write: width="100px".width_dict - accepts list of string representation of pixels. It will only work if the length of the list matches the number of columns of your pandas dataframe. You can for example provide the following argument to the fonction: width_dict=['300px','auto', 'auto', 'auto','auto', 'auto'] only the first column would be resized to 300px, the other would be "auto".index - bolean. False by default - If you write index=True, index of the dataframe will then be visible in your table.even_color - accepts string representation of colors (either "white" or "FFFFF"). For instance, for the font color of the even lines to be white, you would write: even_color='white'.color - accepts string representation of colors (either "white" or "FFFFF"). For instance, for the background color of the even lines to be black, you would write: even_color='black'.conditions - accepts dictionnary providing the following information: <name_of_column>: {'min': <min range>,'max': <max range>,'min_color': <color_for_min>,'max_color': <color_for_max>} Below is an exmaple, if a column name is "Age" and we wish to have the ages represented in red if they are under 25 and green if they are over 60.padding - accepts a string to set the CSS padding in the table (10px, 0px 20px, 0px 20px 0px 0px)odd_bg_color - accepts a hex or standard color for the odd row backgroundborder_bottom_color - accepts a color for the bottom border for the headershtml_table = build_table(df
, 'yellow_dark'
, font_size='medium'
, font_family='Open Sans
, sans-serif'
, text_align='left'
, width='auto'
, index=False
,conditions={
'Age': {
'min': 25,
'max': 60,
'min_color': 'red',
'max_color': 'green',
}
}
, even_color='black'
, even_bg_color='white')
FAQs
Make pandas dataframe looking pretty again
We found that pretty-html-table demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
In this segment of the Risky Business podcast, Feross Aboukhadijeh and Patrick Gray discuss the challenges of tracking malware discovered in open source softare.
Research
Security News
A threat actor's playbook for exploiting the npm ecosystem was exposed on the dark web, detailing how to build a blockchain-powered botnet.
Security News
NVD’s backlog surpasses 20,000 CVEs as analysis slows and NIST announces new system updates to address ongoing delays.