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 vote329 views1 answer
Datediff in seconds in pandas
Python
2 votes296 views2 answers
Pandas replace null values with values from another column
Python
0 vote300 views1 answer
Find the middle of the document in the image opencv
Python
2 votes294 views2 answers
Sort by multiple keys in object python
Python
0 vote283 views1 answer
Openpyxl iter_rows skip first
Python
37 votes297 views4 answers
How to add data to pandas dataframe
Python
1 vote281 views1 answer
Required validator python WTForms
Python
5 votes326 views2 answers
Python ffmpeg
Python
0 vote287 views3 answers
Dataframe to dictionary using index as key
Python
0 vote292 views1 answer
Python print \n every n loops
Python