源地址 https://xbuba.com/questions/31820069
import pandas as pd
df = pd.DataFrame({'Year': [2000, 2001, 2002 , 2003]})
df['link'] = '-'
df.set_value(0, 'link', '=HYPERLINK("https://en.wikipedia.org/wiki/2000", 2000)')
df.set_value(1, 'link', '=HYPERLINK("https://en.wikipedia.org/wiki/2001", 2001)')
df.set_value(2, 'link', '=HYPERLINK("https://en.wikipedia.org/wiki/2002", 2002)')
df.set_value(3, 'link', '=HYPERLINK("https://en.wikipedia.org/wiki/2003", 2003)')
df.to_excel('test.xlsx', index = False)
看得出基本上就是用 excel 中的 '=HYPERLINK(linkurl, linktext)' 函数
比如:
'=HYPERLINK("https://en.wikipedia.org/wiki/2002", 2002)'
'=HYPERLINK("{}","{}")'.format(filepath, filename)
附上我实际使用的例子:
def fun(series):
fname = series['Predicted Structure']
return '=HYPERLINK("{}","{}")'.format(fname,fname)
df['Predicted Structure'] = df.apply(func=fun, axis=1)