Groupby functions in Pandas to combine string values

Question

My df is in the following Format:

When i do a df.groupby('Tool').sum() i get the following:

The expected output is the following:

Please guide me in achieving the desired output.

1. Do not post images of the dataframe but a Minimal, Complete and Verifiable example. 2. What have you tried until now (except the groupby.sum() line)? Did you move past that? — CAPSLOCK
– CAPSLOCK, Commented Apr 24, 2019 at 11:10
Apologies for posting dataframe as image. Will avoid doing it next time onwards. — Prasanna
– Prasanna, Commented Apr 24, 2019 at 11:14

jezrael · Accepted Answer · 2019-04-24 11:39:57Z

3

Use GroupBy.agg with convert values to sets and then join by /:

df.groupby('Tool').agg(lambda x: '/'.join(set(x)))

answered Apr 24, 2019 at 11:12

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Comments

MIKHIL NAGARALE · Accepted Answer · 2019-04-24 11:45:02Z

0

#You can also use-
df.groupby('Tool').agg(min("Cost Center") as "Cost Center",min("Nature") as "Nature").show

answered Apr 24, 2019 at 11:45

MIKHIL NAGARALE

1939 bronze badges