Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
I went through the community and I couldn't find a solution for my issue when I try to import excel files from SFTP using python recipe:
I'm using the following code:
import dataiku import pandas as pd import numpy as np from dataiku import pandasutils as pdu FOLDER_NAME = 'folder_1' FILE_NAME = 'file_1.xlsx' DATASET_NAME = 'dataset_1' folder = dataiku.Folder(FOLDER_NAME) with folder.get_download_stream(FILE_NAME) as f: df = pd.read_excel(f)
After running the above i get the following error:
Thank you for the reply. I tried your code and I'm getting a new error:
XLRDError: Excel xlsx file; not supported
I tried to install xlrd==2.0.1 and openpyxl==3.0.9 packages, however even after installation, i'm still getting the error.
Hi @pafj ,
If you won't specify an engine to use, the xlrd is used by default. xlrd removed support for anything other than .xls files from version 2.0 (docs), hence you will need to use xlrd<1.2.0 in your code env to be able to read the xlsx files with xlrd engine. Otherwise, you will need to specify openpyxl engine to use:
df = pd.read_excel(temp_path, engine='openpyxl')