擅长:python、mysql、java
<p>只需数据帧和合并。代码如下</p>
<pre><code>dff.merge(pd.DataFrame([{'source_id': '1', 'source_desc': 'XML1'},
{'source_id': '2', 'source_desc': 'XML2'},
{'source_id': '3', 'source_desc': 'XML3'}]), how='left', on='source_id')
</code></pre>
<p>输出</p>
<pre><code> source_id city source_desc
0 1 NY XML1
1 2 Santiago XML2
2 3 Berlin XML3
</code></pre>