作者查詢 / lery
作者 lery 在 PTT [ Database ] 看板的留言(推文), 共12則
限定看板:Database
看板排序:
全部Angels931Elephants453Baseball323NTSU-SM95311MLB108CCF83Gossiping46studyabroad40Dragons38GRE32Guardians24MLBGAME24Wade24CSI23Asian-MLB14Bucks13TOEFL_iBT13creditcard12CYCU_EE_06A12Database12GuardRookies9HCKuo9Tennis9Kings8kachaball7NTCPE_SM_957Printer_scan7Unicup7Golden-Award6SteveNash136Hantuchova5IntlShopping5MLB-TW5Office5Sabermetrics5Braves4CMWang4Federer4Lions4Monkeys4NARUTO4Scifi_Drama4Tsao4YAKYU4Anti-Cancer3Astros3BayStars3CLHu3Marlins3NTSU-SM963oeo_493Olympics_ISG3SFGiants3SoftbankHawk3Blog2C_Anthony2Chicago2Chunichi2CTSH923012CTV2CYCUEEsoft2CYUT2e-shopping2Employee2Japan_Travel2Peanuts2T-mac2Tigers2VISA2YCChen2Zombie2Athletics1b89610xxx1BBSmovie1Beauty1Cavaliers1CCSH_88_3041CEM921cjjhs3271ck55th3211ck58th3021CKCMGuitar141cksh80th3171cksh82nd3031cksh82nd3041Cobras1CSCM1CT21th3391dog1DTJH_3221DYU_EnvE901Eagles1FJU-Stat93A1GoldenEagles1Hate1HatePolitics1HC5th-3121HCHS913181HK-movie1HotBloodYuan1hotspring1Hsinchu1hwhEE_592B1Indians1INMJH90_3051Itaiano-931Jeremy_Lin1KS88-3251KS92-3111KS92-3131KS93-3041KS93-3161KS94-3201KS95-3081KS95-3141KS95-3181LeBronJames1lizen28-6021maevsoftball1Marines1Matsuzaka_181MLSH_5TH_3031movie1MusicStudent1NBAEasyChat1NCCU04_GRMI1NCCU04_RMI1NCCU_JAPAN_G1NCCUPA_SPORT1NCHUAGRSOFTB1NCKU_EARTH981NeedFood1NIUECE911NKFUST_MD1Notebook1NSYSU_MIS_971NTNU-SLM931NTPU-LAND90B1NTU-EM911NTU-EM931NUU_ME1PeopleSeries1phys011PushDoll1railtour1Rangers1RSSH90_3021SCU_MBA961share1Softball1specialman1TFSHS66th3071THU_BA20001TKU_HisSB1TTU-US941weiyin1WorkanTravel1WuLing46-3171Yup03-071<< 收起看板(159)
首頁
上一頁
1
下一頁
尾頁
1F推:http://0rz.tw/843Pg 是每個play的數據 所以只有幾好幾壞03/28 20:12
2F推:的時候發生這個 play,檔案是Excel的不過可用Access打開03/28 20:17
3F推:其實這是我的論文data, 研究對象是中繼後援投手,謝謝g大03/28 20:29
4F推:這邊的檔案只有天使隊07年的資料,因為要做80~07年,所以需要03/28 20:40
5F推:SQL的幫助 另一個管道就是從ESPN抓 但是投手真的太多03/28 20:41
7F推:嗯 其實我都是用MS Access開,只是上傳方便用Excel檔03/28 22:55
8F推:用 delete 的話,我不知道如何刪掉相同的投手,我太弱了sorry03/29 17:43
9F推:我只能刪掉leadoff='T'且outsonplay=0的列03/29 17:44
1F推:f大的意思是一筆一筆找嗎?03/28 20:40
2F→:保留當時的狀況,為了統計更換投手後,壘上的人數03/27 22:42
3F→:套入公式後可以計算出該投手的表現03/27 22:50
4F→:就是投手登場時,若壘上有人,該投手的列不要刪掉03/27 22:56
首頁
上一頁
1
下一頁
尾頁