Total number of goals scored by a single team (extracted from JSON data)

Question

Total number of goals scored by a single team (extracted from JSON data)

My data consists of football games in a JSON file

[
   {
      "game_id":"258716",
      "game_date_start":"2016-08-15",
      "season": "2016",
      "team_1_id":"119",
      "team_2_id":"120",      
      "team_1_goals_quantity":"2",
      "team_2_goals_quantity":"1",         
   },
   {
      "game_id":"258717",
      "game_date_start":"2016-09-15",
      "season": "2016",
      "team_1_id":"119",
      "team_2_id":"122",      
      "team_1_goals_quantity":"1",
      "team_2_goals_quantity":"1"     
   },
   {
      "game_id":"258718",
      "game_date_start":"2016-07-15",
      "season": "2016",
      "team_1_id":"121",
      "team_2_id":"119",     
      "team_1_goals_quantity":"1",
      "team_2_goals_quantity":"1"      
   }
]

I have completed Task #1 which counts the total number of games for each team

For Task #2, I am using Vue.js but unsure how to count the total number of goals for each team across all games. The challenge lies in the fact that the team's unique ID can be found in either team_1_id or team_2_id.

If you have any suggestions or solutions for Task #2, please share them with me.

javascript json vue.js

Answer 1

Answer №1

If you prefer to maintain the code as is, consider incorporating an additional object for tracking goals in the following manner:

 function countGames() {
      var data = this.$store.getters.games;      
      var arr1 = []; 
      var goalsPerTeam = []; // keeping track of goals here
      var obj1 = {}; 

      //Fetching all unique Team IDs
      function getMatches() { 
              for (var i in data) {        
                    obj1[data[i].team_1_id] = (obj1[data[i].team_1_id] || 0) + 1;
                    obj1[data[i].team_2_id] = (obj1[data[i].team_2_id] || 0) + 1;
                    // adding goals count
                    if (goalsPerTeam[data[i].team_1_id] === undefined) {
                      goalsPerTeam[data[i].team_1_id] = parseInt(data[i].team_1_goals_quantity);
                    } else {
                      goalsPerTeam[data[i].team_1_id] += parseInt(data[i].team_1_goals_quantity);
                    }

                    if (goalsPerTeam[data[i].team_2_id] === undefined) {
                      goalsPerTeam[data[i].team_2_id] = parseInt(data[i].team_2_goals_quantity);
                    } else {
                      goalsPerTeam[data[i].team_2_id] += parseInt(data[i].team_2_goals_quantity);
                    }
              };      
              Object.keys(obj1).forEach(function(el, data) {
                  arr1.push( [ el, obj1[el], goalsPerTeam[el]] );  // updating this                   
              });                          
           }; 
        getMatches();          
        var result = arr1.map(
              // finally adding here
              ([team_id, matches, goals]) => ({team_id, matches, goals}) //resulting in { {team_id: "119", matches: 3}, {team_id: "120", matches: 1} ... }
        );
        return result;                 
      }

Answer 2

If you prefer to maintain the code as is, consider incorporating an additional object for tracking goals in the following manner:

 function countGames() {
      var data = this.$store.getters.games;      
      var arr1 = []; 
      var goalsPerTeam = []; // keeping track of goals here
      var obj1 = {}; 

      //Fetching all unique Team IDs
      function getMatches() { 
              for (var i in data) {        
                    obj1[data[i].team_1_id] = (obj1[data[i].team_1_id] || 0) + 1;
                    obj1[data[i].team_2_id] = (obj1[data[i].team_2_id] || 0) + 1;
                    // adding goals count
                    if (goalsPerTeam[data[i].team_1_id] === undefined) {
                      goalsPerTeam[data[i].team_1_id] = parseInt(data[i].team_1_goals_quantity);
                    } else {
                      goalsPerTeam[data[i].team_1_id] += parseInt(data[i].team_1_goals_quantity);
                    }

                    if (goalsPerTeam[data[i].team_2_id] === undefined) {
                      goalsPerTeam[data[i].team_2_id] = parseInt(data[i].team_2_goals_quantity);
                    } else {
                      goalsPerTeam[data[i].team_2_id] += parseInt(data[i].team_2_goals_quantity);
                    }
              };      
              Object.keys(obj1).forEach(function(el, data) {
                  arr1.push( [ el, obj1[el], goalsPerTeam[el]] );  // updating this                   
              });                          
           }; 
        getMatches();          
        var result = arr1.map(
              // finally adding here
              ([team_id, matches, goals]) => ({team_id, matches, goals}) //resulting in { {team_id: "119", matches: 3}, {team_id: "120", matches: 1} ... }
        );
        return result;                 
      }

