When downloading csv files from https://www.baseballhq.com/articles/...ownload-center, the last column is some kind of hex or hash. When I download historical stats from https://www.baseballhq.com/tools/stats/hitters this does not happen. The "hash" is causing issues when trying to process the csv file. Is this "hash column" expected?
HQID | MLBAMID | Player | Age | Bats | Pos | Team | LG | C | 1B | 2B | 3B | SS | OF | DH | PA | AB | R | H | 2B | 3B | HR | RBI | BB | K | SB | CS | AVG | OBP | SLG | OPS | BB % | Ct% | Eye | H% | PX | xPX | HctX | SPD | RSPD | GB % | LD % | FB % | xBA | RCG | RAR | BPV | 12$ | 15$ | GB | GBO | LD | LDO | FB | FBO | PAvRHP | PAvLHP | AVGvRHP | AVGvLHP | OBPvRHP | OBPvLHP | SLGvRHP | SLGvLHP | OPSvRHP | OPSvLHP | L31 C | L31 1B | L31 2B | L31 3B | L31 SS | L31 OF | L31 DH | L31 AB | L31 PA | L31 R | L31 H | L31 2B | L31 3B | L31 HR | L31 RBI | L31 BB | L31 K | L31 SB | L31 CS | L31 AVG | L31 OBP | L31 SLG | L31 OPS | L31 BB% | L31 CT% | L31 Eye | L31 H% | L31 PX | L31 xPX | L31 HctX | L31 Spd | L31 RSpd | L31 G% | L31 L% | L31 F% | L31 xBA | L31 RCG | L31 RAR | L31 BPV | L31 GB | L31 GBO | L31 LD | L31 LDO | L31 FB | L31 FBO | L31 PAvRH | L31 PAvLH | L31 AVGvRH | L31 AVGvLH | L31 OBPvRH | L31 OBPvLH | L31 SLGvRH | L31 SLGvLH | L31 OPSvRH | L31 OPSvLH | L7 C | L7 1B | L7 2B | L7 3B | L7 SS | L7 OF | L7 DH | L7 AB | L7 PA | L7 R | L7 H | L7 2B | L7 3B | L7 HR | L7 RBI | L7 BB | L7 K | L7 SB | L7 CS | L7 AVG | L7 OBP | L7 SLG | L7 OPS | L7 BB% | L7 Ct% | L7 Eye | L7 H% | L7 PX | L7 xPX | L7 HCtX | L7 Spd | L7 RSpd | L7 G% | L7 L% | L7 F% | L7 xBA | L7 RCG | L7 RAR | L7 BPV | L7 GB | L7 GBO | L7 LD | L7 LDO | L7 FB | L7 FBO | L7 PAvRH | L7 PAvLH | L7 AVGvRH | L7 AVGvLH | L7 OBPvRH | L7 OBPvLH | L7 SLGvRH | L7 SLGvLH | L7 OPSvRH | L7 OPSvLH | |||
6791 | 682928 | Abrams, CJ | 23 | L | SS | WSH | NL | 136 | 602 | 541 | 79 | 133 | 29 | 6 | 20 | 65 | 40 | 128 | 31 | 12 | 0.246 | 0.315 | 0.432 | 0.747 | 7% | 76% | 0.31 | 28% | 115 | 119 | 108 | 116 | 80 | 40% | 18% | 42% | 0.251 | 4.2 | 0.1 | 48 | 15 | 18 | 167 | 121 | 76 | 26 | 174 | 135 | 414 | 188 | 0.223 | 0.293 | 0.303 | 0.34 | 0.414 | 0.471 | 0.717 | 0.812 | 15 | 55 | 60 | 6 | 14 | 3 | 2 | 3 | 3 | 14 | 4 | 1 | 0.255 | 0.3 | 0.418 | 0.718 | 5.20% | 74% | 0.21 | 30% | 108 | 119 | 112 | 101 | 127 | 51% | 9% | 41% | 0.231 | 4.22 | 27 | 21 | 13 | 4 | 26 | 17 | 13 | 42 | 18 | 0.21 | 0.353 | 0.262 | 0.389 | 0.368 | 0.529 | 0.63 | 0.918 | -17 | 107 | 109 | -366 | 4 | 0 | 0 | 0 | 0.25 | 0 | 0 | 0 | 0.25 | 0 | 35ee7e68-0049-4c84-9691-07c49b44fbfa | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
4515 | 547989 | Abreu, Jose | 37 | R | 1B | NOTEAM | 35 | 120 | 113 | 10 | 14 | 2 | 2 | 7 | 4 | 28 | 0.124 | 0.167 | 0.195 | 0.361 | 3% | 75% | 0.14 | 14% | 44 | 49 | 73 | 91 | 50 | 54% | 14% | 32% | 0.199 | 0.9 | -13.6 | -28 | -22 | -15 | 46 | 38 | 12 | 8 | 28 | 25 | 83 | 37 | 0.127 | 0.118 | 0.157 | 0.189 | 0.203 | 0.176 | 0.359 | 0.366 | -17 | 109 | 111 | -365 | 8 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -17 | 109 | 111 | -365 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | b59c6ed2-061e-4c9b-b624-2d1aee74853c |
Comment