Turning a String Decimal To String Int by Using Regex

Question

I have below string;

line='P1: 6.0, P2: 5.0, P3: 10.3, P4: 7.0, P5: 10.0, P6: 6.0, P7: 4.0, P8: 5.8, P9: 5.0, P10: 5.0'

I only want to delete .0's and keep the values like 4.5 or 10.3. So what I want is like,

line='P1: 6, P2: 5, P3: 10.3, P4: 7, P5: 10, P6: 6, P7: 4., P8: 5.8, P9: 5, P10: 5'

I tried to do this,

import re
re.sub(r'.0(?=,)','',line)

It didn't work. I would appreciate any help.

Please be more descriptive that "didn't work" - what happened? Error? Unexpected results? — Mathias R. Jessen
– Mathias R. Jessen, Commented Jan 30, 2021 at 21:39
Actually it works but not for the last element of the string. Output is ''P1: 6, P2: 5, P3: 10.3, P4: 7, P5: 10, P6: 6, P7: 4, P8: 5.8, P9: 5, P10: 5.0'' — svn_21
– svn_21, Commented Jan 30, 2021 at 21:42
You could also use re.sub(r'(?<=\d)\.0(?![^,])','',line) to make sure you only remove .0 after a digit and before a comma/end of string. — Wiktor Stribiżew
– Wiktor Stribiżew, Commented Jan 30, 2021 at 21:52
@Wiktor Stribiżew Wow! that looks complex, thanks a lot for clarification and the effort — svn_21
– svn_21, Commented Jan 30, 2021 at 22:08

marcos · Accepted Answer · 2021-01-30 21:41:30Z

1

U can just do a simple replace, for example:

line = "P1: 6.0, P2: 5.0, P3: 10.3, P4: 7.0, P5: 10.0, P6: 6.0, P7: 4.0, P8: 5.8, P9: 5.0, P10: 5.0"


print(line.replace('.0', ''))
>>> P1: 6, P2: 5, P3: 10.3, P4: 7, P5: 10, P6: 6, P7: 4, P8: 5.8, P9: 5, P10: 5

answered Jan 30, 2021 at 21:41

marcos

4,5101 gold badge13 silver badges26 bronze badges

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

4 Comments

svn_21 Over a year ago

Thanks a lot! It is much more easy :)

Wiktor Stribiżew Over a year ago

@svn_21 Try '5.05'.replace('.0', ''), do you expect this?

marcos Over a year ago

u can only use this like @WiktorStribiżew mentioned if they have only one decimal digit.

svn_21 Over a year ago

@Wiktor Stribiżew The data has only one decimal numbers, so above code worked for me

Ryszard Czech · Accepted Answer · 2021-01-30 21:43:32Z

1

Use

re.sub(r'\b\.0\b', '', line)

See regex proof.

Node	Explanation
`\b`	the boundary between a word char (\w) and something that is not a word char
`\.`	'.'
`0`	'0'
`\b`	the boundary between a word char (\w) and something that is not a word char

Python code:

import re
regex = r"\b\.0\b"
test_str = "P1: 6.0, P2: 5.0, P3: 10.3, P4: 7.0, P5: 10.0, P6: 6.0, P7: 4.0, P8: 5.8, P9: 5.0, P10: 5.0"
print(re.sub(regex, "", test_str))

Results: P1: 6, P2: 5, P3: 10.3, P4: 7, P5: 10, P6: 6, P7: 4, P8: 5.8, P9: 5, P10: 5

answered Jan 30, 2021 at 21:43

Ryszard Czech

18.7k4 gold badges27 silver badges39 bronze badges

Collectives™ on Stack Overflow

Turning a String Decimal To String Int by Using Regex

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related