Need Sum from multidimensional array using LINQ

Question

I have the following code:

var ccdata = dict1.Select(i => 
                          new object[] { i.Key, Int32.Parse(i.Value) }
                         ).ToArray();

I need to get the sum of all of the i.Value's. Please note this is a multidimensional object array. i.Key is a string value and i.Value is a int value which needs to be summed up.

Thank you in advance

Why are you putting the two into an object array, thereby boxing everything? — Jon Skeet
– Jon Skeet, Commented Oct 18, 2011 at 19:37
What i.Value is string? Why do you parse it, why isn't it initially a number? — abatishchev
– abatishchev, Commented Oct 18, 2011 at 19:43
if I.Value is already an int then int.Parse will not compile since it expects a string. Is it a string or an int? — Rune FS
– Rune FS, Commented Oct 18, 2011 at 20:00
@JonSkeet: Because when he asked how to create a multidimensional array, I suggested doing it with Linq. Looks like he didn't bother looking up what Linq is all about and hoped random code he gets from this site can be combined into a working solution. — Roman
– Roman, Commented Oct 19, 2011 at 2:51

abatishchev · Accepted Answer · 2011-10-18 19:45:13Z

3

dic.Sum(i => Int32.Parse(i.Value)); // if i.Value is string instead of just int

dic.Sum(i => i.Value); // if string

or

ccdata.Sum(i => (int)i[1]); // if i[1] is object instead of just int

ccdata.Sum(i => i[1]); // if int

edited Oct 18, 2011 at 19:45

answered Oct 18, 2011 at 19:38

abatishchev

101k88 gold badges303 silver badges443 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jon Skeet Over a year ago

The latter will fail to compile, as the compile-time type of i[1] is just object.

Jon Skeet · Accepted Answer · 2011-10-18 19:38:07Z

2

It's unclear why you're doing it in quite this way, but it's fairly easy to sum them...

int sum = ccdata.Sum(x => (int) x[1]);

It would be clearer and more efficient if you used:

var ccdata = dict1.Select(i => new { i.Key, Value = Int32.Parse(i.Value) })
                  .ToArray();

That way you end up with compile-time type safety and no boxing:

int sum = ccdata.Sum(x => x.Value);

(I'm assuming you actually want ccdata for some other reason. Otherwise, use abatishchev's solution and get rid of your existing code altogether.)

answered Oct 18, 2011 at 19:38

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

Comments

Jan · Accepted Answer · 2011-10-18 19:38:48Z

1

i.Value is at the second position in your inner array. So it should go like that:

var sum = cdata.Sum(arr => (int)arr[1]);

answered Oct 18, 2011 at 19:38

Jan

16.1k5 gold badges38 silver badges60 bronze badges

Collectives™ on Stack Overflow

Need Sum from multidimensional array using LINQ

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related