擅长:python、mysql、java
<p>我要做的<code>replace</code></p>
<pre><code>df=pd.concat([file1,file1.replace(dict(zip(file2.col1,file2.col2))).add_suffix('_1')],axis=1).\
sort_index(axis=1)
col1 col1_1 col2 col2_1 col3 col3_1
0 A001 8 B001 7 C001 2
1 A002 2 B002 4 C002 9
2 A003 4 B003 10 C003 8
3 A004 1 B004 11 C004 1
4 A005 8 B005 8 C005 7
5 A006 3 B006 3 C006 6
</code></pre>