LINQ aggregate and group by specified intervals

Question

I'm trying to understand how LINQ can be used to group data by specific intervals, and then ideally aggregate each group.
For example, I have a class called sample:

public class Sample {
public int value;
public double count; }

These observations are contained as a series in a List collection:

List<Sample> series;
group value by specified period (ex period =10) and then aggregate count by sum

Answer 1

hossein B Based on your description, I'm imagining the code would look something like this:

var query = from item in series
group item by item.Period into p
where p.Key == 10
select new {
Period = p.Key,
Sum = p.Sum(i => i.Value)
};

foreach(var i in query) {
Console.WriteLine(
quot;Period: {i.Period} | Sum: {i.Sum}");
}

----
I've created this working sample code to give you a starting point with some sample data.

https://code.sololearn.com/cCQ7SfOcAL1Q/?ref=app

Answer 2

You've lost me in your example.

Where is period in your Sample class?

It would be better if you created some code as a starting point with the sample data to review and work with.

Also... what does grouping by period represent?

Answer 3

David Carroll thanks 😍 You never cease to amaze me. I have been looking for an answer since yesterday. I felt frustrated. I got the idea from your code and what I searched on Google.
Finally it became clear to me. 😎

This is the result of my efforts and your guidance

https://code.sololearn.com/ckf5vkeHrt82/?ref=app

Answer 4

hossein B Awesome! I'm glad I could help. 🍻

Personally... it was refreshing to answer a question that was a little more involved than the typical questions I'm seeing here these days. 😉👌

So... thanks for taking it up a notch. 🙏

Answer 5

Good