CODEWITHSUNDEEP
pythonpandas
Igor K.
Igor K.

Reputation: 877

Choose rows that contain value inside string

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?

Upvotes: 1

Views: 34

Answers (1)

jezrael
jezrael

Reputation: 863531

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')]

Upvotes: 1

Related Questions