Icon

JKISeason2-27

Just Knime It season2-27

Just KNIME It! Season2-27KNMIE version: 4.7.7 Description:We explore World Cup datasets in this challenge, with the goal of seeing how many games under FIFA were played betweendifferent confederations in the last year (between 2021-2022). We have two files, results.csv and shootouts.csv, from which weneed the year when the games were played. We also have a third file, teams.xlsx, detailing teams and to which confederation theybelong. The output table should look something like this AFC UEFA CONCACAFAFC 34 67 89 UEFA 67 65 12CONCACAF 89 12 36 The data should be a symmetric matrix !! results.csv読み込み日付をday typeに2021-01-01から2022-01-01までに限定teams.xlsx読み込みhome teamの置換重複削除home teamの置換組み合わせをリスト化リストを分解 順番を逆にする組み合わせをリスト化リストを分割結合同エリア同士の試合はduplicateになるので削除するPivotsort?を0で置換 CSV Reader String to Date&Time Date&Time-basedRow Filter Excel Reader Cell Replacer DuplicateRow Filter Cell Replacer Column Aggregator Split CollectionColumn Column Resorter Column Aggregator Split CollectionColumn Concatenate Rule-basedRow Filter Pivoting Column Resorter Missing Value Just KNIME It! Season2-27KNMIE version: 4.7.7 Description:We explore World Cup datasets in this challenge, with the goal of seeing how many games under FIFA were played betweendifferent confederations in the last year (between 2021-2022). We have two files, results.csv and shootouts.csv, from which weneed the year when the games were played. We also have a third file, teams.xlsx, detailing teams and to which confederation theybelong. The output table should look something like this AFC UEFA CONCACAFAFC 34 67 89 UEFA 67 65 12CONCACAF 89 12 36 The data should be a symmetric matrix !! results.csv読み込み日付をday typeに2021-01-01から2022-01-01までに限定teams.xlsx読み込みhome teamの置換重複削除home teamの置換組み合わせをリスト化リストを分解 順番を逆にする組み合わせをリスト化リストを分割結合同エリア同士の試合はduplicateになるので削除するPivotsort?を0で置換 CSV Reader String to Date&Time Date&Time-basedRow Filter Excel Reader Cell Replacer DuplicateRow Filter Cell Replacer Column Aggregator Split CollectionColumn Column Resorter Column Aggregator Split CollectionColumn Concatenate Rule-basedRow Filter Pivoting Column Resorter Missing Value

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: oofusaka
Created at: 2023-09-22
On NodePit since: 2023-09-29
Last update: 2024-04-26
Created with KNIME version: v4.7.7
Tags: JKISeason2-27

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

Try NodePit Runner!