SQL output to list

Question

I have a csv in this format

ORDER_ID    Item_DESC
 121    Beer
 121    Chips
 121    Wine
 141    Chips
 141    Wine

I need to push this out in this format:

121    Beer,Chips,Wine
141    Chips,Wine

Can somebody point me to the right direction, I have been breaking my head for a week now.

I tried the following:

Excel Pandas-Pivot,stack,melt Recursive table in SQL

Any help is appreciated.

Andy Hayden · Accepted Answer · 2015-04-28 02:59:48Z

1

You can use groupby and apply:

In [11]: df
Out[11]:
   ORDER_ID Item_DESC
0       121      Beer
1       121     Chips
2       121      Wine
3       141     Chips
4       141      Wine

In [12]: df.groupby("ORDER_ID")["Item_DESC"].apply(",".join)
Out[12]:
ORDER_ID
121         Beer,Chips,Wine
141              Chips,Wine
Name: Item_DESC, dtype: object

Then use to_csv on this result.

answered Apr 28, 2015 at 2:59

Andy Hayden

378k110 gold badges640 silver badges546 bronze badges

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

4 Comments

sai Over a year ago

Awesome and If i want to get only Item_DESC , then how do I change the code.

Andy Hayden Over a year ago

@sai Not quite sure I know what you mean. Do you mean do list(...).

sai Over a year ago

The output from the above code comes with the ORDER_ID and then Beer,Chips,Wine. What if I dont want the order ID and only see Beer,Chips,Wine followed by Chips,Wine in the second row.

Andy Hayden Over a year ago

Use .to_csv(..., index=False).

Collectives™ on Stack Overflow

SQL output to list

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related