如何将标签添加到pandas dataframe.to_html链接中，使url的绝对路径不会显示在html中，而是显示为一个标签？

import pandas as pd
from bs4 import BeautifulSoup

data = {'Name': ['John', 'Emma', 'Mike'],
        'Website': ['https://www.example.com', 'https://www.example2.com', 'https://www.example3.com']}
df = pd.DataFrame(data)

def add_link(row):
    url = row['Website']
    return f'<a href="{url}">Link</a>'

df['Link'] = df.apply(add_link, axis=1)

html = df.to_html(index=False)
soup = BeautifulSoup(html, 'html.parser')

# 找到包含链接的单元格，并替换为带有标签的文本
for link_cell in soup.find_all('td', string='Link'):
    link_cell.string = ''
    link_cell.append(BeautifulSoup(df.loc[link_cell.parent.name, 'Link'], 'html.parser'))

# 将处理后的HTML转换为字符串
html_with_links = str(soup)