<p>从所需的输出来看,除了默认情况下完成的列相交合并之外,似乎不需要任何<em>规范。你知道吗</p>
<pre><code>>>> df1.merge(df2).merge(df3)
Name1 Name2 Name3 Address ID1 ID2 Own Name4 Address2 Hash
0 Matt John1 Jill 878 home 1 0 Deal face1 face\123 abc123
1 Matt John1 Jill 878 home 1 0 Deal face2 face\345 cde321
2 Matt John1 Jill 878 home 1 0 Deal face3 face\678 efg123
3 Matt John2 Jack 879 home 2 1 Dael head1 head\123 123efg
4 Matt John2 Jack 879 home 2 1 Dael head2 head\345 efg321
5 Matt John2 Jack 879 home 2 1 Dael head3 head\678 acd321
</code></pre>
<p>指定要合并的单列作为接受的答案实际上会导致问题,因为您将有后缀列。你知道吗</p>
<pre><code>>>> df1.merge(df2, on="ID1", how="inner").merge(df3, on="Address2", how="inner")
Name1_x Name2 Name3 Address_x ID1 ID2 Own Name1_y Address_y Name4 \
0 Matt John1 Jill 878home 1 0 Deal Matt 878home face1
1 Matt John1 Jill 878home 1 0 Deal Matt 878home face2
2 Matt John1 Jill 878home 1 0 Deal Matt 878home face3
3 Matt John2 Jack 879home 2 1 Dael Matt 879home head1
4 Matt John2 Jack 879home 2 1 Dael Matt 879home head2
5 Matt John2 Jack 879home 2 1 Dael Matt 879home head3
Address2 Hash
0 face\123 abc123
1 face\345 cde321
2 face\678 efg123
3 head\123 123efg
4 head\345 efg321
5 head\678 acd321
</code></pre>