1

I need to hyperlink all the strings in a column with the matching URL from another column and compile the report in a excel format.

The data comes in the format below in a .csv file:

Headline;URL
string1;https://www.url1
string2;https://www.url2
string3;https://www.url3

How can I use python to hyperlink the strings in the 'Headline' column with the matching URLs, delete the 'URL' column from the table and export it to an .xlsx file without losing the hyperlinks?

Improve this question
2
Related questions
2
dataframe.to_html does not create hyperlinks
6
Retain hyperlinks in Pandas - Excel to dataframe
4
clickable link in pandas dataframe
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.