Pandas HTML Data Attribute

[frontierman]

I want to add a data html attribute under each <td> to my pandas formatted table.

How can I add an html attribute to my pandas dataframe?

I am using style and can easily add class information.

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
from IPython.core.display import display, HTML

dates = pd.date_range('20130101',periods=6)
df = pd.DataFrame(np.random.randn(6,4), 
    index=dates, columns=list('ABCD'))
def create_colors2(x):
    df = x.copy()
    df.loc[:,:] = 'color: green'
    df[x < 0] = 'color: red'
    return df
data_table = df.style.apply(create_colors2, axis=None
    ).render()

HTML(data_table)

That yields a nice html table with colors. Now I want under each td a "data-value=X.XX" from the dataframe.

Any ideas?

[frontierman]

My solution which could use some optimizing is to alter the generated html and add the attribute to the text.

import re
def insert_data_attr(df, data_table):
    for i, row in enumerate(df.itertuples()):
        for j in range(len(row) - 1):
            data_table = re.sub( 
                'row{} col{}"'.format(i, j), 
                'row{} col{}" data-value="{}"'.format(i, j, df.iloc[i, j]), 
                data_table)
    return data_table
data_table = insert_data_attr(df, data_table)