Counting number of vertical bars | in pandas string has strange behaviour?

user_2970083 0
Viewed 47

I want to count the number of instances of vertical bars "|" in a each row of a particular column in a pandas dataframe. But using str.count("|") yields some strange behaviour:

import pandas as pd
df = pd.DataFrame(['some text', None, 'a|few|vertical|bars', 'one|'])
df[0].str.count("|")

outputs

0    10.0
1     NaN
2    20.0
3     5.0
Name: 0, dtype: float64

What's going on here? If I use apply instead, I get the expected answer:

df.apply(lambda x: str(x[0]).count("|"),axis=1)

yields

0    0
1    0
2    3
3    1
dtype: int64
pandas python
1 Answers

Try this, pat is a regex string and | is a regex operator, OR, so escape with '\', blackslash:

df[0].str.count('\|')

Output:

0    0.0
1    NaN
2    3.0
3    1.0
Name: 0, dtype: float64

Note: str.count in the standard library is different from pd.Series.str.count where the former doesn't use regex, but the method from pandas does per docs linked above.

user_63615310
Related