select multiple objects from list based on values from another list

Question

I have two lists. One list is of type Cascade (named, cascadeList) & the other list if of type PriceDetails (named priceList), both classes are shown below. I have also given a simple example of what I'm trying to achieve below the classes.

So the priceList contains a list of PriceDetail objects where they can be multiple (up to three) PriceDetail objects with the same ISIN. When there are multiple PriceDetails with the same ISIN I want to select just one based on the Source field.

This is where the cascadeList comes in. So if there were 3 PriceDetails with the same ISIN I would want to select the one where the source has the highest rank in the cascade list (1 is the highest). Hopefully the example below helps.

Reason for the question

I do have some code that is doing this for me however its not very efficient due to my lack of skill.

In a nutshell it first creates a unique list of ISIN's from the priceList. It then loops through this list for each unique ISIN to get a list of the PriceDetails with the same ISIN then uses some if statements to determine which object I want. So hoping and pretty sure there is a better way to do this.

My Classes

class Cascade
{
     int Rank;
     string Source;
}


class PriceDetails
{
     string ISIN;
     string Sedol;
     double Price;
     string Source;
}

Example

PriceList                                Cascade
ISIN   Source    Price                   Source    Rank
BN1    XYZ       100                     ABC       1
MGH    PLJ       102                     XYZ       2
BN1    PLJ       99.5                    PLJ       3
BN1    ABC       98
MGH    XYZ       102

Result I'm looking for

PriceList
ISIN   Source   Price
BN1    ABC      98
MGH    XYZ      102

If highest rank is the criteria why XYZ is there in the result and that too why with price 102? — Rahul Singh
– Rahul Singh, Commented Jan 15, 2016 at 13:27
you're correct the source doesn't need to be there - was just trying to make it clear. The price MGH with source XYZ is 102 as the only other MGH object has a source PLJ but that is lower than XYZ in the cascade - hope that makes sense — mHelpMe
– mHelpMe, Commented Jan 15, 2016 at 13:30

Farhad Jabiyev · Accepted Answer · 2016-01-16 06:31:05Z

4

For getting the desired result we must do these steps:

Join two lists based on Source property.
Group the last result by ISIN property.
After grouping we must get the minimum rank for each ISIN.
Then we will use the minRank variable to compare it against the rank of an elements with the same ISIN and then select the first element.

We can write this query either with query or method syntax.

With query syntax:

var result = from pr in pricesList
             join cas in cascadesList on pr.Source equals cas.Source
             select new { pr, cas } into s
             group s by new { s.pr.ISIN } into prcd
                let minRank = prcd.Min(x => x.cas.Rank)
             select prcd.First(y => y.cas.Rank == minRank).pr;

With method syntax:

var result = pricesList.Join(cascadesList,
                  pr => pr.Source,
                  cas => cas.Source,
                  (pr, cas) => new { pr, cas })
            .GroupBy(j => j.pr.ISIN)
            .Select(g => new { g, MinRank = g.Min(x => x.cas.Rank) })
            .Select(r => r.g.First(x => x.cas.Rank == r.MinRank).pr);

Result will be same with both ways:

PriceList
ISIN   Source   Price
BN1    ABC      98
MGH    XYZ      102

P.S: I have assumed that list's name is as following: pricesList and cascadesList

edited Jan 16, 2016 at 6:31

answered Jan 15, 2016 at 13:54

Farhad Jabiyev

26.9k8 gold badges79 silver badges103 bronze badges

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

2 Comments

Rahul Singh Over a year ago

Exactly what OP was looking for! Nice Answer :)

Farhad Jabiyev Over a year ago

@RahulSingh Thanks very much.

martavoi · Accepted Answer · 2016-01-15 13:31:29Z

4

from pr in priceList
join c in cascadeList on pr.Source = c.Source
order by c.Rank
select new {Isin = pr.Isin, Source = pr.Source, Price = pr.Price}

edited Jan 15, 2016 at 13:31

answered Jan 15, 2016 at 13:27

martavoi

7,1127 gold badges43 silver badges62 bronze badges

4 Comments

Hamlet Hakobyan Over a year ago

It is amazing, how the obvious wrong (also bad formed) answer can be upwoted.

mHelpMe Over a year ago

I believe this will still return me all 3 BN1 pricedetails but just order or am I missing something?

martavoi Over a year ago

@mHelpMe give me a minute

Rahul Singh Over a year ago

This will not produce the expected output.

Jairo · Accepted Answer · 2016-01-15 13:52:18Z

0

See if this works for you

priceList.GroupBy(p => p.ISIN).OrderByDescending(p =>
    cascadeList.FirstOrDefault(c => c.Source == p.Source).Rank).First();

answered Jan 15, 2016 at 13:52

Jairo

4264 silver badges12 bronze badges

Collectives™ on Stack Overflow

select multiple objects from list based on values from another list

3 Answers 3

2 Comments

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related