Count the number of occurences.

Equivalent to as.data.frame(table(x)), but does not include combinations with zero counts.

count(df, vars = NULL, wt_var = NULL)

Arguments

df	data frame to be processed
vars	variables to count unique values of
wt_var	optional variable to weight by - if this is non-NULL, count will sum up the value of this variable for each combination of id variables.

Value

a data frame with label and freq columns

Details

Speed-wise count is competitive with table for single variables, but it really comes into its own when summarising multiple dimensions because it only counts combinations that actually occur in the data.

Compared to table + as.data.frame, count also preserves the type of the identifier variables, instead of converting them to characters/factors.

See also

table for related functionality in the base package

Examples

# Count of each value of "id" in the first 100 cases
count(baseball[1:100,], vars = "id")
#>           id freq
#> 1  ansonca01    8
#> 2  bennech01    1
#> 3  burdoja01    7
#> 4  forceda01    9
#> 5  galvipu01    1
#> 6  gerhajo01    5
#> 7  hinespa01    6
#> 8  jonesch01    6
#> 9  mathebo01    7
#> 10 morrijo01    2
#> 11 nelsoca01    5
#> 12 orourji01    6
#> 13 shaffor01    4
#> 14 snydepo01    5
#> 15 startjo01    7
#> 16 suttoez01    7
#> 17 whitede01    7
#> 18  yorkto01    7
# Count of ids, weighted by their "g" loading
count(baseball[1:100,], vars = "id", wt_var = "g")
#>           id freq
#> 1  ansonca01  432
#> 2  bennech01   49
#> 3  burdoja01  414
#> 4  forceda01  380
#> 5  galvipu01   13
#> 6  gerhajo01  209
#> 7  hinespa01  302
#> 8  jonesch01  134
#> 9  mathebo01  327
#> 10 morrijo01  127
#> 11 nelsoca01  193
#> 12 orourji01  356
#> 13 shaffor01   90
#> 14 snydepo01  250
#> 15 startjo01  389
#> 16 suttoez01  344
#> 17 whitede01  386
#> 18  yorkto01  396
count(baseball, "id", "ab")
#>             id  freq
#> 1    aaronha01 12364
#> 2    abernte02   181
#> 3    adairje01  4019
#> 4    adamsba01  1019
#> 5    adamsbo03  4019
#> 6    adcocjo01  6606
#> 7    agostju01    20
#> 8    aguilri01   139
#> 9    aguirha01   388
#> 10   ainsmed01  3048
#> 11   alexado01   265
#> 12   alexape01  1810
#> 13   allendi01  6332
#> 14   allenet01  4418
#> 15   allenjo02   716
#> 16   almonbi01  3330
#> 17   alomaro01  9073
#> 18   alomasa01  4760
#> 19   alomasa02  4530
#> 20    aloufe01  7339
#> 21    alouje01  4345
#> 22    alouma01  5789
#> 23    aloumo01  6988
#> 24   altroni01   550
#> 25   alvarwi01    95
#> 26    amesre01  1014
#> 27   anderbr01  6499
#> 28   anderjo01  6341
#> 29   anderla02    38
#> 30   ansonca01 10277
#> 31   aparilu01 10230
#> 32   appieke01    83
#> 33   applepe01   374
#> 34   applilu01  8856
#> 35   ashburi01  8365
#> 36   ashbyal01  4123
#> 37   ashbyan01   521
#> 38   assenpa01    36
#> 39   astacpe01   676
#> 40   ausmubr01  5905
#> 41   austiji01  5388
#> 42   azcuejo01  2828
#> 43   baergca01  5439
#> 44   bagweje01  7797
#> 45   bahnsst01   479
#> 46   bailebo01  6082
#> 47   baileed01  3581
#> 48   baineha01  9908
#> 49    bairdo01    52
#> 50   bakerdu01  7117
#> 51   bakerfl01  2280
#> 52   bancrda01  7182
#> 53   bandosa01  7060
#> 54   bankser01  9421
#> 55   bannifl01    80
#> 56   barbest01   563
#> 57   barrysh01  4014
#> 58   bartedi01  7629
#> 59    basske01  4839
#> 60   baylodo01  8198
#> 61   becklja01  9526
#> 62   bedrost01   153
#> 63   belanma01  5784
#> 64   belchti01   388
#> 65    bellbu01  8995
#> 66    bellda01  4826
#> 67    bellgu01  6478
#> 68   bellira01  2301
#> 69    bellja01  7398
#> 70   benchjo01  7658
#> 71   bendech01  1147
#> 72   benesan01   741
#> 73   beniqju01  4651
#> 74   benitar01     8
#> 75   bennech01  3821
#> 76   bentola01   738
#> 77   bentoru01   825
#> 78   berenju01    24
#> 79   bergmda01  2679
#> 80    bergmo01  1813
#> 81   berrayo01  7555
#> 82   bevacku01  2117
#> 83   bicheda01  6381
#> 84   bielemi01   282
#> 85   biggicr01 10876
#> 86   biittla01  3151
#> 87   blackbu02   179
#> 88   blairpa01  6042
#> 89   blasido01  5296
#> 90   bluegos01  6440
#> 91    bluevi01   512
#> 92   blylebe01   451
#> 93   boddimi01     0
#> 94   boggswa01  9180
#> 95   bondsba01  9847
#> 96   bondsbo01  7043
#> 97   bonilbo01  7213
#> 98   boonebo01  7245
#> 99   boonebr01  6683
#> 100  boonera01  4589
#> 101  bordepa01  3282
#> 102  bordimi01  5770
#> 103  bosleth01  1581
#> 104  bottoji01  7471
#> 105  boudrlo01  6029
#> 106   bowala01  8418
#> 107  bowerfr01  3401
#> 108  boyercl02  5780
#> 109  boyerke01  7455
#> 110  braunst01  3650
#> 111  bresnro01  4481
#> 112  bressru01  3881
#> 113  brettge01 10349
#> 114  brettke01   347
#> 115  breweji01   140
#> 116  bridgto01  1003
#> 117  brilene01   469
#> 118  brinked01  6045
#> 119  brocklo01 10332
#> 120  brookhu01  5974
#> 121  broutda01  6711
#> 122  browncl01   457
#> 123  brownge01  4300
#> 124  brownha01   484
#> 125  brownke01   495
#> 126  brownmo01  1143
#> 127  brownol02  3642
#> 128  brownpe01  4820
#> 129  brownto01  7363
#> 130  brunato01  6289
#> 131  brunege01   418
#> 132  bucknbi01  9397
#> 133   buhlbo01   857
#> 134  buhneja01  5013
#> 135  bunniji01  1275
#> 136  burbada01   194
#> 137  burdele01  1011
#> 138  burdoja01  4915
#> 139  burgesm01  4471
#> 140  burgmto01    66
#> 141  burkeje01  8421
#> 142  burkejo03   540
#> 143  burksel01  7232
#> 144  burnije01  5710
#> 145  burnsge01  7241
#> 146  burnsge02  6573
#> 147  burrira01   502
#> 148  burroje01  5536
#> 149  busbyji01  4250
#> 150   bushdo01  7210
#> 151   bushgu01   888
#> 152   bushjo01  1239
#> 153  butlebr01  8180
#> 154  byrneto01   601
#> 155  cabelen01  5952
#> 156  caldwmi01   216
#> 157  callijo01  6652
#> 158  caminke01  6288
#> 159  campabe01  8684
#> 160  campbbi02    26
#> 161  candejo01   596
#> 162  candito01   299
#> 163  cansejo01  7057
#> 164  carbobe01  2733
#> 165  cardejo02  6964
#> 166  cardele01  6707
#> 167  cardwdo01   698
#> 168  carewro01  9315
#> 169  careyma01  9363
#> 170  carlsha01   712
#> 171  carltst01  1719
#> 172  carrocl02   208
#> 173  cartega01  7971
#> 174  cartejo01  8422
#> 175  cartyri01  5606
#> 176   cashno01  6705
#> 177  castivi02  6822
#> 178  cavarph01  6754
#> 179  cedence01  7310
#> 180  cepedor01  7927
#> 181  ceronri01  4069
#> 182   cervbo01  2261
#> 183    ceyro01  7162
#> 184  chambch01  7571
#> 185  chancfr01  4297
#> 186  chapmbe01  6478
#> 187  charlno01    87
#> 188  chaseha01  7417
#> 189  cicoted01  1062
#> 190  cirilje01  5396
#> 191  clancji01    61
#> 192  clarkfr01  8568
#> 193  clarkja01  6847
#> 194  clarkwi02  7173
#> 195  claytro01  7379
#> 196  clemeja01  4283
#> 197  clemero01  9454
#> 198  clemero02   179
#> 199  clinety01  1834
#> 200   cobbty01 11434
#> 201  coffmdi01   400
#> 202  colavro01  6503
#> 203  colbrgr01  2769
#> 204  colemjo05   462
#> 205  colesda01  2891
#> 206  collida02  4907
#> 207  collied01  9949
#> 208  colliji01  6795
#> 209  collish01  6390
#> 210  conceda01  8723
#> 211   coneda01   412
#> 212  coninje01  6957
#> 213  connoro01  7794
#> 214   cookde01   110
#> 215  coonejo01  3372
#> 216  coopece01  7349
#> 217  coopewa01  4702
#> 218  coopewi01  1227
#> 219  corcoto01  8804
#> 220  cordewi01  4311
#> 221  cormirh01   192
#> 222  covinwe01  2978
#> 223  cramedo01  9140
#> 224  crandde01  5026
#> 225  crawfsa01  9570
#> 226  crawfwi01  3435
#> 227  crigelo01  3202
#> 228  cronijo01  7579
#> 229  crosefr01  6277
#> 230  crossla01  9072
#> 231  crossmo01  5821
#> 232  crowlte01  1518
#> 233   cruzjo01  7917
#> 234  cuccito01  6184
#> 235  cuellmi01   661
#> 236  curtijo01   359
#> 237  cuyleki01  7161
#> 238  dahlebi01  9031
#> 239  dahlgba01  4045
#> 240   dalyto01  5684
#> 241   darkal01  7219
#> 242  darliro01   526
#> 243  darwida01   305
#> 244  daubeja01  7673
#> 245  daultda01  3630
#> 246  daussho01  1124
#> 247  davalvi01  4017
#> 248  davisch01  8673
#> 249  daviscu01   813
#> 250  daviser01  5321
#> 251  davisge01  9031
#> 252  davisha01  6653
#> 253  davisma01   167
#> 254  davissp01  4255
#> 255  davisst02    16
#> 256  davisto02  7223
#> 257  daviswi02  9174
#> 258  dawsoan01  9927
#> 259  decindo01  5809
#> 260  dejesiv01  4602
#> 261  delahed01  7505
#> 262  delahji01  4091
#> 263  deleojo01   419
#> 264  delgaca01  6591
#> 265  dempsri01  4692
#> 266  dennyje01  4946
#> 267  derripa01  1260
#> 268  dickebi01  6300
#> 269  dicksmu01  1095
#> 270  dietrbi01   627
#> 271  dilonmi01  2000
#> 272   doakbi01   905
#> 273  donovbi01  1302
#> 274  donovdi01   694
#> 275  donovpa01  7496
#> 276  dooinre01  4004
#> 277  doolami01  5977
#> 278  downial01   717
#> 279  downibr01  7853
#> 280  doyleja01  6039
#> 281  doylela01  6509
#> 282  drabomo01   420
#> 283  driesda01  5479
#> 284  dropowa01  4124
#> 285  duceyro01  1279
#> 286  duffyhu01  7042
#> 287  duganjo01  5410
#> 288  duncama01  4677
#> 289  dunstsh01  5927
#> 290  durocle01  5350
#> 291  dwyerji01  2761
#> 292  dykesji01  8046
#> 293  easleda01  5168
#> 294  easlemi01  3677
#> 295  eckerde01   181
#> 296  edmonji01  6272
#> 297  ehmkeho01  1009
#> 298  eisenji01  3995
#> 299  elberki01  4561
#> 300  elliobo01  7141
#> 301  ellisdo01   489
#> 302  ellswdi01   673
#> 303    elybo01  5159
#> 304  embreal01     3
#> 305  ennisde01  7254
#> 306  ericksc01    35
#> 307  etchean01  2618
#> 308  evansda01  8973
#> 309  evansdw01  8996
#> 310  evereca01  4809
#> 311  eversho01  3801
#> 312  eversjo01  6137
#> 313  ewingbu01  5363
#> 314  faberre01  1269
#> 315   facero01   194
#> 316  fairlro01  7184
#> 317  farredu01  5679
#> 318  farretu01   436
#> 319  fasseje01   276
#> 320  fellebo01  1282
#> 321  fergujo01  3001
#> 322  fernasi01   539
#> 323  fernato01  7911
#> 324  ferreri01  6028
#> 325  ferrewe01  1176
#> 326  fettemi01     0
#> 327  fieldce01  5157
#> 328  fingero01   180
#> 329  finlech01    53
#> 330  finlest01  9397
#> 331  finnelo01  4631
#> 332  fisheed02   246
#> 333   fiskca01  8756
#> 334  fitzsfr01  1155
#> 335  flagsir01  4139
#> 336  flahejo01  3372
#> 337  flanami01     0
#> 338  fletcda01  3902
#> 339  fletcsc01  5258
#> 340  floodcu01  6357
#> 341  floydcl01  5057
#> 342  foileha01  1455
#> 343  foleyto02  2708
#> 344   foliti01  6047
#> 345  forceda01  4251
#> 346   fordho01  4833
#> 347   fordwh01  1023
#> 348  foremfr01   754
#> 349  fornimi01   308
#> 350  forscbo01   893
#> 351  forscke01   383
#> 352  forstte01    78
#> 353  fostege01  7023
#> 354  fournja01  5208
#> 355    foxne01  9232
#> 356   foxxji01  8134
#> 357  francjo01    34
#> 358  francju01  8677
#> 359  francti01  5121
#> 360  frasech01  1316
#> 361  freehbi01  6073
#> 362  freesge02  3446
#> 363  fregoji01  6523
#> 364  frencla01  1057
#> 365   freylo01  5517
#> 366  fribebe01  4169
#> 367  frienbo01  1137
#> 368  friscfr01  9112
#> 369  frymawo01   609
#> 370  furilca01  6378
#> 371  gaettga01  8951
#> 372  gagnegr01  5673
#> 373  galanau01  5937
#> 374  galaran01  8096
#> 375  galehde01   665
#> 376  galvipu01  2748
#> 377  gamblos01  4502
#> 378  gantnji01  6189
#> 379   gantro01  6449
#> 380  ganzech01  2984
#> 381  garbege01   115
#> 382  gardnla01  6688
#> 383  garneph01  6136
#> 384  garvene01   827
#> 385  garvest01  8835
#> 386  gehrich01  8860
#> 387  gehrilo01  8001
#> 388  gerbewa01  5099
#> 389  gerhajo01  4139
#> 390  geronce01  3780
#> 391  gibbojo01   263
#> 392  gibsobo01  1328
#> 393  gibsoki01  5798
#> 394  ginsbjo01  1716
#> 395  girarjo01  4127
#> 396  giustda01   412
#> 397  glassja01  7030
#> 398  glavito02  1304
#> 399  gleaski01  7452
#> 400  gomezch02  4421
#> 401  gonzaal01  4977
#> 402  gonzaju03  6556
#> 403  gonzalu01  8816
#> 404  gonzami01  2829
#> 405  gonzato01  5195
#> 406  goodedw01   741
#> 407  goodmbi01  5644
#> 408  goodwto01  3846
#> 409  gordoto01     2
#> 410   gorege01  5357
#> 411  gosligo01  8656
#> 412  gossari01    85
#> 413   gottji01    73
#> 414  gowdyha01  2735
#> 415  gracema01  8065
#> 416  graffto01  2787
#> 417  grantmu01   759
#> 418  greenle01  2956
#> 419  greensh01  7082
#> 420  grichbo01  6890
#> 421  griffal01  6780
#> 422  griffcl01  1380
#> 423  griffke01  7229
#> 424  griffke02  8826
#> 425  griffto02   405
#> 426  grimebu01  1535
#> 427  grimmch01  7917
#> 428  grimsja01    43
#> 429  grissma02  8275
#> 430  groatdi01  7484
#> 431   grohhe01  6074
#> 432  gromest01   630
#> 433  groombu01     0
#> 434  grossgr01  3745
#> 435  grosske01   660
#> 436  groteje01  4339
#> 437  grothjo01  3808
#> 438  grovele01  1369
#> 439  grubbjo01  4154
#> 440  guarded01     1
#> 441  guerrpe01  5392
#> 442  guilloz01  6686
#> 443  gullibi01   576
#> 444  gumbeha01   708
#> 445   gurala01    33
#> 446  guthrma01    14
#> 447  gwynnto01  9288
#> 448   hackst01  7278
#> 449  haddiha01   798
#> 450  hadlebu01  1004
#> 451  haineje01  1124
#> 452  hairsje01  1699
#> 453   halldi01   714
#> 454  hallmbi01  6012
#> 455  hamilda02  4577
#> 456  hamilea01   733
#> 457  hammoje01  3032
#> 458  hamnegr01  5839
#> 459  hanseda01  1793
#> 460  hansero02  4311
#> 461  hardeme01  1203
#> 462  harnipe01   513
#> 463  harpebr01  3151
#> 464  harpeto01  6269
#> 465  harrato01  7402
#> 466  harrebu01  4744
#> 467  harrigr01    68
#> 468  harrile01  3924
#> 469  hartnga01  6432
#> 470  hassero01  3440
#> 471  hasslan01    29
#> 472  hatchbi01  4339
#> 473  hattogr01  4206
#> 474  hayesch01  5262
#> 475  hayesfr01  4493
#> 476  haywora01  2062
#> 477  heathcl01  4443
#> 478  heathje01  4937
#> 479  heathmi02  4212
#> 480  hebneri01  6144
#> 481  heganji01  4772
#> 482  heganmi01  2080
#> 483  heilmha01  7787
#> 484   heldwo01  4019
#> 485  helliri01   104
#> 486  helmsto01  4997
#> 487  hemslro01  5047
#> 488  hendeda01  5130
#> 489  hendeke01  4553
#> 490  henderi01 10961
#> 491  hendrge01  7129
#> 492  henrybi01   203
#> 493  herbera01   569
#> 494  hermabi01  7707
#> 495  hernajo01  4618
#> 496  hernake01  7370
#> 497  hernaro01     2
#> 498   herrto01  5349
#> 499  hershor01   810
#> 500  herzobu01  5284
#> 501  hickmch01  3982
#> 502  higbeki01   660
#> 503  higgipi01  6636
#> 504  hillejo01   101
#> 505   hillgl01  3715
#> 506   hillke01   333
#> 507   hillma01  1809
#> 508  hinespa01  7062
#> 509  hitchst01   210
#> 510   hoagmy01  3147
#> 511  hodgegi01  7030
#> 512  hoeftbi01   531
#> 513  hoernjo01    59
#> 514  hoffmtr01    33
#> 515  hofmaso01  4072
#> 516  hollato01  3191
#> 517  holmeda01    28
#> 518  holtzke01   607
#> 519  honeyri01   182
#> 520  hoopeha01  8785
#> 521  hootobu01   748
#> 522   hoppjo01  4260
#> 523  hornsro01  8173
#> 524  hortowi01  7298
#> 525  houghch01   226
#> 526  howarel01  5363
#> 527  howarfr01  6488
#> 528  howelja01     9
#> 529   hoytwa01  1287
#> 530  hubbeca01  1288
#> 531  hudliwi01   894
#> 532  hugheto01   958
#> 533  hunteca01   658
#> 534  hurstbr01   274
#> 535  incavpe01  4233
#> 536  jacksda02   428
#> 537  jacksda03  2629
#> 538  jacksgr01   236
#> 539  jacksla01  1089
#> 540  jacksmi02    28
#> 541  jacksre01  9864
#> 542  jackstr01  6086
#> 543  jacobba01  5507
#> 544  jamiech01  6560
#> 545  jarvike01   188
#> 546  javiest01  5047
#> 547  jeffegr01  5520
#> 548  jenkife01   896
#> 549  jennihu01  4904
#> 550  johnscl01  3945
#> 551  johnsde01  5941
#> 552  johnsja01  4703
#> 553  johnske02   534
#> 554  johnsla03  5379
#> 555  johnsra05   549
#> 556  johnssi01   709
#> 557  johnssy01   702
#> 558  johnswa01  2324
#> 559   johnto01   900
#> 560  jonesch01  3738
#> 561  jonesda01  3774
#> 562  jonesdo01     7
#> 563  jonesfi01  6747
#> 564  jonessa01  1243
#> 565  jonesto02    19
#> 566  joneswi01  5826
#> 567  joosted01  5606
#> 568  jordabr01  5160
#> 569  jorgemi01  3421
#> 570  joynewa01  7127
#> 571  judgejo01  7898
#> 572  jurgebi01  6253
#> 573  justida01  5625
#> 574   kaatji01  1251
#> 575  kalinal01 10116
#> 576  keefeti01  2083
#> 577  keelewi01  8591
#> 578  kellejo01  7006
#> 579   kellge01  6702
#> 580  kellyge01  5993
#> 581  kellyki01  5894
#> 582  kellypa01  4338
#> 583  kellyro01  4797
#> 584  kennebo01  4624
#> 585  kenneve01   743
#> 586   kentje01  8058
#> 587   kernji01     9
#> 588  kessido01  7651
#> 589    keyji01     2
#> 590  killeha01  8147
#> 591  kingmda01  6677
#> 592  kirkped01  3467
#> 593  kisonbr01   404
#> 594  kittrma01  4027
#> 595  kleinch01  6486
#> 596  kleskry01  5611
#> 597  klinero01   491
#> 598  klippjo01   502
#> 599  kluszte01  5929
#> 600  kneppbo01   840
#> 601  knowlda01   125
#> 602  koneted01  7649
#> 603  koosmje01   915
#> 604  kraneed01  5436
#> 605  kressre01  5087
#> 606  kreutch01  2505
#> 607  kruegbi01    15
#> 608  kuennha01  6913
#> 609  kuheljo01  7984
#> 610  kuzavbo01   256
#> 611  labincl01   227
#> 612   lacyle01  4549
#> 613  lajoina01  9589
#> 614   lampde01   201
#> 615  landrho01  1929
#> 616  langsma01    92
#> 617  laniema01   535
#> 618  lankfra01  5747
#> 619  lansfca01  7158
#> 620  lapoida01   251
#> 621  larkiba01  7937
#> 622  larocda01    61
#> 623  larsedo01   596
#> 624   laryfr01   734
#> 625   laryly01  4603
#> 626  lathaar01  6822
#> 627    lauch01  1170
#> 628  lawtoma02  4763
#> 629    lawve01   883
#> 630  lazzeto01  6297
#> 631  leachto01  7959
#> 632  learyti01   163
#> 633    leebi02   980
#> 634    leeth01   835
#> 635  leibone01  4167
#> 636  leiteal01   530
#> 637  lemonbo01  1183
#> 638  lemonch01  6868
#> 639  leonadu02  1054
#> 640  leonaje01  5045
#> 641  lewisda01  4081
#> 642  leyriji01  2527
#> 643  lindbpa01   133
#> 644  loaizes01   265
#> 645  lockmwh01  5940
#> 646  loftoke01  8120
#> 647  lolicmi01   821
#> 648  lollash01  5351
#> 649  lombaer01  5855
#> 650  lonboji01   770
#> 651   longhe01  7674
#> 652  lopesda01  6354
#> 653  lopezal01  5916
#> 654  lopezja01  5319
#> 655   lowebo01  7064
#> 656  lowenjo01  3476
#> 657  lowrepe01  4317
#> 658  lucasre01  1439
#> 659    lummi01  3554
#> 660  luquedo01  1043
#> 661  luzingr01  6505
#> 662   lylesp01    78
#> 663   lynnfr01  6925
#> 664  lyonste01  1563
#> 665  mabryjo01  3409
#> 666  macfada01   910
#> 667  maddoga01  6331
#> 668  maddugr01  1536
#> 669  maddumi01    92
#> 670  madlobi01  6594
#> 671  magadda01  4159
#> 672  mageesh01  7441
#> 673  majesha01  3421
#> 674  maldoca01  4106
#> 675  mancugu01  4505
#> 676   mannle01  4716
#> 677  mantlmi01  8102
#> 678  manushe01  7654
#> 679  maranra01 10078
#> 680  marbefi01   668
#> 681  maricju01  1221
#> 682  marquru01  1107
#> 683  marshmi01   179
#> 684  martibu01  2743
#> 685  martida01  5795
#> 686  martide01   520
#> 687  martied01  7213
#> 688  martipe02   381
#> 689  martiti01     0
#> 690  martiti02  7111
#> 691   masiph01  3468
#> 692  mastewa02   486
#> 693  mathebo01  2487
#> 694  mathech01  1684
#> 695  matheed01  8537
#> 696  matthga01  7147
#> 697   maulal01  1376
#> 698  maxvida01  3443
#> 699  maxwech01  3245
#> 700  maybejo01  5447
#> 701   mayele01  4048
#> 702    mayle01  7609
#> 703    maymi01  3693
#> 704  maynebr01  3614
#> 705    mayru01   341
#> 706   maysca01  1085
#> 707   mayswi01 10881
#> 708  mazerbi01  7755
#> 709  mazzile01  4124
#> 710  mcauldi01  6185
#> 711  mcbrige01  5526
#> 712  mccarti01  5529
#> 713  mcclubo01     9
#> 714  mccormi03   738
#> 715  mccovwi01  8197
#> 716  mcculcl01  3121
#> 717  mcdanli01   378
#> 718  mcdowsa01   774
#> 719  mcelrch01    42
#> 720  mcfared01  3007
#> 721  mcgeewi01  7649
#> 722  mcgrajo01  3924
#> 723  mcgratu01   214
#> 724  mcgrifr01  8757
#> 725  mcguide01  6290
#> 726  mcgwima01  6187
#> 727  mcinnst01  7822
#> 728  mclemma01  6192
#> 729  mclisca01   490
#> 730  mcmahdo02   168
#> 731  mcmanma01  6660
#> 732  mcmilro01  6752
#> 733  mcmulke01  5131
#> 734  mcnaier01  4519
#> 735  mcphebi01  8291
#> 736  mcraeha01  7218
#> 737  mcwilla01   446
#> 738  meadole01  1117
#> 739  medwijo01  7635
#> 740  merceor01  3998
#> 741  merckke01   248
#> 742  merklfr01  5782
#> 743   mesajo01     2
#> 744  micelda01    22
#> 745  michaca01  4367
#> 746  miksied01  3053
#> 747  milancl01  7359
#> 748  millebi02  6212
#> 749  millebo04   299
#> 750  milleri01  3887
#> 751  millest01   369
#> 752  minchdo01  4026
#> 753  minosmi01  6579
#> 754  mintogr01   103
#> 755  mitchcl01  1287
#> 756  mitchke01  4134
#> 757   mizejo01  6443
#> 758  mogrige01   754
#> 759  molitpa01 10835
#> 760  mondari01  6136
#> 761  mondera01  5814
#> 762  moneydo01  6215
#> 763  montawi01  5843
#> 764  moorech02  4033
#> 765  mooreea01   949
#> 766  moorege03  3543
#> 767  moralje01  4528
#> 768  morgajo02  9277
#> 769  morgami01   497
#> 770  morrija02     1
#> 771  morriji01  3375
#> 772  morrijo01  4912
#> 773  moseswa01  7356
#> 774   mossle01  2234
#> 775   motama01  3779
#> 776  moyerja01   268
#> 777  muellra01  2911
#> 778  mulhote01   619
#> 779  mullato01  2720
#> 780  mullige01  1531
#> 781  mullira01  3569
#> 782  mumphje01  4993
#> 783  murcebo01  6730
#> 784  murphda02  5399
#> 785  murphda05  7960
#> 786  murphto02   289
#> 787  murrada01    65
#> 788  murraed02 11336
#> 789  musiast01 10972
#> 790  mussimi01    47
#> 791  myattgl01  2678
#> 792   myerbu01  7038
#> 793  myersgr01  3042
#> 794  myershy01  4910
#> 795  myersmi01     2
#> 796  myersra01    60
#> 797   nashbi01  5849
#> 798  neaglde01   531
#> 799   nehfar01   915
#> 800  nelsoca01  3294
#> 801  nelsoje01     2
#> 802  nettlgr01  8986
#> 803  nevinph01  4188
#> 804  newhoha01   999
#> 805  newsobo01  1337
#> 806  nichobi01  5546
#> 807  nichoki01  2086
#> 808  niekrjo01   973
#> 809  niekrph01  1537
#> 810  niemabo01  3452
#> 811  nixonot01  5115
#> 812  norenir01  3119
#> 813  normafr01   574
#> 814  northro01  3172
#> 815  nunezed01     0
#> 816  nuxhajo01   766
#> 817  oberkke01  4874
#> 818  obriech01  2232
#> 819  oconnja01  5380
#> 820   odombl01   405
#> 821  oeschjo01   599
#> 822  ofarrbo01  4101
#> 823  offerjo01  5681
#> 824  oglivbe01  5913
#> 825  ojedabo01   347
#> 826  olerujo01  7592
#> 827  olivaom01   242
#> 828  olivato01  6301
#> 829  oliveal01  9049
#> 830  oliveda02   217
#> 831  olivejo01  3367
#> 832  olsongr01     4
#> 833  olsoniv01  6111
#> 834  oneilpa01  7318
#> 835  oneilst01  4795
#> 836  oroscje01    59
#> 837  orourji01  8505
#> 838   ortajo01  5829
#> 839   orthal01  1698
#> 840  osteecl01  1099
#> 841  osterfr01   749
#> 842   otisam01  7299
#> 843    ottme01  9456
#> 844  pacioto01  4121
#> 845  pafkoan01  6292
#> 846  paganjo01  3689
#> 847  palmede01  4902
#> 848  palmeji01   489
#> 849  palmera01 10472
#> 850  pappami01  1073
#> 851  parenma01  1303
#> 852   parkch01   406
#> 853  parkeda01  9358
#> 854  parrila01  6792
#> 855  parrila02  7067
#> 856  pascuca02   967
#> 857  paskedo01  6017
#> 858  peckiro01  7233
#> 859  peitzhe01  4121
#> 860   penaal01   181
#> 861   penaor01   264
#> 862   penato01  6489
#> 863  pendlte01  7032
#> 864  pennohe01  1214
#> 865  perezne01  5127
#> 866  perezto01  9778
#> 867  perkicy01  3604
#> 868  perraro01   167
#> 869  perryga01  1076
#> 870  perryji01   889
#> 871  petryda01     5
#> 872  pfefffr01  6555
#> 873  pfeffje01   874
#> 874  phillda01  6296
#> 875  phillto02  7617
#> 876  piazzmi01  6911
#> 877  picinva01  2877
#> 878  piercbi02  1102
#> 879  piersji01  5890
#> 880  pinielo01  5867
#> 881  pinsova01  9645
#> 882   pippwa01  6914
#> 883  pizarju01   658
#> 884  planked01  1607
#> 885  plesada01    15
#> 886  plunker01     2
#> 887  podrejo01   762
#> 888  polleho01   698
#> 889  polonlu01  4840
#> 890  pooleji02     8
#> 891  portebo01   516
#> 892  porteda02  5539
#> 893  portuma01   450
#> 894   postwa01  4007
#> 895  pottene01   562
#> 896  powelbo01  6681
#> 897  powelja01  1610
#> 898  powerte01   157
#> 899  powervi01  6046
#> 900  prattto02  1612
#> 901  princto01  1190
#> 902   puhlte01  4855
#> 903  purcebl01  4563
#> 904  quantpa01    67
#> 905  quinnja01  1349
#> 906  quinnjo02  6879
#> 907  quirkja01  2266
#> 908  raffeke01   688
#> 909  raganpa01   544
#> 910  raineti01  8872
#> 911  ramirma02  7058
#> 912  ramospe01   703
#> 913  randowi01  8018
#> 914  rasmude01   259
#> 915  rawlijo01  3719
#> 916  readyra01  2110
#> 917  reardje01    57
#> 918   reedje02  3101
#> 919   reedri01   297
#> 920   reedro01   620
#> 921   reedst01    25
#> 922  reesepe01  8058
#> 923  reganph01   321
#> 924  remlimi01   110
#> 925  renkost01   531
#> 926  reuscri01  1115
#> 927  reussje01  1024
#> 928  reynocr01  4466
#> 929  rhodear01     4
#> 930  rhoderi01   761
#> 931   ricede01  3826
#> 932   riceji01  8225
#> 933   ricesa01  9269
#> 934  richaha01  5642
#> 935  richepe01   297
#> 936  righeda01    11
#> 937  ripkeca01 11551
#> 938  rivermi01  5629
#> 939  rixeyep01  1522
#> 940  roberda05   531
#> 941  roberro01  1525
#> 942  robinbi02  4364
#> 943  robinbr01 10654
#> 944  robindo01   631
#> 945  robined01  4282
#> 946  robinfr02 10006
#> 947  robinwi01  5075
#> 948  rodriau01  6611
#> 949  rodriiv01  8247
#> 950  rogerke01    65
#> 951  rojasco01  6309
#> 952   roofph01  2151
#> 953   rootch01  1086
#> 954   rosepe01 14053
#> 955  roushed01  7363
#> 956   rowesc01   909
#> 957  roystje01  4208
#> 958   rudijo01  5556
#> 959   ruelmu01  4514
#> 960  ruffire01  1937
#> 961  russebi01  7318
#> 962  russeja01   617
#> 963  russeje01    79
#> 964   ruthba01  8398
#> 965  ruthvdi01   671
#> 966   ryanji01  8164
#> 967   ryanno01   852
#> 968  saberbr01   190
#> 969  sadecra01   789
#> 970  sallesl01   924
#> 971  samueju01  6081
#> 972  sanchre01  4850
#> 973  sandbry01  8385
#> 974  sandere02  6241
#> 975  sandesc01   474
#> 976  santibe01  6951
#> 977  santoro01  8143
#> 978  sauerha01  4796
#> 979  schaege01  3784
#> 980  schalra01  5306
#> 981  schanwa01  5307
#> 982  schatda01   242
#> 983  schilcu01   773
#> 984  schmija01   591
#> 985  schmijo01   587
#> 986  schmimi01  8352
#> 987  schoere01  8479
#> 988  schofdi01  3083
#> 989  schofdi02  4299
#> 990  schreos01  3057
#> 991  schulfr01  6533
#> 992  scottev01  5837
#> 993  scottge02  7433
#> 994  seaneru01     5
#> 995  seaveto01  1315
#> 996  seguida01  4847
#> 997  seguidi01   384
#> 998   seleaa01    58
#> 999  seminan01  3921
#> 1000 servisc01    17
#> 1001 severha01  4312
#> 1002 sewellu01  5383
#> 1003 seymocy01  5682
#> 1004 shaffor01  3552
#> 1005 shantbo01   548
#> 1006  shawbo01   519
#> 1007 shawkbo01  1049
#> 1008 sheckji01  7605
#> 1009 sheffga01  8531
#> 1010 sherdbi01   960
#> 1011 shortch02   697
#> 1012 shouncl01   362
#> 1013 siebeso01   660
#> 1014 sierrru01  8044
#> 1015 sievero01  6387
#> 1016 simmoal01  8759
#> 1017 simmocu01  1135
#> 1018 simmote01  8680
#> 1019 singebi01   413
#> 1020 singlke01  7189
#> 1021 sislege01  8267
#> 1022 skowrbi01  5547
#> 1023 slatoji01    57
#> 1024 slaugdo01  4063
#> 1025 slaugen01  7946
#> 1026 smallro02  5657
#> 1027 smithbo02  1689
#> 1028 smithea02  2264
#> 1029 smithel01  4684
#> 1030 smithge01  6552
#> 1031 smithja03  4532
#> 1032 smithle02    64
#> 1033 smithlo01  5170
#> 1034 smithoz01  9396
#> 1035 smithpo01  4238
#> 1036 smithre06  7033
#> 1037 smithsh01   709
#> 1038 smithza01   551
#> 1039 smoltjo01   925
#> 1040 snidedu01  7161
#> 1041  snowjt01  5641
#> 1042 snydefr01  4229
#> 1043 snydepo01  3644
#> 1044  sojolu01  2571
#> 1045  sosasa01  8813
#> 1046 spahnwa01  1872
#> 1047 speaktr01 10195
#> 1048 speiech01  7156
#> 1049 spencji01  4908
#> 1050 spilmha01   810
#> 1051 splitpa01   121
#> 1052 sprinru01    27
#> 1053 staintu01  2261
#> 1054 stairma01  4600
#> 1055 stalege01   525
#> 1056 stanlfr01  1650
#> 1057 stanlmi01  5022
#> 1058 stanlmi02  4222
#> 1059 stantmi02    24
#> 1060 stargwi01  7927
#> 1061 startjo01  4747
#> 1062 staubru01  9720
#> 1063 stengca01  4288
#> 1064 stephve01  6497
#> 1065 stewada01    51
#> 1066 stiebda01     2
#> 1067 stinnke01  2033
#> 1068 stobbch01   578
#> 1069 stottto01   242
#> 1070 stoveha01  6138
#> 1071 strawda01  5418
#> 1072 strunam01  4999
#> 1073 sturdto01   328
#> 1074 sullibi03  3647
#> 1075 sundbji01  6021
#> 1076 suppaje01   312
#> 1077 surhobj01  8258
#> 1078 sutclri01   562
#> 1079 suttodo01  1354
#> 1080 suttoez01  5359
#> 1081 sweenma01  1738
#> 1082 swiftbo01  2750
#> 1083 swindgr01   245
#> 1084 tananfr01    59
#> 1085 tanneje01  1410
#> 1086 tapanke01   261
#> 1087 tartada01  5011
#> 1088 tavarju01   139
#> 1089 tayloto02  7680
#> 1090 tayloza02  2865
#> 1091 tebbebi01  3704
#> 1092 tekulke01   121
#> 1093 templga01  7721
#> 1094 tenacge01  4390
#> 1095 tennefr02  7595
#> 1096 terryad01  2389
#> 1097 terryra01   593
#> 1098 theveto01  4164
#> 1099 thomade01  4677
#> 1100 thomafr03  6285
#> 1101 thomafr04  7953
#> 1102 thomage01  1688
#> 1103 thomago01  4677
#> 1104 thomato02   722
#> 1105 thomeji01  6841
#> 1106 thompmi02  3761
#> 1107 thompsa01  5984
#> 1108 thomsbo01  6305
#> 1109  thondi01  4449
#> 1110 thornan01  5291
#> 1111 tiantlu01   513
#> 1112 tidrodi01    95
#> 1113 timlimi01     7
#> 1114 tinkejo01  6434
#> 1115 torgeea01  4969
#> 1116 torrejo01  7874
#> 1117 torremi01   412
#> 1118 trachst01   651
#> 1119 trammal01  8288
#> 1120 traynpi01  7559
#> 1121 trevial01  2430
#> 1122 trillma01  5950
#> 1123 troutdi01   961
#> 1124 truckvi01   949
#> 1125 tucketo01  6479
#> 1126 turnete01  5921
#> 1127  uhlege01  1360
#> 1128 unserde01  5215
#> 1129 valdeis01   399
#> 1130 valenfe01   936
#> 1131 valenjo03  5539
#> 1132  valoel01  5029
#> 1133 vanceda01   971
#> 1134 vandejo02  2751
#> 1135 vanhage01  8021
#> 1136 vaughgr01  6103
#> 1137 veachbo01  6656
#> 1138 velarra01  4244
#> 1139 venturo01  7064
#> 1140 vernomi01  8731
#> 1141 villoro01   169
#> 1142 violafr01   185
#> 1143 vizcajo01  5379
#> 1144 vizquom01  9479
#> 1145 wagneha01  1849
#> 1146 wagneho01 10430
#> 1147 wakefti01    98
#> 1148 walberu01   905
#> 1149 walkedi02  6740
#> 1150 walkege02  6771
#> 1151 walkela01  6907
#> 1152 walketo04  4554
#> 1153 wallabo01  8618
#> 1154 wallati01  8099
#> 1155 wallide01  2945
#> 1156 waltebu01  1966
#> 1157 wanerll01  7772
#> 1158 wanerpa01  9459
#> 1159  wardjo01  7647
#> 1160 warnejo01  3494
#> 1161 warnelo01   962
#> 1162 washicl01  6787
#> 1163 watsobo01  6185
#> 1164 weathda01   139
#> 1165 webstmi01  3419
#> 1166 wehmehe01   633
#> 1167 welchbo01   582
#> 1168 wellsda01   178
#> 1169 wertzvi01  6099
#> 1170  westsa01  6148
#> 1171 weyhigu01  1849
#> 1172 wheatza01  9106
#> 1173 whitalo01  8570
#> 1174 whitede01  6624
#> 1175 whitede03  7344
#> 1176 whiteea01  1291
#> 1177 whitefr01  7859
#> 1178 whitema01  3104
#> 1179 whiteri01    43
#> 1180 whitero01  6650
#> 1181 whitero02  5357
#> 1182 whitsed01   576
#> 1183 whitter01  3774
#> 1184 wickmbo01     2
#> 1185 wightbi01   480
#> 1186 wilcomi01    62
#> 1187 wilheho01   432
#> 1188 wilkiri01  2114
#> 1189 willibe02  7869
#> 1190 willibi01  9350
#> 1191 willicy01  6780
#> 1192 willidi02  2959
#> 1193 willige02  3059
#> 1194 willima04  7000
#> 1195 willist02   502
#> 1196 willite01  7706
#> 1197 williwo02   540
#> 1198 willsma01  7588
#> 1199 wilsoar01  2056
#> 1200 wilsoji01  4778
#> 1201 wilsowi02  7731
#> 1202 winfida01 11003
#> 1203 wingoiv01  4003
#> 1204  wiseri01   668
#> 1205 witasja01    42
#> 1206  wittbo01    64
#> 1207 wohlfji01  3049
#> 1208 womacto01  4963
#> 1209  woodge01  5371
#> 1210 woodlge01  5587
#> 1211  woodwi01   322
#> 1212 worreti01    81
#> 1213 worthal01   255
#> 1214 wyattwh01   607
#> 1215  wynnea01  1704
#> 1216  wynnji01  6653
#> 1217 yastrca01 11988
#> 1218 yeagest01  3584
#> 1219  yorkto01  4002
#> 1220  yosted01  7346
#> 1221 youngcy01  2960
#> 1222 younger01  6119
#> 1223 youngjo02  3659
#> 1224 yountro01 11008
#> 1225 zachato01  1122
#> 1226  zaungr01  2880
#> 1227 zeileto01  7573
#> 1228 zimmech01  4546
count(baseball, "lg")
#>   lg  freq
#> 1       65
#> 2 AA   171
#> 3 AL 10007
#> 4 FL    37
#> 5 NL 11378
#> 6 PL    32
#> 7 UA     9
# How many stints do players do?
count(baseball, "stint")
#>   stint  freq
#> 1     1 19808
#> 2     2  1775
#> 3     3   111
#> 4     4     5
# Count of times each player appeared in each of the years they played
count(baseball[1:100,], c("id", "year"))
#>           id year freq
#> 1  ansonca01 1871    1
#> 2  ansonca01 1872    1
#> 3  ansonca01 1873    1
#> 4  ansonca01 1874    1
#> 5  ansonca01 1875    1
#> 6  ansonca01 1876    1
#> 7  ansonca01 1877    1
#> 8  ansonca01 1878    1
#> 9  bennech01 1878    1
#> 10 burdoja01 1872    1
#> 11 burdoja01 1873    1
#> 12 burdoja01 1874    1
#> 13 burdoja01 1875    1
#> 14 burdoja01 1876    1
#> 15 burdoja01 1877    1
#> 16 burdoja01 1878    1
#> 17 forceda01 1871    1
#> 18 forceda01 1872    2
#> 19 forceda01 1873    1
#> 20 forceda01 1874    1
#> 21 forceda01 1875    1
#> 22 forceda01 1876    2
#> 23 forceda01 1877    1
#> 24 galvipu01 1875    1
#> 25 gerhajo01 1873    1
#> 26 gerhajo01 1874    1
#> 27 gerhajo01 1875    1
#> 28 gerhajo01 1876    1
#> 29 gerhajo01 1877    1
#> 30 hinespa01 1872    1
#> 31 hinespa01 1873    1
#> 32 hinespa01 1874    1
#> 33 hinespa01 1875    1
#> 34 hinespa01 1876    1
#> 35 hinespa01 1877    1
#> 36 jonesch01 1875    2
#> 37 jonesch01 1876    1
#> 38 jonesch01 1877    3
#> 39 mathebo01 1871    1
#> 40 mathebo01 1872    1
#> 41 mathebo01 1873    1
#> 42 mathebo01 1874    1
#> 43 mathebo01 1875    1
#> 44 mathebo01 1876    1
#> 45 mathebo01 1877    1
#> 46 morrijo01 1876    1
#> 47 morrijo01 1877    1
#> 48 nelsoca01 1872    2
#> 49 nelsoca01 1873    1
#> 50 nelsoca01 1874    1
#> 51 nelsoca01 1875    1
#> 52 orourji01 1872    1
#> 53 orourji01 1873    1
#> 54 orourji01 1874    1
#> 55 orourji01 1875    1
#> 56 orourji01 1876    1
#> 57 orourji01 1877    1
#> 58 shaffor01 1874    2
#> 59 shaffor01 1875    1
#> 60 shaffor01 1877    1
#> 61 snydepo01 1873    1
#> 62 snydepo01 1874    1
#> 63 snydepo01 1875    1
#> 64 snydepo01 1876    1
#> 65 snydepo01 1877    1
#> 66 startjo01 1871    1
#> 67 startjo01 1872    1
#> 68 startjo01 1873    1
#> 69 startjo01 1874    1
#> 70 startjo01 1875    1
#> 71 startjo01 1876    1
#> 72 startjo01 1877    1
#> 73 suttoez01 1871    1
#> 74 suttoez01 1872    1
#> 75 suttoez01 1873    1
#> 76 suttoez01 1874    1
#> 77 suttoez01 1875    1
#> 78 suttoez01 1876    1
#> 79 suttoez01 1877    1
#> 80 whitede01 1871    1
#> 81 whitede01 1872    1
#> 82 whitede01 1873    1
#> 83 whitede01 1874    1
#> 84 whitede01 1875    1
#> 85 whitede01 1876    1
#> 86 whitede01 1877    1
#> 87  yorkto01 1871    1
#> 88  yorkto01 1872    1
#> 89  yorkto01 1873    1
#> 90  yorkto01 1874    1
#> 91  yorkto01 1875    1
#> 92  yorkto01 1876    1
#> 93  yorkto01 1877    1
# Count of counts
count(count(baseball[1:100,], c("id", "year")), "id", "freq")
#>           id freq
#> 1  ansonca01    8
#> 2  bennech01    1
#> 3  burdoja01    7
#> 4  forceda01    9
#> 5  galvipu01    1
#> 6  gerhajo01    5
#> 7  hinespa01    6
#> 8  jonesch01    6
#> 9  mathebo01    7
#> 10 morrijo01    2
#> 11 nelsoca01    5
#> 12 orourji01    6
#> 13 shaffor01    4
#> 14 snydepo01    5
#> 15 startjo01    7
#> 16 suttoez01    7
#> 17 whitede01    7
#> 18  yorkto01    7
count(count(baseball, c("id", "year")), "freq")
#> Using freq as weighting variable
#>   freq freq.1
#> 1    1  18033
#> 2    2   3328
#> 3    3    318
#> 4    4     20