python pandas create hyperlink to image file while writing csv

Question

This is data frame i am working with: {'Image File': {0: 'C:\Users\Param1.png', 1: 'C:\Users\Param2.png', 2: 'C:\Users\Param3.png'}, 'Param': {0: 'Param1', 1: 'Param2', 2: 'Param3'}} I would like to create hyper link in csv file to Image File with following statement:

Data['HYPERLINK'] = "<a href=\"Test\">"+Data['Image File']+"</a>"

My problem that as hyperlink i see the path i am supplying in "Image File" column, but i am interested in Param column value be as caption for hyperlink. any thoughts? Thank you

Table with additional column HYPERLINK with hyperlinks to image files while caption on hyperlinks are values from Param column — Felix
– Felix, Commented Jan 7, 2017 at 17:03

chris-sc · Accepted Answer · 2017-01-07 17:04:40Z

2

If you want the link text shown being your Param field, you need to add it to the link. In your example syntax this would be:

Data['HYPERLINK'] = "<a href=\"" + Data['Image File'] + "\">"+Data['Param']+"</a>"

The html link syntax is

<a href="url">link text</a>

see here for details: http://www.w3schools.com/html/html_links.asp

answered Jan 7, 2017 at 17:04

chris-sc

1,72811 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

python pandas create hyperlink to image file while writing csv

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related