回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我有一个数据框,看起来像:</p>
<pre><code>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"]})
print(df)
| user_id | score | valval
-----+---------+-------+--------
0 | a | 0 | va2.3
1 | b | 100 | va1.1
2 | c | 50 | va2.1
3 | d | 0 | va2.2
4 | e | 25 | va1.2
5 | f | 50 | va1.1
6 | g | 100 | va2.1
7 | h | 0 | va1.2
8 | i | 7 | va1.2
9 | j | 20 | va1.3
</code></pre>
<p>我还有一本字典,看起来像:</p>
<pre><code>dic_t = { "key1" : ["va1.1", "va1.2", "va1.3"], "key2" : ["va2.1", "va2.2", "va2.3"]}
</code></pre>
<p>我想要一个新的专栏“keykey”</p>
<p>此列的值具有对应值字典的键</p>
<p>结果如下所示:</p>
<pre><code> | 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>