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

Edit a file already imported

claudia_figueraclaudia_figuera Member Posts: 2 Learner II
edited November 2018 in Help

Hi!

I would like to know if there is any possibility to edit a file (like excluding a column, for instance) once I have clicked on Import. Can someone help me? Moreover, can I remove this file without accessing to my finder and files?

 

Thanks a lot in advance.

 

Claudia

Answers

  • Telcontar120Telcontar120 RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,635 Unicorn

    There are multiple ways of doing what you are suggesting, depending on how you imported the data and whether you want the change to be permanent.

     

    Perhaps the easiest solution is that you can always eliminate any number of attributes from your dataset using the "Select Attributes" operator.  This will only affect the copy in memory when running the process.  If you want to go back and overwrite the data you originally imported with this smaller dataset you would then need to add another Store operator to do that.

     

    If you want to skip certain columns when importing, there is a check box when using the wizard (with Read CSV or Read Excel, for example) for each column--unchecking that will skip that column.  Once you have run the wizard once, this can be edited in the import metadata available through the parameter window.

     

     

    Brian T.
    Lindon Ventures 
    Data Science Consulting from Certified RapidMiner Experts
  • Marco_BoeckMarco_Boeck Administrator, Moderator, Employee-RapidMiner, Member, University Professor Posts: 1,996 RM Engineering

    Hi,

     

    in addition to the reply above, a sometimes very useful trick can be to right-click the data in your Repository panel, and select "Edit". This will allow you to modify the data in a way quite similar to Excel :)

    You can directly edit data, add new attributes or remove old ones, as well as modify name, type, and role of already existing attributes. Search & Replace is also available there.

     

    Regards,

    Marco

Sign In or Register to comment.