two data sets

[Deleted User]
[Deleted User] New Altair Community Member
edited November 2024 in Community Q&A
Hi
I have two excel form of data and one of them has Label the other one doesnt have label column so is it possible to import both of them to RM and start use ML algorithms for them?
Thank you

mbs
Tagged:

Best Answers

  • varunm1
    varunm1 New Altair Community Member
    Answer ✓
    Hello @mbs

    Yes, you can. You do not need a label for importing. If both of these datasets are related, you can train the algorithm on a dataset with labels and use the apply model to predict labels for the dataset without labels.

    Hope this helps. Please inform if you have more questions.
  • varunm1
    varunm1 New Altair Community Member
    Answer ✓
    I attached a sample process using Titanic labeled and unlabelled datasets for your reference. You can import the .rmp file.

    Thanks

Answers

  • varunm1
    varunm1 New Altair Community Member
    Answer ✓
    Hello @mbs

    Yes, you can. You do not need a label for importing. If both of these datasets are related, you can train the algorithm on a dataset with labels and use the apply model to predict labels for the dataset without labels.

    Hope this helps. Please inform if you have more questions.
  • [Deleted User]
    [Deleted User] New Altair Community Member
    @varunm1

    Thank you for your quick answer. ;)
    I will try it

    regards 

    mbs
  • varunm1
    varunm1 New Altair Community Member
    Answer ✓
    I attached a sample process using Titanic labeled and unlabelled datasets for your reference. You can import the .rmp file.

    Thanks
  • [Deleted User]
    [Deleted User] New Altair Community Member
    @varunm1

    Thank you very much  o:)

    best regards
    mbs

    ...................................................................................................................................................
    @varunm1

    از راهنمایی شما خیلی ممنونم

    با احترام
    mbs
  • [Deleted User]
    [Deleted User] New Altair Community Member
    @varunm1

    I import your rmp file but unfortunately I see a problem that shows some columns doesnt match with each other but I check the data and it doesnt have any problem. please guide me to solve it.

    Thank you

    mbs
  • [Deleted User]
    [Deleted User] New Altair Community Member
    edited October 2019
    yes
  • varunm1
    varunm1 New Altair Community Member
    Hello @mbs

    Can you set a breakpoint before apply model by right clicking on the apply model operator? Once you set it, run the process and see if the attribute is available, if it is available see what the type (numeric, polynomial etc) of that attribute is. You can also see what type of attribute is coming from the training data set by setting break point after  read excel (training data).
  • [Deleted User]
    [Deleted User] New Altair Community Member
    @varunm1

    all my data is in binary form but I think this is not the problem of data and its like a bug and i couldnt handle it. :(

    mbs
  • varunm1
    varunm1 New Altair Community Member
    You can send me your data and process in direct message for checking.
  • [Deleted User]
    [Deleted User] New Altair Community Member
    sure ;)

    I did it :)
  • [Deleted User]
    [Deleted User] New Altair Community Member
    @varunm1


    Hello

    I changed all the columns header (type dote between words) but still I see so many bugs :(

    And no thing work :/

    please help me to solve it

    regards 

    mbs
  • varunm1
    varunm1 New Altair Community Member
    Can you post the images of those bugs?
  • [Deleted User]
    [Deleted User] New Altair Community Member
    names dont have any problem :/
  • varunm1
    varunm1 New Altair Community Member
    If you have the attribute available in both data sets and they belong to the same data type (polnomial, integer etc), from my understanding its the Names issue (spaces). Lets see if @sgenzer or @mschmitz
  • MartinLiebig
    MartinLiebig
    Altair Employee
    Hi,
    this UserError just states, that the data set you apply the model on (the lowerone) doesnot contain the attribute WRITE.CONTACTS. Please verify that it exists andis not special.

    BR,
    Martin
  • [Deleted User]
    [Deleted User] New Altair Community Member
    @mschmitz
    Hi

    In both data I have the same attribute " write.contacts".
    But still I see the error. :/

    regards 

    mbs

  • MartinLiebig
    MartinLiebig
    Altair Employee
    hi,
    keep in mind that captial letters play a role. is this writtena lso all in caps?

    Best,
    Martin
  • varunm1
    varunm1 New Altair Community Member
    edited September 2019
    Hello Martin, @mschmitz

    can the spaces before the start of names in excel impact RM attributes if we use read excel operator?
  • [Deleted User]
    [Deleted User] New Altair Community Member
    edited September 2019
    @mschmitz


    Yes you see the exact form of writing with captial letters in both of them.

    Thank you 

    mbs