오늘 등록현황
require(RODBC)
## Warning: package 'RODBC' was built under R version 3.5.2
conn_mssql=odbcDriverConnect("DSN=test; uid=OPT; pwd=sports@i%pt2012!!@^") all_pts_2019=sqlQuery(conn_mssql,[1991 chars quoted with '"']) ## DB에서 날짜별 데이터 불러오기 pts2019=sqlQuery(conn_mssql,[2274 chars quoted with '"'] ) all_pts_2019$gu1=all_pts_2019$DEFLECTION_BREAK_MAGNITUDE_KOR/all_pts_2019$VY0_KOR all_pts_2019$gu2=all_pts_2019$SPIN_RATE/all_pts_2019$VY0_KOR all_pts_2019$gu3=all_pts_2019$PITCH_START_SPEED_KOR/all_pts_2019$VY0_KOR all_pts_2019$gu4=all_pts_2019$ARC_BREAK_MAGNITUDE_KOR/all_pts_2019$VY0_KOR pts2019$gu1=pts2019$DEFLECTION_BREAK_MAGNITUDE_KOR/pts2019$VY0_KOR pts2019$gu2=pts2019$SPIN_RATE/pts2019$VY0_KOR pts2019$gu3=pts2019$PITCH_START_SPEED_KOR/pts2019$VY0_KOR pts2019$gu4=pts2019$ARC_BREAK_MAGNITUDE_KOR/pts2019$VY0_KOR pre=NULL ## 저장할 테이블 생성 pit_pcode=unique(pts2019$PCODE) ## 반복문을 위한 선수 PCODE 저장(당일 경기 출전한 투수만) ## 선수별 구종분류 require(MASS) ## 필요 패키지 : MASS
## Warning: package 'MASS' was built under R version 3.5.3
for(i in 1:length(pit_pcode)){ game1=all_pts_2019[all_pts_2019$PCODE==as.character(pit_pcode[i]),] game=pts2019[pts2019$PCODE==as.character(pit_pcode[i]),] if(nrow(game1)==0) ## 이전 투구가 없는 선수의 경우 전체모형으로 이동, 아닐 경우 개인모형으로 이동 { ## 전체 PTS 데이터중 투구유형이 같은 투수들의 PTS 데이터만 가지고 모형 생성 gg=lda(stuff ~ SPIN_ANGLE + VX0_KOR + VY0_KOR + VZ0_KOR + PITCH_START_SPEED_KOR + SPIN_RATE + gu4 + gu2 + gu1 + gu3 , data=all_pts_2019[as.character(all_pts_2019$투타)==unique(as.character(game$투타)) & abs(all_pts_2019$Z0_KOR - game$Z0_KOR) <= 10, ]) pre_stuff=predict(gg, game)$class z=cbind(game, pre_stuff) pre=rbind(pre,z) } else { ## 개인별 모형 만들기 gg=lda(stuff ~ SPIN_ANGLE + VX0_KOR + VY0_KOR + VZ0_KOR + PITCH_START_SPEED_KOR + SPIN_RATE + gu4 + gu2 + gu1 + gu3 , data=game1) pre_stuff=predict(gg, game)$class z=cbind(game, pre_stuff) pre=rbind(pre,z) } }
## Warning in lda.default(x, grouping, ...): groups 너클 체인 커터 투심 are ## empty
## Warning in lda.default(x, grouping, ...): groups 너클 커터 포크 are empty
## Warning in lda.default(x, grouping, ...): groups 너클 체인 커터 투심 are ## empty
## Warning in lda.default(x, grouping, ...): groups 너클 커브 커터 are empty
## Warning in lda.default(x, grouping, ...): groups 너클 커터 투심 포크 are ## empty
## Warning in lda.default(x, grouping, ...): groups 너클 투심 포크 are empty
## Warning in lda.default(x, grouping, ...): groups 너클 슬라 커터 are empty
## Warning in all_pts_2019$Z0_KOR - game$Z0_KOR: 두 객체의 길이가 서로 배수관 ## 계에 있지 않습니다
## Warning in lda.default(x, grouping, ...): groups 너클 체인 커터 투심 are ## empty
## Warning in lda.default(x, grouping, ...): groups 너클 커터 포크 are empty
## Warning in lda.default(x, grouping, ...): groups 너클 체인 커터 are empty
## Warning in lda.default(x, grouping, ...): groups 너클 커터 포크 are empty
## Warning in lda.default(x, grouping, ...): groups 너클 체인 커터 are empty
## Warning in lda.default(x, grouping, ...): groups 너클 커브 커터 투심 are ## empty
## Warning in lda.default(x, grouping, ...): groups 너클 커터 투심 포크 are ## empty
## Warning in lda.default(x, grouping, ...): groups 너클 슬라 커터 포크 are ## empty
## Warning in lda.default(x, grouping, ...): groups 너클 체인 커터 are empty
## Warning in lda.default(x, grouping, ...): groups 너클 커터 포크 are empty
## Warning in lda.default(x, grouping, ...): groups 너클 커터 are empty
## Warning in lda.default(x, grouping, ...): groups 너클 체인 투심 are empty
## Warning in lda.default(x, grouping, ...): groups 너클 커터 투심 포크 are ## empty
## Warning in lda.default(x, grouping, ...): groups 너클 커터 투심 are empty
## Warning in lda.default(x, grouping, ...): groups 너클 포크 are empty
## Warning in lda.default(x, grouping, ...): groups 너클 체인 커터 투심 포크 ## are empty
## Warning in lda.default(x, grouping, ...): groups 너클 커터 투심 포크 are ## empty
## Warning in lda.default(x, grouping, ...): groups 너클 체인 커터 포크 are ## empty
## Warning in lda.default(x, grouping, ...): groups 너클 커터 투심 are empty
## Warning in lda.default(x, grouping, ...): groups 너클 체인 커터 투심 are ## empty
## Warning in lda.default(x, grouping, ...): groups 너클 커터 투심 포크 are ## empty
## Warning in lda.default(x, grouping, ...): groups 너클 체인 커터 are empty
## Warning in lda.default(x, grouping, ...): groups 너클 커터 포크 are empty ## Warning in lda.default(x, grouping, ...): groups 너클 커터 포크 are empty
## Warning in lda.default(x, grouping, ...): groups 너클 체인 커터 포크 are ## empty
## Warning in lda.default(x, grouping, ...): groups 너클 체인 커터 투심 are ## empty
## Warning in lda.default(x, grouping, ...): groups 너클 체인 are empty
## DB에 입력된 구종과 예측항 구종의 일치확인 - 일치 : TRUE, 불일치 : FALSE pre$match = factor(pre$stuff) == factor(pre$pre_stuff) print(pre[pre$match=="FALSE",])
## name PCODE 투타 GAMEID GYEAR diff SPIN_ANGLE X0_KOR Z0_KOR ## 45 구창모 65933 좌투 20190627HHNC0 2019 9.13 129.96218 0.657 1.731 ## 128 구창모 65933 좌투 20190627HHNC0 2019 9.57 128.81922 0.731 1.735 ## 168 구창모 65933 좌투 20190627HHNC0 2019 10.03 144.51205 0.719 1.696 ## 196 구창모 65933 좌투 20190627HHNC0 2019 9.72 121.08404 0.730 1.743 ## 22 채드벨 69748 좌투 20190627HHNC0 2019 10.98 124.55944 0.560 1.862 ## 23 채드벨 69748 좌투 20190627HHNC0 2019 12.63 112.07818 0.539 1.872 ## 25 채드벨 69748 좌투 20190627HHNC0 2019 12.14 129.93135 0.455 1.891 ## 37 채드벨 69748 좌투 20190627HHNC0 2019 13.03 156.45546 0.461 1.816 ## 58 채드벨 69748 좌투 20190627HHNC0 2019 9.36 136.69741 0.518 1.926 ## 59 채드벨 69748 좌투 20190627HHNC0 2019 8.38 119.11659 0.598 1.825 ## 60 채드벨 69748 좌투 20190627HHNC0 2019 11.02 137.83084 0.508 1.871 ## 68 채드벨 69748 좌투 20190627HHNC0 2019 11.77 123.89048 0.522 1.785 ## 72 채드벨 69748 좌투 20190627HHNC0 2019 10.99 161.15378 0.404 1.830 ## 74 채드벨 69748 좌투 20190627HHNC0 2019 10.66 144.74130 0.464 1.836 ## 76 채드벨 69748 좌투 20190627HHNC0 2019 10.40 119.67145 0.478 1.843 ## 77 채드벨 69748 좌투 20190627HHNC0 2019 10.27 114.43629 0.494 1.850 ## 96 채드벨 69748 좌투 20190627HHNC0 2019 12.02 150.71059 0.513 1.888 ## 102 채드벨 69748 좌투 20190627HHNC0 2019 12.75 148.25487 0.470 1.886 ## 104 채드벨 69748 좌투 20190627HHNC0 2019 11.56 131.63246 0.549 1.845 ## 107 채드벨 69748 좌투 20190627HHNC0 2019 11.54 143.83374 0.436 1.782 ## 112 채드벨 69748 좌투 20190627HHNC0 2019 10.53 140.56774 0.461 1.830 ## 114 채드벨 69748 좌투 20190627HHNC0 2019 10.68 145.33617 0.526 1.851 ## 118 채드벨 69748 좌투 20190627HHNC0 2019 11.46 137.40059 0.399 1.852 ## 141 채드벨 69748 좌투 20190627HHNC0 2019 13.06 154.38378 0.445 1.860 ## 143 이태양 60768 우투 20190627HHNC0 2019 9.30 182.46803 -0.190 1.956 ## 148 이태양 60768 우투 20190627HHNC0 2019 8.93 229.92661 -0.189 1.907 ## 149 이태양 60768 우투 20190627HHNC0 2019 8.50 177.09790 -0.194 1.897 ## 241 강윤구 79358 좌투 20190627HHNC0 2019 10.76 144.79048 0.523 1.754 ## 244 강윤구 79358 좌투 20190627HHNC0 2019 9.58 161.00275 0.516 1.688 ## 248 강윤구 79358 좌투 20190627HHNC0 2019 10.57 144.48810 0.514 1.704 ## 263 윤규진 73750 우투 20190627HHNC0 2019 10.00 233.03442 -0.743 1.813 ## 265 윤규진 73750 우투 20190627HHNC0 2019 9.81 229.69272 -0.757 1.843 ## 266 윤규진 73750 우투 20190627HHNC0 2019 8.61 341.27866 -0.617 1.882 ## 320 임준섭 62611 좌투 20190627HHNC0 2019 9.88 189.63940 0.346 1.817 ## 324 임준섭 62611 좌투 20190627HHNC0 2019 9.78 192.73283 0.384 1.868 ## 333 임준섭 62611 좌투 20190627HHNC0 2019 9.32 330.77359 0.356 1.994 ## 372 요키시 69343 좌투 20190627HTWO0 2019 13.77 122.77779 0.708 1.790 ## 373 요키시 69343 좌투 20190627HTWO0 2019 14.68 134.48531 0.714 1.658 ## 382 터너 69640 우투 20190627HTWO0 2019 12.93 194.47430 -0.540 1.793 ## 383 터너 69640 우투 20190627HTWO0 2019 13.76 218.96617 -0.496 1.705 ## 384 터너 69640 우투 20190627HTWO0 2019 14.52 207.89269 -0.523 1.774 ## 387 터너 69640 우투 20190627HTWO0 2019 15.05 223.27298 -0.631 1.771 ## 389 터너 69640 우투 20190627HTWO0 2019 13.81 220.61406 -0.488 1.717 ## 390 터너 69640 우투 20190627HTWO0 2019 13.81 188.89859 -0.513 1.769 ## 404 터너 69640 우투 20190627HTWO0 2019 14.28 218.86177 -0.527 1.732 ## 415 터너 69640 우투 20190627HTWO0 2019 12.82 208.66222 -0.472 1.763 ## 446 터너 69640 우투 20190627HTWO0 2019 13.72 218.08754 -0.446 1.663 ## 450 터너 69640 우투 20190627HTWO0 2019 13.17 196.92223 -0.500 1.688 ## 453 터너 69640 우투 20190627HTWO0 2019 15.36 202.41702 -0.537 1.677 ## 457 터너 69640 우투 20190627HTWO0 2019 14.84 220.05609 -0.525 1.686 ## 458 터너 69640 우투 20190627HTWO0 2019 15.06 222.31015 -0.509 1.684 ## 459 터너 69640 우투 20190627HTWO0 2019 15.81 213.72390 -0.524 1.741 ## 473 터너 69640 우투 20190627HTWO0 2019 12.09 208.08681 -0.551 1.719 ## 477 터너 69640 우투 20190627HTWO0 2019 14.57 198.54295 -0.557 1.688 ## 478 터너 69640 우투 20190627HTWO0 2019 14.44 205.87189 -0.502 1.687 ## 480 터너 69640 우투 20190627HTWO0 2019 15.10 214.25587 -0.578 1.711 ## 481 터너 69640 우투 20190627HTWO0 2019 14.51 215.60406 -0.530 1.738 ## 482 터너 69640 우투 20190627HTWO0 2019 15.28 225.28418 -0.522 1.742 ## 500 터너 69640 우투 20190627HTWO0 2019 15.96 208.94508 -0.575 1.766 ## 501 터너 69640 우투 20190627HTWO0 2019 15.17 213.57756 -0.527 1.707 ## 503 터너 69640 우투 20190627HTWO0 2019 13.69 216.25204 -0.523 1.709 ## 504 터너 69640 우투 20190627HTWO0 2019 14.74 215.89146 -0.498 1.674 ## 505 터너 69640 우투 20190627HTWO0 2019 13.41 218.29439 -0.580 1.722 ## 526 터너 69640 우투 20190627HTWO0 2019 15.08 227.47086 -0.449 1.692 ## 527 터너 69640 우투 20190627HTWO0 2019 14.50 214.79531 -0.480 1.696 ## 530 터너 69640 우투 20190627HTWO0 2019 14.42 222.12305 -0.517 1.704 ## 531 터너 69640 우투 20190627HTWO0 2019 15.32 210.81210 -0.475 1.678 ## 534 터너 69640 우투 20190627HTWO0 2019 14.67 211.11430 -0.551 1.681 ## 535 터너 69640 우투 20190627HTWO0 2019 15.16 203.09773 -0.529 1.692 ## 591 박준표 63638 우언 20190627HTWO0 2019 13.64 241.53406 -0.498 1.335 ## 598 박준표 63638 우언 20190627HTWO0 2019 13.04 247.93030 -0.537 1.379 ## 577 김상수 76430 우투 20190627HTWO0 2019 10.30 181.28038 -0.459 1.676 ## 606 이준영 65665 좌투 20190627HTWO0 2019 13.02 131.12418 0.603 1.752 ## 622 오주원 74359 좌투 20190627HTWO0 2019 12.15 119.80634 0.854 1.662 ## 627 오주원 74359 좌투 20190627HTWO0 2019 11.87 127.40906 0.859 1.612 ## 760 김원중 62528 우투 20190627KTLT0 2019 10.73 209.92384 -0.535 1.855 ## 805 김원중 62528 우투 20190627KTLT0 2019 11.43 226.28101 -0.490 1.927 ## 920 김대유 60337 좌투 20190627KTLT0 2019 10.23 116.32565 0.780 1.539 ## 945 조현우 64047 좌투 20190627KTLT0 2019 11.49 153.68870 0.513 1.682 ## 946 조현우 64047 좌투 20190627KTLT0 2019 8.18 345.89380 0.476 1.795 ## 951 조현우 64047 좌투 20190627KTLT0 2019 7.97 334.93477 0.405 1.738 ## 952 조현우 64047 좌투 20190627KTLT0 2019 6.80 330.85513 0.504 1.681 ## 957 조현우 64047 좌투 20190627KTLT0 2019 8.35 328.87347 0.508 1.707 ## 966 신정락 60140 우언 20190627SKLG0 2019 9.06 71.64523 -0.617 1.487 ## 968 신정락 60140 우언 20190627SKLG0 2019 9.31 82.80472 -0.682 1.469 ## 970 신정락 60140 우언 20190627SKLG0 2019 9.30 79.05783 -0.596 1.402 ## 1013 신정락 60140 우언 20190627SKLG0 2019 10.09 72.74304 -0.596 1.474 ## 1014 신정락 60140 우언 20190627SKLG0 2019 10.11 74.84628 -0.622 1.472 ## 1018 신정락 60140 우언 20190627SKLG0 2019 9.67 75.19211 -0.565 1.413 ## 1020 신정락 60140 우언 20190627SKLG0 2019 8.84 68.85608 -0.544 1.434 ## 1021 신정락 60140 우언 20190627SKLG0 2019 9.46 87.31128 -0.557 1.428 ## 1022 신정락 60140 우언 20190627SKLG0 2019 10.27 75.01776 -0.597 1.553 ## 1026 신정락 60140 우언 20190627SKLG0 2019 9.86 71.41409 -0.562 1.463 ## 1028 신정락 60140 우언 20190627SKLG0 2019 10.63 96.37111 -0.689 1.435 ## 1029 신정락 60140 우언 20190627SKLG0 2019 9.56 94.94672 -0.587 1.447 ## 1059 신정락 60140 우언 20190627SKLG0 2019 8.68 75.43793 -0.569 1.443 ## 1066 신정락 60140 우언 20190627SKLG0 2019 8.01 81.99548 -0.599 1.454 ## 1072 신정락 60140 우언 20190627SKLG0 2019 9.39 67.44888 -0.525 1.471 ## 983 소사 62698 우투 20190627SKLG0 2019 10.16 196.50231 -0.165 1.907 ## 984 소사 62698 우투 20190627SKLG0 2019 9.51 198.48398 -0.141 1.877 ## 985 소사 62698 우투 20190627SKLG0 2019 11.04 197.29784 -0.156 1.863 ## 988 소사 62698 우투 20190627SKLG0 2019 11.31 153.21021 -0.135 1.910 ## 992 소사 62698 우투 20190627SKLG0 2019 11.45 197.65230 -0.241 1.893 ## 1003 소사 62698 우투 20190627SKLG0 2019 11.38 200.40724 -0.124 1.910 ## 1035 소사 62698 우투 20190627SKLG0 2019 10.98 178.45230 -0.162 1.937 ## 1036 소사 62698 우투 20190627SKLG0 2019 9.48 179.48177 -0.209 1.866 ## 1046 소사 62698 우투 20190627SKLG0 2019 12.33 192.72425 -0.159 1.836 ## 1049 소사 62698 우투 20190627SKLG0 2019 10.19 122.53137 -0.299 1.835 ## 1050 소사 62698 우투 20190627SKLG0 2019 10.96 187.94668 -0.349 1.794 ## 1093 소사 62698 우투 20190627SKLG0 2019 9.63 203.70493 -0.197 1.862 ## 1099 소사 62698 우투 20190627SKLG0 2019 11.83 154.07198 -0.168 1.870 ## 1122 소사 62698 우투 20190627SKLG0 2019 10.08 165.09335 -0.228 1.920 ## 1149 소사 62698 우투 20190627SKLG0 2019 11.15 176.80879 -0.158 1.927 ## 1154 소사 62698 우투 20190627SKLG0 2019 11.19 124.09933 -0.398 1.776 ## 1167 소사 62698 우투 20190627SKLG0 2019 10.87 178.62202 -0.163 1.966 ## 1170 소사 62698 우투 20190627SKLG0 2019 10.73 177.09755 -0.199 1.946 ## 1171 소사 62698 우투 20190627SKLG0 2019 10.15 123.74162 -0.460 1.882 ## 1173 소사 62698 우투 20190627SKLG0 2019 10.64 203.82657 -0.222 1.926 ## 1174 소사 62698 우투 20190627SKLG0 2019 9.84 135.19169 -0.477 1.789 ## 1175 소사 62698 우투 20190627SKLG0 2019 10.71 125.58700 -0.348 1.795 ## 1177 소사 62698 우투 20190627SKLG0 2019 11.44 184.32130 -0.241 1.840 ## 1195 박민호 64893 우언 20190627SKLG0 2019 10.24 39.19577 -0.741 1.289 ## 1198 박민호 64893 우언 20190627SKLG0 2019 10.37 32.88644 -0.704 1.251 ## 1201 박민호 64893 우언 20190627SKLG0 2019 9.63 61.54865 -0.702 1.227 ## 1204 박민호 64893 우언 20190627SKLG0 2019 10.42 49.19760 -0.761 1.298 ## 1230 고우석 67119 우투 20190627SKLG0 2019 13.90 208.72872 -0.504 1.743 ## VX0_KOR VZ0_KOR VY0_KOR DEFLECTION_BREAK_X_KOR DEFLECTION_BREAK_Z_KOR ## 45 -2.360 -0.882 -36.808 13.0 10.9 ## 128 -2.142 -0.433 -37.198 12.3 9.9 ## 168 -1.644 -0.910 -37.421 9.5 13.4 ## 196 -1.709 0.023 -36.639 14.5 8.7 ## 22 -1.327 -1.235 -37.882 18.4 12.7 ## 23 -0.923 -0.469 -37.527 21.2 8.6 ## 25 -2.447 -0.826 -40.999 19.9 16.6 ## 37 -1.561 -2.276 -41.334 10.8 24.8 ## 58 -1.105 -0.657 -39.720 13.6 14.4 ## 59 -0.083 -1.376 -37.186 14.0 7.8 ## 60 -1.324 -1.888 -40.241 17.6 19.4 ## 68 -1.772 -2.254 -38.124 15.1 10.2 ## 72 -2.546 -2.548 -40.359 8.9 26.2 ## 74 -2.160 -1.974 -40.999 15.0 21.2 ## 76 -1.822 -1.565 -38.081 19.1 10.9 ## 77 -1.011 -1.269 -38.165 14.8 6.7 ## 96 -1.446 -1.866 -40.106 14.7 26.2 ## 102 -1.530 -1.908 -40.169 16.0 25.8 ## 104 -0.127 -1.099 -37.693 13.5 12.0 ## 107 -2.551 -2.366 -38.247 13.6 18.6 ## 112 -1.905 -2.333 -40.092 15.9 19.4 ## 114 -1.418 -1.310 -37.655 11.8 17.1 ## 118 -2.358 -2.453 -40.308 19.2 20.8 ## 141 -2.047 -1.590 -39.858 13.2 27.5 ## 143 0.674 -0.349 -35.071 -0.4 8.3 ## 148 0.484 -0.589 -34.399 -3.0 2.5 ## 149 0.643 -0.700 -35.013 0.2 4.7 ## 241 -0.128 0.429 -36.517 11.9 16.9 ## 244 -0.527 -1.629 -36.938 7.5 21.8 ## 248 -0.974 -0.746 -36.661 11.2 15.6 ## 263 2.069 -0.526 -36.354 -9.2 6.9 ## 265 1.490 -0.019 -35.654 -9.0 7.6 ## 266 2.290 -0.062 -32.503 -4.0 -11.7 ## 320 -0.242 -2.595 -39.436 -3.6 21.5 ## 324 0.611 -1.316 -38.910 -5.4 23.9 ## 333 -0.226 0.606 -35.080 -6.6 -11.9 ## 372 -3.020 -0.446 -36.278 30.5 19.6 ## 373 -4.100 -2.664 -39.890 26.8 26.3 ## 382 0.635 -1.746 -40.061 -8.0 31.0 ## 383 2.545 -3.528 -40.183 -20.1 24.9 ## 384 2.011 -1.602 -40.786 -15.0 28.3 ## 387 0.634 -0.888 -40.809 -20.6 21.8 ## 389 1.933 -2.359 -41.768 -21.4 25.0 ## 390 1.211 -2.153 -40.953 -5.8 37.3 ## 404 1.844 -1.547 -41.368 -19.2 23.9 ## 415 1.443 -1.724 -40.271 -13.9 25.3 ## 446 3.028 -2.316 -41.526 -18.8 24.0 ## 450 2.277 -2.363 -41.854 -9.2 30.4 ## 453 1.756 -2.604 -41.856 -11.7 28.5 ## 457 2.181 -1.711 -41.292 -23.6 28.0 ## 458 2.298 -2.674 -41.443 -24.3 26.7 ## 459 2.152 -1.630 -41.338 -20.5 30.7 ## 473 2.244 -2.014 -41.277 -16.4 30.7 ## 477 1.826 -1.626 -41.654 -9.3 27.8 ## 478 2.602 -2.721 -41.867 -12.9 26.6 ## 480 1.717 -1.708 -41.652 -15.9 23.3 ## 481 2.273 -1.603 -41.050 -21.7 30.3 ## 482 2.068 -1.306 -40.873 -24.0 23.8 ## 500 0.997 -1.039 -40.779 -15.5 28.0 ## 501 2.018 -2.290 -41.531 -18.7 28.2 ## 503 2.644 -2.173 -41.623 -20.8 28.4 ## 504 2.392 -2.634 -42.404 -20.1 27.8 ## 505 1.711 -1.928 -41.794 -20.5 25.9 ## 526 2.503 -2.037 -42.484 -24.6 22.6 ## 527 2.082 -2.024 -41.641 -16.6 23.9 ## 530 2.176 -1.511 -41.305 -21.0 23.2 ## 531 2.787 -2.271 -42.513 -18.2 30.5 ## 534 1.308 -1.925 -42.089 -16.5 27.4 ## 535 1.740 -1.649 -41.692 -11.6 27.2 ## 591 1.794 -0.104 -38.280 -21.9 11.9 ## 598 1.785 0.234 -37.906 -18.6 7.5 ## 577 0.450 -0.972 -35.719 -0.2 9.5 ## 606 -1.823 -2.362 -36.940 29.6 25.9 ## 622 -2.752 -0.933 -36.077 31.0 17.8 ## 627 -3.153 -1.650 -36.180 27.4 21.0 ## 760 1.036 -1.930 -38.836 -13.9 24.1 ## 805 1.631 -1.183 -38.187 -21.4 20.5 ## 920 -2.908 -0.681 -35.068 25.6 12.7 ## 945 -0.824 -1.090 -39.040 13.9 28.2 ## 946 -0.833 1.447 -33.513 -2.7 -10.6 ## 951 -1.553 0.406 -33.467 -5.2 -11.1 ## 952 -0.736 -0.453 -33.127 -3.7 -6.7 ## 957 -0.541 0.169 -34.110 -4.1 -6.9 ## 966 0.605 1.130 -34.872 24.5 -8.1 ## 968 0.200 1.001 -34.719 30.6 -3.9 ## 970 1.213 0.185 -34.834 22.7 -4.4 ## 1013 1.431 0.641 -34.795 22.2 -6.9 ## 1014 0.813 1.179 -34.661 24.8 -6.7 ## 1018 1.174 -0.034 -34.702 22.8 -6.0 ## 1020 1.603 0.302 -35.453 20.7 -8.0 ## 1021 1.887 -0.127 -35.481 15.7 -0.7 ## 1022 0.558 1.491 -34.966 22.0 -5.9 ## 1026 1.484 0.743 -35.391 18.3 -6.2 ## 1028 -0.469 0.878 -34.707 28.7 3.2 ## 1029 0.879 0.069 -35.068 22.9 2.0 ## 1059 0.969 0.239 -34.570 19.3 -5.0 ## 1066 1.212 0.385 -35.296 21.8 -3.1 ## 1072 1.451 0.424 -34.469 21.9 -9.1 ## 983 0.897 -1.455 -37.938 -3.6 12.1 ## 984 1.215 -1.582 -37.374 -4.6 13.7 ## 985 0.972 -1.944 -38.416 -5.1 16.3 ## 988 0.537 -1.063 -38.752 4.6 9.2 ## 992 -0.316 -1.145 -39.096 -5.7 17.9 ## 1003 1.014 -1.443 -37.042 -5.4 14.5 ## 1035 0.295 -1.322 -37.046 0.3 12.2 ## 1036 1.275 -1.062 -35.813 0.1 10.7 ## 1046 0.864 -1.894 -38.038 -4.5 19.9 ## 1049 0.621 -1.049 -38.755 10.9 7.0 ## 1050 1.104 -1.921 -38.795 -1.3 9.1 ## 1093 0.727 -1.298 -37.623 -4.5 10.1 ## 1099 0.939 -1.035 -36.937 5.1 10.5 ## 1122 0.658 -0.776 -36.617 2.4 9.1 ## 1149 1.228 -1.112 -35.591 0.8 15.0 ## 1154 0.010 -1.332 -37.266 15.1 10.2 ## 1167 1.166 -0.954 -35.434 0.3 11.0 ## 1170 1.023 -0.964 -36.588 0.3 5.1 ## 1171 1.003 0.144 -34.141 8.6 5.8 ## 1173 1.187 -0.096 -35.421 -6.5 14.8 ## 1174 0.288 -0.464 -35.506 9.2 9.3 ## 1175 1.097 -0.839 -36.003 11.4 8.2 ## 1177 0.251 -1.099 -36.130 -1.4 19.1 ## 1195 0.913 2.063 -34.277 6.2 -7.6 ## 1198 1.623 0.932 -34.879 2.0 -3.0 ## 1201 1.556 1.267 -34.313 9.1 -4.9 ## 1204 0.956 1.209 -34.136 7.8 -6.7 ## 1230 1.921 -0.644 -42.578 -12.9 23.5 ## DEFLECTION_BREAK_MAGNITUDE_KOR SPIN_RATE PITCH_START_SPEED_KOR ## 45 17.0 1204 132.82 ## 128 15.8 1130 134.14 ## 168 16.4 1176 134.89 ## 196 16.9 1185 132.04 ## 22 22.4 1605 136.53 ## 23 22.9 1600 135.15 ## 25 25.9 2016 147.89 ## 37 27.1 2108 149.13 ## 58 19.8 1525 143.07 ## 59 16.0 1149 133.96 ## 60 26.2 2012 145.10 ## 68 18.2 1303 137.64 ## 72 27.7 2135 145.87 ## 74 25.9 2042 147.97 ## 76 22.0 1591 137.37 ## 77 16.3 1180 137.52 ## 96 30.0 2280 144.63 ## 102 30.4 2295 144.88 ## 104 18.0 1280 135.75 ## 107 23.1 1665 138.26 ## 112 25.1 1925 144.74 ## 114 20.8 1488 135.74 ## 118 28.3 2168 145.62 ## 141 30.5 2281 143.79 ## 143 8.3 561 126.28 ## 148 3.9 260 123.87 ## 149 4.8 326 126.09 ## 241 20.6 1432 131.47 ## 244 23.0 1630 133.12 ## 248 19.2 1337 132.05 ## 263 11.5 797 131.10 ## 265 11.8 801 128.47 ## 266 12.4 746 117.30 ## 320 21.8 1650 142.28 ## 324 24.5 1836 140.17 ## 333 13.6 895 126.31 ## 372 36.2 2421 131.06 ## 373 37.6 2773 144.68 ## 382 32.1 2414 144.37 ## 383 32.0 2393 145.50 ## 384 32.0 2427 147.12 ## 387 30.0 2259 146.96 ## 389 32.9 2576 150.77 ## 390 37.7 2893 147.70 ## 404 30.7 2365 149.18 ## 415 28.9 2188 145.20 ## 446 30.5 2374 150.12 ## 450 31.7 2505 151.14 ## 453 30.8 2386 151.11 ## 457 36.6 2807 148.98 ## 458 36.1 2767 149.73 ## 459 36.9 2810 149.13 ## 473 34.8 2729 148.99 ## 477 29.3 2272 150.21 ## 478 29.6 2310 151.33 ## 480 28.2 2174 150.20 ## 481 37.3 2848 148.12 ## 482 33.8 2551 147.41 ## 500 32.0 2393 146.90 ## 501 33.9 2603 149.91 ## 503 35.2 2748 150.35 ## 504 34.3 2711 153.19 ## 505 33.0 2593 150.74 ## 526 33.4 2633 153.38 ## 527 29.1 2258 150.27 ## 530 31.2 2402 149.00 ## 531 35.5 2801 153.59 ## 534 32.0 2509 151.75 ## 535 29.6 2285 150.34 ## 591 25.0 1771 137.96 ## 598 20.0 1413 136.61 ## 577 9.5 646 128.65 ## 606 39.3 2689 133.42 ## 622 35.8 2407 130.30 ## 627 34.5 2337 130.88 ## 760 27.9 2063 140.03 ## 805 29.7 2143 137.67 ## 920 28.6 1896 126.70 ## 945 31.4 2327 140.63 ## 946 11.0 694 120.80 ## 951 12.2 772 120.62 ## 952 7.6 477 119.30 ## 957 8.0 512 122.81 ## 966 25.8 1707 125.63 ## 968 30.8 2026 125.04 ## 970 23.1 1515 125.48 ## 1013 23.2 1511 125.39 ## 1014 25.7 1672 124.89 ## 1018 23.6 1534 125.00 ## 1020 22.2 1490 127.76 ## 1021 15.7 1051 127.91 ## 1022 22.8 1499 126.01 ## 1026 19.3 1286 127.55 ## 1028 28.9 1880 125.00 ## 1029 23.0 1523 126.28 ## 1059 19.9 1306 124.50 ## 1066 22.0 1487 127.15 ## 1072 23.7 1532 124.21 ## 983 12.7 919 136.72 ## 984 14.5 1039 134.74 ## 985 17.1 1246 138.52 ## 988 10.3 757 139.57 ## 992 18.8 1396 140.81 ## 1003 15.5 1081 133.50 ## 1035 12.3 861 133.45 ## 1036 10.7 734 129.07 ## 1046 20.4 1453 137.14 ## 1049 12.9 956 139.59 ## 1050 9.2 682 139.89 ## 1093 11.1 801 135.55 ## 1099 11.7 813 133.07 ## 1122 9.4 659 131.87 ## 1149 15.1 1009 128.27 ## 1154 18.2 1277 134.24 ## 1167 11.0 740 127.68 ## 1170 5.1 361 131.82 ## 1171 10.4 671 122.96 ## 1173 16.2 1089 127.59 ## 1174 13.1 883 127.84 ## 1175 14.1 953 129.71 ## 1177 19.1 1300 130.13 ## 1195 9.9 631 123.66 ## 1198 3.6 229 125.74 ## 1201 10.4 668 123.74 ## 1204 10.3 654 123.02 ## 1230 26.8 2143 153.45 ## AZ_KOR ARC_BREAK_MAGNITUDE_KOR BREAK_ANGLE inn tb ilsun ## 45 -7.830 19.7 39.96220 2 T 0 ## 128 -7.975 19.5 38.81920 4 T 0 ## 168 -7.327 17.9 54.51200 5 T 0 ## 196 -8.244 20.8 31.08400 6 T 0 ## 22 -7.414 19.2 34.55940 1 B 0 ## 23 -8.232 21.9 22.07820 1 B 0 ## 25 -6.136 14.5 39.93140 1 B 0 ## 37 -4.295 10.2 66.45550 1 B 0 ## 58 -6.756 15.1 46.69740 2 B 0 ## 59 -8.356 20.9 29.11660 2 B 0 ## 60 -5.660 14.1 47.83080 2 B 0 ## 68 -7.882 20.1 33.89050 2 B 0 ## 72 -4.183 9.9 71.15380 2 B 0 ## 74 -5.085 12.0 54.74130 2 B 0 ## 76 -7.721 19.7 29.67140 2 B 0 ## 77 -8.503 20.6 24.43630 2 B 0 ## 96 -4.304 11.3 60.71060 3 B 0 ## 102 -4.395 11.8 58.25490 3 B 0 ## 104 -7.585 19.3 41.63250 3 B 0 ## 107 -6.254 16.1 53.83370 3 B 0 ## 112 -5.687 13.9 50.56770 3 B 0 ## 114 -6.621 16.6 55.33620 3 B 0 ## 118 -5.362 14.0 47.40060 3 B 0 ## 141 -4.151 10.7 64.38380 4 B 0 ## 143 -8.451 22.7 92.46800 4 B 0 ## 148 -9.396 26.4 139.92700 4 B 0 ## 149 -9.019 24.3 87.09790 4 B 0 ## 241 -6.853 17.6 54.79050 7 T 0 ## 244 -5.878 15.1 71.00280 7 T 0 ## 248 -7.049 18.2 54.48810 7 T 0 ## 263 -8.591 21.9 143.03400 7 B 0 ## 265 -8.520 22.3 139.69300 7 B 0 ## 266 -11.387 35.8 251.27900 7 B 0 ## 320 -5.383 12.4 99.63940 8 B 0 ## 324 -5.002 11.4 102.73300 8 B 0 ## 333 -11.691 31.2 240.77400 8 B 0 ## 372 -6.512 20.7 32.77780 1 T 0 ## 373 -4.452 14.5 44.48530 1 T 0 ## 382 -3.350 8.5 104.47400 1 B 0 ## 383 -4.644 13.7 128.96600 1 B 0 ## 384 -3.770 10.1 117.89300 1 B 0 ## 387 -5.168 14.1 133.27300 1 B 0 ## 389 -4.166 12.4 130.61400 1 B 0 ## 390 -1.737 4.9 98.89860 1 B 0 ## 404 -4.546 12.3 128.86200 1 B 0 ## 415 -4.471 11.4 118.66200 2 B 0 ## 446 -4.448 11.9 128.08800 3 B 0 ## 450 -2.890 7.2 106.92200 3 B 0 ## 453 -3.439 9.1 112.41700 3 B 0 ## 457 -3.681 12.3 130.05600 3 B 0 ## 458 -3.950 13.2 132.31000 3 B 0 ## 459 -3.140 10.6 123.72400 3 B 0 ## 473 -2.951 9.0 118.08700 4 B 0 ## 477 -3.618 8.5 108.54300 4 B 0 ## 478 -3.804 9.7 115.87200 4 B 0 ## 480 -4.640 11.7 124.25600 4 B 0 ## 481 -3.246 11.1 125.60400 4 B 0 ## 482 -4.738 14.0 135.28400 4 B 0 ## 500 -3.915 10.7 118.94500 5 B 0 ## 501 -3.591 10.9 123.57800 5 B 0 ## 503 -3.439 10.9 126.25200 5 B 0 ## 504 -3.380 10.8 125.89100 5 B 0 ## 505 -3.935 11.7 128.29400 5 B 0 ## 526 -4.581 13.5 137.47100 6 B 0 ## 527 -4.476 11.6 124.79500 6 B 0 ## 530 -4.722 12.9 132.12300 6 B 0 ## 531 -2.750 9.1 120.81200 6 B 0 ## 534 -3.567 10.2 121.11400 6 B 0 ## 535 -3.762 9.2 113.09800 6 B 0 ## 591 -7.561 19.6 151.53400 8 B 0 ## 598 -8.399 20.9 157.93000 8 B 0 ## 577 -8.216 21.9 91.28040 8 T 0 ## 606 -5.290 18.8 41.12420 8 B 0 ## 622 -6.814 21.8 29.80630 9 T 0 ## 627 -6.252 19.8 37.40910 9 T 0 ## 760 -5.015 13.0 119.92400 4 T 0 ## 805 -5.896 16.4 136.28100 6 T 0 ## 920 -7.755 23.3 26.32570 8 B 0 ## 945 -4.187 11.1 63.68870 9 B 0 ## 946 -11.361 32.3 255.89400 9 B 0 ## 951 -11.417 33.2 244.93500 9 B 0 ## 952 -10.753 31.8 240.85500 9 B 0 ## 957 -10.831 30.4 238.87300 9 B 0 ## 966 -11.078 31.3 341.64500 1 T 0 ## 968 -10.392 30.9 352.80500 1 T 0 ## 970 -10.476 30.3 349.05800 1 T 0 ## 1013 -10.861 31.3 342.74300 2 T 0 ## 1014 -10.830 31.4 344.84600 2 T 0 ## 1018 -10.724 31.4 345.19200 2 T 0 ## 1020 -11.100 30.4 338.85600 2 T 0 ## 1021 -9.905 27.1 357.31100 2 T 0 ## 1022 -10.720 30.0 345.01800 2 T 0 ## 1026 -10.787 29.5 341.41400 2 T 0 ## 1028 -9.285 28.1 6.37111 2 T 0 ## 1029 -9.467 27.4 4.94672 2 T 0 ## 1059 -10.568 30.2 345.43800 3 T 0 ## 1066 -10.288 28.3 351.99500 3 T 0 ## 1072 -11.183 32.6 337.44900 3 T 0 ## 983 -7.499 17.8 106.50200 1 B 0 ## 984 -7.265 17.7 108.48400 1 B 0 ## 985 -6.654 15.9 107.29800 1 B 0 ## 988 -7.995 18.3 63.21020 1 B 0 ## 992 -6.218 14.2 107.65200 1 B 0 ## 1003 -7.215 18.4 110.40700 1 B 0 ## 1035 -7.608 19.1 88.45230 2 B 0 ## 1036 -7.994 21.0 89.48180 2 B 0 ## 1046 -6.089 15.2 102.72400 2 B 0 ## 1049 -8.416 19.5 32.53140 2 B 0 ## 1050 -7.999 18.4 97.94670 2 B 0 ## 1093 -7.899 18.9 113.70500 3 B 0 ## 1099 -7.939 20.3 64.07200 3 B 0 ## 1122 -8.196 20.6 75.09340 4 B 0 ## 1149 -7.334 20.1 86.80880 5 B 0 ## 1154 -7.952 20.8 34.09930 5 B 0 ## 1167 -7.997 21.9 88.62200 6 B 0 ## 1170 -8.897 22.6 87.09750 6 B 0 ## 1171 -8.914 25.8 33.74160 6 B 0 ## 1173 -7.370 19.7 113.82700 6 B 0 ## 1174 -8.261 22.2 45.19170 6 B 0 ## 1175 -8.415 22.8 35.58700 6 B 0 ## 1177 -6.577 17.5 94.32130 6 B 0 ## 1195 -10.954 30.0 309.19600 7 B 0 ## 1198 -10.263 27.7 302.88600 7 B 0 ## 1201 -10.542 29.3 331.54900 7 B 0 ## 1204 -10.800 30.6 319.19800 7 B 0 ## 1230 -4.286 9.5 118.72900 8 T 0 ## batstartorder batorder ballcount seqno SC_ID stuff gu1 ## 45 5 6 3 45 포크 -0.4618561 ## 128 4 6 4 128 포크 -0.4247540 ## 168 8 9 6 168 포크 -0.4382566 ## 196 6 6 1 196 포크 -0.4612571 ## 22 1 2 1 22 체인 -0.5913099 ## 23 1 2 2 23 체인 -0.6102273 ## 25 1 2 4 25 포심 -0.6317227 ## 37 1 5 6 37 포심 -0.6556346 ## 58 6 6 1 58 투심 -0.4984894 ## 59 6 6 2 59 체인 -0.4302695 ## 60 6 6 3 60 포심 -0.6510773 ## 68 6 8 4 68 체인 -0.4773896 ## 72 6 1 2 72 투심 -0.6863401 ## 74 6 1 4 74 포심 -0.6317227 ## 76 6 2 1 76 체인 -0.5777159 ## 77 6 2 2 77 체인 -0.4270929 ## 96 4 4 1 96 포심 -0.7480178 ## 102 4 5 1 102 포심 -0.7568025 ## 104 4 5 3 104 체인 -0.4775422 ## 107 4 5 6 107 체인 -0.6039689 ## 112 4 7 1 112 포심 -0.6260601 ## 114 4 8 1 114 체인 -0.5523835 ## 118 4 9 4 118 포심 -0.7020939 ## 141 1 1 7 141 포심 -0.7652165 ## 143 1 2 1 143 슬라 -0.2366628 ## 148 1 4 1 148 슬라 -0.1133754 ## 149 1 4 2 149 슬라 -0.1370919 ## 241 2 2 6 241 체인 -0.5641208 ## 244 2 3 3 244 체인 -0.6226650 ## 248 2 4 2 248 체인 -0.5237173 ## 263 7 7 3 263 슬라 -0.3163338 ## 265 7 8 2 265 슬라 -0.3309587 ## 266 7 9 1 266 커브 -0.3815032 ## 320 4 6 2 320 포심 -0.5527944 ## 324 4 6 6 324 포심 -0.6296582 ## 333 4 8 5 333 슬라 -0.3876853 ## 372 1 5 1 28 슬라 -0.9978499 ## 373 1 5 2 29 체인 -0.9425921 ## 382 1 1 1 38 투심 -0.8012781 ## 383 1 1 2 39 투심 -0.7963567 ## 384 1 1 3 40 투심 -0.7845829 ## 387 1 3 1 43 투심 -0.7351320 ## 389 1 3 3 45 투심 -0.7876844 ## 390 1 4 1 46 투심 -0.9205675 ## 404 1 7 1 60 투심 -0.7421195 ## 415 8 8 1 71 투심 -0.7176380 ## 446 2 2 3 102 투심 -0.7344796 ## 450 2 3 3 106 투심 -0.7573948 ## 453 2 3 6 109 투심 -0.7358563 ## 457 2 4 4 113 투심 -0.8863702 ## 458 2 5 1 114 투심 -0.8710759 ## 459 2 5 2 115 투심 -0.8926412 ## 473 6 6 1 129 투심 -0.8430845 ## 477 6 6 5 133 투심 -0.7034138 ## 478 6 7 1 134 투심 -0.7070007 ## 480 6 7 3 136 투심 -0.6770383 ## 481 6 8 1 137 투심 -0.9086480 ## 482 6 8 2 138 투심 -0.8269518 ## 500 1 1 1 156 투심 -0.7847176 ## 501 1 1 2 157 투심 -0.8162577 ## 503 1 2 2 159 투심 -0.8456863 ## 504 1 2 3 160 투심 -0.8088860 ## 505 1 3 1 161 투심 -0.7895870 ## 526 4 4 4 182 투심 -0.7861783 ## 527 4 5 1 183 투심 -0.6988305 ## 530 4 5 4 186 투심 -0.7553565 ## 531 4 5 5 187 투심 -0.8350387 ## 534 4 6 3 190 투심 -0.7602937 ## 535 4 6 4 191 투심 -0.7099683 ## 591 4 4 1 247 투심 -0.6530825 ## 598 4 6 1 254 투심 -0.5276210 ## 577 9 1 3 233 포크 -0.2659649 ## 606 4 8 1 262 투심 -1.0638874 ## 622 4 5 3 278 체인 -0.9923220 ## 627 4 6 5 283 체인 -0.9535655 ## 760 9 2 1 133 투심 -0.7184056 ## 805 6 6 1 178 투심 -0.7777516 ## 920 2 6 3 293 체인 -0.8155583 ## 945 7 7 6 318 포심 -0.8043033 ## 946 7 8 1 319 슬라 -0.3282308 ## 951 7 9 1 324 슬라 -0.3645382 ## 952 7 9 2 325 슬라 -0.2294201 ## 957 7 1 1 330 슬라 -0.2345353 ## 966 1 2 2 3 커브 -0.7398486 ## 968 1 2 4 5 커브 -0.8871223 ## 970 1 4 1 7 커브 -0.6631452 ## 1013 6 7 2 50 커브 -0.6667625 ## 1014 6 7 3 51 커브 -0.7414674 ## 1018 6 8 2 55 커브 -0.6800761 ## 1020 6 8 4 57 커브 -0.6261811 ## 1021 6 8 5 58 커브 -0.4424903 ## 1022 6 9 1 59 커브 -0.6520620 ## 1026 6 9 5 63 커브 -0.5453364 ## 1028 6 1 1 65 커브 -0.8326850 ## 1029 6 1 2 66 커브 -0.6558686 ## 1059 2 2 2 96 커브 -0.5756436 ## 1066 2 3 2 103 커브 -0.6233001 ## 1072 2 4 4 109 커브 -0.6875743 ## 983 1 2 2 20 포크 -0.3347567 ## 984 1 3 1 21 포크 -0.3879702 ## 985 1 3 2 22 포크 -0.4451270 ## 988 1 3 5 25 포크 -0.2657927 ## 992 1 4 3 29 포크 -0.4808676 ## 1003 1 6 4 40 포크 -0.4184439 ## 1035 8 9 3 72 포크 -0.3320197 ## 1036 8 1 1 73 포크 -0.2987742 ## 1046 8 2 5 83 포크 -0.5363058 ## 1049 8 3 3 86 슬라 -0.3328603 ## 1050 8 3 4 87 포크 -0.2371440 ## 1093 5 7 2 130 포크 -0.2950323 ## 1099 5 8 5 136 포크 -0.3167556 ## 1122 1 1 5 159 포크 -0.2567114 ## 1149 4 6 2 186 포크 -0.4242646 ## 1154 4 7 4 191 슬라 -0.4883808 ## 1167 8 8 1 205 포크 -0.3104363 ## 1170 8 8 4 208 포크 -0.1393900 ## 1171 8 9 1 209 슬라 -0.3046191 ## 1173 8 1 2 211 포크 -0.4573558 ## 1174 8 1 3 212 슬라 -0.3689517 ## 1175 8 1 4 213 슬라 -0.3916340 ## 1177 8 1 6 215 포크 -0.5286466 ## 1195 3 3 1 233 슬라 -0.2888234 ## 1198 3 3 4 236 슬라 -0.1032140 ## 1201 3 4 3 239 슬라 -0.3030921 ## 1204 3 6 1 242 슬라 -0.3017342 ## 1230 8 1 1 268 투심 -0.6294330 ## gu2 gu3 gu4 pre_stuff match ## 45 -32.710280 -3.608455 -0.5352097 슬라 FALSE ## 128 -30.377977 -3.606108 -0.5242217 슬라 FALSE ## 168 -31.426205 -3.604660 -0.4783410 슬라 FALSE ## 196 -32.342586 -3.603810 -0.5677011 슬라 FALSE ## 22 -42.368407 -3.604086 -0.5068370 슬라 FALSE ## 23 -42.635969 -3.601407 -0.5835798 슬라 FALSE ## 25 -49.171931 -3.607161 -0.3536672 투심 FALSE ## 37 -50.999177 -3.607926 -0.2467702 투심 FALSE ## 58 -38.393756 -3.601964 -0.3801611 슬라 FALSE ## 59 -30.898725 -3.602431 -0.5620395 슬라 FALSE ## 60 -49.998757 -3.605775 -0.3503889 투심 FALSE ## 68 -34.177946 -3.610324 -0.5272269 슬라 FALSE ## 72 -52.900221 -3.614312 -0.2452984 포심 FALSE ## 74 -49.806093 -3.609112 -0.2926901 투심 FALSE ## 76 -41.779365 -3.607311 -0.5173183 슬라 FALSE ## 77 -30.918381 -3.603301 -0.5397616 슬라 FALSE ## 96 -56.849349 -3.606194 -0.2817534 투심 FALSE ## 102 -57.133610 -3.606761 -0.2937589 투심 FALSE ## 104 -33.958560 -3.601464 -0.5120314 슬라 FALSE ## 107 -43.532826 -3.614924 -0.4209480 슬라 FALSE ## 112 -48.014566 -3.610197 -0.3467026 투심 FALSE ## 114 -39.516664 -3.604833 -0.4408445 슬라 FALSE ## 118 -53.785849 -3.612682 -0.3473256 투심 FALSE ## 141 -57.228160 -3.607557 -0.2684530 투심 FALSE ## 143 -15.996122 -3.600696 -0.6472584 포크 FALSE ## 148 -7.558359 -3.600977 -0.7674642 포크 FALSE ## 149 -9.310827 -3.601234 -0.6940279 포크 FALSE ## 241 -39.214612 -3.600241 -0.4819673 슬라 FALSE ## 244 -44.127998 -3.603877 -0.4087931 슬라 FALSE ## 248 -36.469273 -3.601920 -0.4964404 슬라 FALSE ## 263 -21.923310 -3.606206 -0.6024096 포크 FALSE ## 265 -22.465922 -3.603242 -0.6254558 포크 FALSE ## 266 -22.951728 -3.608898 -1.1014368 포크 FALSE ## 320 -41.839943 -3.607871 -0.3144335 투심 FALSE ## 324 -47.185813 -3.602416 -0.2929838 투심 FALSE ## 333 -25.513113 -3.600627 -0.8893957 커브 FALSE ## 372 -66.734660 -3.612658 -0.5705937 체인 FALSE ## 373 -69.516169 -3.626974 -0.3634996 투심 FALSE ## 382 -60.258106 -3.603754 -0.2121764 포심 FALSE ## 383 -59.552547 -3.620934 -0.3409402 포심 FALSE ## 384 -59.505713 -3.607120 -0.2476340 포심 FALSE ## 387 -55.355436 -3.601166 -0.3455120 포심 FALSE ## 389 -61.674009 -3.609701 -0.2968780 포심 FALSE ## 390 -70.641955 -3.606573 -0.1196494 포심 FALSE ## 404 -57.169793 -3.606169 -0.2973313 포심 FALSE ## 415 -54.331901 -3.605572 -0.2830821 포심 FALSE ## 446 -57.169003 -3.615085 -0.2865675 포심 FALSE ## 450 -59.850910 -3.611124 -0.1720266 포심 FALSE ## 453 -57.004969 -3.610235 -0.2174121 포심 FALSE ## 457 -67.979270 -3.607963 -0.2978785 포심 FALSE ## 458 -66.766402 -3.612914 -0.3185098 포심 FALSE ## 459 -67.976196 -3.607577 -0.2564227 포심 FALSE ## 473 -66.114301 -3.609516 -0.2180391 포심 FALSE ## 477 -54.544582 -3.606136 -0.2040620 포심 FALSE ## 478 -55.174720 -3.614541 -0.2316861 포심 FALSE ## 480 -52.194372 -3.606069 -0.2808989 포심 FALSE ## 481 -69.378806 -3.608283 -0.2704019 포심 FALSE ## 482 -62.412840 -3.606537 -0.3425244 포심 FALSE ## 500 -58.682165 -3.602344 -0.2623900 포심 FALSE ## 501 -62.676073 -3.609593 -0.2624546 포심 FALSE ## 503 -66.021190 -3.612186 -0.2618744 포심 FALSE ## 504 -63.932648 -3.612631 -0.2546930 포심 FALSE ## 505 -62.042398 -3.606738 -0.2799445 포심 FALSE ## 526 -61.976273 -3.610300 -0.3177667 포심 FALSE ## 527 -54.225403 -3.608703 -0.2785716 포심 FALSE ## 530 -58.152766 -3.607311 -0.3123109 포심 FALSE ## 531 -65.885729 -3.612777 -0.2140522 포심 FALSE ## 534 -59.611775 -3.605455 -0.2423436 포심 FALSE ## 535 -54.806678 -3.605968 -0.2206658 포심 FALSE ## 591 -46.264368 -3.603971 -0.5120167 포심 FALSE ## 598 -37.276421 -3.603915 -0.5513639 포심 FALSE ## 577 -18.085613 -3.601725 -0.6131191 슬라 FALSE ## 606 -72.793720 -3.611803 -0.5089334 체인 FALSE ## 622 -66.718408 -3.611719 -0.6042631 포크 FALSE ## 627 -64.593698 -3.617468 -0.5472637 포크 FALSE ## 760 -53.120816 -3.605675 -0.3347410 포심 FALSE ## 805 -56.118574 -3.605154 -0.4294655 포심 FALSE ## 920 -54.066385 -3.612980 -0.6644234 슬라 FALSE ## 945 -59.605533 -3.602203 -0.2843238 투심 FALSE ## 946 -20.708382 -3.604571 -0.9638051 커브 FALSE ## 951 -23.067499 -3.604147 -0.9920220 커브 FALSE ## 952 -14.399131 -3.601292 -0.9599420 커브 FALSE ## 957 -15.010261 -3.600410 -0.8912342 커브 FALSE ## 966 -48.950447 -3.602604 -0.8975682 슬라 FALSE ## 968 -58.354215 -3.601486 -0.8900026 슬라 FALSE ## 970 -43.491991 -3.602228 -0.8698398 슬라 FALSE ## 1013 -43.425780 -3.603679 -0.8995545 슬라 FALSE ## 1014 -48.238654 -3.603185 -0.9059173 슬라 FALSE ## 1018 -44.204945 -3.602098 -0.9048470 슬라 FALSE ## 1020 -42.027473 -3.603644 -0.8574733 슬라 FALSE ## 1021 -29.621488 -3.605028 -0.7637891 슬라 FALSE ## 1022 -42.870217 -3.603787 -0.8579763 슬라 FALSE ## 1026 -36.336922 -3.604024 -0.8335453 슬라 FALSE ## 1028 -54.167747 -3.601579 -0.8096349 슬라 FALSE ## 1029 -43.429908 -3.601004 -0.7813391 슬라 FALSE ## 1059 -37.778421 -3.601388 -0.8735898 슬라 FALSE ## 1066 -42.129420 -3.602391 -0.8017906 슬라 FALSE ## 1072 -44.445734 -3.603528 -0.9457774 슬라 FALSE ## 983 -24.223733 -3.603775 -0.4691866 슬라 FALSE ## 984 -27.800075 -3.605180 -0.4735913 슬라 FALSE ## 985 -32.434402 -3.605789 -0.4138900 슬라 FALSE ## 988 -19.534476 -3.601621 -0.4722337 슬라 FALSE ## 992 -35.706978 -3.601647 -0.3632085 슬라 FALSE ## 1003 -29.183089 -3.604017 -0.4967334 슬라 FALSE ## 1035 -23.241376 -3.602278 -0.5155752 슬라 FALSE ## 1036 -20.495351 -3.603999 -0.5863792 슬라 FALSE ## 1046 -38.198643 -3.605342 -0.3996004 슬라 FALSE ## 1049 -24.667785 -3.601858 -0.5031609 커브 FALSE ## 1050 -17.579585 -3.605877 -0.4742879 슬라 FALSE ## 1093 -21.290168 -3.602849 -0.5023523 슬라 FALSE ## 1099 -22.010450 -3.602621 -0.5495844 슬라 FALSE ## 1122 -17.997105 -3.601333 -0.5625802 슬라 FALSE ## 1149 -28.349864 -3.604001 -0.5647495 슬라 FALSE ## 1154 -34.267160 -3.602211 -0.5581495 커브 FALSE ## 1167 -20.883897 -3.603319 -0.6180505 슬라 FALSE ## 1170 -9.866623 -3.602821 -0.6176889 슬라 FALSE ## 1171 -19.653789 -3.601535 -0.7556896 커브 FALSE ## 1173 -30.744474 -3.602100 -0.5561672 슬라 FALSE ## 1174 -24.869036 -3.600518 -0.6252464 커브 FALSE ## 1175 -26.470016 -3.602755 -0.6332806 커브 FALSE ## 1177 -35.981179 -3.601716 -0.4843620 슬라 FALSE ## 1195 -18.408846 -3.607667 -0.8752225 커브 FALSE ## 1198 -6.565555 -3.605035 -0.7941741 커브 FALSE ## 1201 -19.467840 -3.606213 -0.8539038 커브 FALSE ## 1204 -19.158659 -3.603820 -0.8964143 커브 FALSE ## 1230 -50.331157 -3.603974 -0.2231199 포심 FALSE
require(RODBC) conn_mssql=odbcDriverConnect("DSN=test; uid=OPT; pwd=sports@i%pt2012!!@^") output=sqlQuery(conn_mssql," select team = case when team='t' then substring(gmkey,9,2) else substring(gmkey,11,2) end, * from baseball_new.dbo.entry where gday = '20190627'") print(table(output$team))
## ## HH HT KT LG LT NC OB SK SS WO ## 24 19 20 16 20 20 19 20 18 16