python比较两个dataframe是否一致

python比较两个dataframe是否一致

需求

如题

代码

def compare_values(df1_list, df2_list):
    result = []
    for i in range(0,4):
        df1 = df1_list[i]
        df2 = df2_list[i]
        df1_r, df1_c = df1.shape
        df2_r, df2_c = df2.shape
        res = True
        if ((df1_r != df2_r) or (df1_c != df2_c)):
            raise Exception('Dimension Mismatch!')

        df1_t = df1.fillna(value='')
        df2_t = df2.fillna(value='')
        value = (df1_t.values.ravel() == df2_t.values.ravel())
        value = list(value)
        if False in value:
            res = False
        '''
        for i, v in enumerate(res):  # 这里其实需要做循环判断了,只是为了展示哪行哪列不好
            if not v:
                r = i // df1_c
                c = i % df1_c
                print('====================')
                print(r, c)
                print(df1.iloc[r, c])
                print(df2.iloc[r, c])
                print('====================')
        '''
        result.append(res)
    #return res.count(False) <= 0
    return result

原文不知道在哪了,看到有类似的请联系我。


版权声明:本文为qq_37195179原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。