Answer 3

Answer №2

To extract the necessary data, you can iterate through each object in the array and update the corresponding counters in this manner:

    let totalGames = {},
        totalGoals = {};

    data.map( game => {

        //count games for team 1
        if (!totalGames.hasOwnProperty(game.team_1_id)) {
            totalGames[game.team_1_id] = 1;
        } else {
            totalGames[game.team_1_id] += 1;
        }
        
        //count games for team 2
        if (!totalGames.hasOwnProperty(game.team_2_id)) {
            totalGames[game.team_2_id] = 1;
        } else {
            totalGames[game.team_2_id] += 1;
        }

        //calculate goals for team 1
        if (!totalGoals.hasOwnProperty(game.team_1_id)) {
            totalGoals[game.team_1_id] = parseInt(game.team_1_goals_quantity);
        } else {
            totalGoals[game.team_1_id] += parseInt(game.team_1_goals_quantity);
        }

        //calculate goals for team 2
        if (!totalGoals.hasOwnProperty(game.team_2_id)) {
            totalGoals[game.team_2_id] = parseInt(game.team_2_goals_quantity);
        } else {
            totalGoals[game.team_2_id] += parseInt(game.team_2_goals_quantity);
        }
    });

Answer 4

To extract the necessary data, you can iterate through each object in the array and update the corresponding counters in this manner:

    let totalGames = {},
        totalGoals = {};

    data.map( game => {

        //count games for team 1
        if (!totalGames.hasOwnProperty(game.team_1_id)) {
            totalGames[game.team_1_id] = 1;
        } else {
            totalGames[game.team_1_id] += 1;
        }
        
        //count games for team 2
        if (!totalGames.hasOwnProperty(game.team_2_id)) {
            totalGames[game.team_2_id] = 1;
        } else {
            totalGames[game.team_2_id] += 1;
        }

        //calculate goals for team 1
        if (!totalGoals.hasOwnProperty(game.team_1_id)) {
            totalGoals[game.team_1_id] = parseInt(game.team_1_goals_quantity);
        } else {
            totalGoals[game.team_1_id] += parseInt(game.team_1_goals_quantity);
        }

        //calculate goals for team 2
        if (!totalGoals.hasOwnProperty(game.team_2_id)) {
            totalGoals[game.team_2_id] = parseInt(game.team_2_goals_quantity);
        } else {
            totalGoals[game.team_2_id] += parseInt(game.team_2_goals_quantity);
        }
    });

Answer 5

Answer №3

When it comes to tracking goals scored, my approach involves constructing a dictionary containing pairs of teams and their respective goal counts. This information is then transformed into an array featuring team-goal number combinations:

function trackTeamGoals(jsonObject){

   // generate a summarized JSON
   let summary = []
   for(let index in jsonObject){
      let team1 = {'team': jsonObject[index]['team_1_id'], 'goals': jsonObject[index]['team_1_goals_quantity']};
      let team2 = {'team': jsonObject[index]['team_2_id'], 'goals': jsonObject[index]['team_2_goals_quantity']};
      summary.push(team1)
      summary.push(team2);
   }

   // calculate the total goals per team using reduce and return
   let sumData = summary.reduce(function(accumulator, currentValue) {
      accumulator[currentValue.team] = accumulator[currentValue.team] || {'team_id': currentValue.team, 'goals': 0};
      accumulator[currentValue.team]['goals'] = accumulator[currentValue.team]['goals'] + parseInt(currentValue.goals);
      return accumulator;
   }, {})

   // return as an array
   return Object.keys(sumData).map(key => sumData[key])
}

Answer 6

When it comes to tracking goals scored, my approach involves constructing a dictionary containing pairs of teams and their respective goal counts. This information is then transformed into an array featuring team-goal number combinations:

