正在提取索引式元素

Question

data = {'fid':['EL202AK5130C','EL531BC3090K','EL617BE2110PA','EL614A36120G','EL607AJ3200MA'],'testdate':['2021-07-01 00:07:02','2021-07-01 00:07:20',
                                  '2021-07-01 00:07:48','2021-07-01 00:08:16','2021-07-01 00:08:23'],
'failrea':['HA13','ST13','MFD','NOTRACE','HA15']}
df = Dataframe(data)
fid testdate    failrea
0   EL202AK5130C    2021-07-01 00:07:02 HA13
1   EL531BC3090K    2021-07-01 00:07:20 ST13
2   EL617BE2110PA   2021-07-01 00:07:48 MFD
3   EL614A36120G    2021-07-01 00:08:16 NOTRACE
4   EL607AJ3200MA   2021-07-01 00:08:23 HA15

但我想创建另一列，其中的行如下：

preid
EL202AK513
EL531BC3090
EL617BE2110
EL614A36120
EL607AJ3200

有人能建议怎么做吗？

Answer 1

尝试使用正则表达式方法

df['preid'] = df.fid.str.extract('(w+d)w+$')

或

仅使用索引提取元素

df['preid'] = df.fid.str[:11]