Announcement

Collapse
No announcement yet.

CSV Download question

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • CSV Download question

    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
    11 Team AL only 5x5 Keeper League
    12 Hitters 10 Pitchers (Holds+Saves)

    11 Team NL only 5x5 Keeper League
    12 Hitters 10 Pitchers (Holds+Saves)

  • #2
    The preview of the above message looked fine in preview. Let me know if you want to to reload those first 3 recs another way
    11 Team AL only 5x5 Keeper League
    12 Hitters 10 Pitchers (Holds+Saves)

    11 Team NL only 5x5 Keeper League
    12 Hitters 10 Pitchers (Holds+Saves)

    Comment


    • #3
      It's not expected. I'll see if I can get that cleaned up. Which specific CSVs are you downloading from the download center? Is it the YTD files?

      Comment


      • #4
        Correct, the 2024 YTD Stats. Thanx Ray. No expectation on my part that its addressed this weekend
        11 Team AL only 5x5 Keeper League
        12 Hitters 10 Pitchers (Holds+Saves)

        11 Team NL only 5x5 Keeper League
        12 Hitters 10 Pitchers (Holds+Saves)

        Comment


        • #5
          Sure, got it. I've noticed this previously and meant to get it cleaned up.

          Comment

          Working...
          X