event_case_study_1.py

import pandas as pd


# Import customer list for company match and employee list for department atribution
df_customer_list = pd.read_excel('---.xlsx', skiprows=10)
customers = df_customer_list[['Company']]['Company'].to_list()

employee_list = pd.read_excel('---.xlsx')

employee_list['Full Name'] = [f"{employee_list['First Name'][i]} {employee_list['Last Name'][i]}" for i in range(employee_list.shape[0])]
employee_list = employee_list[['Full Name', 'Department']].rename(columns={'Full Name':'Employee (if channel=employee sharing)'})