擅长:python、mysql、java
<p>存储国家代码映射的更好方法是在字典中。我假设<code>country_dict1</code>,<code>country_dict2</code>分别是每个数据帧的<code>code:region</code>的映射:</p>
<pre><code>def determine_region(row):
for item in row[:-3:-1]:
if item in country_dict1:
return country_dict1.get(item)
for item2 in row[-3::-1]:
if item2 in country_dict2:
return country_dict2.get(item2)
return pd.np.nan
df['Region'] = df.apply(determine_region, axis=1)
</code></pre>