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

1 vote280 views1 answer
Get all classes from css file using python
Python
3 votes277 views1 answer
Create or update django models
Python
0 vote279 views2 answers
Python int to ascii string
Python
2 votes248 views1 answer
How to call super class constructor in python two classes
Python
35 votes289 views5 answers
How to use replace in python
Python
2 votes240 views1 answer
Pythagoras theorem formula
Python
0 vote257 views1 answer
_getfullpathname: path should be string, bytes or os.PathLike, not list
Python
0 vote247 views1 answer
Pyinstaller onefile current working directory
Python
2 votes269 views1 answer
Torch device
Python
0 vote309 views1 answer
Django check user admin
Python Django