Advertisement
g96

Untitled

g96
Feb 18th, 2022
154
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 2.12 KB | None | 0 0
  1. Traceback (most recent call last):
  2.   File "C:\Users\gobro7\AppData\Local\Programs\Python\Python39\lib\site-packages\pandas\core\indexes\base.py", line 3080, in get_loc
  3.     return self._engine.get_loc(casted_key)
  4.   File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc
  5.   File "pandas\_libs\index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc
  6.   File "pandas\_libs\hashtable_class_helper.pxi", line 4554, in pandas._libs.hashtable.PyObjectHashTable.get_item
  7.   File "pandas\_libs\hashtable_class_helper.pxi", line 4562, in pandas._libs.hashtable.PyObjectHashTable.get_item
  8. KeyError: ('Order Qty (SL)', 'Confirmed Qty (SL)', 'Unconfirmed Qty (SL)', 'Cancelled Qty (SL)', 'Open Qty (SL)', 'Reserved Qty (SL)', 'Fixed Qty (SL)', '% Allocation (SL)', 'Delivered Qty (SL)', 'PGI Qty (SL)', 'Invoiced Qty (SL)', 'Net Unit Price', 'Confirmed Net Value (SL)', 'Dollars Shipped (SL)', '% Shipped/Allocated (SL)')
  9.  
  10. The above exception was the direct cause of the following exception:
  11.  
  12. Traceback (most recent call last):
  13.   File "C:\Users\Digital Wholesale - Documents\2. Amazon\Customer Operations_OTC\02. Amazon weekly Report\Amazon weekly automation (Giorgi)\VL.py", line 29, in <module>
  14.     'Net Unit Price','Confirmed Net Value (SL)','Dollars Shipped (SL)','% Shipped/Allocated (SL)']] = pd.to_numeric(df['Order Qty (SL)','Confirmed Qty (SL)','Unconfirmed Qty (SL)','Cancelled Qty (SL)','Open Qty (SL)','Reserved Qty (SL)',
  15.   File "C:\Users\gobro7\AppData\Local\Programs\Python\Python39\lib\site-packages\pandas\core\frame.py", line 3024, in __getitem__
  16.     indexer = self.columns.get_loc(key)
  17.   File "C:\Users\gobro7\AppData\Local\Programs\Python\Python39\lib\site-packages\pandas\core\indexes\base.py", line 3082, in get_loc
  18.     raise KeyError(key) from err
  19. KeyError: ('Order Qty (SL)', 'Confirmed Qty (SL)', 'Unconfirmed Qty (SL)', 'Cancelled Qty (SL)', 'Open Qty (SL)', 'Reserved Qty (SL)', 'Fixed Qty (SL)', '% Allocation (SL)', 'Delivered Qty (SL)', 'PGI Qty (SL)', 'Invoiced Qty (SL)', 'Net Unit Price', 'Confirmed Net Value (SL)', 'Dollars Shipped (SL)', '% Shipped/Allocated (SL)')
  20.  
  21. Process finished with exit code 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement