Read Csv using LINQ

by 
var stuff = from l in File.ReadAllLines(filename)
            let x = l.Split(new [] {',', ' '}, StringSplitOptions.RemoveEmptyEntries)
                     .Skip(1)
                     .Select(s => int.Parse(s))
            select new
            {
                Sum = x.Sum(),
                Average = x.Average()
            };

If you’re reading big files and memory use is a concern, then the following will work better using .NET 4:

var stuff = from l in File.ReadLines(filename)
            let x = l.Split(new [] {',', ' '}, StringSplitOptions.RemoveEmptyEntries)
                     .Skip(1)
                     .Select(s => int.Parse(s))
            select new
            {
                Sum = x.Sum(),
                Average = x.Average()
            };

In both cases, the stuff variable contains an enumerable which won’t actually be executed until you start reading from it (e.g. inside a foreach loop).

More Related Contents:

  1. linq syntax: What is the type that this returns? How can I now go ahead and use firstRow.ingredientName etc?
  2. Retrieving Property name from lambda expression
  3. Return anonymous type results?
  4. How do I specify the Linq OrderBy argument dynamically? [duplicate]
  5. When to use BlockingCollection and when ConcurrentBag instead of List?
  6. How to get the index of an element in an IEnumerable?
  7. How do I invoke an extension method using reflection?
  8. Entity framework left join
  9. How to check if IEnumerable is null or empty?
  10. Find index of a value in an array
  11. How do you add an index field to Linq results
  12. Add two Lists of different length in C#
  13. Local sequence cannot be used in LINQ to SQL implementation of query operators except the Contains() operator
  14. Linq query built in foreach loop always takes parameter value from last iteration
  15. Entity Framework. Delete all rows in table
  16. Find() vs. Where().FirstOrDefault()
  17. How to Get XML Node from XDocument
  18. Filter a list by another list C#
  19. Is there an IEnumerable implementation that only iterates over it’s source (e.g. LINQ) once?
  20. LINQ identity function
  21. LINQ .Any VS .Exists – What’s the difference?
  22. LINQ Expression to return Property value?
  23. Simulating Cross Context Joins–LINQ/C#
  24. Remove duplicate items from list in C#, according to one of their properties
  25. Entity Framework core – Contains is case sensitive or case insensitive?
  26. How to do an “in” query in entity framework?
  27. LINQ: Add RowNumber Column
  28. Is there an easy way to merge two ordered sequences using LINQ?
  29. C# Searching for files and folders except in certain folders
  30. What is the difference between LINQ ToDictionary and ToLookup

Leave a Comment