df.loc[~df['Actual Days to Complete'].notnull(), 'Cases Metric Met'] = df['Actual Days to Complete']

df['Cases Metric Met'] = np.where((df['Actual Days to Complete']<= df['Metric (Days)']),1 ,0)

df.loc[(df['Component'] == 'USSS') & (df['New Hire Series']== 1811), 'PMCO'] = 'USSS Special Agent- 1811'

elastic.loc[~elastic['dl_comp_acr'].isnull(), 'org'] = elastic['dl_comp_acr']#where dl_comp_acr isnt null org is dl_comp_acr

eventcat.loc[(eventcat['idaction_event_category_name'] == 'download all') | (eventcat['idaction_event_category_name']== 'download selected'), 'type'] = 'downloadlog'