Plot Table with values in scientific notation in Python?

Question

I have a pandas dataframe

           Names   leak  start  stop       Vth      F_E_M        on/off
94   150-300-G11   True    3.0   2.0  0.735245  17.484957  3.908669e+02
97   150-300-G23  False    3.0   2.0  0.640523  19.183871  3.435479e+06
99   150-300-G24  False    3.0   2.0  0.586703  20.406298  1.556000e+06
106  150-300-G34   True    3.0   2.0  0.636318  16.726437  2.933874e+05

and want to create a table that displays the data in scientific notation.

I have found code to create the table (Export a Pandas dataframe as a table image):

def render_mpl_table(data, col_width=3.0, row_height=0.625, font_size=14,
                     header_color='#40466e', row_colors=['#f1f1f2', 'w'], edge_color='w',
                     bbox=[0, 0, 1, 1], header_columns=0,
                     ax=None, **kwargs):
    if ax is None:
        size = (np.array(data.shape[::-1]) + np.array([0, 1])) * np.array([col_width, row_height])
        fig, ax = plt.subplots(figsize=size)
        ax.axis('off')

    mpl_table = ax.table(cellText=data.values, bbox=bbox, colLabels=data.columns, **kwargs)

    mpl_table.auto_set_font_size(False)
    mpl_table.set_fontsize(font_size)

    for k, cell in  six.iteritems(mpl_table._cells):
        cell.set_edgecolor(edge_color)
        if k[0] == 0 or k[1] < header_columns:
            cell.set_text_props(weight='bold', color='w')
            cell.set_facecolor(header_color)
        else:
            cell.set_facecolor(row_colors[k[0]%len(row_colors) ])
    return ax

render_mpl_table(df, header_columns=0, col_width=2.0)

I need to pass it something like:

cellText=data.values.scientific()

is there a command to do this?

How does the table look like with this code? Isn't `3.908669e+02` already scientific notation? — ImportanceOfBeingErnest, May 08 '19 at 14:59
that is just the dataframe, I wasn't able to add the image of the table, but no they aren't in scientific notation — Leo, May 08 '19 at 20:41

SpghttCd · Accepted Answer · 2019-05-08T20:48:09.257

0

You could try df.style.format() as suggested by examples in the docs.

For formatting the last three columns of your df in scientific notation, use:

with open('test.html', 'w') as f:
    f.write(df.style.format({col: '{:.2e}' for col in df.columns[-3:]}).render())

Picture of result:

edited May 08 '19 at 20:48

answered May 08 '19 at 13:32

SpghttCd

10,510
2
20
25

Plot Table with values in scientific notation in Python?

1 Answers1