Created
December 22, 2022 04:37
-
-
Save kun432/dfe86759c430963cbc8d01745acb8294 to your computer and use it in GitHub Desktop.
競馬道オンラインの成績データ(kol_sei2.kd3)をCSVに変換する
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/usr/bin/env ruby | |
| fields = [0,2,6,8,10,12,20,22,23,25,27,34,64,66,67,69,109,129,149,150,153,156,159,162,167,199,207,208,210,215,216,217,222,254,262,264,265,266,267,269,274,276,278,280,281,282,286,288,289,292,295,298,300,302,304,306,307,308,316,324,330,332,334,340,346,352,358,364,370,376,377,383,384,424,432,436,598] | |
| puts "開催場所コード,開催年,開催回次,開催日次,レース番号,年月日,曜日コード,枠番,馬番,ゲート,馬コード,カナ馬名,馬記号,性別,年齢,馬主名,短縮馬主名,予備フィールド,ブリンカー,斤量,馬体重,増減,レコード指数,騎手コード,騎手名,短縮騎手名,騎手東西別,騎手所属場所コード,騎手所属厩舎コード,見習い区分,乗り替り,厩舎コード,厩舎名,短縮厩舎名,厩舎所属場所コード,厩舎栗北南別,出馬表の予想印,予想(本紙),人気,オッズ,確定着順,着順附加,入線着順,取消種別,レコード認識,タイム,着差1,着差2,タイム差,前半3F,後半3F,通過順位1,通過順位2,通過順位3,通過順位4,4角位置取り,調教フラグ,調教 騎乗者,年月日,場所,コース,馬場,8F(1哩),7F,6F,5F,4F(半哩),3F,1F,回った位置,脚色,調教矢印,調教例外,データ作成年月日,生年,予備フィールド" | |
| ARGF.each do |line| | |
| str = Array.new() | |
| for i in 0...fields.size | |
| str.push(line.byteslice(fields[i]...fields[i+1]).encode('utf-8', 'cp932').strip) | |
| end | |
| puts str.join(',') | |
| end |
Author
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
他のデータも同じようにできるはず、試してないし知らんけど。