The include sheet data option

[Berns Buenaobra]

If I train from a sing;e sheet alone would that mean I should not tick the option [ ] Include sheet data? I'm confused with the statement:  Use the data in the current sheet to better explain the model. This sheet should not be the one used to train the model.?

[Bill Wood]

This is confusing to me as well.  Which sheet should we use if not the one used to train the model?

[Luiz Gustavo Martins]

Hi Bill and Berns,

The idea behind this is that you should run evaluation metrics on data that wasn't used in the training process. This is why there is the check box.

for a very good explanation, you can watch this video here: https://developers.google.com/machine-learning/crash-course/training-and-test-sets/video-lecture

but the rationale is:

when you train a model, it is learning from your data. To know if it really learned properly, you should test it on data that it has never seen before. Otherwise it's like a student that studied with the test questions. They will do very well on the test but that's because they "cheated".

To do that in real life, we usually take some data from our training dataset and put it on a different sheet and don't use it on training, only for testing purposes.

Does it make sense?

    Gus

--
You received this message because you are subscribed to the Google Groups "User Group | Simple ML for Sheets (Public)" group.
To unsubscribe from this group and stop receiving emails from it, send an email to simple-ml-for-sheet...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/simple-ml-for-sheets-users/ed805670-73e1-41ca-af12-5a2d6af39866n%40googlegroups.com.

[Bill Wood]

Yes it does make sense, thanks!