function trackTeamGoals(jsonObject){

   // generate a summarized JSON
   let summary = []
   for(let index in jsonObject){
      let team1 = {'team': jsonObject[index]['team_1_id'], 'goals': jsonObject[index]['team_1_goals_quantity']};
      let team2 = {'team': jsonObject[index]['team_2_id'], 'goals': jsonObject[index]['team_2_goals_quantity']};
      summary.push(team1)
      summary.push(team2);
   }

   // calculate the total goals per team using reduce and return
   let sumData = summary.reduce(function(accumulator, currentValue) {
      accumulator[currentValue.team] = accumulator[currentValue.team] || {'team_id': currentValue.team, 'goals': 0};
      accumulator[currentValue.team]['goals'] = accumulator[currentValue.team]['goals'] + parseInt(currentValue.goals);
      return accumulator;
   }, {})

   // return as an array
   return Object.keys(sumData).map(key => sumData[key])
}

Answer 7

Answer №4

Here's a simple way to achieve the desired outcome:

const fetchStatsByTeamId = (id) => {
  const games = list
    .filter((game) => game.team_1_id === id || game.team_2_id === id)

  const goalsScored = games
    .map((game) => game.team_1_id === id
      ? game.team_1_goals_quantity
      : game.team_2_goals_quantity)
    .reduce((total, goals) => total + parseInt(goals), 0)

  return {
    games: games.length,
    goals: goalsScored
  }
}

Then use it like so:

// Use string argument for team ID.
fetchStatsByTeamId('119') #returns { games: 3, goals: 4 }
fetchStatsByTeamId('120') #returns { games: 1, goals: 1 }
fetchStatsByTeamId('121') #returns { games: 1, goals: 1 }
fetchStatsByTeamId('122') #returns { games: 1, goals: 1 }

To summarize: Filter matches involving the specified team, calculate their goals, and provide the total stats.

Answer 8

Here's a simple way to achieve the desired outcome:

const fetchStatsByTeamId = (id) => {
  const games = list
    .filter((game) => game.team_1_id === id || game.team_2_id === id)

  const goalsScored = games
    .map((game) => game.team_1_id === id
      ? game.team_1_goals_quantity
      : game.team_2_goals_quantity)
    .reduce((total, goals) => total + parseInt(goals), 0)

  return {
    games: games.length,
    goals: goalsScored
  }
}

Then use it like so:

// Use string argument for team ID.
fetchStatsByTeamId('119') #returns { games: 3, goals: 4 }
fetchStatsByTeamId('120') #returns { games: 1, goals: 1 }
fetchStatsByTeamId('121') #returns { games: 1, goals: 1 }
fetchStatsByTeamId('122') #returns { games: 1, goals: 1 }

To summarize: Filter matches involving the specified team, calculate their goals, and provide the total stats.

Total number of goals scored by a single team (extracted from JSON data)

Answer №1

Answer №2

Answer №3

Answer №4

Similar questions

Having trouble with NVM not working correctly in Ubuntu 21.04 Terminal?

Assign external data to component prior to rendering

How to extract data from a JSON file in Java without relying on org.json library

Encountered an Error with My Protractor Script - Object Expected

Python script to retrieve matching values on the same level of a JSON structure

Having trouble with submitting data in an ExpressJS POST request while using mongoose?

Implementing this type of route in Vue Router - What are the steps I should take?

Convert XML to JSON with Azure

Unable to trigger Vuejs click event when using v-if condition

Extracting Parameters using JQuery's load Method

Guide on accessing the text content within a div element in HTML by triggering a button click

Problem with IE off-canvas scrolling

The sidebar stays fixed in place and doesn't adapt to varying screen resolutions

What is the method for defining the current date variable within a .json object?

Partially accessible Angular service within a callback function

Is there a way to configure my dropdown menu so that only one dropdown can be open at a time and it remains open when clicking on a <li> item?

What is the best way to trigger a JavaScript onclick event for a button that is located within a dropdown menu on an HTML page

What is causing the issue preventing me from running npm run dev on CentOS 7?

Sending data from a parent component to a child component through a function

Understand the nature of the reply