Recent Question/Assignment
The International Ultra Indoor Cricket Federation (IUICF) has contracted you to assist in their analysis and reporting of results. You have been provided three data files:
• matchResults. json containing details of each match (the teams that played, the players in the teams, and the runs, wickets and catches for each player).
• teamMembers. json containing the list of player IDs associated to each team.
• playerNames. csv containing the name of each player associated to each player ID.
The IUICF want you to use these three files to provide the needed four pieces of analysis below. The IUICF also want to use your code for analysis of future data files.
1. Write the code to compute the total runs scored by each team for each match. Run your code on the data and present the results in a table showing the match number, the home and away team names and their runs.
2. The winner of each match is the team who scored the most runs. Each team scores 3 points for a win and 1 point for a draw and the team with the most points at the end of the season is the season winner. Write the code to compute each team’s points after the first 14 matches and the 28 matches. Provide the results in a table (two tables, one table for each set of results), ordering teams by their points (i.e. a results ladder).
3. An investigation into home game advantage in planned for the coming months. Write a function that takes the file “matchResults.json” as its only argument, and returns a count of the number of home games each team has had and the total number of games each team has played in. Provide these results in a data frame. Run the function on the provided “matchResults.json” and show the resulting table output.
4. Provide a table containing the set of player names of players that played for Parramatta, and their average number of Wickets per game. This table is to be used to provide a bowling award. Order the table from highest to lowest average Wickets and split ties using the number of matches (e.g. if two players have an average of 2, but one has played more matches, then the player who has played more matches should ordered in front of the other).
Write a PDF report containing your code and all required analysis and results. The report is being marked using the marking criteria, so make sure that each piece of analysis covers all of the criteria.
• matchResults. json containing details of each match (the teams that played, the players in the teams, and the runs, wickets and catches for each player).
• teamMembers. json containing the list of player IDs associated to each team.
• playerNames. csv containing the name of each player associated to each player ID.
The IUICF want you to use these three files to provide the needed four pieces of analysis below. The IUICF also want to use your code for analysis of future data files.
1. Write the code to compute the total runs scored by each team for each match. Run your code on the data and present the results in a table showing the match number, the home and away team names and their runs.
2. The winner of each match is the team who scored the most runs. Each team scores 3 points for a win and 1 point for a draw and the team with the most points at the end of the season is the season winner. Write the code to compute each team’s points after the first 14 matches and the 28 matches. Provide the results in a table (two tables, one table for each set of results), ordering teams by their points (i.e. a results ladder).
3. An investigation into home game advantage in planned for the coming months. Write a function that takes the file “matchResults.json” as its only argument, and returns a count of the number of home games each team has had and the total number of games each team has played in. Provide these results in a data frame. Run the function on the provided “matchResults.json” and show the resulting table output.
4. Provide a table containing the set of player names of players that played for Parramatta, and their average number of Wickets per game. This table is to be used to provide a bowling award. Order the table from highest to lowest average Wickets and split ties using the number of matches (e.g. if two players have an average of 2, but one has played more matches, then the player who has played more matches should ordered in front of the other).
Write a PDF report containing your code and all required analysis and results. The report is being marked using the marking criteria, so make sure that each piece of analysis covers all of the criteria.
Looking for answers ?
Recent Questions
Assessment 2: (20%) Case Study Presentation Due Date weeks 10This assessment builds on your theoretical knowledge and tests your ability to apply this knowledge to practice.you are required to formulate...Assessment 2Assessment 2Report: 30%Word count: 1400 – 1600 wordsDue date: Sunday of Week 8DescriptionYou are playing the role of a community service worker supporting a young adult son who is 18 years...1500-1800 wordsInstructions From TutorPlease download the eTask3 spreadsheet from Canvas and save the eTask spread as an Excel file. The main content of the force method is taught in Lectures 6,7&8.eTask3.1 is a...ASSIGNMENT INSTRUCTIONSAssessment Practical assessmentAssessment code: 011Academic Year: 2023/2024Trimester: 2Module Title: Critical Perspectives on Cross-Border BusinessModule Code: MOD009194Level: 6Module...Information Systems Analysis & DesignAssignmentDue date: Week 5 Friday (5 Apr 2024) 11:59 pm AESTWeighting: 30%Length: 1,200 to 1,500 words (penalty will apply if the length is outside this limit)Assessment...Problem:University of Technology Sydney 48353: CONCRETE DESIGN Autumn 2024 - Assignment 2 (13 Marks)The figure illustrates the cross-section of a reinforced concrete column with a hexagonal shape (equal...Show All Questions