擅长:python、mysql、java
<p>您可以重新定义字典(<code>d</code>此处),为字符串中出现的每个代码提供一个单独的<code>code:region</code>条目,并使用它映射<code>code</code>列中的值:</p>
<pre><code>d_ = {code:sd['name'] for sd in d['regions'] for code in sd['code'].split(',')}
# {'SA01': 'South America', 'SA02': 'South America', 'SA03': 'South America',...
df['region'] = df.code.map(d_)
</code></pre>
<hr/>
<pre><code>print(df)
id code region
0 1 SA01 South America
1 2 SA02 South America
2 3 SA03 South America
3 4 AP01 Asia Pacific
4 5 AP02 Asia Pacific
5 6 AP03 Asia Pacific
</code></pre>