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 vote142 views1 answer
Python selenium scroll all down
Python
11 votes128 views2 answers
Show more rows pandas
Python
0 vote148 views1 answer
Python pipe select where
Python
0 vote168 views1 answer
Python loading image file requires absolute path
Python
0 vote146 views1 answer
Ipynb to py online
Python
0 vote138 views1 answer
Pd calculations between columns
Python
1 vote139 views1 answer
FutureWarning: Input image dtype is bool. Interpolation is not defined with bool data type. Please set order to 0 or explicitly cast input image to another data type. Starting from version 0.19 a ValueError will be raised instead of this warning.
Python
3 votes167 views2 answers
Pygame bg color
Python
2 votes151 views2 answers
Set axis plt python
Python
0 vote144 views1 answer
File attributes in os
Python