Pandas combining one column's values with same index into list [duplicate]

Question

I have a Pandas DF as below, and I'm struggling with printing it in a good looking format... Could someone please show me how to combine those two values from same column values?

data = {'Animal':['DOG','CAT','CAT','BIRD'],
        'Color':['WHITE','BLACK','ORANGE','YELLOW']}
df = pd.DataFrame(data)
df

And I wish the print result would be exactly as below:

DOG, WHITE
CAT, BLACK, ORANGE
BIRD, YELLOW

print(df.to_string()) stackoverflow.com/questions/19124601/… — k3b
– k3b, Commented Sep 17, 2020 at 11:09

Umar.H · Accepted Answer · 2020-09-17 11:10:09Z

0

use groupby and to_string

print(df.groupby('Animal')['Color'].agg(', '.join).to_string())


Animal
BIRD           YELLOW
CAT     BLACK, ORANGE
DOG             WHITE

answered Sep 17, 2020 at 11:10

Umar.H

23.1k7 gold badges50 silver badges94 bronze badges

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

4 Comments

vem Over a year ago

Hi, thank you so much for replying. The way you did combines the two values with same index. But the result will still show the "Animal" column, I only want the rows' values, and between the Animal and Color columns, only add ", ". Like the way I show in my question.

Umar.H Over a year ago

use header=None i.e print(df.groupby('Animal')['Color'].agg(', '.join).to_string(header=None)) @vem

vem Over a year ago

But after the print function, there is still so many blank spaces between "Animal" and "Color". I actually want to combine them with one comma and one space. i.e. CAT, BLACK, ORANGE @Manakin

Umar.H Over a year ago

try print(df.groupby('Animal')['Color'].agg(','.join).reset_index().agg(','.join,1).to_string(header=None,index=None)) you need to agg all your columns into a single field then print, won't be very performant though. @vem

Collectives™ on Stack Overflow

Pandas combining one column's values with same index into list [duplicate]

1 Answer 1

4 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Linked

Related