使用字典替换pandas列中字符串中的字符串

使用字典替换pandas列中字符串中的字符串

您可以创建

dictionary

然后

replace

：

ids = {'Id':['NYC','LA','UK'],      'City':['New York City','Los Angeles','United Kingdom']}ids = dict(zip(ids['Id'], ids['City']))print (ids){'UK': 'United Kingdom', 'LA': 'Los Angeles', 'NYC': 'New York City'}df['commentTest'] = df['Comment'].replace(ids, regex=True)print (df)  Categories Comment  Type       animal      The NYC tree is very big  tree   1      plant  The cat from the UK is small   dog   2     object     The rock was found in LA.  rock          commentTest  0        The New York City tree is very big  1  The cat from the United Kingdom is small  2        The rock was found in Los Angeles.