3

I am new to Flask Python. So please accept my apology if my problem seems to be trivial or stupid. I am displaying a dataframe in the form of table on html page. I want to data one column into existing dataframe with name 'link' (that contains clickable link) so that when user clicks on the column value, it goes to some page. In short I want something like that: enter image description here

I borrowed the idea from one of the existing threads How to create a table with clickable hyperlink in pandas & Jupyter Notebook. However, it produces the actual output like this:

Actual output

Here is part of my code:

def make_clickable(val1='welcome.html',val2='Click here'):
    return '<a href="{}">{}</a>'.format(val1,val2)

df['Link']= df.style.format(make_clickable)

Could anyone point me where am I making mistake?

user2293224
  • 2,128
  • 5
  • 28
  • 52

1 Answers1

3

This work fine with Jupyter Notebook

code:

import pandas as pd ; import numpy as np
data = [dict(name='Google', url='http://www.google.com'),
        dict(name='Stackoverflow', url='http://stackoverflow.com')]
df = pd.DataFrame(data)

def make_clickable(val):
    # target _blank to open new window
    return '<a target="_blank" href="{}">{}</a>'.format(val,val)

df.style.format({'url': make_clickable})

proof:

enter image description here

L F
  • 548
  • 1
  • 7
  • 22
BENY
  • 317,841
  • 20
  • 164
  • 234