擅长:python、mysql、java
<p>您希望在<code>'SETTLEMENTDATE'</code>上进行合并,但此系列从您的输入数据帧中排除。{}因此饲养熊猫。请尝试:</p>
<pre><code>result = pd.merge(data1[['REGION', 'TOTALDEMAND', 'RRP', 'SETTLEMENTDATE']],
data2[['REGION', 'TOTALDEMAND', 'RRP', 'SETTLEMENTDATE']],
on='SETTLEMENTDATE')
</code></pre>