擅长:python、mysql、java
<p>用途:</p>
<pre><code>#if value not match get NaN
df = df[columnlist].applymap(dict1.get)
</code></pre>
<p>或:</p>
<pre><code>#if value not match get original value
df = df[columnlist].replace(dict1)
</code></pre>
<p>或:</p>
<pre><code>#if value not match get NaN
df = df[columnlist].stack().map(dict1).unstack()
</code></pre>
<hr/>
<pre><code>print (df)
OfferPreference_A OfferPreference_B OfferPreference_C
0 1 2 1
1 2 3 3
2 3 4 5
</code></pre>