Python - Drop rows from a Pandas DataFrame that contain numbers

Question

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"

have you somewhere bound df to something that isn't a dataframe? Otherwise - what you've shown should work... what does type(df) show you? — Jon Clements
– Jon Clements, Commented Feb 26, 2018 at 20:52
I didn't bind it anywhere except where it loaded the data from a .csv — No one
– No one, Commented Feb 26, 2018 at 21:05

Brad Solomon · Accepted Answer · 2018-02-26 20:57:13Z

6

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).

edited Feb 26, 2018 at 20:57

answered Feb 26, 2018 at 20:50

Brad Solomon

41.2k39 gold badges167 silver badges260 bronze badges

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

2 Comments

Jon Clements Over a year ago

The OPs code should work - the error suggests that they've assigned df to something that isn't a dataframe... So until they sort that out - this code will produce the same error... it is an alternative way of doing it though when that part of it is sorted.

Jon Clements Over a year ago

Completely agree - "I want to remove values containing numbers" - using this approach makes more sense to me and is more accurate than the criteria being "not a-z"...(which isn't the same thing)

BENY · Accepted Answer · 2018-02-26 21:04:20Z

3

IIUC isalpha

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

answered Feb 26, 2018 at 21:04

BENY

324k22 gold badges176 silver badges250 bronze badges

Collectives™ on Stack Overflow

Python - Drop rows from a Pandas DataFrame that contain numbers

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related