Vlookup in python dataframes

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Vlookup in python dataframes

Rohit Adhikari
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
[hidden email]
https://mail.python.org/mailman/listinfo/bangpypers
Reply | Threaded
Open this post in threaded view
|

Re: Vlookup in python dataframes

Soumyo Dey
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=[hidden email]] On Behalf Of Rohit Adhikari
Sent: 28 March 2018 11:39
To: [hidden email]
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
[hidden email]
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
[hidden email]
https://mail.python.org/mailman/listinfo/bangpypers
Reply | Threaded
Open this post in threaded view
|

Re: Vlookup in python dataframes

Rohit Adhikari
I tried with that but i got lots of duplicates rows.

Regards,
Rohit

On Wed, Mar 28, 2018 at 11:43 AM, Soumyo Dey <[hidden email]> 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=[hidden email]]
> On Behalf Of Rohit Adhikari
> Sent: 28 March 2018 11:39
> To: [hidden email]
> 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
> [hidden email]
> 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
> [hidden email]
> https://mail.python.org/mailman/listinfo/bangpypers
>
_______________________________________________
BangPypers mailing list
[hidden email]
https://mail.python.org/mailman/listinfo/bangpypers
Reply | Threaded
Open this post in threaded view
|

Re: Vlookup in python dataframes

Sarfraaz Ahmed
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 <[hidden email]> 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 <[hidden email]> 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=
> [hidden email]]
> > On Behalf Of Rohit Adhikari
> > Sent: 28 March 2018 11:39
> > To: [hidden email]
> > 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
> > [hidden email]
> > 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
> > [hidden email]
> > https://mail.python.org/mailman/listinfo/bangpypers
> >
> _______________________________________________
> BangPypers mailing list
> [hidden email]
> https://mail.python.org/mailman/listinfo/bangpypers
>



--
        Thanks
               -- Sarfraaz Ahmed
_______________________________________________
BangPypers mailing list
[hidden email]
https://mail.python.org/mailman/listinfo/bangpypers