combine string in python pandas

Question

I got a problem when analyzing dataset about combining string together. The data frame looks like the one below:

IP      Event
01      check
01      redo
01      view
02      check
02      check
03      review
04      delete

As you can see, the IP contains duplicates. My question is, how can I get the results of combining the Event group by each IP in order.For example, the result I'm looking for is:

IP    result
01    check->redo->view
02    check->check
03    review
04    delete

MaxU - stand with Ukraine · Accepted Answer · 2016-06-20 22:11:22Z

3

try this:

In [27]: df.groupby('IP').agg('->'.join).reset_index()
Out[27]:
   IP              Event
0  01  check->redo->view
1  02       check->check
2  03             review
3  04             delete

or

In [26]: df.groupby('IP').agg('->'.join)
Out[26]:
                Event
IP
01  check->redo->view
02       check->check
03             review
04             delete

answered Jun 20, 2016 at 22:11

MaxU - stand with Ukraine

212k37 gold badges402 silver badges436 bronze badges

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

Comments

Merlin · Accepted Answer · 2016-06-21 03:48:19Z

1

Try this with lambda:

df.groupby("IP")['Event'].apply(lambda x: '->'.join(x)).reset_index()


  #  IP           Event
# 0   1  check->redo->view
# 1   2       check->check
# 2   3             review
# 3   4             delete

answered Jun 21, 2016 at 3:48

Merlin

25.9k44 gold badges141 silver badges213 bronze badges

Collectives™ on Stack Overflow

combine string in python pandas

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related