How do I count the longest consecutive '0' flanked by number '1' in is string using pandas dataframe

Question

I want to do I count the longest consecutive '0' flanked by number '1' in is string using pandas dataframe

Here's my dataset

Id     label

1          1

2         11

3        101

4      10101

5       1001

Here's my expected output

Id     label   result

1          1        0

2         11        0

3        101        1

4      10101        1

5       1001        2

Answer 1

You can do the following steps:

1. Convert the column to string.

2. Split the resulting strings by ‘1’.

3. Count the max.

df['result'] = df.label.astype(str).str.split('1').apply(lambda x: len(max(x)))