How to insert a hyperlink to a python dataframe

Question

I have a dataframe as given below [input_dataframe]. I want the column Number to display as a clickable hyperlink. For e.g., under column Number, I want it to be displayed as 1234, but it should be as hyperlink and the link should be taken from the next column.

I tried the following code, but it is showing the entire hyperlink from the 2nd column twice in the first column [Output_dataframe]. Kindly help me in resolving this issue.

Code:

import pandas as pd
df = pd.read_excel("C:\\Users\\XYZ\\Desktop\\Test_1.xlsx",sheet_name='Sheet1')
df['Number'] = '<a href=' + df['url'] + '><div>' + df['url'] + '</div></a>'
df.to_excel("Test_2.xlsx",index=False)

input_dataframe

Output_dataframe

This works!!! def make_clickable(Number, url): return '{}'.format(Number,url) df['Number'] = df.apply(lambda x: make_clickable(x['url'], x['Number']), axis=1) df.style a = df.to_html(index=False,render_links=True, escape=False) — Bharath, Oct 03 '22 at 07:22

Jason Baker · Answer 1 · 2022-10-03T06:28:30.387

0

Can't test but believe this should work:

df["Number"] = df["url"].apply(lambda x: f"=HYPERLINK({x}, {x})")

edited Oct 03 '22 at 06:28

answered Oct 03 '22 at 06:20

Jason Baker

3,170
2
12
15

This doesn't work. I tried this and getting the output as follows in column Number: https://jira/browse/1234 – Bharath Oct 03 '22 at 06:26
Try edit my original answer was for html but excel uses =HYPERLINK – Jason Baker Oct 03 '22 at 06:29
This doesn't work either. It shows all the values in the Number as 0 – Bharath Oct 03 '22 at 06:32

How to insert a hyperlink to a python dataframe

1 Answers1