Pandas contains filter

Asked Apr 07 '19 at 19:04

Active Apr 07 '19 at 20:55

Viewed 24 times

i have this column in a dataframe:

epicor issue,
epicor issue,
epicor launch issue,
epicor - employee invoice entry issue,
epicor weekly time entry issue,
having issues to export from epicor to excel ..system complains about license,
epicor slowness issue,
epicor reports issue,
epicor issue,

filter the above column with contains filter with two string "epicor" and "issue",result will contains all the above rows

i tried with contains with and

df[df['BriefDescription'].str.contains(keyword1,case=False)]

with contains filter i need below result.

epicor issue,
epicor issue,
epicor launch issue,
epicor - employee invoice entry issue,
epicor weekly time entry issue,
having issues to export from epicor to excel ..system complains about license,
epicor slowness issue,
epicor reports issue,
epicor issue,

edited Apr 07 '19 at 20:55

asked Apr 07 '19 at 19:04

vijay muthu

`df[df.BriefDescription.str.contains("epicor") & df.BriefDescription.str.contains("issue")]` will filter for both – Alex Riina Apr 07 '19 at 20:44
Also see this answer: https://stackoverflow.com/a/55335207 – cs95 Apr 07 '19 at 21:01

Pandas contains filter

0 Answers0