擅长:python、mysql、java
<P>更新空白字典并使用map函数</p>
<pre><code>import pandas as pd
df = pd.DataFrame({"user_id" : ['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j'],
"score" : [0, 100, 50, 0, 25, 50, 100, 0, 7, 20],
"valval" : ["va2.3", "va1.1", "va2.1", "va2.2", "va1.2", "va1.1", "va2.1", "va1.2", "va1.2", "va1.3"]})
dic_t = { "key1" : ["va1.1", "va1.2", "va1.3"], "key2" : ["va2.1", "va2.2", "va2.3"]}
d_keykey = {}
for k, v in dic_t.items():
for val in v:
d_keykey.update({val: k})
df["keykey"] = df["valval"].map(d_keykey)
print(df)
user_id score valval keykey
0 a 0 va2.3 key2
1 b 100 va1.1 key1
2 c 50 va2.1 key2
3 d 0 va2.2 key2
4 e 25 va1.2 key1
5 f 50 va1.1 key1
6 g 100 va2.1 key2
7 h 0 va1.2 key1
8 i 7 va1.2 key1
9 j 20 va1.3 key1
</code></pre>