Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Traceback (most recent call last):
- File "C:\Users\gobro7\AppData\Local\Programs\Python\Python39\lib\site-packages\pandas\core\indexes\base.py", line 3080, in get_loc
- return self._engine.get_loc(casted_key)
- File "pandas\_libs\index.pyx", line 70, in pandas._libs.index.IndexEngine.get_loc
- File "pandas\_libs\index.pyx", line 101, in pandas._libs.index.IndexEngine.get_loc
- File "pandas\_libs\hashtable_class_helper.pxi", line 4554, in pandas._libs.hashtable.PyObjectHashTable.get_item
- File "pandas\_libs\hashtable_class_helper.pxi", line 4562, in pandas._libs.hashtable.PyObjectHashTable.get_item
- 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)')
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- 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>
- '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)',
- File "C:\Users\gobro7\AppData\Local\Programs\Python\Python39\lib\site-packages\pandas\core\frame.py", line 3024, in __getitem__
- indexer = self.columns.get_loc(key)
- File "C:\Users\gobro7\AppData\Local\Programs\Python\Python39\lib\site-packages\pandas\core\indexes\base.py", line 3082, in get_loc
- raise KeyError(key) from err
- 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)')
- Process finished with exit code 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement