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 vote171 views1 answer
Ubuntu install pip for python 3.8
Python
0 vote170 views1 answer
Python clean all .pyc
Python
0 vote188 views1 answer
Dataframe show to semicolon python
Python
0 vote164 views1 answer
Find & replace in csv file
Python
6 votes173 views2 answers
Python file to array
Python
11 votes174 views2 answers
Cross validation python
Python
0 vote170 views1 answer
Get next multiple of a number
Python
0 vote207 views1 answer
Python create empty dictionary with keys
Python
5 votes201 views3 answers
ModuleNotFoundError: No module named 'StringIO'
Python
14 votes175 views2 answers
How to get device name using pythno
Python