擅长:python、mysql、java
<p>使用<code>str</code></p>
<pre><code>df2['LAST_NAME']=df2['LAST_NAME'].str[:3]+df1['LAST_NAME'].str[:6]
df2['FIRST_NAME']=df2['FIRST_NAME'].str[:3]+df1['FIRST_NAME'].str[:6]
df2
Out[768]:
CUSTOMER_KEY LAST_NAME FIRST_NAME
0 30 Artf2b676 And97bb97
1 46 Terca0464 Johe27653
2 51 Lou62f290 Hur8dfabd
3 57 Tim21032c Add1f7e5e
4 62 Jeff7e7fd Wileb6cf4
5 64 Andf53699 Tul7fc39e
6 80 Dan606919 Gred873a7
7 99 Fra0ba61a Nada6cf7a
8 102 Faie8b579 Youc8048f
</code></pre>
<p>如果你需要合并。在</p>
^{pr2}$