首页 > 解决方案 > 可以在一行中完成以下操作#python #dataframe

问题描述

#Following 是我创建的数据框

dict1 = {'Store': 'A','B','A','C','D','A','D','A','C','B'],'Location':'Mumbai','Pune','Hyderabad','Mumbai','Pune','Delhi','Hyderabad','Pune','Mumbai','Pune'],'Sales':40000,45000,50000,90000,89000,87000,85000,78000,89000,70000]}
data1 = pn.DataFrame(dict1)

#想要更改店铺名称:

data1.loc[(data1.Store == 'A'), 'Store'] = 'Store_A'
data1.loc[(data1.Store == 'B'), 'Store'] = 'Store_B'
data1.loc[(data1.Store == 'C'), 'Store'] = 'Store_C'
data1.loc[(data1.Store == 'D'), 'Store'] = 'Store_D'

#如何在一行而不是四行中做到这一点

标签: pythonpandas

解决方案


如果您只想Store_在给定列中的所有行之前连接一个字符串,那么您可以尝试:

data1['Store'] = 'Store_' + data1['Store'] 

推荐阅读