I have pandas data frame in which I need to replace one part of the vale with another value
for Example. I have
HF - Antartica HF - America HF - Asia
out of which I’d like to replace ony the HF -
part
thus the result would be
Hi Funny Antartica Hi Funny America Hi Funny Asia
I have tried pd.replace()
but it doesnt work as I need only one part of the string replaced, rather than the entire string
Advertisement
Answer
It seems you need Series.replace
:
print (df) val 0 HF - Antartica 1 HF - America 2 HF - Asia print (df.val.replace({'HF -':'Hi'}, regex=True)) 0 Hi Antartica 1 Hi America 2 Hi Asia Name: val, dtype: object
Similar solution with str.replace
:
print (df.val.str.replace('HF -', 'Hi')) 0 Hi Antartica 1 Hi America 2 Hi Asia Name: val, dtype: object