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

2 votes261 views1 answer
Python read text file next line
Python
0 vote251 views1 answer
Ipython.display latex in the IDE like spyder
Python
4 votes265 views1 answer
7chats_np
Python
28 votes306 views2 answers
Simple python for loop print 1 to 5
Python
3 votes317 views2 answers
Dict get list of values
Python
-2 votes257 views2 answers
Where to import reverse_lazy in django
Python
1 vote260 views1 answer
Multiprocessing a for loop python
Python
1 vote242 views1 answer
How to add an active class to current element in navbar in django
Python
48 votes247 views6 answers
Python read file line by line
Python
0 vote247 views1 answer
Python import module from bitbucket
Python