I have a data set of mean. I want to add a validation column in order to set values as:
between 0- 2 = train
between 2-3 = validation
3+ = test
I read all the help and community discussions but cant find such a thing.
I also tried to manually add a column wich I wrote each row by myself. But when ı try to use this validation column in analysis I get an error of column properties.
waiting your kind help.
thanks and regards
feelsgood: I'm not quite sure what you are asking in your question. Are you trying to parse the data such that for a given column's value, if it's between 0 and 2 you'd like to assign the 'training' designation, and on and on? Please clarify before I provide a recommendation or thoughts.
OK, now I'll ask another question. Is the column that you are using to determine the validation category value a dependent variable from a modeling point of view? And will you use this column for modeling purposes as a dependent variable?