Hi,
I have below data in which some of the cells are merged,
This data is saved in excel temp.xlsx, I want to read and write to another workbook detail.xlsx
KeyError: 'Group'
I have below data in which some of the cells are merged,
This data is saved in excel temp.xlsx, I want to read and write to another workbook detail.xlsx
Group Name Rank Group1 ABC 2 BGA 5 HJK 10 Group2 PLK 4 UJK 5 VBA 50 YZ 23 YU_20 3I tried below code but did not work, give an error:
KeyError: 'Group'
import pandas as pd excel = pd.read_excel('D:\pivotdata.xlsx',sheetname='merge',header=1) excel['Group']=excel['Group'].fillna(method='ffill')