The given input is like:

EMPLOYEE_ID NAME     MANAGER_ID101         A       10102         B       1110          C       111          D       11           E       nullEmployee     Cycle      LEVEL Path101         A         101/10/1102         B         102/11/110          C         10/111          D         11/11           E         1

It will be great if one can solve it using python "pandas" library. I am not sure if it can be achieved using pandas or not. Other solutions are also welcomed.

dictionary with EMPLOYEE_ID and MANAGER_ID:

dct = dict(zip(df.EMPLOYEE_ID.values, df.MANAGER_ID.values))

function to create hierarchy string

def heirarchy(id):boss = str(id) + '/'while dct[id] != 'null':boss += dct[id] + '/'id = int(dct[id])return boss[:-1]

apply

df['LEVEL'] = df.EMPLOYEE_ID.apply(heirarchy)# ResultEMPLOYEE_ID NAME MANAGER_ID     LEVEL
0          101    A         10  101/10/1
1          102    B         11  102/11/1
2           10    C          1      10/1
3           11    D          1      11/1
4            1    E       null         1