I have this value 10-X-002 in a column and I want to extract only the X-002 to be in a new column.
So far what I have tried was this:
mask = df["eq_id"].str.count('-').gt(0)
splitted = df["eq_id"].str.split("-")
df.loc[mask, "eg_number"] = splitted[mask].str[-1]
but the script resulted only the 002 is in the new column, what should I do to get X-002 value in the new column?
Thankyou.
add first + and '-' with last element
mask = df["eq_id"].str.count('-').gt(0)
splitted = df["eq_id"].str.split("-")
df.loc[mask, "eg_number"] = splitted[mask].str[1]+'-' +splitted[mask].str[-1]
The simplest thing is to only change one line in your code which is totally fine.
change this splitted = df["eq_id"].str.split("-")
into this splitted = df["eq_id"].str.split("-", 1)
which means you want only one split based on '-' starting from the left.
Leave the rest of your code unchanged, it should do the job
If you know the index location of the string, then you can do this:
mask = df["eq_id"].split('-')[1]+'-'+df["eq_id"].split('-')[-1]
df.loc[mask, "eg_number"] = mask
Split them by '-' sign and recombine those back, and just assign back to that specific column
Try
df["eq_id"].replace('10-','')
splitted = df["eq_id"].str.split("-",1)