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

3 votes197 views2 answers
Python iterate over string
Python
1 vote120 views1 answer
How to only print final iteration of a for loop pyhton
Python
1 vote137 views1 answer
3d array into 2d array python
Python
0 vote111 views1 answer
Select features and label from df
Python
11 votes128 views2 answers
Change pandas column value based on condition
Python
0 vote141 views2 answers
Zbarge / s3gui
Python
0 vote118 views1 answer
Pandas calculate same day 3 months ago dateoffset
Python
3 votes154 views2 answers
Django timezone india
Python Django
2 votes136 views1 answer
How to change button background color while clicked tkinter python
Python
55 votes130 views6 answers
Train test split
Python