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

4 votes330 views1 answer
Pandas read_csv ignore first column
Python
0 vote321 views1 answer
Unable to locate package python3.6-venv
Python
-1 vote323 views1 answer
AttributeError: __enter__ in python cde
Python
0 vote291 views1 answer
Pandas make new dataframe
Python
18 votes397 views5 answers
Python dictionary to json
Python
0 vote313 views1 answer
How to get the top 100 frequent words on a python dataframe colummn
Python
0 vote345 views1 answer
Selenium press tab python
Python
15 votes318 views2 answers
Ansi colors
Python
2 votes326 views1 answer
Flask import jsonify
Python
0 vote321 views1 answer
Root template
Python