用Pandas将一个字符串列组合到另一个字符串列

Question

如果我有以下数据帧：

id     categories      products
01        fruit       Apple, Apricot
02        fruit       Apple, Banana, Clementine, Pear
03        fruit       Orange, Pineapple, Pear
04      vegetable     Carrot, Cabbage

我想创建一个这样的新df，我该怎么办？谢谢。你知道吗

id          products
01     (fruit)Apple, Apricot
02     (fruit)Apple, Banana, Clementine, Pear
03     (fruit)Orange, Pineapple, Pear
04     (vegetable)Carrot, Cabbage

Answer 1

试试这个

    df = df.set_index('id')
    df  =df.apply(lambda x: "(" + x['categories'] + ")" + x['products'],axis=1).to_frame('products')
    print df