top of page
horizontal lines
Gigasheet Primary logo
  • Anubhav Awasthi

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 Scores Data Analysis in Gigasheet

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.)

Snapshot of processed CSV file in Gigasheet's library.

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.

CSV dataset of FIFA World Cup Scores processed in spreadsheet format in Gigasheet.

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 allows users to perform arithmetic operations on two columns with numerical values and create a new column containing the result.

Gigasheet automatically performs arithmetic calculations 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.