擅长:python、mysql、java
<p><code>replace</code>和<code>loc</code>访问:</p>
<pre><code>s = df[['UniqueID','PRODUCTIVITY']].set_index('UniqueID')
# using to_numpy here :-)
df['PRODUCTIVITY'] = s.loc[df['UniqueID'].replace(parent_child_dict)].to_numpy()
</code></pre>
<p>输出:</p>
<pre><code> UniqueID CST WEIGHT VOLUME PRODUCTIVITY
0 413-20012 3 123 12 7894
1 413-45365 1 889 75 4545
2 413-21165 8 554 13 7894
3 413-24354 1 387 35 7649
4 413-34658 2 121 88 2468
5 413-36889 4 105 76 3336
6 413-23457 5 355 42 7894
7 413-30089 5 146 10 9112
8 413-41158 5 453 91 4545
9 413-51015 9 654 66 4545
</code></pre>