TD_TrainTestSplit Examples | train_test_split | Teradata Vantage - TD_TrainTestSplit Examples - Analytics Database

The following input table is used with the examples:

Example: StratifyColumn and Seed Do Not Exist

When Seed is not specified, the Seed value is randomly generated and the rows chosen for train and test data sets are not deterministic across multiple function calls.

SELECT * FROM TD_TrainTestSplit(
ON titanicDataset AS InputTable
USING
IDColumn('PassengerId')
trainSize(0.75)
testSize(0.25)
)As dt;

Example: StratifyColumn Does Not Exist and Seed Exists

SELECT * FROM TD_TrainTestSplit(
ON titanicDataset AS InputTable
USING
IDColumn('PassengerId')
trainSize(0.75)
testSize(0.25)
Seed(42)
)AS dt;

Example: StratifyColumn Exists and Seed Does Not Exist

SELECT * FROM TD_TrainTestSplit(
ON titanicDataset AS InputTable
USING
IDColumn('PassengerId')
trainSize(0.75)
testSize(0.25)
stratifyColumn('Survived')
)AS dt;

Example: StratifyColumn and Seed Exist

SELECT * FROM TD_TrainTestSplit(
ON titanicDataset AS InputTable
USING
IDColumn('PassengerId')
trainSize(0.75)
testSize(0.25)
Seed (42)
stratifyColumn('Survived')
)AS dt;