'Is there a way to see the url addreses on Jupyter notebook when read a csv file with pandas

I have a dataset in a csv file. There is a 'Link' column and its values are clickable links with the same general name ‘source’, but they are different websites.

When I read the file on Jupyter notebook using Python ‘pd.read_csv’, the data frame shows the Link column with all the values same string, ‘source’ and no link.

Is there a way I can see the url addreses on Jupyter notebook instead of the word ‘source’ ? Thank you in advance.



Solution 1:[1]

You might find some helpful information here: https://datascientyst.com/create-clickable-link-pandas-dataframe-jupyterlab/. This link suggests you convert the DF to HTML and output that in your jupyter notebook. More specifically, you can view the major takeaway here:

from IPython.display import HTML

HTML(df.to_html(render_links=True, escape=False))

Hope this helps!

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Amit Maraj