Choose rows that contain value inside string

Question

This is my DataFrame:

                            Asp
2010-01-15 11:00:00    Moon0Sun
2010-01-19 15:00:00   Moon45Sun
2010-01-20 02:00:00   Moon50Sun
2010-02-01 05:00:00  Moon185Sun
2010-02-02 07:00:00  Moon140Sun
2010-02-02 15:00:00  Moon135Sun
2010-02-05 17:00:00   Moon0Sun
2010-02-08 05:00:00   Moon90Sun
2010-02-09 15:00:00   Moon50Sun
2010-02-10 02:00:00   Moon45Sun

I want to choose rows that contain zero as a number. If it is 50 or 140, it shouldn't be chosen.
Only rows like Moon0Sun.
How can I do it?

@jezrael, it returns Moon50Sun and Moon90Sun too. I need only Moon0Sun — Igor K., Sep 16 '20 at 05:24
@jezrael, thank you, df[df['Asp'].str.contains("\D0\D")] works perfect — Igor K., Sep 16 '20 at 05:39

score 1 · Accepted Answer · answered Sep 16 '20 at 05:39

You can use Series.str.contains with regex \D0\D for filter non number \D, 0 and no number \D:

df[df['Asp'].str.contains("\D0\D")

Another more general solution is get numbers and compare by '0' in Series.str.extract:

df[df['Asp'].str.extract("(\d+)", expand=False).eq('0')]

Choose rows that contain value inside string

1 Answers1