I am new to pandas. I am trying to fetch a multiple substring from a string. But I need to check between particular start and end.
if it is present i need to get its position, which substring.
1
-
1Can you provide a sample of the data?mozway– mozway2023-01-30 16:08:03 +00:00Commented Jan 30, 2023 at 16:08
Add a comment
|
1 Answer
Use str.replace:
target = 'hi|love'
m = df['sequence'].str.contains(target)
df.loc[m, 'output'] = (df.loc[m, 'sequence']
.str.replace(fr'.*({target}).*',
lambda m: f'{m.start(1)+1},{m.group(1)}',
regex=True)
)
df.loc[~m, 'output'] = 'NA'
Output:
sequence output
0 HelloWorld NO
1 worldofhi 8,hi
2 worldoflove 8,love
Used input:
sequence
0 HelloWorld
1 worldofhi
2 worldoflove
checking only in substring 7:10
target = 'hi|love'
s = df['sequence'].str[7:10+1]
m = s.str.contains(target)
df.loc[m, 'output'] = (s[m]
.str.replace(fr'.*({target}).*',
lambda m: f'{m.start(1)+7+1},{m.group(1)}',
regex=True)
)
df.loc[~m, 'output'] = 'NA'
8 Comments
julie
Thank you. But I need the string to be checked only from 7 to 10 in the position.
mozway
@julie then, just slice before and add 7 to the position, see update
julie
Thank you so much. But may I know what is actually doing here
s[m] .str.replace(fr'.*({target})', lambda m: f'{m.start(1)+7+1},{m.group(1)}',julie
When there is another sequence like "worldofhide" , the output print like "hid" instead of "hi"
mozway
Do you wan to match the end of string? What you expect is unclear, please be specific.
|