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 vote276 views1 answer
Fibonacci sequence generator python
Python
1 vote396 views1 answer
Flask enumerate index
Python Flask
12 votes272 views5 answers
Python get the intersection of two lists
Python
1 vote259 views1 answer
Django queryset first element
Python
0 vote261 views1 answer
Change size of yticks python
Python
1 vote321 views1 answer
Factorial sequence code in python with while loops
Python
8 votes317 views2 answers
Python add a string to a list
Python
1 vote275 views1 answer
Append to list in dictionary python if exists
Python
0 vote256 views1 answer
Django get form data from post
Python
1 vote278 views1 answer
Extract data from lichess python
Python