Add value to string if string doesn't already contain this value

Question

I need to add value to string without making "TRC+TRC" cells. So if it already contains TRC -> add nothing. How to do it?

for i in range(len(df)):
  d = str(df['description'][i]).lower()
  if df['segment'][i] == 'shopping':
    if any(TRC in d for TRC in TRC):
      if (df['landsize'][i] > 9000):
        df['class'][i] = (f"{df['class'][i]} + TRC")
        continue

and what are other variants to do this thing?

df['class'][i] = (f"{df['class'][i]} + TRC")

Can TRC be in the middle of the string or will it always be at the start or end? — Jkind9
– Jkind9, Commented Aug 21, 2019 at 13:05
i have multiple classes like TRC, so it may add multiple times and in random positions, thanks — Aisys
– Aisys, Commented Aug 21, 2019 at 13:09

Gilgo · Accepted Answer · 2019-08-21 13:24:37Z

1

I believe this is what you're looking for, definitely avoid loops in pandas in anyway possible. Hope that this is what you meant :)

df['description'] = df['description'].str.lower()

df.loc[(df['segment'] == 'shopping')
   &(~df['description'].str.contains('trc')) 
   & (df['landsize'] > 9000)
   , 'class'] += "TRC"

answered Aug 21, 2019 at 13:24

Gilgo

604 bronze badges

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

4 Comments

Aisys Over a year ago

i have both variants of code: with loops and with loc. But @Benoit Drogou wrote with iloc for some reason :) but with loc i have another troubles, so i'm trying to do this as loop now

Aisys Over a year ago

what does ~ mean?

Gilgo Over a year ago

Maybe try to solve your loc problem? It's the cleaner way to approach it in my opinion,

Gilgo Over a year ago

~ means not, so it checks that description doesn't contain trc

Benoit Drogou · Accepted Answer · 2019-08-21 15:03:05Z

1

Loops are not pythonic at all, the more you are avoiding them the better, faster and more efficient your code is.

df.loc[ (df['segment']=='shopping')
       & (df['landsize']>9000)
       & (~df['class'].str.contains(pat='TRC', na=False))
       , 'class'] += 'TRC'

I maybe misunderstood your issue

edited Aug 21, 2019 at 15:03

answered Aug 21, 2019 at 13:18

Benoit Drogou

9691 gold badge5 silver badges15 bronze badges

2 Comments

Nathan Furnal Over a year ago

I think they meant that df['class'] cells must be appended 'TRC' under the conditions, not make it 'TRC'.

Benoit Drogou Over a year ago

sure, then += works for dataframe as well, I updated the answer

Collectives™ on Stack Overflow

Add value to string if string doesn't already contain this value

2 Answers 2

4 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related