Using regex and its flags with .eq() function in python to ignore case

Question

I'm thinking something like below where I can use and re.I to ingnore case or use any other flag for that matter.

df.column.eq('Male').sum()

Use `df.column.str.match()`: https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.str.match.html — Jan Wilamowski, Feb 02 '22 at 07:51
You probably need `df['column'].str.contains('Male', case=False).sum()` — Wiktor Stribiżew, Feb 02 '22 at 19:16

score 1 · Accepted Answer · answered Feb 02 '22 at 19:18

1

You can use the Series.str.contains function with case=False argument, ^Male$ as regex pattern and the regex=True argument:

df['column'].str.contains('^Male$', case=False, regex=True).sum()

answered Feb 02 '22 at 19:18

Wiktor Stribiżew

So in df .contains, `regex=True` is the default, not necessary, that's what I was trying to find out, thanks for the documentation link – gseattle May 08 '22 at 00:14

1 Answers1