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

1 vote233 views3 answers
Loops
Python
20 votes235 views3 answers
Convert a number column into datetime pandas
Python
3 votes209 views2 answers
Pandas read excel with two headers
Python
0 vote197 views1 answer
Python remove .0
Python
0 vote200 views1 answer
Form data postman don't work
Python
18 votes237 views3 answers
Run calc.exe inside python
Python
1 vote217 views2 answers
Get pytorch version
Python
0 vote233 views1 answer
Are there learning activities for django-debug-toolbar
Python Django
0 vote216 views1 answer
Power of array
Python
0 vote210 views1 answer
How to find if the numpy array contains negative values
Python