share

def groups_share_1(data_frame):
    #formula : GxR / sum(revenue) * 100
    first_group = data_frame.loc[3, 'GxR / GxRW']
    result_sum = data_frame.loc[0, 'Revenue']
    data_frame.loc[2, 'Groups Share'] = str(int((first_group / result_sum) * 100)) + '%'
    return data_frame

def groups_share_2(data_frame):
    second_group = data_frame.loc[3, '1']
    result_sum = data_frame.loc[0, 'Revenue']
    data_frame.loc[2, '7'] = str(int((second_group / result_sum) * 100)) + '%'
    return data_frame


def groups_share_3(data_frame):
    third_group = data_frame.loc[3, '2']
    result_sum = data_frame.loc[0, 'Revenue']
    data_frame.loc[2, '8'] = str(int((third_group / result_sum) * 100 )) + '%'
    return data_frame

def groups_share_delta(data_frame):
    delta_group = data_frame.loc[3, '6']
    result_sum = data_frame.loc[0, 'Revenue']
    data_frame.loc[2, '9'] = str(int((delta_group / result_sum) * 100)) + '%'
    return data_frame