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)

Tags:

Updated: