Data Analysis: FIFA World Cup Scores

The FIFA World Cup 2022 is over, and Argentina has won its third title in a thriller final against France. Lionel Messi finally has the last accolade he needs to be the greatest to have ever played the game of football. Some even call the 2022 edition of the football World Cup held in Qatar the best. Is it so? What does data say?

‍

Let us find out by analyzing FIFA world cup scores data!  At Gigasheet, we make it easy to open and analyze CSV files online, for free! We also love football, soccer, or whichever term you prefer. Make sure you check out our other soccer data exploration, Facts About Soccer, that explores the power of home field advantage.

FIFA World Cup Qatar 2022 Match Data

For our data analysis, we use a FIFA's dataset with match details, including goals, fouls, possession, penalties, and more. In addition, the dataset contains performance data for each team in separate columns: team1, team2, goals team1, goals team2, possession team1, possession team2, and so on.

As mentioned, we will use Gigasheet, a cloud-based no-code data analysis tool for analyzing FIFA data. We will use the features like groups, filters, formulae, and more to analyze data. So, let’s get started!

Upload FIFA Performance Data to Gigasheet

Gigasheet is very versatile when it comes to handling file formats and file sizes. You can upload large datasets in all popular file formats, such as CSV, JSON, XLSX, and more. In addition, you can upload your Zipped datasets directly, and Gigasheet will decompress and process the datasets within the zip file. Just follow these steps:

For analyzing FIFA data, we will log in to Gigasheet (Don’t have a Gigasheet account yet? Create a free account here.)

We will upload the CSV file containing FIFA 2022 data. Gigasheet will process it, and then we can click to open. Gigasheet processes datasets in spreadsheet format so even large data sets are easy to work with.

Analyzing FIFA Data

1. Total Goals Scored in FIFA World Cup 2022

If FIFA 2022 was the best edition of the football World Cup, then the teams must have scored a ton of goals. But were they able to beat the 171 goals mark, the highest ever total goals scored in a football World Cup tournament? Let us find out.

Since the goals for each team in a match have separate columns, we need to create a new column with the total goals in a game.

We will head to the Insert section in the menu bar and select Calculations. In the dialog box, we will select column “number of goals team1”, select addition operator, and column “number of goals team2.” Hit Apply, and we will have a resultant column with the total goals in a match.

Gigasheet automatically performs arithmetic calculations, or aggregations, for columns with a numerical value. We just have to select the function for the answers we need. For example, for total goals in the entire tournament, we will choose “Sum.” According to FIFA 2022 data, a total of 172 goals were scored, making the latest edition of the football World Cup with the most goals ever.

2. Goals Scored By Different Groups

FIFA World Cup 2022 has 32 teams divided into eight groups. To see the total goals scored by each group, we will use Gigasheet’s Group function. Click on Group, select the column “category,” and click Apply.

Then we will use the Sum function on the goals column to reveal the total goals for each group. We can see that Group E scored 22 goals, the most goals by a group in the tournament.

We can expand these grouped rows to reveal more information like teams, goals per team, etc. The group has former World Cup winners like Spain and Germany, which dominated the group.

Now we have the total number of goals for each group, and we can also visualize it in Gigasheet. Just select Grouped rows for Group A to H, right click > chart range > pie chart.

There we have a neat pictorial representation of our data in the form of a pie chart.

3. Own Goals

Own goals are embarrassing, but it is even more of an embarrassment to put one in your own goalpost on the biggest stage of them all. Our FIFA performance data has columns of own goals, which we can use to filter out teams who put themselves in disadvantage.

First, we will head to the menu bar and click on Filter. Since we have our own goals for team1 and team2 in separate columns, we will use the OR operator to filter teams with their own goals.

Only, two teams were unlucky to have scored an own goal: Morocco and Argentina.

Wrapping up the FIFA World Cup Scores

While Argentina is the world champion of football, France and others must wait for the next four years to get their hands on the cup. But for data analysts, data exploration and visualization is an everyday job. So, turn to Gigasheet for snappy and hassle-free big data analysis.

Using Gigasheet’s features, like filters and groups, make data analysis easy. With Gigasheet, you can even visualize data without having to export data to any data visualization tools. Best part? Gigasheet is free-to-use and helps you analyze large datasets without code.

To try it for yourself, Sign up for a free account today!

‍