def get_siteid(df, default='unknown'):
    """does case insensitive match on column names for SiteID.
        If found, will return string from the first row.
        If not found, will return default value."""
    rtn = ''
    print('looking for SiteID in dataframe...')
    for col in df.columns:
        if col.lower().replace('_', '') == 'siteid':
            rtn = df[col].iloc[0]
            break
    if rtn == '':
        rtn = default
        print('did not find, using default', default)
    else:
        print('found SiteID in dataframe', rtn)
    return rtn
