0

I have the following dataset:

enter image description here

I want to do the following:

dataset = pd.read_excel(datasets_dir + '\\' + dataset_filename,na_values="NULL")
if dataset['ExpectedWeight'][0][0] == 630:
   return True # This should work.

Is this possible?

Omri Shneor
  • 965
  • 3
  • 18
  • 34
  • I don't know exactly what you want to achieve but you should take a look at [this answer](https://stackoverflow.com/questions/22937650/pandas-reading-excel-with-merged-cells) about merged cells in excel and pandas. – Akarius Nov 30 '18 at 17:30

1 Answers1

0

Not sure if this is what you are asking for, but if you manually set your columns by the tag headers and started reading in the data form the second line, with the tag skiprows being 1, you could split the data into column names you need or just index them.

Jay Patel
  • 26
  • 1