def __compare_vars(a1, a2, name):
    """
    Check that the metadata variable names are the same as the data header variable names
    :param list a1: Variable names
    :param list a2: Variable names
    :param str name: Sheet name
    :return bool: Truth
    """
    try:
        a1 = [i for i in a1 if i]
        a2 = [i for i in a2 if i]
        a3 = set(a1).symmetric_difference(set(a2))
        if a3:
            print("- Error: Variables are not entered correctly in sheet: {}\n\tUnmatched variables: {}".format(name, a3))
    except Exception as e:
        logger_excel.error("compare_vars: {}".format(e))
    return
def __compare_vars ( a1 , a2 , name ) : try : a1 = [ i for i in a1 if i ] a2 = [ i for i in a2 if i ] a3 = set ( a1 ) . symmetric_difference ( set ( a2 ) ) if a3 : print ( "- Error: Variables are not entered correctly in sheet: {}\n\tUnmatched variables: {}" . format ( name , a3 ) ) except Exception as e : logger_excel . error ( "compare_vars: {}" . format ( e ) ) return
Check that the metadata variable names are the same as the data header variable names
    :param list a1: Variable names
    :param list a2: Variable names
    :param str name: Sheet name
    :return bool: Truth