Pandas interpolate string

import pandas as pd

s = pd.Series([None, None, 'red', 'red', None, 'blue', None, None])

print(s.to_list())
print(s.bfill().tolist())
print(s.ffill().tolist())
print(s.bfill().ffill().tolist())
print(s.ffill().bfill().tolist())
print(s.interpolate(method='pad').tolist())

Output:
[None, None, 'red', 'red', None, 'blue', None, None]
['red', 'red', 'red', 'red', 'blue', 'blue', None, None]
[None, None, 'red', 'red', 'red', 'blue', 'blue', 'blue']
['red', 'red', 'red', 'red', 'blue', 'blue', 'blue', 'blue']
['red', 'red', 'red', 'red', 'red', 'blue', 'blue', 'blue']
[None, None, 'red', 'red', 'red', 'blue', 'blue', 'blue']

Source: stackoverflow.com

Similar codes

0 vote301 views1 answer
Red black tree python
Python
0 vote300 views1 answer
Python float till 2 decimal places
Python
1 vote298 views2 answers
N factorial
Python
0 vote434 views1 answer
Exception Type: AssertionError Exception Value: Expected a `Response`, `HttpResponse` or `HttpStreamingResponse` to be returned from the view, but received a `<class 'django.db.models.query.QuerySet'>`
Python Django
6 votes304 views2 answers
How to use colorama
Python
0 vote280 views1 answer
Conversion of int to a specified base number
Python
-2 votes262 views1 answer
Requests.exceptions.connectionerror: ('connection aborted.', remotedisconnected('remote end closed connection without response'))
Python
1 vote301 views1 answer
Python sympy solve equation equal to 0
Python
0 vote286 views1 answer
Add_node python
Python
0 vote282 views2 answers
How to permanently store data in python
Python