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 vote207 views1 answer
{% load humanise %}
Python
5 votes334 views2 answers
How does HTTPServer work in python
Python
3 votes161 views2 answers
Multiply all values in column pandas
Python
2 votes142 views2 answers
Bot ping discord.py
Python
1 vote167 views1 answer
Save np array as mat file
Python
0 vote152 views1 answer
Python drop in tuple
Python
0 vote149 views1 answer
Stellargraph python
Python
1 vote169 views1 answer
Return result from exec python
Python
0 vote154 views1 answer
Come mettere una scelta su python
Python
0 vote161 views2 answers
Converting pandas._libs.tslibs.timedeltas.Timedelta to days
Python