The Altair Community is migrating to a new platform to provide a better experience for you. The RapidMiner Community will merge with the Altair Community at the same time. In preparation for the migration, both communities are on read-only mode from July 15th - July 24th, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here.
Options

Reading excel file written by Rapidminer in Pandas Dataframe

xutfe3937xutfe3937 Member Posts: 4 Learner I
Hello,

I have a process in RM that writes some data into excel using "Write Excel" operator, and the file format is .xlsx

This excel file is to be read in a Python script for which I use pandas library, but the excel file is read as an empty dataframe within the script. It can only read the first column name in the excel file, but the other columns and all the data could not be read. I have attached a screenshot with this question.

However, when I open and save the excel file manually, and then try to read the same excel file in my script, it is able to read all the columns and data.

Is there a way in RM to write the data into excel so it can be read in Python script without the need to open and save the excel file manually.
Tagged:
Sign In or Register to comment.