ecld.py

def get_latest_highest(stock, comp, year):
    return get_exec_comp(stock)[get_exec_comp(stock)['year'] == year].drop_duplicates("nameAndPosition").sort_values(by=comp, ascending=False).iloc[0]

fr = []
p = []
stock_comp = []
total_comp = []
for ticker in r_2021['Adj Close'].reset_index()['index'].values:
    fr.append(r_2021['Adj Close'][ticker])
    p.append(p_2021['Adj Close'][ticker])
    stock_comp.append(get_latest_highest(ticker, 'stock_award', 2021)['stock_award'])
    total_comp.append(get_latest_highest(ticker, 'total', 2021)['total'])
    print('Done!')