Error in read_csv python script

Python Help
1

Please check the code snippet and let me know what is the error all about.
Error:
C:\Users\nkumar\Anaconda3\python.exe C:/Users/nkumar/PycharmProjects/pythonProject/WorldPantryExtraction_Errorfiles.py
torani_export_220615.csv
s3://toraniapacheairflow/Source_files/WorldPantry/
Traceback (most recent call last):
File “C:/Users/nkumar/PycharmProjects/pythonProject/WorldPantryExtraction_Errorfiles.py”, line 96, in
FILE = pd.read_csv(f"s3://{‘toraniapacheairflow’}/{‘Source_files/WorldPantry/torani_export_220615.csv’}“, {“key”:ACCESS_KEY_ID,“secret”:SECRET_ACCESS_KEY},encoding=“unicode_escape”, sep=‘,’, header=None, quotechar='”', names=[‘ORDER_DATE’, ‘ORDER_NUMBER’, ‘CUSTOMER_NUMBER’, ‘ORDER_TOTAL’, ‘SHIPPING_TOTAL’,‘TAX_TOTAL’, ‘DISCOUNT_TOTAL’, ‘PRODUCT_TOTAL’, ‘SHIPPING_INFO_TOTAL’, ‘PRODUCT_ID’, ‘VARIANT_ID’, ‘CATALOG_NAME’, ‘QUANTITY’, ‘PRICE’, ‘DISPLAY_NAME’, ‘SHIPPING_FIRSTNAME’, ‘SHIPPING_LASTNAME’, ‘SHIPPING_ADDRESS_LINE1’, ‘SHIPPING_ADDRESS_LINE2’, ‘SHIPPING_CITY’, ‘SHIPPING_STATE’, ‘SHIPPING_ZIP’, ‘SHIPPING_COUNTRY’, ‘SHIPPING_PHONE’, ‘SHIPPING_EMAILADDRESS’, ‘BILLING_FIRSTNAME’, ‘BILLING_LASTNAME’, ‘BILLING_ADDRESS_LINE1’, ‘BILLING_ADDRESS_LINE2’, ‘BILLING_CITY’, ‘BILLING_STATE’, ‘BILLING_ZIP’, ‘BILLING_COUNTRY’, ‘BILLING_PHONE’, ‘BILLING_EMAILADDRESS’, ‘OFFER_CODE’, ‘PAYMENT_METHOD’, ‘FILE_NAME’, ‘FILE_PATH’])
TypeError: read_csv() got multiple values for argument ‘sep’

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File “C:/Users/nkumar/PycharmProjects/pythonProject/WorldPantryExtraction_Errorfiles.py”, line 133, in
except exception as e:
TypeError: catching classes that do not inherit from BaseException is not allowed

Code Snippet:
FILE = pd.read_csv(f"s3://{‘toraniapacheairflow’}/{‘Source_files/WorldPantry/torani_export_220615.csv’}“, {“key”:ACCESS_KEY_ID,“secret”:SECRET_ACCESS_KEY},encoding=“unicode_escape”, sep=‘,’, header=None, quotechar='”', names=[‘ORDER_DATE’, ‘ORDER_NUMBER’, ‘CUSTOMER_NUMBER’, ‘ORDER_TOTAL’, ‘SHIPPING_TOTAL’,‘TAX_TOTAL’, ‘DISCOUNT_TOTAL’, ‘PRODUCT_TOTAL’, ‘SHIPPING_INFO_TOTAL’, ‘PRODUCT_ID’, ‘VARIANT_ID’, ‘CATALOG_NAME’, ‘QUANTITY’, ‘PRICE’, ‘DISPLAY_NAME’, ‘SHIPPING_FIRSTNAME’, ‘SHIPPING_LASTNAME’, ‘SHIPPING_ADDRESS_LINE1’, ‘SHIPPING_ADDRESS_LINE2’, ‘SHIPPING_CITY’, ‘SHIPPING_STATE’, ‘SHIPPING_ZIP’, ‘SHIPPING_COUNTRY’, ‘SHIPPING_PHONE’, ‘SHIPPING_EMAILADDRESS’, ‘BILLING_FIRSTNAME’, ‘BILLING_LASTNAME’, ‘BILLING_ADDRESS_LINE1’, ‘BILLING_ADDRESS_LINE2’, ‘BILLING_CITY’, ‘BILLING_STATE’, ‘BILLING_ZIP’, ‘BILLING_COUNTRY’, ‘BILLING_PHONE’, ‘BILLING_EMAILADDRESS’, ‘OFFER_CODE’, ‘PAYMENT_METHOD’, ‘FILE_NAME’, ‘FILE_PATH’])

CSV File Snippet:

image
image1292×187 15.6 KB

2

read_csv() got multiple values for argument ‘sep’

https://pandas.pydata.org/docs/reference/api/pandas.read_csv.html

sep is the second positional parameter. You pass {“key”:ACCESS_KEY_ID,“secret”:SECRET_ACCESS_KEY} in that position, which is unexpected.

Then you also pass a keyword parameter sep=','. That part seems good, but conflicts with the unexpected positional parameter above.

3

Thanks Peter,
The above issue has been fixed by changing sep to delimiter. Now having below error how shall I fix the below error:
snowflake.connector.errors.ProgrammingError: 100071 (22000): Failed to cast variant value “"Order Date"” to DATE