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

12 votes283 views3 answers
Iloc pandas
Python
1 vote297 views1 answer
How to lock writing to a variable thread python
Python
1 vote259 views2 answers
Get required packages from python project
Python
0 vote302 views1 answer
Django not saving images forms
Python Django
1 vote313 views2 answers
Django unique_together
Python
1 vote305 views1 answer
Tabula python pdf to csv
Python
4 votes302 views6 answers
Function in function python
Python
0 vote276 views1 answer
Python colorbar for circular heatmap
Python
0 vote255 views1 answer
Bar Plot Seaborn with No Error Bars
Python
1 vote298 views1 answer
How to send json in django response
Python