question

XuJeff-1256 avatar image
0 Votes"
XuJeff-1256 asked romungi-MSFT answered

Add ID column after feature selection processing in Azure ML studio

Hi all,

In my dataset, i have one ID key with 100 features and target column. After using feature filtering function, i select top 50 feature for the prediction. the problem is, after i covert my experiment to predictive experiment, i still need to report final result as: id, scored label.

i found id column was missed in the predictive experiments and was not included in the SCORE MODLE - Probably due to feature filtering process.

How can i include ID column back to the final score model ?

thx.

azure-machine-learning
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

romungi-MSFT avatar image
0 Votes"
romungi-MSFT answered

@XuJeff-1256 How is your pipeline configured in the designer? Are you using any normalization module and included the ID in it?
Ideally you can include your ID and the scored label in your web output as mentioned in this sample. But, of course your score model module does not have it so you can't include it. Something like this,

111794-image.png



image.png (72.5 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

hi, thanks for the quick reply with the example. i am able to add in the ID column with select the column in the data set. looks it is working now.

thx.

0 Votes 0 ·

Thanks @XuJeff-1256 for confirming. I will go ahead and move my response as answer, please feel free to accept it it helped.

0 Votes 0 ·