Hey everyone Facing an issue where I am trying to LOAD Excel

Question

Hey everyone Facing an issue where I am trying to LOAD Excel data xlsx stored in an S3 bucket writing and saving to the same S3 bucket is OK Error messasge ```kedro io core DataSetError Failed while loading data from data set ExcelDataSet filepath=my s3 path file xlsx load args= engine openpyxl sheet name Sheet1 protocol=s3 save args= index False writer args= engine xlsxwriter my s3 path file xlsx``` Have no issues with other formats parquet csv PDF Anyone seen this before or have insights to where I am going wrong FYI I am using `kedro=0 17 7`

Leslie Wu · Answer

Including the entire traceback here ```Traceback most recent call last File opt conda envs delisting lib python3 8 site packages s3fs core py line 529 in info out = self call s3 self s3 head object kwargs Bucket=bucket File opt conda envs delisting lib python3 8 site packages s3fs core py line 200 in call s3 return method additional kwargs File opt conda envs delisting lib python3 8 site packages botocore client py line 530 in api call return self make api call operation name kwargs File opt conda envs delisting lib python3 8 site packages botocore client py line 964 in make api call raise error class parsed response operation name botocore exceptions ClientError An error occurred 404 when calling the HeadObject operation Not Found During handling of the above exception another exception occurred Traceback most recent call last File opt conda envs delisting lib python3 8 site packages kedro io core py line 182 in load return self load File opt conda envs delisting lib python3 8 site packages kedro extras datasets pandas excel dataset py line 161 in load with self fs open load path self fs open args load as fs file File opt conda envs delisting lib python3 8 site packages fsspec spec py line 1009 in open f = self open File opt conda envs delisting lib python3 8 site packages s3fs core py line 375 in open return S3File self path mode block size=block size acl=acl File opt conda envs delisting lib python3 8 site packages s3fs core py line 1096 in init super init s3 path mode block size autocommit=autocommit File opt conda envs delisting lib python3 8 site packages fsspec spec py line 1351 in init self size = self details size File opt conda envs delisting lib python3 8 site packages fsspec spec py line 1364 in details self details = <http self fs info|self fs info> self path File opt conda envs delisting lib python3 8 site packages s3fs core py line 546 in info return super S3FileSystem self info path File opt conda envs delisting lib python3 8 site packages fsspec spec py line 599 in info raise FileNotFoundError path FileNotFoundError my s3 path file xlsxx The above exception was the direct cause of the following exception Traceback most recent call last File opt conda envs delisting bin kedro line 8 in lt module gt sys exit main File opt conda envs delisting lib python3 8 site packages kedro framework cli cli py line 246 in main cli collection File opt conda envs delisting lib python3 8 site packages click core py line 829 in call return self main args kwargs File opt conda envs delisting lib python3 8 site packages kedro framework cli cli py line 184 in main super main File opt conda envs delisting lib python3 8 site packages click core py line 782 in main rv = self invoke ctx File opt conda envs delisting lib python3 8 site packages click core py line 1259 in invoke return process result sub ctx command invoke sub ctx File opt conda envs delisting lib python3 8 site packages click core py line 1066 in invoke return ctx invoke self callback ctx params File opt conda envs delisting lib python3 8 site packages click core py line 610 in invoke return callback args kwargs File opt conda envs delisting lib python3 8 site packages kedro framework cli project py line 390 in run session run File opt conda envs delisting lib python3 8 site packages kedro framework session session py line 391 in run run result = runner run filtered pipeline catalog run id File opt conda envs delisting lib python3 8 site packages kedro runner runner py line 79 in run self run pipeline catalog run id File opt conda envs delisting lib python3 8 site packages kedro runner sequential runner py line 63 in run run node node catalog self is async run id File opt conda envs delisting lib python3 8 site packages kedro runner runner py line 192 in run node node = run node sequential node catalog run id File opt conda envs delisting lib python3 8 site packages kedro runner runner py line 269 in run node sequential inputs name = catalog load name File opt conda envs delisting lib python3 8 site packages kedro io data catalog py line 397 in load result = func File opt conda envs delisting lib python3 8 site packages kedro io core py line 595 in load return super load File opt conda envs delisting lib python3 8 site packages kedro io core py line 191 in load raise DataSetError message from exc kedro io core DataSetError Failed while loading data from data set ExcelDataSet filepath=my s3 path file xlsx load args= engine openpyxl sheet name Sheet1 protocol=s3 save args= index False writer args= engine xlsxwriter my s3 path file xlsx```

Leslie Wu · Answer

I see ```FileNotFoundError my s3 path file xlsx``` I can definitely confirm that the file exists in the specified path

Michel van den Berg · Answer

maybe auth

Leslie Wu · Answer

Would it be auth I have no problems writing other file formats to the same S3 bucket

Michel van den Berg · Answer

then I have no clue haha