0

I have a dataframe which contains the list of employees with their managers. The dataframe has the below columns

Employee ID Employee Name Manager Name

I want to insert a fourth column in the dataframe to pull out the Employee ID of the Manager. In Excel, I would have done that by using a Vlookup for the Manager Name in the Employee Name section and pulling out the Employee ID. Can someone please guide me on how this can be done in Python Dataframes?

Improve this question
3
  • "pull out the Employee ID of the Manager" is very vague. Please be precise in what the final output would look like Commented Jul 13, 2022 at 17:15
  • Sorry Nicholas. My bad. I also just got the answer to my query through this link (stackoverflow.com/questions/38291908/…). Thanks for offering your help. Commented Jul 13, 2022 at 17:19
  • Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Commented Jul 22, 2022 at 6:01
Related questions
7
vlookup between 2 Pandas dataframes
1
How to conditionally do a vlookup in Pandas dataframe
0
How to use VLOOKUP - using pandas, I guess - with python?
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.