擅长:python、mysql、java
<p><strong>设置</strong></p>
<p>考虑数据帧<code>inventory</code>和<code>replace_with</code></p>
<pre><code>inventory = pd.DataFrame(dict(Partnumbers=['123AAA', '123BBB', '123CCC']))
replace_with = pd.DataFrame(dict(
oldPartnumbers=['123AAA', '123BBB', '123CCC'],
newPartnumbers=['123ABC', '123DEF', '123GHI']
))
</code></pre>
<p><strong>选项1</strong><br/>
<em><code>map</code></em></p>
<pre><code>d = replace_with.set_index('oldPartnumbers').newPartnumbers
inventory['Partnumbers'] = inventory['Partnumbers'].map(d)
inventory
Partnumbers
0 123ABC
1 123DEF
2 123GHI
</code></pre>
<hr/>
<p><strong>选项2</strong><br/>
<em><code>replace</code></em></p>
<pre><code>d = replace_with.set_index('oldPartnumbers').newPartnumbers
inventory['Partnumbers'].replace(d, inplace=True)
inventory
Partnumbers
0 123ABC
1 123DEF
2 123GHI
</code></pre>