擅长:python、mysql、java
<p>所以我们需要<code>merge</code>和一个额外的键,由<code>cumcount</code>创建</p>
<pre><code>df1=df1.assign(Key=df1.groupby(list(df1)).cumcount())
df2=df2.assign(Key=df1.groupby(list(df1)).cumcount()
df1.merge(df2, left_on=['ColumnA','ColumnB','ColumnC','ColumnD','Key'],
right_on=['ColumnE','ColumnF','ColumnG','ColumnH','Key'], how='outer')
Out[19]:
ColumnA ColumnB ColumnC ColumnD Key ColumnE ColumnF ColumnG ColumnH
0 1 2 3 4 0 1 2 3 4
1 1 2 3 4 1 1 2 3 4
</code></pre>