Determining season goals for teams using nested JSON data

Question

Determining season goals for teams using nested JSON data

Is it possible to retrieve a team's total goals scored for the season from the provided data by using the team's name as the input for a function?

Would it be accurate to attempt mapping over the rounds and filtering matches where either team1 or team2 is equal to the inputted team, then reducing the sum of those scores?

Here is a condensed sample of the data:

{
  "name": "English Premier League 2014/15",
  "rounds": [
    {
      "name": "Matchday 1",
      "matches": [
        {
          "date": "2014-08-16",
          "team1": {
            "key": "manutd",
            "name": "Manchester United",
            "code": "MUN"
          },
          "team2": {
            "key": "swansea",
            "name": "Swansea",
            "code": "SWA"
          },
          "score1": 1,
          "score2": 2
        },
        {
          "date": "2014-08-16",
          "team1": {
            "key": "leicester",
            "name": "Leicester City",
            "code": "LEI"
          },
          "team2": {
            "key": "everton",
            "name": "Everton",
            "code": "EVE"
          },
          "score1": 2,
          "score2": 2
        },

This is my current approach:

function calculateGoals (teamName){

    function sumScores (total, match) {
        return total + match.score1;
    }


    fetch('https://raw.githubusercontent.com/openfootball/football.json/master/2014-15/en.1.json')
    .then(response => response.json())
    .then(data => console.log(data.rounds.map( round => round.matches.filter(match => match.team1.name === teamName).reduce(sumScores))));

}

calculateGoals('Liverpool')

javascript json ecmascript-6

Answer 1

Answer №1

Give this a try

function calculateScoreByTeamName(strTeam){

  let leagueData = {
    "name": "English Premier League 2014/15",
    "rounds": [
      {
        "name": "Matchday 1",
        "matches": [
          {
            "date": "2014-08-16",
            "team1": {
              "key": "manutd",
              "name": "Manchester United",
              "code": "MUN"
            },
            "team2": {
              "key": "swansea",
              "name": "Swansea",
              "code": "SWA"
            },
            "score1": 1,
            "score2": 2
          },
          {
            "date": "2014-08-16",
            "team1": {
              "key": "leicester",
              "name": "Leicester City",
              "code": "LEI"
            },
            "team2": {
              "key": "everton",
              "name": "Everton",
              "code": "EVE"
            },
            "score1": 2,
            "score2": 2
          }
        ]
      }
    ]
  };

  let totalScore = 0;

  for(week of leagueData.rounds){
      for(game of week.matches){
          if(game.team1.name == strTeam){
              totalScore += game.score1;
          }else if(game.team2.name == strTeam){
              totalScore += game.score2;
          }
      }
  }

  console.log(totalScore);

}

//Test the function with this call
calculateScoreByTeamName("Swansea");

You can check the code by pasting it in an online JavaScript editor

Hope this information is useful!

Answer 2

Give this a try

function calculateScoreByTeamName(strTeam){

  let leagueData = {
    "name": "English Premier League 2014/15",
    "rounds": [
      {
        "name": "Matchday 1",
        "matches": [
          {
            "date": "2014-08-16",
            "team1": {
              "key": "manutd",
              "name": "Manchester United",
              "code": "MUN"
            },
            "team2": {
              "key": "swansea",
              "name": "Swansea",
              "code": "SWA"
            },
            "score1": 1,
            "score2": 2
          },
          {
            "date": "2014-08-16",
            "team1": {
              "key": "leicester",
              "name": "Leicester City",
              "code": "LEI"
            },
            "team2": {
              "key": "everton",
              "name": "Everton",
              "code": "EVE"
            },
            "score1": 2,
            "score2": 2
          }
        ]
      }
    ]
  };

  let totalScore = 0;

  for(week of leagueData.rounds){
      for(game of week.matches){
          if(game.team1.name == strTeam){
              totalScore += game.score1;
          }else if(game.team2.name == strTeam){
              totalScore += game.score2;
          }
      }
  }

  console.log(totalScore);

}

//Test the function with this call
calculateScoreByTeamName("Swansea");

You can check the code by pasting it in an online JavaScript editor

Hope this information is useful!

Answer 3

Answer №2

In my implementation using a functional programming approach, I have included comments above each function expression declaration:

const JSON_URL = 'https://raw.githubusercontent.com/openfootball/football.json/master/2014-15/en.1.json'

const downloadData = () =>
  fetch(JSON_URL).then(response => response.json())

const calculateSum = (total, value) => total + value

// Calculate the score for a specific team in a match
const resultPerMatch = teamName => match => {
  if (match.team1.name === teamName) return match.score1
  if (match.team2.name === teamName) return match.score2
  
  // If the chosen team did not play this game, it gets 0 points
  return 0
}

// Sum up the scores of a team for each match in a round
const resultsPerRound = teamName => round =>
  round.matches.map(resultPerMatch(teamName)).reduce(calculateSum, 0)

// Sum up the total scores of a team for all rounds
const resultsPerTeam = (data, teamName) => {
  return data.rounds.map(resultsPerRound(teamName)).reduce(calculateSum, 0)
}

// Wait for the data to be downloaded before calculating results
downloadData().then(data => {
  console.log(resultsPerTeam(data, 'Manchester United'))  // 62
  console.log(resultsPerTeam(data, 'Liverpool'))          // 52
})

Answer 4

In my implementation using a functional programming approach, I have included comments above each function expression declaration:

const JSON_URL = 'https://raw.githubusercontent.com/openfootball/football.json/master/2014-15/en.1.json'

const downloadData = () =>
  fetch(JSON_URL).then(response => response.json())

const calculateSum = (total, value) => total + value

// Calculate the score for a specific team in a match
const resultPerMatch = teamName => match => {
  if (match.team1.name === teamName) return match.score1
  if (match.team2.name === teamName) return match.score2
  
  // If the chosen team did not play this game, it gets 0 points
  return 0
}

// Sum up the scores of a team for each match in a round
const resultsPerRound = teamName => round =>
  round.matches.map(resultPerMatch(teamName)).reduce(calculateSum, 0)

// Sum up the total scores of a team for all rounds
const resultsPerTeam = (data, teamName) => {
  return data.rounds.map(resultsPerRound(teamName)).reduce(calculateSum, 0)
}

// Wait for the data to be downloaded before calculating results
downloadData().then(data => {
  console.log(resultsPerTeam(data, 'Manchester United'))  // 62
  console.log(resultsPerTeam(data, 'Liverpool'))          // 52
})

Answer 5

Answer №3

Appreciate the assistance with combining different approaches to fetch and process data using for loops in my solution. Your help has been invaluable!

async function calculateTeamScore(teamName) {
    const response = await fetch('https://raw.githubusercontent.com/openfootball/football.json/master/2016-17/en.1.json');
    const jsonData = await response.json();

    let totalScore = 0;

    for(const round of jsonData.rounds){
        for(const match of round.matches){
            if(match.team1.name === teamName){ 
                totalScore += match.score1;
            } else if(match.team2.name === teamName) {
                totalScore += match.score2;
            }
        }
    }

    console.log('The total goals scored by ' + teamName + ' this season is: ' + totalScore);
}

calculateTeamScore('Liverpool');

Answer 6

Appreciate the assistance with combining different approaches to fetch and process data using for loops in my solution. Your help has been invaluable!

async function calculateTeamScore(teamName) {
    const response = await fetch('https://raw.githubusercontent.com/openfootball/football.json/master/2016-17/en.1.json');
    const jsonData = await response.json();

    let totalScore = 0;

    for(const round of jsonData.rounds){
        for(const match of round.matches){
            if(match.team1.name === teamName){ 
                totalScore += match.score1;
            } else if(match.team2.name === teamName) {
                totalScore += match.score2;
            }
        }
    }

    console.log('The total goals scored by ' + teamName + ' this season is: ' + totalScore);
}

calculateTeamScore('Liverpool');

Determining season goals for teams using nested JSON data

Answer №1

Answer №2

Answer №3

Similar questions

Rails 4 does not properly handle the execution of Ajax responses

Is it possible for me to transform this code into a useful helper function?

Unable to get the Express.js Router functioning correctly on my server, even in a basic scenario

Flashing tilemap during the update process

Transferring an array of Json objects to Firestore

Retrieving data from Google Places API in JSON format

What is the best way to divide a string that includes commas into separate parts?

Best method for retrieving JSON information from the internet using an API

Steps to display content post authentication using JWT

Discover the position of a div relative to another div using ng-drag-drop

Create a basic search functionality in an Express Node.js application

Is it possible to convert checkbox values from a form into a JSON format?

"Enhance your online shopping experience with a React.js popup modal for

Linq has identified a circular reference

The functionality of findDOMNode is no longer supported

Finding the total number of nodes within a JSON string is a straightforward process that involves analyzing the

Is it possible for .getElementByClassName to identify Ajax.GET elements?

JQuery table sorter is unable to effectively sort tables with date range strings

Guide on transferring a file to Node.js using FormData and receiving a confirmation response from Node

Problem with transferring data from Google Forms to Google Sheets using Google Apps Script