I am attempting to display a clickable hyperlink inside a dataframe containing filtered results on Streamlit. This is my code so far:

import pandas as pd
import streamlit as st
import openpyxl
import numpy as np
from IPython.core.display import display, HTMLdf = pd.read_excel(io='list.xlsx',engine= 'openpyxl',).fillna('')def make_clickable(link):# target _blank to open new window# extract clickable text to display for your linktext = link.split('=')[0]return f'<a target="_blank" href="{link}">{text}</a>'# TRAILER is the column with hyperlinks
df['TRAILER'] = df['TRAILER'].apply(make_clickable)df['TRAILER'] = HTML(display(df.to_html(render_links=True, escape=False), raw=True))

If I use:

df['TRAILER'] = df['TRAILER'].apply(make_clickable)

I get

<a target="_blank" href="{link}">{text}</a>

displayed as a string but not a hyperlink.

When I add:

df['TRAILER'] = HTML(display(df.to_html(render_links=True, escape=False), raw=True))

I get:

<IPython.core.display.HTML object>

displayed as a string but not a hyperlink.

These are the versions I am using. Other components of the site work only with a lower version of Streamlit which is why I am using this version.

streamlit == 0.83 numpy == 1.18 pandas == 1.2 openpyxl ipython == 7.22 python == 3.9

I cannot use st.markdown or st.write directly as I am using st.dataframe to display the results.

You can use st.write(df.to_html(escape=False, index=False), unsafe_allow_html=True):

import pandas as pd
import streamlit as st
import openpyxl
import numpy as np
from IPython.core.display import display, HTMLdf = pd.read_excel(io='list.xlsx',engine= 'openpyxl',).fillna('')def make_clickable(link):# target _blank to open new window# extract clickable text to display for your linktext = link.split('=')[0]return f'<a target="_blank" href="{link}">{text}</a>'# TRAILER is the column with hyperlinks
df['TRAILER'] = df['TRAILER'].apply(make_clickable)st.write(df.to_html(escape=False, index=False), unsafe_allow_html=True)

On a working example:

import pandas as pd
import streamlit as stlink1 = "https://stackoverflow.com/questions/71641666/hyperlink-in-streamlit-dataframe"
link2 = "https://stackoverflow.com/questions/71731937/how-to-plot-comparison-in-streamlit-dynamically-with-multiselect"
df = pd.DataFrame({"url": [f'<a target="_blank" href="{link1}">Hyperlink in Streamlit dataframe</a>',f'<a target="_blank" href="{link2}">How to plot comparison in Streamlit dynamically with multiselect?</a>'],"label": ["question", "question"]}
)st.write(df.to_html(escape=False, index=False), unsafe_allow_html=True)

It gives: