Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- df=pd.read_csv(os.path.join(directory,'1.csv'),low_memory=False)
- df[['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)']] = pd.to_numeric(df[['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)']])
- df[['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)']] /= 1000
- print(df.head())
- Traceback
- 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)',
- File "C:\Users\gobro7\AppData\Local\Programs\Python\Python39\lib\site-packages\pandas\core\tools\numeric.py", line 141, in to_numeric
- raise TypeError("arg must be a list, tuple, 1-d array, or Series")
- TypeError: arg must be a list, tuple, 1-d array, or Series
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement