c# - 根据 csv 文件中的记录分组

Question

我正在加载 CSV 文件

进入:

 public class ReleaseVersion
{
    public string Version { get; set; }
    public DateTime? ReleaseDate { get; set; }
    public IEnumerable<ReleaseNote> ReleaseNotes { get; set; }

}

public class ReleaseNote
{
    public string Description { get; set; }
    public string Progress { get; set; }
    public string Status { get; set; }
}

如何按版本对所有记录进行分组并返回 ReleaseVersion 列表？

这是我所做的，但是我不知道如何按第一列(文件中的版本列)进行分组。

var records = csvLinesData.Select(data => new ReleaseVersion
        {

            Version = data[0],
            ReleaseDate = TryParse(data[1]),
            // add list of ReleaseNote ??
        }).ToList();

Answer 1

仅在第一项上使用 GroupBy:

  DateTime date;

  var records = csvLinesData
    .GroupBy(line => line[0]) // line[0] is version we want to group by on
    .Select(chunk => new ReleaseVersion() {
       Version = chunk.Key,
       ReleaseDate = DateTime.TryParse(chunk.First()[1], out date) 
          ? (DateTime?) date 
          : null,
       ReleaseNotes = chunk
         .Select(item => new ReleaseNote() {
            Description = item[2],
            Progress = item[3],
            Status = item[4], }) 
         .ToArray(), })
    .ToList();