Search code examples
pythonpandasdataframefillna

Python Dataframe fillna with value on left column

I have an excel spreadsheet where there are merged cells.

enter image description here

I would like to build a dictionary of Product_ID - Category - Country.

But for that I need to get, I believe, Python to be able to read an excel file with horizontally merged cells.

import pandas as pd

excel_sheet = pd.read_excel(r'C:\Users\myusername\Documents\Product_Sales_Database.xlsx, 'Product IDs')

However the returned dataframe is this:

enter image description here

My question is, how can I fill the nan values in the dataframe, with the values on the left column?

Thank you!

Solution

  • This should do:

    df.iloc[0] = df.iloc[0].ffill()