CODEWITHSUNDEEP
pythonpandasdata-analysis
dasvootz
dasvootz

Reputation: 413

Python - Drop rows from a Pandas DataFrame that contain numbers

I have a dataframe with one column like this:

Value
xyz123
123
abc
def

I want to remove any rows that contain numbers so I end up with a dataframe like this:

Value
abc
def

I have tried

df = df[df['Value'].str.contains(r'[^a-z]')]

but I got this error:

"TypeError: 'method' object is not subscriptable"

Upvotes: 1

Views: 5679

Answers (2)

BENY
BENY

Reputation: 323226

IIUC isalpha

df[df.Value.str.isalpha()]
Out[2057]: 
  Value
2   abc
3   def

Upvotes: 3

Brad Solomon
Brad Solomon

Reputation: 40878

Independent from what looks like an issue with variable naming, you could be more explicit about removing only rows with numbers:

df[~df.Value.str.contains(r'\d')]

  Value
2   abc
3   def

\d:

Matches any Unicode decimal digit (that is, any character in Unicode character category [Nd]). This includes [0-9], and also many other digit characters. If the ASCII flag is used only [0-9] is matched (but the flag affects the entire regular expression, so in such cases using an explicit [0-9] may be a better choice).

Upvotes: 6

Related Questions