热线电话:13121318867

登录
2019-02-27 阅读量: 836
用replace编辑Pandas中DataFrame

我正在尝试使用如下所示的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)

0.0000
3
关注作者
收藏
评论(0)

发表评论

暂无数据
推荐帖子