擅长:python、mysql、java
<p>如果你能使用熊猫,你可以做如下操作:</p>
<pre><code>new_txt = """key |amount
abgc-nhd|8976
mkis-plqa-d|-254
mjsnh-kis-ls|987
njud-lo-sa|5291
mkjsh-kis-ls|686
mjsnh-fis-ls|387
njudd-kid-ls|-876
nswxd-lo-sa|3191
mki-ksjd-as|-56"""
old_txt = """key |amount
mkjsh-kis-ls|686
njudd-kid-ls|-876
abgc-nhd|8976
mjsnh-kis-ls|987
njud-lo-sa|5291
mjsnh-fis-ls|387
mkis-plqa-d|-254
nswxd-lo-sa|3191"""
import pandas as pd
import io
df_new = pd.DataFrame.from_csv(io.StringIO(new_txt), sep="|")
df_old = pd.DataFrame.from_csv(io.StringIO(old_txt), sep="|")
print(df_new - df_old)
</code></pre>
<p>以下为示例数据:</p>
^{pr2}$
<p><code>NaN</code>表示该密钥只存在于一个集合中。在</p>