Hi Melina Safarinasab ,

I think it can be easily handled by converting the initial three columns into indices and leaving the last columns as values in pandas library (Please, refer to the photo if this is what you want)

With bests,

Mansurbek

Hi,

You can use the pandas library in Python to import data and convert your excel file into CSV format. By using the readcsv command, import your data into the data frame.

I am providing a Python code block that can be helpful to you.

import pandas as pd

def tupleToStr(a, b, c):

return str(a) + "" + str(b) + "" + str(c)

df = pd.read_excel('sample.xlsx', sheet_name='Sheet1') # provide excel file name and sheet name, as applicable

xl_file = df.values

myDict = {}

for i in range(xl_file.shape[0]):

myDict[tupleToStr(xl_file[i][0], xl_file[i][1], xl_file[i][2])] = int(xl_file[i][3])

print (myDict[tupleToStr('o1', 'c1', 1)]) # = 4

print (myDict[tupleToStr('o1', 'c1', 2)]) # = 5

========

Hope this helps. It works on my system, should work in yours, too.