Pandas- Split Text In Column And Search In Rows
This question is with this history: Link Here is a json format table: ID Title 19 I am doing great 25 [Must fix problem] Stomach not well 31 [Not-so-urgent] Wash cloths 498 [VERY U
Solution 1:
I think you can use str.replace
with str.contains
:
s = "[VERY URGENT] Pay your rent"
#replace all [] in column title
tit = df.Title.str.replace(r'[\[\]]', '')
print (tit)
0 I am doing great
1 Must fix problem Stomach not well
2 Not-so-urgent Wash cloths
3 VERY URGENT Pay your rent
4 Landlord wants you to pay your rent tomorrow
5 Girlfriend wants to help you to pay rent if yo...
6 Always reproducible issue Room partner dont wa...
Name: Title, dtype: object
#search one of word of string s (logical or is |)
mask = tit.str.contains(s.replace(' ', '|'))
print (mask)
0 False
1 False
2 True
3 True
4 True
5 True
6 True
Name: Title, dtype: bool
#select all ID by condition
selected_row_title = df.loc[mask, 'ID']
print (selected_row_title)
2 31
3 498
4 517
5 918
6 1000
Name: ID, dtype: int64
Post a Comment for "Pandas- Split Text In Column And Search In Rows"