python - Find substring in pandas -
i have data, there words in rows. example:
test string
(test1) string
test (string1)
i need find substring in brackets using pandas. so, output here ['test1', 'string1']
i tried this, can't find word in brackets.
df['column'].str.extract('([a-z]\w{0,})')
you can use following regex pattern:
in [180]: df['text'].str.extract(r'\((\w+)\)') out[180]: 0 nan 1 test1 2 string1 name: text, dtype: object
so looks words present in brackets, here brackets need escaped \(
example, want find words w+
needed here.
if want list can call dropna
, tolist
:
in [185]: df['text'].str.extract(r'\((\w+)\)').dropna().tolist() out[185]: ['test1', 'string1']
Comments
Post a Comment