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 vote255 views1 answer
Python pandas remove non-numeric characters from multiple columns
Python
8 votes238 views2 answers
New dataframe based on certain row conditions
Python
6 votes226 views6 answers
Python tuples
Python
2 votes242 views1 answer
Python recursive function return none
Python
0 vote223 views1 answer
How to sort a list of dictionary by value in descending order?
Python
0 vote223 views1 answer
Python skip input
Python
68 votes221 views5 answers
Pandas iterate rows
Python
7 votes239 views1 answer
Python marker size
Python
0 vote209 views1 answer
Randint without repitition
Python
1 vote229 views1 answer
How to put in code to download discord py
Python