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 vote141 views1 answer
Find no of 1's in a binary number
Python
2 votes194 views1 answer
How to save query data into dataframe pscopg2
Python
1 vote145 views1 answer
Name 'glob' is not defined
Python
29 votes153 views2 answers
Lambda en python
Python
3 votes159 views3 answers
Python check internet connection
Python
0 vote156 views1 answer
Pyqt menubar example
Python
2 votes159 views1 answer
Write a value of a string in a sentence in python
Python
0 vote168 views1 answer
Numpy array serialize to string
Python
0 vote158 views1 answer
Add suffix to multiple file names python
Python
4 votes174 views1 answer
Django slug int url mapping
Python