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

2 votes397 views1 answer
How to make a python program to count from 1 to 100
Python
0 vote366 views1 answer
Add a string to each element of a list python
Python
1 vote349 views1 answer
How to replace a row value in pyspark dataframe
Python
1 vote392 views1 answer
Browser pop up yes no selenium python
Python
4 votes354 views2 answers
How to print a word in different line in python
Python
3 votes317 views1 answer
Change plot size matplotlib python
Python
3 votes327 views1 answer
Python how to find the highest number in a dictionary
Python
0 vote362 views1 answer
Spliting the text to lines and keep the deliminaters python
Python
50 votes335 views4 answers
Python get args
Python
31 votes348 views6 answers
Strip whitespace python
Python