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

5 votes141 views4 answers
How to take float input upto 2 decimal points in python
Python
1 vote134 views2 answers
Types of all columns pandas
Python
1 vote151 views1 answer
How to merge dataframe with different keys
Python
0 vote142 views1 answer
Frozen graph can't be modified
Python
0 vote146 views1 answer
Strategy forex with python
Python
28 votes145 views2 answers
Pyplot attributes
Python
21 votes148 views7 answers
Pyinstaller
Python
13 votes145 views3 answers
Python http server command line
Python
0 vote130 views1 answer
How to break an if statement python
Python
0 vote144 views1 answer
Django dump previous migrations
Python