Pandas dataframe add a clickable url by adding values of the associate rows

Question

Let's say I have a dataframe as shown below. I need to add a new url column to the dataframe and then create a clickable url link by using the values of the other associated rows.

import pandas as pd
url='https://stackoverflow.com/'
df = pd.DataFrame({'A': ('62392411', 60273469), 'B': ('questions/', 'questions/')})
>>> df
          A           B
0  62392411  questions/
1  60273469  questions/

I am looking to get something like this:

>>> df
          A           B         url    
0  62392411  questions/         https://stackoverflow.com/questions/62392411
1  60273469  questions/         https://stackoverflow.com/questions/60273469

df.assign(Url=[f"https://stackoverflow.com/{b}{a}" for a,b in zip(df['A'],df['B'])]).style.format(make_clickable,subset=['Url']) function taken from here does this help? — anky
– anky, Commented Jun 15, 2020 at 17:19

jackosumtrades · Accepted Answer · 2020-06-15 17:17:57Z

1

If both columns are strings and won't contain NaN, then you could do something like:

df['url'] = 'somestring/' + df['B'].astype(str) + df['A'].astype(str)

Output:

0    somestring/questions/62392411
1    somestring/questions/60273469
Name: url, dtype: object

To make it clickable something like this should work:

def make_clickable(val):
    return '<a href="{}">{}</a>'.format(val,val)

df.style.format({'url': make_clickable})

edited Jun 15, 2020 at 17:17

answered Jun 15, 2020 at 17:04

jackosumtrades

841 silver badge6 bronze badges

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

1 Comment

Alex Man Over a year ago

Thanks. I am not sure if that can make it clickable.

Collectives™ on Stack Overflow

Pandas dataframe add a clickable url by adding values of the associate rows

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related