We, Group 1 have chosen to load in 2012-2018_playerBoxScore data from kaggle: https://www.kaggle.com/pablote/nba-enhanced-stats
Data Load
nba = read.csv("C://Users//still//OneDrive//Documents//School//6136 Data Mining//playerbox.csv")
Lets get data types and structures.
str(nba)
## 'data.frame': 155713 obs. of 51 variables:
## $ gmDate : Factor w/ 979 levels "1/1/2013","1/1/2014",..: 211 211 211 211 211 211 211 211 211 211 ...
## $ gmTime : Factor w/ 39 levels "1:00","10:00",..: 17 17 17 17 17 17 17 17 17 17 ...
## $ seasTyp : Factor w/ 1 level "Regular": 1 1 1 1 1 1 1 1 1 1 ...
## $ playLNm : Factor w/ 702 levels "Žižić","Abrines",..: 535 26 496 53 85 149 675 655 594 45 ...
## $ playFNm : Factor w/ 592 levels "A.J.","Aaron",..: 1 559 191 55 559 304 396 264 90 179 ...
## $ teamAbbr : Factor w/ 30 levels "ATL","BKN","BOS",..: 30 30 30 30 30 30 30 30 30 30 ...
## $ teamConf : Factor w/ 2 levels "East","West": 1 1 1 1 1 1 1 1 1 1 ...
## $ teamDiv : Factor w/ 6 levels "Atlantic","Central",..: 5 5 5 5 5 5 5 5 5 5 ...
## $ teamLoc : Factor w/ 2 levels "Away","Home": 1 1 1 1 1 1 1 1 1 1 ...
## $ teamRslt : Factor w/ 2 levels "Loss","Win": 1 1 1 1 1 1 1 1 1 1 ...
## $ teamDayOff: int 0 0 0 0 0 0 0 0 0 0 ...
## $ offLNm1 : Factor w/ 68 levels "Adams","Anderson",..: 7 7 7 7 7 7 7 7 7 7 ...
## $ offFNm1 : Factor w/ 61 levels "Aaron","Ben",..: 56 56 56 56 56 56 56 56 56 56 ...
## $ offLNm2 : Factor w/ 69 levels "Adams","Anderson",..: 55 55 55 55 55 55 55 55 55 55 ...
## $ offFNm2 : Factor w/ 61 levels "Aaron","Ben",..: 43 43 43 43 43 43 43 43 43 43 ...
## $ offLNm3 : Factor w/ 77 levels "","Acosta","Adair",..: 74 74 74 74 74 74 74 74 74 74 ...
## $ offFNm3 : Factor w/ 70 levels "","Aaron","Ben",..: 26 26 26 26 26 26 26 26 26 26 ...
## $ playDispNm: Factor w/ 936 levels "A.J. Hammons",..: 2 877 284 86 878 472 627 395 149 271 ...
## $ playStat : Factor w/ 2 levels "Bench","Starter": 2 2 2 2 2 1 1 1 1 1 ...
## $ playMin : int 29 25 25 22 17 29 23 21 17 16 ...
## $ playPos : Factor w/ 7 levels "C","F","G","PF",..: 5 7 1 7 4 7 7 6 6 4 ...
## $ playHeight: int 74 80 82 77 79 76 81 83 80 84 ...
## $ playWeight: int 195 200 255 202 240 195 210 235 225 250 ...
## $ playBDate : Factor w/ 880 levels "1/1/1985","1/1/1986",..: 134 636 854 630 179 94 257 466 174 741 ...
## $ playPTS : int 7 9 10 8 4 11 9 7 4 8 ...
## $ playAST : int 6 4 0 3 1 5 1 1 2 0 ...
## $ playTO : int 1 0 1 2 4 1 0 1 1 0 ...
## $ playSTL : int 0 3 0 1 1 1 2 0 2 1 ...
## $ playBLK : int 0 2 4 0 1 1 0 1 0 1 ...
## $ playPF : int 1 0 1 1 4 1 1 3 2 2 ...
## $ playFGA : int 13 8 10 8 9 13 6 4 7 6 ...
## $ playFGM : int 2 3 4 2 2 4 4 3 2 4 ...
## $ playFG. : num 0.154 0.375 0.4 0.25 0.222 ...
## $ play2PA : int 4 4 10 4 8 7 3 4 6 6 ...
## $ play2PM : int 0 1 4 0 2 4 3 3 2 4 ...
## $ play2P. : num 0 0.25 0.4 0 0.25 ...
## $ play3PA : int 9 4 0 4 1 6 3 0 1 0 ...
## $ play3PM : int 2 2 0 2 0 0 1 0 0 0 ...
## $ play3P. : num 0.222 0.5 0 0.5 0 ...
## $ playFTA : int 1 2 4 2 0 4 0 4 0 1 ...
## $ playFTM : int 1 1 2 2 0 3 0 1 0 0 ...
## $ playFT. : num 1 0.5 0.5 1 0 0.75 0 0.25 0 0 ...
## $ playORB : int 1 1 5 0 1 1 0 3 2 4 ...
## $ playDRB : int 1 2 2 3 0 2 3 1 2 4 ...
## $ playTRB : int 2 3 7 3 1 3 3 4 4 8 ...
## $ opptAbbr : Factor w/ 30 levels "ATL","BKN","BOS",..: 6 6 6 6 6 6 6 6 6 6 ...
## $ opptConf : Factor w/ 2 levels "East","West": 1 1 1 1 1 1 1 1 1 1 ...
## $ opptDiv : Factor w/ 6 levels "Atlantic","Central",..: 2 2 2 2 2 2 2 2 2 2 ...
## $ opptLoc : Factor w/ 2 levels "Away","Home": 2 2 2 2 2 2 2 2 2 2 ...
## $ opptRslt : Factor w/ 2 levels "Loss","Win": 2 2 2 2 2 2 2 2 2 2 ...
## $ opptDayOff: int 0 0 0 0 0 0 0 0 0 0 ...
summary(nba)
## gmDate gmTime seasTyp playLNm
## 11/25/2016: 327 20:00 :23384 Regular:155713 Johnson : 2585
## 11/22/2017: 308 19:00 :20387 Williams: 2220
## 4/17/2013 : 308 19:30 :17495 Green : 2219
## 2/15/2017 : 304 8:00 :12198 Smith : 1759
## 10/28/2015: 302 7:00 : 9918 Thompson: 1487
## 4/12/2017 : 300 22:30 : 9857 Harris : 1292
## (Other) :153864 (Other):62474 (Other) :144151
## playFNm teamAbbr teamConf teamDiv teamLoc
## Anthony: 2111 SA : 5748 East:77392 Atlantic :26053 Away:77789
## Kyle : 2006 GS : 5536 West:78321 Central :25600 Home:77924
## James : 1820 DAL : 5429 Northwest:25904
## Kevin : 1688 BKN : 5363 Pacific :26057
## Brandon: 1500 OKC : 5319 Southeast:25739
## Patrick: 1462 NY : 5276 Southwest:26360
## (Other):145126 (Other):123042
## teamRslt teamDayOff offLNm1 offFNm1
## Loss:77725 Min. : 0.000 Richardson: 5938 Scott : 10008
## Win :77988 1st Qu.: 1.000 Kirkland : 5729 Sean : 6706
## Median : 2.000 Foster : 5436 David : 6638
## Mean : 1.941 Zielinski : 5352 Tony : 5824
## 3rd Qu.: 2.000 Goble : 5028 Leroy : 5769
## Max. :11.000 Crawford : 4735 Courtney: 5729
## (Other) :123495 (Other) :115039
## offLNm2 offFNm2 offLNm3 offFNm3
## Guthrie : 4329 Mark : 7163 Taylor : 6125 James : 9107
## Richardson: 4310 Derrick: 6696 Capers : 5526 Kevin : 8372
## Collins : 4277 Sean : 6534 Blair : 5079 Scott : 6644
## Crawford : 4251 Tony : 6098 Maddox : 4764 Eric : 6295
## Smith : 4193 Eric : 6010 Scott : 4508 Mark : 5662
## Lewis : 4120 Scott : 5932 Lane : 4380 Derrick: 5371
## (Other) :130233 (Other):117280 (Other):125331 (Other):114262
## playDispNm playStat playMin playPos
## P.J. Tucker : 483 Bench :81923 Min. : 0.00 C :25060
## DeAndre Jordan: 481 Starter:73790 1st Qu.:15.00 F : 191
## Corey Brewer : 479 Median :24.00 G : 118
## Klay Thompson : 471 Mean :22.92 PF:33466
## Evan Turner : 470 3rd Qu.:31.00 PG:33091
## Damian Lillard: 469 Max. :60.00 SF:29993
## (Other) :152860 SG:33794
## playHeight playWeight playBDate playPTS
## Min. :69.00 Min. :149 6/26/1984: 1152 Min. : 0.000
## 1st Qu.:77.00 1st Qu.:200 9/2/1989 : 911 1st Qu.: 4.000
## Median :79.00 Median :220 3/25/1986: 869 Median : 8.000
## Mean :79.01 Mean :218 4/1/1988 : 835 Mean : 9.695
## 3rd Qu.:82.00 3rd Qu.:237 6/1/1985 : 833 3rd Qu.:14.000
## Max. :89.00 Max. :355 5/30/1992: 819 Max. :70.000
## (Other) :150294
## playAST playTO playSTL playBLK
## Min. : 0.000 Min. : 0.000 Min. : 0.0000 Min. : 0.0000
## 1st Qu.: 0.000 1st Qu.: 0.000 1st Qu.: 0.0000 1st Qu.: 0.0000
## Median : 1.000 Median : 1.000 Median : 0.0000 Median : 0.0000
## Mean : 2.122 Mean : 1.305 Mean : 0.7347 Mean : 0.4609
## 3rd Qu.: 3.000 3rd Qu.: 2.000 3rd Qu.: 1.0000 3rd Qu.: 1.0000
## Max. :25.000 Max. :12.000 Max. :10.0000 Max. :12.0000
##
## playPF playFGA playFGM playFG.
## Min. :0.000 Min. : 0.000 Min. : 0.000 Min. :0.0000
## 1st Qu.:1.000 1st Qu.: 4.000 1st Qu.: 1.000 1st Qu.:0.2800
## Median :2.000 Median : 7.000 Median : 3.000 Median :0.4286
## Mean :1.908 Mean : 7.971 Mean : 3.621 Mean :0.4196
## 3rd Qu.:3.000 3rd Qu.:11.000 3rd Qu.: 5.000 3rd Qu.:0.5714
## Max. :6.000 Max. :50.000 Max. :24.000 Max. :1.0000
##
## play2PA play2PM play2P. play3PA
## Min. : 0.000 Min. : 0.000 Min. :0.0000 Min. : 0.000
## 1st Qu.: 2.000 1st Qu.: 1.000 1st Qu.:0.2500 1st Qu.: 0.000
## Median : 5.000 Median : 2.000 Median :0.5000 Median : 2.000
## Mean : 5.696 Mean : 2.809 Mean :0.4383 Mean : 2.274
## 3rd Qu.: 8.000 3rd Qu.: 4.000 3rd Qu.:0.6250 3rd Qu.: 4.000
## Max. :34.000 Max. :22.000 Max. :1.0000 Max. :22.000
##
## play3PM play3P. playFTA playFTM
## Min. : 0.0000 Min. :0.0000 Min. : 0.00 Min. : 0.00
## 1st Qu.: 0.0000 1st Qu.:0.0000 1st Qu.: 0.00 1st Qu.: 0.00
## Median : 0.0000 Median :0.0000 Median : 2.00 Median : 1.00
## Mean : 0.8122 Mean :0.2116 Mean : 2.16 Mean : 1.64
## 3rd Qu.: 1.0000 3rd Qu.:0.4000 3rd Qu.: 4.00 3rd Qu.: 2.00
## Max. :13.0000 Max. :1.0000 Max. :39.00 Max. :25.00
##
## playFT. playORB playDRB playTRB
## Min. :0.0000 Min. : 0.0000 Min. : 0.000 Min. : 0.000
## 1st Qu.:0.0000 1st Qu.: 0.0000 1st Qu.: 1.000 1st Qu.: 1.000
## Median :0.5000 Median : 1.0000 Median : 2.000 Median : 3.000
## Mean :0.4273 Mean : 0.9993 Mean : 3.092 Mean : 4.091
## 3rd Qu.:0.9091 3rd Qu.: 1.0000 3rd Qu.: 4.000 3rd Qu.: 6.000
## Max. :1.0000 Max. :18.0000 Max. :23.000 Max. :30.000
##
## opptAbbr opptConf opptDiv opptLoc opptRslt
## PHI : 5246 East:77644 Atlantic :25892 Away:77924 Loss:77988
## MIN : 5237 West:78069 Central :25856 Home:77789 Win :77725
## UTA : 5237 Northwest:26003
## DET : 5236 Pacific :26125
## ORL : 5235 Southeast:25896
## PHO : 5235 Southwest:25941
## (Other):124287
## opptDayOff
## Min. : 0.000
## 1st Qu.: 1.000
## Median : 2.000
## Mean : 1.939
## 3rd Qu.: 2.000
## Max. :11.000
##