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

11 votes176 views5 answers
Convert dataframe column to float
Python
0 vote215 views1 answer
Colorbar remove tick lines and border
Python
1 vote125 views1 answer
How to check if string is camelcase python
Python
0 vote126 views1 answer
Python elementTree tostring write() argument must be str, not bytes
Python
0 vote135 views1 answer
Create new column pandas and order sequence
Python
1 vote129 views1 answer
Python is not writing whole line
Python
1 vote151 views1 answer
How to use regex in a list
Python
12 votes133 views6 answers
Print string and variable python
Python
80 votes129 views4 answers
Invert list python
Python
0 vote142 views1 answer
Give cell format to condition pandas dataframe
Python