Finding how many times a team lost from an array

1 次查看（过去 30 天）
Max
Max 2015-10-11
回答： Image Analyst 2015-10-11
Im given
1 5 2004 16 8 13 3
1 5 2004 21 12 8 6
1 5 2005 22 25 3 8
1 5 2005 23 22 2 1
1 5 2005 22 19 3 6
2 5 2005 20 29 2 6
2 5 2005 20 5 1 3
2 5 2005 20 28 2 3
2 5 2005 27 18 2 6
2 5 2005 2 25 8 9
2 5 2006 8 26 9 10
2 5 2006 24 1 0 5
column 4 represents the home team, and column 5 represents the away team. Column 6 represents the home team goals and column 7 represents the away teams goals. How do i write a piece of code that shows how many teams lost at most 3 times playing in the year 2005. From the table you can see team 22 and team 20 lost at most 3 times in 2005 so I would like my answer to be 2.
So column 4 represents the home team and column 5 represents the away team column 6 represents the home team goals and column 7 represents the away team goals. Ignoring the first 2 columns row 1 would mean that in 2004 team 16 beat team 8 with a score of 13-3. I would like to find out for the year 2005 what teams lost at most 3 times.
  2 个评论
Star Strider
Star Strider 2015-10-11
Please clarify the column interpretations. Your description leaves much to the imagination.
Max
Max 2015-10-11
So column 4 represents the home team and column 5 represents the away team column 6 represents the home team goals and column 7 represents the away team goals. Ignoring the first 2 columns row 1 would mean that in 2004 team 16 beat team 8 with a score of 13-3. I would like to find out for the year 2005 what teams lost at most 3 times.

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Image Analyst
Image Analyst 2015-10-11
Try this:
m = [...
1 5 2004 16 8 13 3
1 5 2004 21 12 8 6
1 5 2005 22 25 3 8
1 5 2005 23 22 2 1
1 5 2005 22 19 3 6
2 5 2005 20 29 2 6
2 5 2005 20 5 1 3
2 5 2005 20 28 2 3
2 5 2005 27 18 2 6
2 5 2005 2 25 8 9
2 5 2006 8 26 9 10
2 5 2006 24 1 0 5]
year2005Rows = m(:, 3) == 2005
homeTeams = m(year2005Rows, 4)
homeTeamGoals = m(year2005Rows, 6)
awayTeamGoals = m(year2005Rows, 7)
homeTeamWins = homeTeamGoals > awayTeamGoals
winsByTeam = grpstats(homeTeamWins, homeTeams, 'max')
teamsInOrder = unique(homeTeams)
for t = 1 : length(winsByTeam)
fprintf('Team %d won %d times at home in 2005.\n', ...
teamsInOrder(t), winsByTeam(t));
end
In the command window:
Team 2 won 0 times at home in 2005.
Team 20 won 0 times at home in 2005.
Team 22 won 0 times at home in 2005.
Team 23 won 1 times at home in 2005.
Team 27 won 0 times at home in 2005.
It requires grpstats from the Statistics and Machine Learning toolbox.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by