Extract substring between two characters in pandas
10,178
As suggested in this answer https://stackoverflow.com/a/16842576/9754169 you can use the apply approach
your_column.apply(lambda st: st[st.find("[")+1:st.find("]")])
Related videos on Youtube
05 : 09
How to Split Strings in Python With the split() Method
01 : 59
Python pandas - Text Feature Engineering - How to Extract a Substring
10 : 12
Python Regular Expression (RegEx). Extract Dates from Strings in Pandas DataFrame
10 : 35
SPLIT PANDAS COLUMN | How to split items into multiple columns in a dataframe (Python)
08 : 41
pandas dataframe search for string in all columns filter regex
03 : 49
Extract a sub-string in Python Pandas - Step 2
14 : 20
Filtering Pandas Dataframe with .str.contains, .str.startswith, .str.endswith, ~ (Tilde)
08 : 41
C03V092 Split Strings by Characters with str split Method
Author by
Shyama Sonti
Updated on June 04, 2022Comments
-
Shyama Sonti almost 2 years
I have a column containing strings in this format:
/* [MCCOOK 0 ] */,999990,'MCCOOK 0 'I want to extract the substring between [ and ] into another column. Please advise.
-
Yuca over 5 yearswhat have you tried so far?
-
