考虑我的数据集中的以下列。
Norm
marketer
summer
vip
teacher
vip
manager at hotel我想知道,如果我在vip之后让manager at hotel来,把vip改成vip of manager,我该怎么做呢?
输出
Norm
marketer
summer
vip
teacher
vip of manager
manager at hotel发布于 2021-02-11 22:32:45
考虑df
In [1190]: df = pd.DataFrame({'Norm': ['marketer', 'summer', 'vip', 'teacher', 'vip', 'manager at hotel']})
In [1191]: df
Out[1191]:
Norm
0 marketer
1 summer
2 vip
3 teacher
4 vip
5 manager at hotel使用:
In [1175]: df['new'] = df.Norm.shift(-1)
In [1194]: ix = df[df.Norm.eq('vip') & df.new.eq('manager at hotel')].index
In [1197]: df.loc[ix, 'Norm'] = df.loc[ix, 'Norm'] + ' of manager'
In [1199]: df.drop('new', 1, inplace=True)
In [1200]: df
Out[1200]:
Norm
0 marketer
1 summer
2 vip
3 teacher
4 vip of manager
5 manager at hotelhttps://stackoverflow.com/questions/66156390
复制相似问题