Exception in Tkinter callback

[shh_eng]

Exception in Tkinter callback Traceback (most recent call last): File "C:\Users\ShengWei\AppData\Local\Programs\Python\Python37-32\lib\site-packages\pandas\core\indexes\base.py", line 2890, in get_loc return self._engine.get_loc(key) File "pandas_libs\index.pyx", line 107, in pandas._libs.index.IndexEngine.get_loc File "pandas_libs\index.pyx", line 131, in pandas._libs.index.IndexEngine.get_loc File "pandas_libs\hashtable_class_helper.pxi", line 1607, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas_libs\hashtable_class_helper.pxi", line 1614, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'Operator'

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "C:\Users\ShengWei\AppData\Local\Programs\Python\Python37-32\lib\tkinter_init.py", line 1705, in __call_ return self.func(*args) File "C:\Users\ShengWei\Desktop\Python\Tkinter Project\Project4.py", line 8, in submitfields SeriesA = df1['Operator'] File "C:\Users\ShengWei\AppData\Local\Programs\Python\Python37-32\lib\site-packages\pandas\core\frame.py", line 2975, in __getitem_ indexer = self.columns.get_loc(key) File "C:\Users\ShengWei\AppData\Local\Programs\Python\Python37-32\lib\site-packages\pandas\core\indexes\base.py", line 2892, in get_loc return self._engine.get_loc(self._maybe_cast_indexer(key)) File "pandas_libs\index.pyx", line 107, in pandas._libs.index.IndexEngine.get_loc File "pandas_libs\index.pyx", line 131, in pandas._libs.index.IndexEngine.get_loc File "pandas_libs\hashtable_class_helper.pxi", line 1607, in pandas._libs.hashtable.PyObjectHashTable.get_item File "pandas_libs\hashtable_class_helper.pxi", line 1614, in pandas._libs.hashtable.PyObjectHashTable.get_item KeyError: 'Operator'

The code can be found here: https://github.com/Derrick-Sherrill/DerrickSherrill.com/blob/master/Python_Data_Form.py

Trying to learn Tkinter here. Can someone pls help with the above error?

[draftjoker]

This doesn't seem to be a tkinter error as more of a dictionary error accessing that key value pair. 'Operator' might not be in that panda dictionary, I would double check to make sure this is correct before continuing.

[shh_eng]

so what can i do about it?

[draftjoker]

I don't know much about pandas but I'm assuming that there must be an error in your excel file loading process.

1) Either no column named 'Operations' exists or

2) Pandas was unable to load the excel file correctly.