擅长:python、mysql、java
<p>尝试重命名<code>data2</code>中的列,这将稍微简化合并代码。在</p>
<pre><code>data1.merge(data2.rename(columns={'Loan_ID2' : 'Loan_ID'}), on='Loan_ID')
Loan_ID Gender LoanAmount
0 LP001003 Male 128.0
1 LP001005 Male 66.0
2 LP001006 Male 120.0
3 LP001008 Male 141.0
4 LP001011 Male 267.0
</code></pre>