col_neg.py

## Highliting losses in the dataframe 
def color_negative_values(value): 
    """
    This function takes in values of dataframe 
    if particular value is negative it is colored as redwhich implies loss
    if value is greater than one it implies higher profit
    """
    if value < 0:
        color = '#ff8a8a'
    elif value > 1:
        color = '#4fc277'
    else:
        color = 'black'
    return f"color: {color}"
companies_returns.style.applymap(color_negative_values)