Hello Rohit, Found this on the net : https://stackoverflow.com/questions/25493625/vlookup-in-pandas-using-join
May be that might give you some hints. On Wed, Mar 28, 2018 at 12:00 PM, Rohit Adhikari <rohad...@gmail.com> wrote: > I tried with that but i got lots of duplicates rows. > > Regards, > Rohit > > On Wed, Mar 28, 2018 at 11:43 AM, Soumyo Dey <soumyo...@live.com> wrote: > > > Hey Rohit, > > > > Please consider using Pandas Dataframe Merge/Join functions for vlookup > > like results. > > > > Regards, > > Soumyo Dey > > > > -----Original Message----- > > From: BangPypers [mailto:bangpypers-bounces+soumyodey= > live....@python.org] > > On Behalf Of Rohit Adhikari > > Sent: 28 March 2018 11:39 > > To: bangpypers@python.org > > Subject: [BangPypers] Vlookup in python dataframes > > > > Hi all, > > Do we have vlookup function for the python where we can search the value > > of variable in range of column and return the same like we have in excel. > > > > Regards, > > Rohit > > _______________________________________________ > > BangPypers mailing list > > BangPypers@python.org > > https://nam01.safelinks.protection.outlook.com/?url= > > https%3A%2F%2Fmail.python.org%2Fmailman%2Flistinfo% > > 2Fbangpypers&data=02%7C01%7C%7C97bb8dd26f2f49f3360008d594727116% > > 7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636578141599368987&sdata= > > bjcsSuObXKzFeIl7xRkv10Vni2IjWTRF%2FP3i2VnXaek%3D&reserved=0 > > _______________________________________________ > > BangPypers mailing list > > BangPypers@python.org > > https://mail.python.org/mailman/listinfo/bangpypers > > > _______________________________________________ > BangPypers mailing list > BangPypers@python.org > https://mail.python.org/mailman/listinfo/bangpypers > -- Thanks -- Sarfraaz Ahmed _______________________________________________ BangPypers mailing list BangPypers@python.org https://mail.python.org/mailman/listinfo/bangpypers