程序员最近都爱上了这个网站  程序员们快来瞅瞅吧！  it98k网:it98k.com

I have the following code which outputs an HTML table:

import pandas as pd

df = pd.DataFrame({
    'Color': ['Red', 'Red', 'Yellow', 'Yellow'],
    'Fruit': ['Apple', 'Strawberry', 'Banana', 'Peach'],
    'Weight': [5, 3, 8, 6]
})

df = pd.pivot(df, index='Color', columns='Fruit', values='Weight')

print(df.to_html())

I would like the output of each cell to reference its row (index) and column value. For example, I'd like a format function that looks like this:

def format_value(val, row, col):
    return f"<a href=/{row}/{col}>{val}</a>"

However, I cannot figure out how to do this. This is what I've tried:

df.applymap()

df = df.applymap(lambda x: format_value(x, row=x.index, col=x.name))

This returns an error:

AttributeError: 'float' object has no attribute 'index'

to_html(formatter=...)

def format_cell(val, col, row):

    def f(val):
      return f"/{row}/{col}"
            
    return f

format_map = {}
for col in df.columns:
    format_map[col] = format_cell(col, df.index)

print(df.to_html(formatter=format_map))

However, df.index returns all of the indexes, so there is no way to know which row specifically the formatter is referring to.

How can I create an HTML formatter which is aware of both the index and column for each value?

解决方案

暂无回答