How to add hyperlinks for value in column using Pandas?

Question

I got 3 columns in my dataframe.

Example:

name = ['iphone']
price = ['1000']
url = ['https://iphone.com/']
MY_DF = pd.DataFrame({'name': name, 'price':price})
MY_DF.to_excel('123.xlsx')

I need did it in loop in my dataframe.

How to apply url as hyperlink to price? and export it to xlsx result need to be like:

The methods described in this article: add hyperlink to excel sheet created by pandas dataframe to_excel method do not suit me.

In my situation every url is unique and I don't know how to right apply them for my 'price'.

Seems like this could work, but I don't know how to loop it:

Thank you in advance

Does this answer your question? add hyperlink to excel sheet created by pandas dataframe to_excel method — Rodalm
– Rodalm, Commented Oct 30, 2021 at 12:56
Please update your post with a sample of the DataFrame. It's not clear from the example how it's formated. Do you have 3 separate columns: product name, price and url? — Rodalm
– Rodalm, Commented Oct 30, 2021 at 17:16
@HarryPlotter i was find solution, see below. anyway thanks for your attention. — Yaroslav Butorin
– Yaroslav Butorin, Commented Oct 30, 2021 at 18:12

Yaroslav Butorin · Accepted Answer · 2021-10-30 18:11:21Z

1

def make_hyperlink(value):
    url = "{}"
    return '=HYPERLINK("%s", "%s")' % (url.format(value).split(' ')[0], url.format(value).split(' ')[1])

Il combine my url and price as prices = 'urls' +' '+'price' append it to main dataframe as ['price'] and apply next myDF['price'] = myDF['price'].apply(lambda x: make_hyperlink(x)) and it works! =)

answered Oct 30, 2021 at 18:11

Yaroslav Butorin

631 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to add hyperlinks for value in column using Pandas?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related