csvファイルから条件に合うレコードを抽出する

Question

rubyでcsvファイルから下記条件のレコードを抽出して新規ファイルに保存したいです。
・日付が22日23時〜25日9時までのレコード

カラムは下記のようになっています。

#sample.csv
"type","apMac","apFloors","lat","lng","unc","x","y",
"seenTime","ssid","clientMac","rssi","manufacturer"

日付は"seenTime"に下記の形で格納
"2018-11-22T04:29:02Z"

#sample.csv
"type","apMac","apFloors","lat","lng","unc","x","y","seenTime","ssid","clientMac","rssi","manufacturer"
"DevicesSeen","11:11:11:22:df:ff",,"","","","","","2018-11-22T04:29:02Z",,"a8:cc:xx:bb:aa:aa","2","LG Electronics (Mobile..."
"DevicesSeen","ew:cc:cc:bb:ff:ff",,"123.69348579580548","22.44500594148633","49.0",,,"2018-11-22T04:33:20Z",,"cc:22:ee:bb:33:ee","19","KYOCERA"
"DevicesSeen","ee:cc:bb:99:66:22",,"11.6926993360435","11.44438098678415","49.0",,,"2018-11-25T08:21:05Z",,"ee:aa:cc:55:dd:ff","5","Apple"
"DevicesSeen","aa:cc:cc:99:66:22",,"98.69342342340435","21.0038098678415","49.0",,,"2018-11-25T08:20:50Z",,"aa:ff:77:ff:ff:bb","7","Apple"

Answer 1

以下のようにしてください。out.csvに出力されます。
エンコーディングはあなたの環境にあわせてください。

require "csv"
require "time"
t1 = Time.parse("2018-11-22 23:00:00 JST")
t2 = Time.parse("2018-11-25 09:00:00 JST")

File.open("out.csv","w") do |outf|
  File.open("sample.csv") do |inf|
    lno = 0
    inf.each_line do |line|
      lno += 1
      if lno == 1
        outf.write(line)
        next
      end
      cols = CSV.parse(line)
      tm = Time.parse(cols[0][8])
      if t1 <= tm && t2 >= tm
        outf.write(line)
      end
    end
  end
end