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 vote212 views1 answer
Sns regplot make the line and confidence interval thicker
Python
2 votes202 views4 answers
Python dict get random key
Python
1 vote236 views1 answer
Deleting DataFrame row in Pandas based on column value
Python
0 vote218 views1 answer
How to access rows and columns indexing numpy
Python
7 votes216 views3 answers
Divmod
Python
3 votes220 views1 answer
Python docstring
Python
0 vote220 views1 answer
Print from within funciton with multiprocessing
Python
1 vote209 views1 answer
How to save inputs python
Python
0 vote205 views1 answer
How to incorportate a different language in python code
Python
0 vote200 views1 answer
How to take first half of list python
Python