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 vote132 views1 answer
Print treelib.Tree
Python
20 votes123 views6 answers
Sort list in python
Python
5 votes128 views1 answer
Turn multiindex into columns#
Python
4 votes139 views6 answers
Rgb to hex python
Python
0 vote171 views1 answer
Python linked list insert
Python
0 vote122 views1 answer
Python subtract months from date
Python
5 votes129 views1 answer
How to delete na values in a dataframe
Python
9 votes133 views2 answers
Argc python
Python
186 votes203 views6 answers
Pip upgrade command
Python
19 votes173 views6 answers
Install Django in Windows
Python Django