通过像一些固定倍数浮动列-您可以使用一个小巧的黑客工具
100,
1000…,转换列
int,
merge:和恒最后的除以
N = 100#thank you koalo for commentA.col2 = np.round(A.col2*N).astype(int) B.col2 = np.round(B.col2*N).astype(int) df = pd.merge(A, B, how = 'outer', on = ['col1', 'col2'])df.col2 = df.col2 / Nprint (df) col1 col2 sub grade group ID0 1 34.32 x a t z1 1 34.32 x b t z2 1 34.33 y c r z3 2 10.14 z b q z4 3 33.01 z a q e5 1 54.32 NaN NaN s w



