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 vote170 views1 answer
Django admin manytomanyfield filter
Python
12 votes208 views1 answer
Python range for float
Python
0 vote221 views1 answer
Pandas dataframe to excel hyperlink length limit
Python
0 vote209 views1 answer
Csv file sort python
Python
0 vote200 views1 answer
Python generate html
Python
0 vote189 views1 answer
Python how to switch between true and false
Python
0 vote207 views2 answers
Pynput left click command
Python
2 votes199 views1 answer
How to return a value from a function in python
Python
-1 vote246 views1 answer
How to generate random list in python with specific range
Python
5 votes195 views4 answers
Prime numbers from 1 to 100 in python
Python