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

3 votes162 views1 answer
How do you print a integer in python
Python
6 votes157 views2 answers
Python pandas series to dataframe
Python
5 votes147 views3 answers
Series change index pandas
Python
2 votes149 views1 answer
How to compare two text files in python
Python
0 vote140 views1 answer
Calculate iqr in python dataset example
Python
0 vote149 views1 answer
Python list of dates between
Python
0 vote207 views1 answer
TypeError: 'LazyCorpusLoader' object is not callable
Python
6 votes196 views1 answer
Send data through tcp sockets python
Python
0 vote150 views1 answer
Python create a pinging sound
Python
0 vote159 views1 answer
AttributeError: This QueryDict instance is immutable django
Python