- ふらっと C#,C♯,C＃（初心者用） Part116 [転載禁止]©2ch.net
22 ：デフォルトの名無しさん[sage]：2015/07/12(日) 15:49:58.92 ID:AndYlWNb - var result =
from row in (
from line in File.ReadLines("xxx.csv")
let fields = line.Split(",")
select new { time = TimeSpan.Parse(fields[0]), value = int.Parse(fields[1]) }
)
group row by (int)row.time.TotalMinutes into gr
let values = (from r in gr select r.value)
select new { time = gr.First().time, start = gr.First().value, end = gr.Last().value, low = values.Min(), high = values.Max() };
using (var writer = new StreamWriter("yyy.csv"))
foreach (var r in result)
writer.WriteLine("{0},{1},{2},{3},{4}", r.time, r.start, r.end, r.low, r.high);
|
|