如何用一个值python替换多个值 [英] how to replace multiple values with one value python

问题描述

如何仅用'Drink'替换数据'Beer','Alcohol','Beverage','Drink'.

df.replace(['Beer','Alcohol','Beverage','Drink'],'Drink')

不起作用

推荐答案

您几乎都拥有它.您需要将字典传递给df.replace.

You almost had it. You need to pass a dictionary to df.replace.

df

       Col1
0      Beer
1   Alcohol
2  Beverage
3     Drink

df.replace(dict.fromkeys(['Beer','Alcohol','Beverage','Drink'], 'Drink'))

    Col1
0  Drink
1  Drink
2  Drink
3  Drink

这适用于完全匹配和替换.对于部分匹配和子字符串匹配，请使用

This works for exact matches and replacements. For partial matches and substring matching, use

df.replace(
    dict.fromkeys(['Beer','Alcohol','Beverage','Drink'], 'Drink'), 
    regex=True
)

这不是就地操作，因此请不要忘记将结果分配回去.

This is not an in-place operation so don't forget to assign the result back.

这篇关于如何用一个值python替换多个值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！