Importing Xlsb file to rapidminer

Mera
Mera New Altair Community Member
edited November 2024 in Community Q&A
Hello,
I have 3 questions:
1) How can I import  xlsb file to rapidminer, does rapidminer support this type of file?
2) Do I have to only use a CSV file with collaborative filtering or can I use xlsb file?
3) Is it possible for rapidminer to append and proccess for collaborative filtering 5 files each is 1 million rows ?

Thanks for the help 
Tagged:

Best Answer

  • rfuentealba
    rfuentealba New Altair Community Member
    Answer ✓
    Hello @Mera,

    Answers:
    • XLSB files are binary Excel formats. You can open these with the Read Excel operator.
    • As long as your data is imported at the moment of execution, you can use anything that is supported.
    • I think it depends on your machine specifications, license and how much time it takes to do that. I would begin with smaller samples first.
    All the best,

    Rodrigo.

Answers

  • rfuentealba
    rfuentealba New Altair Community Member
    Answer ✓
    Hello @Mera,

    Answers:
    • XLSB files are binary Excel formats. You can open these with the Read Excel operator.
    • As long as your data is imported at the moment of execution, you can use anything that is supported.
    • I think it depends on your machine specifications, license and how much time it takes to do that. I would begin with smaller samples first.
    All the best,

    Rodrigo.

  • Mera
    Mera New Altair Community Member
    Hello, 
    thank you so much for your help much appreciated.