make clickable url within Pandas dataframe in Flask

Question

I checked several questions from here and tried several methods on my own but didn't work out.

I have a Pandas dataframe of product catalog which contains several columns, and there is a column called 'url', where it has url address to corresponding product.

I'm using Flask to display this dataframe via html, but url column remains as plain text, instead of clickable url.

But it ended up showing nothing in html result (even plain text of url were gone)

Can someone tell me what should I do to convert my plain text url column as clickable, and display it to flask html?

current code:

df['url'] = '<a href="' + df['url'] + '">' + '</a>'
return render_template('result.html',  tables=[df.to_html(classes='data',escape=False)], titles=result.columns.values)

Dharman · Accepted Answer · 2020-10-12 20:08:35Z

1

If you can add some text inside your tag you will be able to see the link URL. Something like this

df['url'] = '<a href="' + df['url'] + '">' + df['url'] + '</a>'

edited Oct 12, 2020 at 20:08

Dharman♦

33.9k27 gold badges106 silver badges157 bronze badges

answered Oct 12, 2020 at 20:02

visrey

4236 silver badges12 bronze badges

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

4 Comments

DS Park Over a year ago

so I need to put df['url'] twice???? can you explain me how this works little more?

visrey Over a year ago

Yes, replace the above snipped with your code it will work.

DS Park Over a year ago

visrey, I'm now trying to show this url in new tab. I found that there is a trick called /"target="_blank, but little confused where do I sneak this into my current existing code. is this right before </a> ?

visrey Over a year ago

df['url'] = '<a href="' + df['url'] + '" target="_blank">' + df['url'] + '</a>'

Collectives™ on Stack Overflow

make clickable url within Pandas dataframe in Flask

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related