Delete Rows in Pandas DataFrame based on conditional expression [duplicate]

Question

I have the following dataframe:

index        text        is_retweet
0            Test        False
1            RT bar      False
2            RT bazz     False
3            Test2       False

I want to delete the rows that begin with "RT"

I tried this:

my_df.drop(my_df.index[my_df['text'].find("RT") == 0], inplace = True)

But I get this error:

AttributeError: 'Series' object has no attribute 'find'

Chris · Accepted Answer · 2020-07-06 23:41:03Z

1

Use pandas.Series.str.startswith:

new_df = df[~df["text"].str.startswith("RT")]
print(new_df)

Output:

   index   text  is_retweet
0      0   Test       False
3      3  Test2       False

answered Jul 6, 2020 at 23:41

Chris

29.8k3 gold badges34 silver badges56 bronze badges

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

Comments

David Erickson · Accepted Answer · 2020-07-06 23:45:59Z

1

Another option taking the position of characters:

df1 = df[df['text'].str[0:2] != 'RT']
df1

ouput:

    index   text    is_retweet
0       0   Test    False
3       3   Test2   False

answered Jul 6, 2020 at 23:45

David Erickson

16.7k2 gold badges21 silver badges37 bronze badges

Collectives™ on Stack Overflow

Delete Rows in Pandas DataFrame based on conditional expression [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related