daily log 10.21.20
less than 1 minute read
How to pretty print all the supervisors into a nice column
def return_report_chain(employee):
print("*"*100)
# print(employee)
all_sups = []
def get_report_chain(employee):
if employee == 'CEO':
all_sups.append('CEO')
return 'done'
else:
print(employee)
curr_employee = df.loc[df['first_last'] == employee]
next_level = "{} {}, {} ({}) reports to -- ".format(
curr_employee['First Name'].values[0],
curr_employee['Last Name'].values[0],
curr_employee['Job'].values[0],
curr_employee['Org Level 1'].values[0])
all_sups.append(next_level)
supervisor = df.loc[df['first_last'] == employee]['supervisor'].values[0]
return get_report_chain(supervisor)
get_report_chain(employee)
return ''.join(all_sups)
df['supervisor_chain'] = df.apply(lambda x: return_report_chain(x['first_last']), axis=1)