我正在尝试使用如下所示的DataFrame.replace()方法替换'Country'列中的少量值。但它不起作用。我也尝试了其他一些方法,但没有运气。任何人都可以帮我解决这个问题吗?
energy = pd.read_excel(r'C:\Users\User\Desktop\New folder\Launchcode\coursera dataScience\course1 week3\Energy Indicators.xls')[16:243]
energy = energy.drop(['Unnamed: 0','Unnamed: 1'], axis = 1).rename(columns={'Environmental Indicators: Energy': 'Country', 'Unnamed: 3': 'Energy Supply', 'Unnamed: 4': 'Energy Supply per Capita', 'Unnamed: 5': '% Renewable'})
energy.replace({"Republic of Korea": "South Korea", "United States of America": "United States", "United Kingdom of Great Britain and Northern Ireland": "United Kingdom", "China, Hong Kong Special Administrative Region": "Hong Kong"}, inplace=True)
解决办法:使用该map方法
country_map = {
"Republic of Korea": "South Korea",
"United States of America": "United States",
"United Kingdom of Great Britain and Northern Ireland": "United Kingdom",
"China, Hong Kong Special Administrative Region": "Hong Kong"
}
energy[column_name] = enegry[column_name].map(country_map)








暂无数据