您可以使用 map
方法,将字典中的键和值进行对调:
d = {k: oldk for oldk, oldv in Regions.items() for k in oldv}
print (d)
{'Andorra': 'Europe', 'Afghanistan': 'Central Asia',
'Algeria': 'Africa', 'American Samoa': 'America', 'Albania': 'Europe'}
df['Region'] = df['country'].map(d)
print (df)
country Region
0 Afghanistan Central Asia
1 Albania Europe
2 Algeria Africa
3 American Samoa America
4 Andorra Europe
DataFrame.from_dict
和df.stack()
可编写一行代码(感谢MaxU!):In [8]: pd.DataFrame.from_dict(Regions, orient='index').stack()\
.reset_index(level=0)\
.rename(columns={'level_0':'Region',0:'country'})\
.reset_index(drop=True)
Out[8]:
Region country
0 Europe Albania
1 Europe Andorra
2 Africa Algeria
3 Central Asia Afghanistan
4 America American Samoa
pd.DataFrame.from_dict(Regions, orient='index').stack().reset_index(level=0).rename(columns={'level_0':'Region',0:'country'}).reset_index(drop=True)
的翻译是什么? - MaxU - stand with Ukraine