How to replace part of string with python pandas?

Question

I'm having a problem replacing a part of the string in Pandas.

I have a list of links of a website like this (for example):

https://stackoverflow.com/questions
https://stackoverflow.com/some_page
https://stackoverflow.com/about

and I would like to replace https://stackoverflow.com/ with link/.

And it should be like this:

link/questions
link/some_page
link/about

I tried something like this but it replaces the whole string:

df.loc[df['links'].str.contains('https://stackoverflow.com/'), 'links'] = 'link/'

links is the name of column

How do I do this?

Thanks in advance.

is it always https://stackoverflow.com/, or just for this example. If it is static, you can just replace it directly with str.replace — Rabinzel
– Rabinzel, Commented May 26, 2022 at 21:33

ArchAngelPwn · Accepted Answer · 2022-05-26 21:41:00Z

1

This should get you what you need as long as the URLs are consistent.

data = {
    'Column1' : ['https://stackoverflow.com/questions', 'https://stackoverflow.com/another', 'https://stackoverflow.com/last']
}

df = pd.DataFrame(data)
df['Column1'] = df['Column1'].apply(lambda x : 'Link/' + x.split('/')[-1])
df

edited May 26, 2022 at 21:41

answered May 26, 2022 at 21:31

ArchAngelPwn

3,0461 gold badge6 silver badges17 bronze badges

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

2 Comments

Naveed Over a year ago

in case where the path has more slashes, i.e., additional paths, you can replace x.split('/')[3] with x.split('/')[-1] to pick the last part.

ArchAngelPwn Over a year ago

Your absolutely right! I'll update the code. I like that a lot better makes it more "fault proof" if only a little

sitting_duck · Accepted Answer · 2022-05-26 22:52:01Z

1

df.loc[df['links'].str.contains('https://stackoverflow.com/'), 'links'] = \
    'link/' + df[0].str.extract('.*/(.*)') 

                                     0           links
0  https://stackoverflow.com/questions  link/questions
1  https://stackoverflow.com/some_page  link/some_page
2      https://stackoverflow.com/about      link/about

answered May 26, 2022 at 22:52

sitting_duck

3,7801 gold badge17 silver badges20 bronze badges

Comments

Ynjxsjmh · Accepted Answer · 2022-05-27 02:51:09Z

1

You need .str.replace in assignment

df.loc[df['links'].str.contains('https://stackoverflow.com/'), 'links'] = df['links'].str.replace('https://stackoverflow.com/', 'link/')

print(df)

                             links
0                   link/questions
1                   link/some_page
2                       link/about
3  https://stackoverflow/questions

answered May 27, 2022 at 2:51

Ynjxsjmh

30.3k7 gold badges43 silver badges64 bronze badges

Collectives™ on Stack Overflow

How to replace part of string with python pandas?

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related