Icon

one_​wf_​rule_​them_​all

tennis_matches_prediction

This workflow aims to replicate the work of M.Sipko on tennis matches prediction with machine learning.

reading historical statistics 1991-now l_retiredsurface weightingset of unique playersweights preparationfatigueretiredH2H calculationuncertaintymeasureloser_id's historicalweighted averagingupcoming_matchset of commonopponents and countwinner_id's historicalweighted averagingw_WSP, l_WSPw/l_Completew/l_ServeadvX-sX-s & Yrow_indexremove ifuncertainty missingfeatures difference:winner - losersurface correlationgroupby yearsby year deschistorical_periodsample year endNode 510Node 511Node 512Node 513Node 517Node 518Node 521Node 522Node 523hist_stat_yearNode 530Node 532Node 534Node 535Node 536Node 537Node 575Node 580Node 581Node 583Node 589Node 590Node 591Node 592 summary 1Node 599Node 600Node 603total netNode 6221991-2019Node 649preprocessed data1991-2019processing1991-2016processing2017-2019Node 682Node 683Node 684Node 685upcoming matchesNode 688Node 690preprocessed data1991-2019Node 694surface correlationNode 697Node 698# years to processNode 700Node 701Node 702Node 703Node 705Node 706upcoming_matches_hist_statNode 711Node 712Node 713Node 714Node 715Node 716Node 718Node 720Node 721Node 722Node 723Node 726Node 727Node 728Node 729Node 730Node 731Node 732Node 733Node 734Node 735winner_left = 1winner_left = 0Node 739Node 740Node 741Node 742Node 743Node 744Node 751Node 752Node 753Node 754Node 757Node 758Node 7590 rowsALL columnsNode 763Node 764Node 7650 rowsALL columnsNode 767Node 771players 1991-2019players 1991-2019Node 774Node 775Node 776Node 777Node 778Node 779Node 780Node 781Node 782Node 783Node 784Node 785Node 786Node 787Node 788Node 789Node 790preprocessed data1991-2019Node 792Node 793Node 794Node 795Node 796Node 797Node 798Node 799Node 790Node 801Node 802Node 803Node 804preprocessed data2020+Node 806Node 807preprocessed data1991-2019preprocessed data2020+Node 810Node 811Node 812 summary 1Node 815Node 816Node 822Node 823 grand slamsnormalizerpreprocessed data2020+Node 829players 1991-2019upcoming_matchespreprocessed data2020+Node 833Node 834Node 835Node 836upcoming_matches_hist_statNode 838normalizerclassifier subst(date) => year summary 2switchNode 846Node 847Node 848set of unique playersplayers 2020+players 2020+Node 852Node 853wildcard*upcoming*Node 855Node 856Node 857Node 858Node 859Node 860Node 861Node 862Node 863Node 865Node 868Node 870Node 871Node 872Node 873Node 881Node 882Node 883Node 884Node 885ML modelsNode 887switchNode 893Node 895Node 896wildcard*completed*completed newmatchesswitchNode 901Node 902Node 903Node 904Node 905Node 906Node 907*(-1)Ymod(iteration/2)Ymod(iteration/2)X-s & YX-s & YNode 922Y*(-1)YYnormalizerNode 936X-s & YNode 938Node 939remove DIRECTNode 941Node 942Node 943keep elo beforeNode 945features difference:winner - loseradded ELOX-sNode 948only ELO & Yonly ELO & YNode 951Node 953k <= 1.31k > 1.31k <= 2.508k > 2.508Node 956Node 957Node 958switchNode 960Node 961Node 962 Node 790 Node 951Node 965Node 966Node 967Node 968Node 969Node 970Node 971Node 972Node 973Node 974Rule Engine Metanode Metanode Metanode Metanode Metanode Metanode Metanode Metanode Variable toTable Row Metanode Metanode Column Appender Column Expressions Column Expressions Column Filter Column Filter Rule Engine Timer Info Missing Value Column Expressions Table Writer GroupBy Sorter IntegerConfiguration Table Row ToVariable Loop Start Math Formula(Variable) Rule-basedRow Filter ParallelChunk Start Parallel Chunk End Table Row ToVariable Loop Start Loop End Column Filter Row Filter Row Filter RowID String Manipulation RowID Table Writer String Manipulation(Variable) String to Path(Variable) Table Reader List Files/Folders Table Row ToVariable Loop Start Loop End Similarity Search ReferenceColumn Splitter ReferenceColumn Splitter Column Filter Rule Engine Rule Engine Math Formula Rule Engine GroupBy IntegerConfiguration Math Formula(Variable) Rule-basedRow Filter GroupBy Insert ColumnHeader String to Date&Time Concatenate Rule Engine Table Writer Metanode Metanode Table Row ToVariable Loop Start List Files/Folders Loop End CSV Reader Table Reader Concatenate CASE Switch Start Table Reader End IF Column Filter Table Reader CASE Switch Start End IF Row Filter CASE Switch Start ReferenceRow Filter End IF CASE Switch Start Variable Loop End CASE Switch End Table Writer Column Splitter String Manipulation(Multi Column) String To Number Math Formula(Multi Column) String Manipulation Cell Splitter Rule-basedRow Filter Rule-basedRow Filter String Manipulation String Manipulation String To Number Rule Engine Rule Engine Rule Engine String Manipulation Column Appender Rule Engine Rule Engine Row Splitter ExtractColumn Header Transpose Table Creator Table Creator Column Appender Insert ColumnHeader ExtractColumn Header Transpose Column Appender Concatenate Column Filter Concatenate Column Splitter ExtractColumn Header ExtractColumn Header Column Filter GroupBy String Manipulation String Manipulation Metanode Rule-basedRow Filter Column Appender Missing Value Column Appender Rule-basedRow Filter Missing Value String Manipulation Table Writer Table Reader Column Filter ExtractColumn Header Joiner Rule-basedRow Splitter String Manipulation String Manipulation Joiner Joiner Column Rename Rule Engine Rule Engine Sorter List Files/Folders String Manipulation String Manipulation Rule Engine Auto-Binner Table Reader Try (VariablePorts) Catch Errors(Data Ports) Table Creator Variable toTable Row Rule-basedRow Filter String Manipulation Rule Engine String Manipulation Auto-Binner Rule-basedRow Filter String Manipulation(Multi Column) String To Number Rule-basedRow Filter Table Writer String Manipulation String To Number Table Reader Table Reader Concatenate Joiner Joiner GroupBy Rule-basedRow Filter Rule-basedRow Filter RowID String Manipulation Rule-basedRow Filter Model Writer Table Reader Table Creator Table Reader Table Writer Table Reader Concatenate Joiner Joiner Column Rename Table Reader Normalizer (Apply) Model Reader Model Reader String Manipulation GroupBy Component CASE Switch Start End IF CASE Switch Start Metanode Table Writer Table Reader Concatenate Joiner List Files/Folders CSV Reader Table Row ToVariable Loop Start Loop End String Manipulation String Manipulation String To Number Rule Engine String To Number String Manipulation String to Date&Time Column Rename Column Filter Column Appender Column Filter Sorter Rule-basedRow Splitter Joiner Joiner Random ForestPredictor Rule-basedRow Splitter Joiner Math Formula Math Formula Column Filter Metanode MultiLayerPerceptronPredictor Component Concatenate Table Row ToVariable Loop Start Loop End List Files/Folders CSV Reader Component CASE Switch Start End IF Joiner Rule-basedRow Splitter Math Formula Math Formula Column Filter Math Formula(Multi Column) Row Filter ConstantValue Column Concatenate Row Filter Math Formula ConstantValue Column Math Formula Column Filter Column Filter Normalizer (Apply) ConstantValue Column Math Formula(Multi Column) ConstantValue Column Concatenate Normalizer ConstantValue Column Model Reader Normalizer (Apply) Column Filter Rule-basedRow Splitter Table Writer Column Filter CSV Writer CSV Reader RowID Column Filter Column Appender Column Expressions Column Filter CSV Writer Column Filter Column Filter GroupBy Histogram Rule-basedRow Splitter Rule-basedRow Splitter End IF End IF CASE Switch Start Component Column Filter Column Filter Column Filter Auto-Binner GroupBy Bar Chart GroupBy Bar Chart(JFreeChart) Rule Engine Rule Engine Math Formula Rule Engine Rule Engine Rule Engine Rule Engine String Manipulation reading historical statistics 1991-now l_retired surface weightingset of unique playersweights preparationfatigueretiredH2H calculationuncertaintymeasureloser_id's historicalweighted averagingupcoming_matchset of commonopponents and countwinner_id's historicalweighted averagingw_WSP, l_WSPw/l_Completew/l_ServeadvX-sX-s & Yrow_indexremove ifuncertainty missingfeatures difference:winner - losersurface correlationgroupby yearsby year deschistorical_periodsample year endNode 510Node 511Node 512Node 513Node 517Node 518Node 521Node 522Node 523hist_stat_yearNode 530Node 532Node 534Node 535Node 536Node 537Node 575Node 580Node 581Node 583Node 589Node 590Node 591Node 592 summary 1Node 599Node 600Node 603total netNode 6221991-2019Node 649preprocessed data1991-2019processing1991-2016processing2017-2019Node 682Node 683Node 684Node 685upcoming matchesNode 688Node 690preprocessed data1991-2019Node 694surface correlationNode 697Node 698# years to processNode 700Node 701Node 702Node 703Node 705Node 706upcoming_matches_hist_statNode 711Node 712Node 713Node 714Node 715Node 716Node 718Node 720Node 721Node 722Node 723Node 726Node 727Node 728Node 729Node 730Node 731Node 732Node 733Node 734Node 735winner_left = 1winner_left = 0Node 739Node 740Node 741Node 742Node 743Node 744Node 751Node 752Node 753Node 754Node 757Node 758Node 7590 rowsALL columnsNode 763Node 764Node 7650 rowsALL columnsNode 767Node 771players 1991-2019players 1991-2019Node 774Node 775Node 776Node 777Node 778Node 779Node 780Node 781Node 782Node 783Node 784Node 785Node 786Node 787Node 788Node 789Node 790preprocessed data1991-2019Node 792Node 793Node 794Node 795Node 796Node 797Node 798Node 799Node 790Node 801Node 802Node 803Node 804preprocessed data2020+Node 806Node 807preprocessed data1991-2019preprocessed data2020+Node 810Node 811Node 812 summary 1Node 815Node 816Node 822Node 823 grand slamsnormalizerpreprocessed data2020+Node 829players 1991-2019upcoming_matchespreprocessed data2020+Node 833Node 834Node 835Node 836upcoming_matches_hist_statNode 838normalizerclassifier subst(date) => year summary 2switchNode 846Node 847Node 848set of unique playersplayers 2020+players 2020+Node 852Node 853wildcard*upcoming*Node 855Node 856Node 857Node 858Node 859Node 860Node 861Node 862Node 863Node 865Node 868Node 870Node 871Node 872Node 873Node 881Node 882Node 883Node 884Node 885ML modelsNode 887switchNode 893Node 895Node 896wildcard*completed*completed newmatchesswitchNode 901Node 902Node 903Node 904Node 905Node 906Node 907*(-1)Ymod(iteration/2)Ymod(iteration/2)X-s & YX-s & YNode 922Y*(-1)YYnormalizerNode 936X-s & YNode 938Node 939remove DIRECTNode 941Node 942Node 943keep elo beforeNode 945features difference:winner - loseradded ELOX-sNode 948only ELO & Yonly ELO & YNode 951Node 953k <= 1.31k > 1.31k <= 2.508k > 2.508Node 956Node 957Node 958switchNode 960Node 961Node 962 Node 790 Node 951Node 965Node 966Node 967Node 968Node 969Node 970Node 971Node 972Node 973Node 974Rule Engine Metanode Metanode Metanode Metanode Metanode Metanode Metanode Metanode Variable toTable Row Metanode Metanode Column Appender Column Expressions Column Expressions Column Filter Column Filter Rule Engine Timer Info Missing Value Column Expressions Table Writer GroupBy Sorter IntegerConfiguration Table Row ToVariable Loop Start Math Formula(Variable) Rule-basedRow Filter ParallelChunk Start Parallel Chunk End Table Row ToVariable Loop Start Loop End Column Filter Row Filter Row Filter RowID String Manipulation RowID Table Writer String Manipulation(Variable) String to Path(Variable) Table Reader List Files/Folders Table Row ToVariable Loop Start Loop End Similarity Search ReferenceColumn Splitter ReferenceColumn Splitter Column Filter Rule Engine Rule Engine Math Formula Rule Engine GroupBy IntegerConfiguration Math Formula(Variable) Rule-basedRow Filter GroupBy Insert ColumnHeader String to Date&Time Concatenate Rule Engine Table Writer Metanode Metanode Table Row ToVariable Loop Start List Files/Folders Loop End CSV Reader Table Reader Concatenate CASE Switch Start Table Reader End IF Column Filter Table Reader CASE Switch Start End IF Row Filter CASE Switch Start ReferenceRow Filter End IF CASE Switch Start Variable Loop End CASE Switch End Table Writer Column Splitter String Manipulation(Multi Column) String To Number Math Formula(Multi Column) String Manipulation Cell Splitter Rule-basedRow Filter Rule-basedRow Filter String Manipulation String Manipulation String To Number Rule Engine Rule Engine Rule Engine String Manipulation Column Appender Rule Engine Rule Engine Row Splitter ExtractColumn Header Transpose Table Creator Table Creator Column Appender Insert ColumnHeader ExtractColumn Header Transpose Column Appender Concatenate Column Filter Concatenate Column Splitter ExtractColumn Header ExtractColumn Header Column Filter GroupBy String Manipulation String Manipulation Metanode Rule-basedRow Filter Column Appender Missing Value Column Appender Rule-basedRow Filter Missing Value String Manipulation Table Writer Table Reader Column Filter ExtractColumn Header Joiner Rule-basedRow Splitter String Manipulation String Manipulation Joiner Joiner Column Rename Rule Engine Rule Engine Sorter List Files/Folders String Manipulation String Manipulation Rule Engine Auto-Binner Table Reader Try (VariablePorts) Catch Errors(Data Ports) Table Creator Variable toTable Row Rule-basedRow Filter String Manipulation Rule Engine String Manipulation Auto-Binner Rule-basedRow Filter String Manipulation(Multi Column) String To Number Rule-basedRow Filter Table Writer String Manipulation String To Number Table Reader Table Reader Concatenate Joiner Joiner GroupBy Rule-basedRow Filter Rule-basedRow Filter RowID String Manipulation Rule-basedRow Filter Model Writer Table Reader Table Creator Table Reader Table Writer Table Reader Concatenate Joiner Joiner Column Rename Table Reader Normalizer (Apply) Model Reader Model Reader String Manipulation GroupBy Component CASE Switch Start End IF CASE Switch Start Metanode Table Writer Table Reader Concatenate Joiner List Files/Folders CSV Reader Table Row ToVariable Loop Start Loop End String Manipulation String Manipulation String To Number Rule Engine String To Number String Manipulation String to Date&Time Column Rename Column Filter Column Appender Column Filter Sorter Rule-basedRow Splitter Joiner Joiner Random ForestPredictor Rule-basedRow Splitter Joiner Math Formula Math Formula Column Filter Metanode MultiLayerPerceptronPredictor Component Concatenate Table Row ToVariable Loop Start Loop End List Files/Folders CSV Reader Component CASE Switch Start End IF Joiner Rule-basedRow Splitter Math Formula Math Formula Column Filter Math Formula(Multi Column) Row Filter ConstantValue Column Concatenate Row Filter Math Formula ConstantValue Column Math Formula Column Filter Column Filter Normalizer (Apply) ConstantValue Column Math Formula(Multi Column) ConstantValue Column Concatenate Normalizer ConstantValue Column Model Reader Normalizer (Apply) Column Filter Rule-basedRow Splitter Table Writer Column Filter CSV Writer CSV Reader RowID Column Filter Column Appender Column Expressions Column Filter CSV Writer Column Filter Column Filter GroupBy Histogram Rule-basedRow Splitter Rule-basedRow Splitter End IF End IF CASE Switch Start Component Column Filter Column Filter Column Filter Auto-Binner GroupBy Bar Chart GroupBy Bar Chart(JFreeChart) Rule Engine Rule Engine Math Formula Rule Engine Rule Engine Rule Engine Rule Engine String Manipulation

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: chyng
Created at: 2022-03-10
On NodePit since: 2023-06-15
Last update: 2024-12-21
Created with KNIME version: v4.7.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!