Exclude values in DF column

Question

I have a problem, I want to exclude from a column and drop from my DF all my rows finishing by "99".

I tried to create a list : filteredvalues = [x for x in df['XX'] if x.endswith('99')]

I have in this list all the concerned rows but how to apply to my DF and drop those rows :

I tried a few things but nothing works :

Lately I tried this :

df = df[df['XX'] not in filteredvalues]

Any help on this?

`df[~df['XX'].str.endswith('99')]` perhaps? – 9769953 Feb 16 '22 at 13:45 — 9769953, Feb 16 '22 at 13:45
Just use `~` operator. `df[~df['XX'].str.endswith('99')]` – Mayank Porwal Feb 16 '22 at 13:47 — Mayank Porwal, Feb 16 '22 at 13:47

score 0 · Answer 1 · answered Feb 16 '22 at 13:48

0

Use the .str attribute, with corresponding string methods, to select such items. Then use ~ to negate the result, and filter your dataframe with that:

df = df[~df['XX'].str.endswith('99')]

answered Feb 16 '22 at 13:48

9769953

10,344
3
26
37

Thanks but I want to to exclude datas ending with 99, how can I manage wit the not in endswith('99') – RomainInTheAnalysis Feb 16 '22 at 13:51
Got it, didn't see the operator, thanks guys – RomainInTheAnalysis Feb 16 '22 at 13:53

Exclude values in DF column

1 Answers1