我在一个数据框上运行一段代码，它有一个链接列，其中有一个指向页面的链接. 基于一些try 和错误，我意识到结果是好的，直到我达到代码的这一部分:
df1 = df[df['operator'] == 'test']
df1.reset_index(inplace=True, drop=True)
df1[phone_col] = df1['new_phone']
df.to_excel(f'step2_1.xlsx', index=False)
when I open the step2_1.xlsx, the link column goes only to index of 65531 and then after that its blank like the picture below.
how can i fix it? is it related to a setting for vscode?
Excel内置的超链接限制为65530.
您可以绕过此限制using the HYPERLINK function of Excel%.
因此，举个例子:
(pd.DataFrame([['test', '=HYPERLINK("https://www.google.com/")']]*65600, columns = ['Name', 'Link'])
.to_excel(f'step2_1.xlsx', index=False))
这说明了如何将列中的当前字符串轻松转换为Excel超链接公式:
df = pd.DataFrame([['test', 'https://www.google.com/']]*10, columns = ['Name', 'Link'])
df['Link'] = df.Link.apply(lambda x: f'=HYPERLINK("{x}")')
输出:
Name Link
0 test =HYPERLINK("https://www.google.com/")
1 test =HYPERLINK("https://www.google.com/")
2 test =HYPERLINK("https://www.google.com/")
3 test =HYPERLINK("https://www.google.com/")
4 test =HYPERLINK("https://www.google.com/")
5 test =HYPERLINK("https://www.google.com/")
6 test =HYPERLINK("https://www.google.com/")
7 test =HYPERLINK("https://www.google.com/")
8 test =HYPERLINK("https://www.google.com/")
9 test =HYPERLINK("https://www.google.com/")