How to get string after last comma in a field

Question

I have a column with data like this that I'm accessing via Python:

501,555,570=3.5

I want to get 570=3.5.

How can I do that? Would it be a variation of the split command?

@gtlambert: Was the downgrade due to my not putting the sample data in a special code block? — Jazzmine, Mar 09 '16 at 16:17
I didn't downvote you! I just improved the formatting of your code — gtlambert, Mar 09 '16 at 16:18
@jazzime: Downvotes usually come to questions where authors fail to do basic research before asking. — 9000, Mar 09 '16 at 16:18
Ok, I've done basic research but didn't see an example of choosing text after the last comma. I saw several examples where there was just one comma. Could someone provide an example in which the text after the last comma is extracted? Thank you — Jazzmine, Mar 09 '16 at 16:21

score 9 · Answer 1 · answered Mar 09 '16 at 16:28

 >>> s = '501,555,570=3.5'
 >>> s.split(",")[-1]
 '570=3.5'

This will access the last element in the split string. It is not dependent on how many commas are in the string.

Example of longer string:

>>> s = "501,555,670,450,1,12,570=3.5"
>>> s.split(",")[-1]
'570=3.5'

score 8 · Accepted Answer · answered Mar 09 '16 at 16:17

8

You can use the str.rsplit() function as follows:

In [34]: s = '501,555,570=3.5'

In [35]: s.rsplit(',', 1)[1]
Out[35]: '570=3.5'

answered Mar 09 '16 at 16:17

gtlambert

I think all the answers provided worked but as you are first, I've indicated this is the correct answer. However, I did test the s.split(',') approach which also produced the same results. Thanks everyone. – Jazzmine Mar 09 '16 at 16:59

score 4 · Answer 3 · answered Mar 09 '16 at 16:18

4

A slight variation of wim's answer, if you're in a recent Python 3 version:

>>> s = '501,555,570=3.5'
>>> *others, last = s.split(',')
>>> last
'570=3.5'

answered Mar 09 '16 at 16:18

L3viathan

1

or just ``last = s.split(',')[-1]`` to access the last element. – MSeifert Mar 09 '16 at 16:19
very nice, I used it : ) – Ido Bleicher May 08 '22 at 15:50

score 2 · Answer 4 · answered Mar 09 '16 at 16:17

2

>>> s = '501,555,570=3.5'
>>> others, last = s.rsplit(',', 1)
>>> last
'570=3.5'

answered Mar 09 '16 at 16:17

wim

score 2 · Answer 5 · answered Mar 09 '16 at 16:20

2

Another variation, and how I would do it myself:

>>> s = '501,555,570=3.5'
>>> last = s.split(',')[-1]
>>> last
'570=3.5'

answered Mar 09 '16 at 16:20

score 2 · Answer 6 · answered Mar 09 '16 at 16:50

2

Using rpartition and as @ MartijnPieters♦ mentioned here in his comment.

for a single split, str.rpartition() is going to be faster.

>>> s.rpartition(',')[-1]
'570=3.5'

answered Mar 09 '16 at 16:50

styvane

score 1 · Answer 7 · answered Mar 09 '16 at 16:24

1

You could take substring from the position after where you find the last comma.

s[s.rfind(',') + 1 : ]

answered Mar 09 '16 at 16:24

dorado

7 Answers7