旧的写法如下文, 出现错误提示: ‘DataFrame‘ object has no attribute ‘set_value‘
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)
新的写法使用 at[row,col] = xxx
Python 3.8.5 测试通过
import pandas as pd
df = pd.DataFrame({'Year': [2000, 2001, 2002 , 2003]})
df['link'] = '-'
df.at[0, 'link'] = '=HYPERLINK("https://en.wikipedia.org/wiki/2000", 2000)'
df.at[1, 'link'] = '=HYPERLINK("https://en.wikipedia.org/wiki/2001", 2001)'
df.at[2, 'link'] = '=HYPERLINK("https://en.wikipedia.org/wiki/2002", 2002)'
df.at[3, 'link'] = '=HYPERLINK("https://en.wikipedia.org/wiki/2003", 2003)'
df.to_excel('test.xlsx', index = False)