segmenting datas at pandas python

Question

I have a problem with segmenting a pd.DataFrame (or pd.Series) at a point the value switches.

For example, I have a data like

list('AAAAABBBBBAAABBBCCCCBBBBAAAAA')

as you can see, As and Bs and Cs are arranged in chunks.

What is the most pythonic way to manage them in to segments?

I believe the code will be produce a array-like data that is like:

list('00000111112223334445555666677777')

which is a list of the names for the segments.

Back2Basics · Accepted Answer · 2017-03-04 01:21:27Z

1

Most pythonic way would be using itertools.groupby()

But your output format needs some work as it only holds 10 numbers (0-9) what's the difference between character '11' and '1' when it's repeated several times like that.

answered Mar 4, 2017 at 1:21

Back2Basics

7,8462 gold badges35 silver badges50 bronze badges

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

1 Comment

Allosteric Over a year ago

thanks a lot! my output format was just to avoid the lousy [0,0,0,0,1, ... ] which could have been veeery long.

Collectives™ on Stack Overflow

segmenting datas at pandas python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related