Hi,
I have below DataFrame:
input:
VA004L200E2T99
VG002K500E4T99
VG002K500E4R45
VN009K30E6T00
VA007K100E2T40
I want to split at "E" and extract the numerical part to the right & left side of "E"
Desired output:
200E2
500E4
500E4
30E6
100E2
I tried the bleo code, but it is removing the specified character.
I have below DataFrame:
input:
VA004L200E2T99
VG002K500E4T99
VG002K500E4R45
VN009K30E6T00
VA007K100E2T40
I want to split at "E" and extract the numerical part to the right & left side of "E"
Desired output:
200E2
500E4
500E4
30E6
100E2
I tried the bleo code, but it is removing the specified character.
import re out=re.sub(r'E', '', input) print(out)