Pandas library does not have the functionality to parse hyperlink as of yet. You could preprocess the excel using libraries such as xlrd
or openpxyl
to get hyperlinks then use it in pandas.
Source: https://stackoverflow.com/a/45446810/7570485
There is also a feature request for this functionality.
1
solved Read Excel file which has one of the column as Hyperlink through python