daily log 10.13.20

df['Email'] = df['E-mail Address']
df['ID'] = df['Employee Number']
df['Name'] = df['clean_name']
df['Dept'] = df['Org Level 1']
for i in range(33):  
    sm_df = df[df['new_group_number'] == str(i)]
    must_be_friday = False
    for index, row in sm_df.iterrows():
        if (row['only_friday'] == True):
            must_be_friday = True
#         print(row['E-mail Address'])
    
    
    sm_sm_df = sm_df[['ID', 'Name', 'Job', 'Dept']]
    print(tabulate(sm_sm_df, tablefmt="rst", headers=sm_sm_df.columns, showindex=False))
    sm_sm_df2 = sm_df[['Name','Email']]
    print(tabulate(sm_sm_df2, tablefmt="rst", headers=sm_sm_df2.columns, showindex=False))
    print
    if must_be_friday:
        
        print('NOTES: Meeting must be friday')