Python Pandas replace a cell containing a string with its above cell

Question

I'm trying to replace a cell which contains certain string with its above cell:

Tried following code but it takes so long and cause error:

    row, col = df.shape
    for i in range(1,row):        
        if df.iloc[i,0] == "string": 
            df.iloc[i,0] = df.iloc[i-1,0]

Is there a better way to achieve this? Thanks.

Vaishali · Accepted Answer · 2019-02-27 04:10:40Z

3

The general structure for these kind of problems is df.loc[cond, col] = ...

Using @meW's setup,

df = pd.DataFrame({'col': ['Elephant', 'Grass', 'Parameter', 'Root']})
df.loc[df.col.eq('Parameter'), 'col'] = df.col.shift(1)

    col
0   Elephant
1   Grass
2   Grass
3   Root

answered Feb 27, 2019 at 4:10

Vaishali

38.5k5 gold badges62 silver badges88 bronze badges

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

1 Comment

Zeshen Zhang Over a year ago

Thanks Vaishali, it looks good, though I used some other logic to work this out.

Collectives™ on Stack Overflow

Python Pandas replace a cell containing a string with its above cell

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related