Options

How to display only certain attributes when exporting into an excel file

lolollolol Member Posts: 5 Newbie

Hi, I'm here to help.

I am currently working on a text prediction task. After preprocessing the text data and tokenizing it, each individual word becomes an attribute, right? However, the number of attributes has become quite large due to the generation of n-grams. Consequently, when I tried to export the predictions to an Excel file, it failed because Excel can only support 16,384 columns, whereas I have 83,827 attributes. Therefore, I'm unable to export the data to an Excel file. Can you please guide me on how to select only certain attributes for export? I would greatly appreciate your assistance.


Answers

  • Options
    BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 Unicorn
    Hi!

    You can use "Select Attributes" for reducing the number of the attributes that go into the excel table.

    If you know the attribute names you want to keep, "Subset" is the best selection mode. 

    Regards,
    Balázs
Sign In or Register to comment.