Replace Pandas Dataframe Value Based on Index Range

Question

I have Pandas Dataframe named df. I want to replace each value in sentence column within start and end with X.

df = pd.DataFrame({'sentence': ['I eat chicken', 'I drive car'], 
                   'start': [3, 3],
                    'end': [6,8]})

For example that will return I X chicken and I X car in sentence column. I try using apply and replace, but it returns error.

Quang Hoang · Accepted Answer · 2020-04-01 15:36:46Z

1

Yes, you can apply, with just the correct function:

df.apply(lambda x: x.sentence[:x.start-1] + ' X ' + x.sentence[x.end:], axis=1)

Output:

0    I  X chicken
1        I  X car
dtype: object

answered Apr 1, 2020 at 15:36

Quang Hoang

151k11 gold badges64 silver badges86 bronze badges

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

Comments

BENY · Accepted Answer · 2020-04-01 15:39:47Z

0

IIUC slice_replace

df.apply(lambda x : x.str.slice_replace(start=x['start']-1, stop=x['end']-1, repl='X'),1).sentence
0    I X chicken
1        I X car
Name: sentence, dtype: object

answered Apr 1, 2020 at 15:39

BENY

324k22 gold badges176 silver badges250 bronze badges

Collectives™ on Stack Overflow

Replace Pandas Dataframe Value Based on Index Range

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related