The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 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

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

lolollolol Member Posts: 5 Learner I
in Help

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

  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee-RapidMiner, 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.