{
"TrainingTime": 60,
"Scenario": "Regression",
"DataSource": {
"Type": "SQL",
"Version": 1,
"ColumnProperties": [
{
"ColumnName": "vendor_id",
"ColumnPurpose": "Feature",
"ColumnDataFormat": "String",
"IsCategorical": true,
"Type": "Column",
"Version": 1
},
{
"ColumnName": "rate_code",
"ColumnPurpose": "Feature",
"ColumnDataFormat": "Single",
"IsCategorical": true,
"Type": "Column",
"Version": 1
},
{
"ColumnName": "passenger_count",
"ColumnPurpose": "Feature",
"ColumnDataFormat": "Single",
"IsCategorical": true,
"Type": "Column",
"Version": 1
},
{
"ColumnName": "trip_time_in_secs",
"ColumnPurpose": "Feature",
"ColumnDataFormat": "Single",
"IsCategorical": false,
"Type": "Column",
"Version": 1
},
{
"ColumnName": "trip_distance",
"ColumnPurpose": "Feature",
"ColumnDataFormat": "Single",
"IsCategorical": false,
"Type": "Column",
"Version": 1
},
{
"ColumnName": "payment_type",
"ColumnPurpose": "Feature",
"ColumnDataFormat": "String",
"IsCategorical": true,
"Type": "Column",
"Version": 1
},
{
"ColumnName": "fare_amount",
"ColumnPurpose": "Label",
"ColumnDataFormat": "Single",
"IsCategorical": false,
"Type": "Column",
"Version": 1
}
],
"ConnectionString": "Data Source=sql-dataset.database.windows.net;Initial Catalog=regression;User ID=littlecloud",
"CommandString": "SELECT vendor_id, CAST(rate_code as REAL), CAST(passenger_count as REAL), CAST(trip_time_in_secs as REAL), CAST(trip_distance as REAL), payment_type, CAST(fare_amount as REAL) FROM [dbo].[taxi-fare-train]",
"DatabaseName": "regression",
"SelectedTableDbo": "dbo",
"TableName": "taxi-fare-train"
},
"Environment": {
"Type": "LocalCPU",
"Version": 1
},
"RunHistory": {
"Version": 0,
"Type": "Result",
"Trials": [
{
"Version": 0,
"Type": "Trial",
"TrainerName": "FastForestRegression",
"Score": 0.91000602877954717,
"RuntimeInSeconds": 0.98100000619888306
},
{
"Version": 0,
"Type": "Trial",
"TrainerName": "FastTreeRegression",
"Score": -0.18542799319036529,
"RuntimeInSeconds": 0.22200000286102295
},
{
"Version": 0,
"Type": "Trial",
"TrainerName": "FastTreeTweedieRegression",
"Score": -0.90069937679385093,
"RuntimeInSeconds": 0.23199999332427979
},
{
"Version": 0,
"Type": "Trial",
"TrainerName": "SdcaRegression",
"Score": 0.32460031789278665,
"RuntimeInSeconds": 0.36100000143051147
},
{
"Version": 0,
"Type": "Trial",
"TrainerName": "LightGbmRegression",
"Score": 0.87500649294540334,
"RuntimeInSeconds": 0.23399999737739563
},
{
"Version": 0,
"Type": "Trial",
"TrainerName": "FastForestRegression",
"Score": 0.90648395408110438,
"RuntimeInSeconds": 0.17200000584125519
},
{
"Version": 0,
"Type": "Trial",
"TrainerName": "LbfgsPoissonRegressionRegression",
"Score": -12.580339823996704,
"RuntimeInSeconds": 0.29499998688697815
},
{
"Version": 0,
"Type": "Trial",
"TrainerName": "FastTreeRegression",
"Score": 0.89987976842698214,
"RuntimeInSeconds": 0.20800000429153442
},
{
"Version": 0,
"Type": "Trial",
"TrainerName": "FastTreeTweedieRegression",
"Score": -1.1018975439236351,
"RuntimeInSeconds": 0.20100000500679016
},
{
"Version": 0,
"Type": "Trial",
"TrainerName": "SdcaRegression",
"Score": 0.33671601885916069,
"RuntimeInSeconds": 0.55199998617172241
},
{
"Version": 0,
"Type": "Trial",
"TrainerName": "LightGbmRegression",
"Score": 0.73892464004999292,
"RuntimeInSeconds": 0.18500000238418579
},
{
"Version": 0,
"Type": "Trial",
"TrainerName": "LbfgsPoissonRegressionRegression",
"Score": -12.410037260410206,
"RuntimeInSeconds": 0.29800000786781311
},
{
"Version": 0,
"Type": "Trial",
"TrainerName": "FastForestRegression",
"Score": 0.90499490253377,
"RuntimeInSeconds": 0.21799999475479126
},
{
"Version": 0,
"Type": "Trial",
"TrainerName": "FastTreeTweedieRegression",
"Score": 0.742923727046542,
"RuntimeInSeconds": 0.20200000703334808
},
{
"Version": 0,
"Type": "Trial",
"TrainerName": "FastTreeRegression",
"Score": 0.90576242351638159,
"RuntimeInSeconds": 0.18700000643730164
},
{
"Version": 0,
"Type": "Trial",
"TrainerName": "SdcaRegression",
"Score": 0.64740971326069419,
"RuntimeInSeconds": 0.20800000429153442
},
{
"Version": 0,
"Type": "Trial",
"TrainerName": "LbfgsPoissonRegressionRegression",
"Score": -9.80194842099228,
"RuntimeInSeconds": 0.24400000274181366
},
{
"Version": 0,
"Type": "Trial",
"TrainerName": "LightGbmRegression",
"Score": 0.89371761119670223,
"RuntimeInSeconds": 0.17200000584125519
},
{
"Version": 0,
"Type": "Trial",
"TrainerName": "FastForestRegression",
"Score": 0.9097859933419099,
"RuntimeInSeconds": 0.18799999356269836
},
{
"Version": 0,
"Type": "Trial",
"TrainerName": "FastTreeTweedieRegression",
"Score": -1.0644162681964935,
"RuntimeInSeconds": 0.20999999344348907
},
{
"Version": 0,
"Type": "Trial",
"TrainerName": "FastTreeRegression",
"Score": 0.92949522408261531,
"RuntimeInSeconds": 0.20399999618530273
}
],
"Pipeline": "{\"parameter\":{\r\n \"0\": {\r\n \"OutputColumnNames\": [\r\n \"vendor_id\",\r\n \"payment_type\"\r\n ],\r\n \"InputColumnNames\": [\r\n \"vendor_id\",\r\n \"payment_type\"\r\n ]\r\n },\r\n \"1\": {\r\n \"OutputColumnNames\": [\r\n \"rate_code\",\r\n \"passenger_count\",\r\n \"trip_time_in_secs\",\r\n \"trip_distance\"\r\n ],\r\n \"InputColumnNames\": [\r\n \"rate_code\",\r\n \"passenger_count\",\r\n \"trip_time_in_secs\",\r\n \"trip_distance\"\r\n ]\r\n },\r\n \"2\": {\r\n \"InputColumnNames\": [\r\n \"vendor_id\",\r\n \"payment_type\",\r\n \"rate_code\",\r\n \"passenger_count\",\r\n \"trip_time_in_secs\",\r\n \"trip_distance\"\r\n ],\r\n \"OutputColumnName\": \"Features\"\r\n },\r\n \"3\": {\r\n \"NumberOfLeaves\": 16,\r\n \"MinimumExampleCountPerLeaf\": 23,\r\n \"NumberOfTrees\": 4,\r\n \"MaximumBinCountPerFeature\": 88,\r\n \"FeatureFraction\": 0.42925323487291989,\r\n \"LearningRate\": 0.99999977667298634,\r\n \"LabelColumnName\": \"fare_amount\",\r\n \"FeatureColumnName\": \"Features\"\r\n }\r\n},\"estimators\":[\"OneHotEncoding\",\"ReplaceMissingValues\",\"Concatenate\",\"FastTreeRegression\"]}",
"MetricName": "RSquared"
},
"Type": "TrainingConfig",
"Version": 1
}
Model Builder Version: current main
reopen the following mbconfig to reproduce it