Equivalent of Vlookup into return values inside Pandas Dataframe

Question

I have this Pandas Dataframe

MasterID  product_id  packing_id   Product Name 
1            1                      Apple
1                       1A          
1           1B
1           1C
2                       2A          Banana
3            3                      Orange
3                       3A
4            4                      kiwi
5                       5A          grape
5                       5B

I would like like to return a "product family" column. In excel, I would do a Vlookup on the master ID and return the product name in my column.

MasterID  product_id  packing_id   Product Name  Product Family
1            1                      Apple          Apple
1                       1A                         Apple
1           1B                                     Apple
1           1C                                     Apple
2                       2A          Banana         Banana
3            3                      Orange         Orange 
3                       3A                         Orange
4            4                      kiwi           Kiwi
5                       5A          grape          grape
5                       5B                         grape

How I do this in Python?

`df['Product Family'] = df.groupby('MasterID')['Product Name'].transform('first')` — anky, Apr 07 '20 at 04:11
Yep :) you can find similar reference here: https://stackoverflow.com/q/30244952 — anky, Apr 07 '20 at 04:15

Simon GIS · Answer 1 · 2020-04-07T04:33:46.307

0

From @anky

df['Product Family'] = df.groupby('MasterID')['Product Name'].transform('first')

edited Apr 07 '20 at 04:33

answered Apr 07 '20 at 04:15

Simon GIS

1,045
2
18
37

Equivalent of Vlookup into return values inside Pandas Dataframe

1 Answers1