Tuesday, February 27, 2018

How merged Cells in Excel being handled by Pandas data frame

image

import pandas as pd
import numpy as np
df = pd.read_excel("C:/Python2/BigData/MergedExcel.xlsx",sheet_name="Sheet1",header=0, skiprows=0)
print (df)

image