How to combine a dataframe normal column with set column in pandas?

Question

have got a dataframe df

item        Space   rem_spc     nxt_item
Pineapple   0.5     0.5         {Mango, Grape}

need to combine df['item'] and df['nxt_item'] into single column df['com_item'] as given below

item        Space   rem_spc     nxt_item        com_item
Pineapple   0.5     0.5         {Mango, Grape}  Pineapple,Mango,Grape

Thanks!

Answer 1

With pandas.Series.strip :

df["com_item"] = df["item"] + "," + df["nxt_item"].astype(str).str.strip("{}")

Output :

print(df)

        item  Space  rem_spc        nxt_item                 com_item
0  Pineapple    0.5      0.5  {Mango, Grape}  Pineapple, Mango, Grape