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

22 votes351 views6 answers
How to merge two dataframes
Python
5 votes347 views2 answers
Python pandas drop column by index
Python
0 vote347 views1 answer
Reference other libraries in library
Python
12 votes277 views3 answers
List insert
Python
0 vote348 views1 answer
Python how to make integer show 2 numbers
Python
2 votes344 views1 answer
Pass in queryset as filter django
Python
6 votes362 views3 answers
Import this
Python
1 vote360 views1 answer
Convert number to time python
Python
0 vote348 views1 answer
Reset Python Dictionary to 0 Zero. Empty existing Python Dictionary
Python
0 vote336 views2 answers
Get index of highest value in array python
Python