Icon

JKISeasor2-27_​tomljh_​ver1

There has been no title set for this workflow's metadata.

Challenge 27: Exploring World Cup Datasets

Challenge 27: Exploring World Cup DatasetsLevel: MediumDescription: We explore World Cup datasets in this challenge, with the goal of seeing howmany games under FIFA were played between different confederations in the last year (between2021-2022). We have two files, results.csv and shootouts.csv, from which we need the yearwhen the games were played. We also have a third file, teams.xlsx, detailing teams and towhich confederation they belong. The output table should look something like this AFC UEFA CONCACAFAFC 34 67 89 UEFA 67 65 12CONCACAF 89 12 36This challenge is based on this blog post.Author: Sanket Joshi 挑战27：探索世界杯数据集级别：中等描述：我们在这项挑战中探索了世界杯数据集，目的是了解去年（2021-2022年）在国际足联的领导下，不同联盟之间进行了多少场比赛。我们有两个文件，results.csv和shootouts.csv，我们需要这些文件中的比赛年份。我们还有第三个文件teams.xlsx，详细说明了团队以及他们所属的联盟。输出表应该如下所示： AFC UEFA CONCACAFAFC 34 67 89 UEFA 67 65 12CONCACAF 89 12 36这个挑战是基于这篇博客文章。作者：Sanket Joshi Readteams.xlsxReadresults.csvstring -> datetime2021-01-01 to 2022-12-31Confederation of home teamConfederation of away teamResultOnly keep:AFCUEFA CONCACAF Excel Reader CSV Reader String to Date&Time Date&Time-basedRow Filter Joiner Joiner DuplicateRow Filter Pivot DuplicateRow Filter Nominal ValueRow Filter Challenge 27: Exploring World Cup DatasetsLevel: MediumDescription: We explore World Cup datasets in this challenge, with the goal of seeing howmany games under FIFA were played between different confederations in the last year (between2021-2022). We have two files, results.csv and shootouts.csv, from which we need the yearwhen the games were played. We also have a third file, teams.xlsx, detailing teams and towhich confederation they belong. The output table should look something like this AFC UEFA CONCACAFAFC 34 67 89 UEFA 67 65 12CONCACAF 89 12 36This challenge is based on this blog post.Author: Sanket Joshi 挑战27：探索世界杯数据集级别：中等描述：我们在这项挑战中探索了世界杯数据集，目的是了解去年（2021-2022年）在国际足联的领导下，不同联盟之间进行了多少场比赛。我们有两个文件，results.csv和shootouts.csv，我们需要这些文件中的比赛年份。我们还有第三个文件teams.xlsx，详细说明了团队以及他们所属的联盟。输出表应该如下所示： AFC UEFA CONCACAFAFC 34 67 89 UEFA 67 65 12CONCACAF 89 12 36这个挑战是基于这篇博客文章。作者：Sanket Joshi Readteams.xlsxReadresults.csvstring -> datetime2021-01-01 to 2022-12-31Confederation of home teamConfederation of away teamResultOnly keep:AFCUEFA CONCACAF Excel Reader CSV Reader String to Date&Time Date&Time-basedRow Filter Joiner Joiner DuplicateRow Filter Pivot DuplicateRow Filter Nominal ValueRow Filter

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: Admin
Created at: 2023-09-27
On NodePit since: 2023-09-28
Last update: 2024-11-21
Created with KNIME version: v5.1.1
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!