compare-dfs 0.0.6

A small example package

compare_df

介绍

找出两个几乎相同的DataFrame的差异

安装

pip install compare_dfs

使用

import pandas as pd
import compare_dfs as cpdfs

df1 = pd.DataFrame({
    "id": [1, 2, 3, 4, 5],
    "name": ["a", "b", "c", "d", "e"],
    "age1": [10, 20, 30, 40, 50],
})
df2 = pd.DataFrame({
    "id": [1, 2, 3, 4, 6],
    "name": ["a", "b", "f", "d", "e"],
    "age2": [10, 25, 30, 40, 50],
})

df1.set_index("id", inplace=True)
df2.set_index("id", inplace=True)

different_colnames = cpdfs.compare_colnames(df1, df2)
print(different_colnames)

print(cpdfs.compare(df1, df2, different_colnames, dfname_1="左表", dfname_2="右表"))

输出：

只在第一个表中的列名：{'age1'}
只在第二个表中的列名：{'age2'}
[('age1', 'age2')]
左表中有，右表中没有的索引：{5}
右表中有，左表中没有的索引：{6}
=====================================
   name_左表 name_右表
id                
3        c       f
=====================================
    age1  age2
id            
2     20    25
=====================================
[   name_左表 name_右表
id                
3        c       f,     age1  age2
id            
2     20    25]