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 vote250 views1 answer
Untrack local changes
Python
1 vote239 views1 answer
Replace the jinja template value inside the dictionary python
Python
0 vote268 views1 answer
Python reverse split only once
Python
0 vote253 views1 answer
Multi-line comments Python Example
Python
1 vote257 views1 answer
FileNotFoundError: [Errno 2] No such file or directory: 'E:\\Work\\Geeky_B\\NWIS_DEMO\\dist\\ttest_spacy\\thinc\\neural\\_custom_kernels.cu' [1192] Failed to execute script ttest_spacy + pyinstaller
Python
0 vote258 views1 answer
Parquet to dataframe
Python
22 votes233 views4 answers
Join two numpy arrays
Python
13 votes248 views1 answer
Check strings last letter python
Python
0 vote261 views1 answer
Django raw without sql injection
Python
0 vote222 views1 answer
Python computer guesses your number
Python