Merge emp (key dept) with managers (key team) and store name, dept, manager_name in result.
import pandas as pd
emp = pd.DataFrame({
"emp_id": [1, 2, 3, 4, 5, 6, 7, 8],
"name": ["Anita", "Rahul", "Priya", "Arjun", "Sneha", "Vikram", "Kavya", "Rohan"],
"dept": ["Eng", "Eng", "Eng", "Sales", "Sales", "HR", "HR", "Sales"],
"salary": [250000, 180000, 140000, 95000, 95000, 110000, 48000, 58000],
"city": ["Bengaluru", "Bengaluru", "Pune", "Mumbai", "Mumbai", "Pune", "Pune", "Kolkata"],
"joined": pd.to_datetime(["2015-03-01", "2017-06-15", "2018-01-10", "2020-07-01",
"2021-02-15", "2016-02-01", "2022-03-01", "2022-11-01"]),
})
managers = pd.DataFrame({"manager_name": ["Anita", "Arjun", "Vikram"], "team": ["Eng", "Sales", "HR"]})Store your final answer in a variable named result.
Run your code to see the output here.