<p>联接列<code>EQ_NR</code>中存在重复项问题。你知道吗</p>
<p>在示例中有重复的值<code>1001380363</code>和<code>1001380594</code>。你知道吗</p>
<p>样品:</p>
<pre><code>import pandas as pd
df1 = pd.DataFrame({'EQ_NR':[1001380363,1001380363,1001380363, 1001380365],
'B':[4,5,6,7],
'C':[7,8,9,7]})
print (df1)
B C EQ_NR
0 4 7 1001380363
1 5 8 1001380363
2 6 9 1001380363
3 7 7 1001380365
df2 = pd.DataFrame({'EQ_NR':[1001380363,1001380363,1001380363,1001380363],
'B':[4,5,6,8],
'C':[7,8,9,3]})
print (df2)
B C EQ_NR
0 4 7 1001380363
1 5 8 1001380363
2 6 9 1001380363
3 8 3 1001380363
</code></pre>
<pre><code>print (pd.merge(df1, df2, on=['EQ_NR']))
B_x C_x EQ_NR B_y C_y
0 4 7 1001380363 4 7
1 4 7 1001380363 5 8
2 4 7 1001380363 6 9
3 4 7 1001380363 8 3
4 5 8 1001380363 4 7
5 5 8 1001380363 5 8
6 5 8 1001380363 6 9
7 5 8 1001380363 8 3
8 6 9 1001380363 4 7
9 6 9 1001380363 5 8
10 6 9 1001380363 6 9
11 6 9 1001380363 8 3
</code></pre>
<p>编辑1:</p>
<p>如果数据帧<code>df2</code>中没有重复数据,请使用:</p>
<pre><code>print (df1)
FAK_ART FAK_DAT LEIST_DAT KD_CRM MW_BW EQ_NR MATERIAL \
0 ZPAF 2015-12-10 2015-12-31 T-HOME ICP B 1001380363 B60ETS
1 ZPAF 2015-12-10 2015-12-31 T-HOME ICP B 1001380363 B60ETS
2 ZPAF 2015-12-10 2015-12-31 T-HOME ICP B 1001380363 B60ETS
3 ZPAF 2015-12-10 2015-12-31 T-HOME ICP B 1001380363 B60ETS
4 ZPAF 2015-12-10 2015-12-31 T-HOME ICP B 1001380363 B60ETS
5 ZPAF 2015-12-10 2015-12-31 T-HOME ICP B 1001380363 B60ETS
6 ZPAF 2015-12-10 2015-12-31 T-HOME ICP B 1001380363 B60ETS
7 ZPAF 2015-12-10 2015-12-31 T-HOME ICP E 1001380594 B60ETS
8 ZPAF 2015-12-10 2015-12-31 T-HOME ICP B 1001380594 B60ETS
KW_WERT NETTO_EURO TA
0 0.150 18.90 SDH
1 0.145 18.27 SDH
2 0.145 18.27 NaN
3 0.150 18.90 SDH
4 0.150 18.90 NaN
5 0.145 18.27 SDH
6 0.150 18.90 SDH
7 3.011 252.92 DSLAM/MSAN
8 3.412 429.91 DSLAM/MSAN
print (df2)
EQ_NR TA
0 1001380363 Sonstiges
1 1000943704 Sonstiges
2 1000943823 Sonstiges
3 1000943985 Sonstiges
4 1000954774 FMED
5 1000954790 FMED
6 1000955097 NaN
</code></pre>
<pre><code>print (pd.merge(df1, df2, on=['EQ_NR'], how='left', suffixes=('','_new')))
FAK_ART FAK_DAT LEIST_DAT KD_CRM MW_BW EQ_NR MATERIAL \
0 ZPAF 2015-12-10 2015-12-31 T-HOME ICP B 1001380363 B60ETS
1 ZPAF 2015-12-10 2015-12-31 T-HOME ICP B 1001380363 B60ETS
2 ZPAF 2015-12-10 2015-12-31 T-HOME ICP B 1001380363 B60ETS
3 ZPAF 2015-12-10 2015-12-31 T-HOME ICP B 1001380363 B60ETS
4 ZPAF 2015-12-10 2015-12-31 T-HOME ICP B 1001380363 B60ETS
5 ZPAF 2015-12-10 2015-12-31 T-HOME ICP B 1001380363 B60ETS
6 ZPAF 2015-12-10 2015-12-31 T-HOME ICP B 1001380363 B60ETS
7 ZPAF 2015-12-10 2015-12-31 T-HOME ICP E 1001380594 B60ETS
8 ZPAF 2015-12-10 2015-12-31 T-HOME ICP B 1001380594 B60ETS
KW_WERT NETTO_EURO TA TA_new
0 0.150 18.90 SDH Sonstiges
1 0.145 18.27 SDH Sonstiges
2 0.145 18.27 NaN Sonstiges
3 0.150 18.90 SDH Sonstiges
4 0.150 18.90 NaN Sonstiges
5 0.145 18.27 SDH Sonstiges
6 0.150 18.90 SDH Sonstiges
7 3.011 252.92 DSLAM/MSAN NaN
8 3.412 429.91 DSLAM/MSAN NaN
</code></pre>