Aggregate in data frame in R

Asked Sep 14 '16 at 08:33

Active Sep 14 '16 at 08:39

Viewed 38 times

I have a data.frame as follows :

Team_1 Team_2 Winning_Team
  A      B         A
  C      A         C
  .      .         .
  .      .         .

I want count of matches won and matches played by each team. Output should be in named list format so that I am able to access the counts by name of the team.

Expected Output :

Team     Matches_Won   Matches_Played
 A            1            2
 B            0            1

Any help is highly appreciated.

edited Sep 14 '16 at 08:39

asked Sep 14 '16 at 08:33

pseudo_teetotaler

1,485
1
15
35

1

It is not clear what you wanted based on the `.` showed. – akrun Sep 14 '16 at 08:34
`.` just shows continuation of data.frame. Nothing else . – pseudo_teetotaler Sep 14 '16 at 08:36
1

I understand that part. It would be better if you show the expected output based on the example – akrun Sep 14 '16 at 08:37
Agreed. I have edited the post – pseudo_teetotaler Sep 14 '16 at 08:39
Try `library(data.table); melt(setDT(df1), id.var = "Winning_Team")[, .(Matches_Won = sum(Winning_Team==value), Matches_Played = .N), .(Team = value)]` – akrun Sep 14 '16 at 08:43
3

If you're variables are in factors with all the team names as levels, then you can just do `table(unlist(df[, 1:2]))` to know the matchs played and `table(unlist(df[, 3]))` to know the matchs won – Cath Sep 14 '16 at 08:50

Aggregate in data frame in R

0 Answers0