Merge emp with depts on dept using validate="many_to_one" (each employee has one department row). Store name, dept, floor 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"]),
})
depts = pd.DataFrame({
"dept": ["Eng", "Sales", "HR", "Finance"],
"head": ["Anita", "Arjun", "Vikram", "Divya"],
"floor": [3, 1, 2, 4],
})Store your final answer in a variable named result.
Run your code to see the output here.