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

44 votes209 views6 answers
Python list files in current directory
Python
0 vote221 views1 answer
Python code to fetch all the files with txt extension from a folder
Python
1 vote198 views1 answer
Python yaml load_all
Python
4 votes166 views1 answer
Python check if value in string
Python
0 vote232 views1 answer
Customise django admin edit model button in field
Python Django
0 vote182 views1 answer
Origin in CORS_ORIGIN_WHITELIST is missing scheme or netloc
Python
0 vote183 views1 answer
Python sns save plot lable axes
Python
39 votes236 views6 answers
Creating dataframe
Python
1 vote197 views1 answer
How to add two different times in python
Python
0 vote189 views1 answer
Typecasting inpython
Python