Regex to exclude only numbers

Question

I have this table

Stars
3 stars
Stars 20
901stars
8

I'm using python to filter the table but I'm not sure of the regex to reject 8. [^0-9] will flag 3 stars, 901stars as errors too but I just want to flag that 8 is incorrect based on the regex.

The regex I need would only flag out the numbers (not number+string or string+number).

If `8` is a number (that is, a Python integer), you need to check for the type of the table elements, not use a regex. Or turn all elements into a string first. — 9769953, Jul 21 '22 at 16:17

score 1 · Answer 1 · answered Jul 21 '22 at 16:09

1

I'd suggest \d+$ to match 1 or more digits at the end of the line. (or even ^\d+$ to search from beginning of line).

disclaimer: I don't have a clue wrt Python, but if has a standard rx library, this should work.

answered Jul 21 '22 at 16:09

MBaas

7,248
6
44
61

score -1 · Answer 2 · answered Jul 21 '22 at 17:04

-1

Here is a way without using regex.

pd.to_numeric(df['Stars'],errors = 'coerce').isna()

answered Jul 21 '22 at 17:04

rhug123

7,893
1
9
24

Regex to exclude only numbers

2 Answers2